Build an integrated three-statement financial model in Excel with assumptions, scenarios and sensitivity analysis, following internationally accepted modeling best practices.
Course Curriculum
| 1. Modeling Foundations | |||
| 1.1 What a financial model is and who uses it Details | 00:06:00 | ||
| 1.2 Model structure and best practices Details | 00:08:00 | ||
| 1.3 Formatting standards and color codes Details | 00:06:00 | ||
| 1.4 Timeline and flags Details | 00:07:00 | ||
| 2. Assumptions | |||
| 2.1 Revenue drivers Details | 00:09:00 | ||
| 2.2 Cost and margin assumptions Details | 00:08:00 | ||
| 2.3 Working capital assumptions Details | 00:08:00 | ||
| 2.4 Capex and depreciation schedule Details | 00:09:00 | ||
| 2.5 Debt and interest schedule Details | 00:09:00 | ||
| 3. The Three Statements | |||
| 3.1 Building the income statement Details | 00:09:00 | ||
| 3.2 Building the balance sheet Details | 00:09:00 | ||
| 3.3 Building the cash flow statement Details | 00:10:00 | ||
| 3.4 Balancing the model and circular references Details | 00:09:00 | ||
| 4. Analysis Layer | |||
| 4.1 Scenarios: base, best and worst Details | 00:08:00 | ||
| 4.2 Sensitivity analysis Details | 00:08:00 | ||
| 4.3 Ratios and outputs page Details | 00:07:00 | ||
| 4.4 Charts for presentation Details | 00:06:00 | ||
| 5. Model Review | |||
| 5.1 Error checks and model audit Details | 00:08:00 | ||
| 5.2 Presenting the model to management or investors Details | 00:07:00 | ||
| 5.3 Final project: 5-year model for a company Details | 00:20:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
STUDENTS ENROLLED
