Financial Modeling Fundamentals (Online)

Master the fundamentals of financial modeling with key concepts, Excel skills, and best practices. Build reliable forecasts and dashboards to drive data-informed decisions.

Subscribe Now

Course curriculum

1. 1.1 Welcome to the course!
2. 1.2 Required Downloads
3. 1.3 Optional Downloads (Intermediate Models)
1. 2.1 Anchoring
2. 2.2 IF Function
3. 2.3 IF (OR) & IF (AND) Functions
4. 2.4 SUMIF Function
5. 2.5 LOOKUP Function
6. 2.6 Date Functions and Timeline
7. Chapter 2 Quiz
8. Chapter 2 Slides 1
9. Chapter 2 Slides 1
1. 3.1 Best Practice Principles
2. 3.2 Best Practices - Formulas
3. 3.3 Financial Modeling Guidelines
4. 3.4 Named Ranges
5. 3.5 Best Practices - Styles
6. 3.6 Best Practice - Flags and Conditional Formatting
7. 3.7 Excel Shortcuts (Downloads)
8. 3.8 Excel Shortcuts
9. Chapter 3 Quiz
10. Chapter 3 Slides
1. 4.1 About MWTs
2. 4.2 MWT (S1) - Model / Workbook Setup
3. 4.3 MWT (S2) - Initial Model Inputs (Timing)
4. 4.4 MWT (S3) - Setting Up Calculation Sheet & Ownership Period
5. 4.5 MWT (S4) Escalation and Processing Inputs
6. 4.6 MWT (S5) Escalation and Processing Calculations
7. 4.7 MWT (S6) Revenue Inputs
8. 4.8 MWT (S7) Revenue Calculations
9. 4.9 Fixed and Variable Costs
10. 4.10 MWT (S8) Operating Expenses Inputs
11. 4.11 MWT (S9) Operating Expenses Calculations
12. 4.12 MWT (S10) Business Cashflow / EBITDA Forecast
13. 4.13 Present Value Math
14. 4.14 NPV Function
15. 4.15 IRR
16. 4.16 MWT (S11) Unlevered Returns Calculations
17. 4.17 MWT (S12) What can improve my returns?
18. Chapter 4 Quiz
19. Chapter 4 Slides
1. 5.1 Data Validation
2. 5.2 Sensitivities and Scenarios
3. 5.3 MWT (S13) - Creating a Scenario Manager
4. 5.4 Data Tables
5. 5.5 MWT (S14) - Creating a 1-D Data Table
6. 5.6 MWT (S15) - Creating a 2-D Data Table
7. 5.7 MWT (S16) - Review Data Table (Part A)
8. 5.8 MWT (S16) - Review Data Table (Part B)
9. 5.9 MWT (S17) - Reviewing the Model
10. 5.10 MWT (S18) - Graphing to Review Models
11. 5.11 MWT (S19) - Grouping
12. 5.12 MWT (S20) - Goal Seek to Achieve Target IRR / MOIC
13. Chapter 5 Quiz
14. Chapter 5 Slides 1
15. Chapter 5 Slides 2
1. 6.1 Intro to Debt and Equity
2. 6.2 WACC
3. 6.3 Benefits of Leverage
4. 6.4 Benefits of Leverage, Extended
5. 6.5 MWT (S21) - Adding Debt Inputs
6. 6.6 Debt Repayment Types
7. 6.7 Best Practice - Accounts
8. 6.8 MWT (S22) - Debt Calculations
9. 6.9 MWT (S23) - Debt Repayment Flag
10. 6.10 Model Checks
11. 6.11 MWT (S24) - Model Checks
12. 6.12 MWT (S25) - Levered Returns
13. 6.13 Changing Scenario from any Sheet
14. 6.14 MWT (S26) - Combo Box
15. 6.15 MWT (S27) - Reviewing Levered Return Outputs
16. Chapter 6 Quiz
17. Chapter 6 Slides 1
18. Chapter 6 Slides 2
1. 7.1 Introduction to 3-Way Statements
2. 7.2 Balance Sheet
3. 7.3 T-Accounts
4. 7.4 Demo S1: Layout of Balance Sheet
5. 7.5 Model Review: Adding PP&E
6. 7.6 Demo S2: Adding Checks + Forecasting
7. 7.7 Model Review: Forecasting on Balance Sheet
8. 7.8 Income Statement
9. 7.9 Depreciation
10. 7.10 Income vs. Cashflow
11. 7.11 Model Review: Forecasting PP&E
12. 7.12 Demo S3: Adding Depreciation
13. 7.13 Model Review: Adding Depreciation
14. 7.14 Retained Earnings
15. 7.15 Retained Earnings and the Balance Sheet
16. 7.16 Model Review: How Depreciation Balances
17. 7.17 Model Review: Forecasting RE
18. 7.18 Demo S4: Adding Revenues, Expenses and Retained Earnings
19. 7.19 Model Review: Adding Revenues, Expenses and Retained Earnings
20. 7.20 Model Review: Change in EBITDA
21. 7.21 Demo S5: Linking Cash
22. 7.22 Model Review: Linking Cash
23. 7.23 Leverage and Financial Statements
24. 7.24 Model Review: Linking Debt
25. 7.25 Demo S6: Adding Debt
26. 7.26 Model Review: Adding Debt
27. 7.27 Income vs. Cash - Check in Model
28. 7.28 Accounts Receivable and Payable
29. 7.29 Change in Accounts Receivable and Payable
30. 7.30 Days Receivable and Days Payable
31. 7.31 Demo S7a: Calculating Accounts Receivable and Payable
32. 7.32 Model Review: Calculating Accounts Receivable and Payable
33. 7.33 Demo S7b: Linking Accounts Receivable and Payable
34. 7.34 Model Review: Linking Accounts Receivable and Payable
35. 7.35 Cashflow Statement
36. 7.36 Demo S8: Cashflow Statement
37. Balance Summaries
38. Chapter 7 Quiz
39. Chapter 7 Slides
1. 8.1 MWT (S28) - Depreciation and Net Working Capital
2. 8.2 MWT (S29) - Cashflows, Payout Ratio and Dividends
3. 8.3 MWT (S30) - Setup for 3-Way Financial Statements
4. 8.4 MWT (S31) - Initial 3-Way Statement Linking
5. 8.5 MWT (S32) - Adding Payout Ratio and Cash Balance to Statements
6. 8.6 MWT (S33) - Adding Debt to Financial Statements
7. 8.7 MWT (S34) - Adding Debtors and Creditors to Statements
8. 8.8 MWT (S35) - Reviewing our 3-Way Statements
9. 8.9 Final Advice for Financial Statements
1. 9.1 Intro to Graphing
2. MWT (S36) - Dashboard
1. Survey To Complete the Course

About this course

$400.00 first payment, $75.00 / year onwards
125 lessons
14 hours of video content

Discover your potential, starting today

Enroll today

Financial Modeling Fundamentals (Online)

Course curriculum

1. Introduction to FM Fundamentals

2. Excel Functions for Financial Modelers

3. Best Practices and Excel Shortcuts

4. Model Development

5. Sensitivities, Scenarios and Optimizing

6. Primer on Debt

7. Intro to 3-Way Statements and Retained Earnings

Modeling 3- Way Statements

9. Outputs and Summary

10. Survey

About this course

Discover your potential, starting today