After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
コース説明
前提条件
カリキュラム
コース概要
1
What are Models?
An introduction to modeling financial statements in Sheets focusing on balance and income statements, which help create cash flow models.
- How to love models50 XP
- Format the income statement100 XP
- Create the sum values100 XP
- Copy sums for each year100 XP
- Continuing simple models with balance sheets50 XP
- Format a balance statement model100 XP
- Balance all the years100 XP
- Common size statement100 XP
- Build a cash flow model50 XP
- Update the cash flow100 XP
- Complete cash flow for all years100 XP
- Forecast Cash Flows100 XP
2
Time Value Money Models
Learn Sheet's financial model functions by creating investment models with the fv, pv, pmt, and nper functions. You will also learn how to pay off debts in a loan amortization table.
3
Planning and Investing Models
Saving for retirement is tricky, but in this chapter, you will learn how to create models that help you plan to save and use your money after retirement.
4
Probabilistic Models
Stock prices go up and down but can we model them? Learn about volatility and simulating stock prices in this final chapter.
S
Google Sheetsで学ぶファイナンシャル・モデリング
コース修了
