Hands-on models
Financial Modelling and Valuation
Build a three-statement model, a discounted cash flow and comparables in Excel, work through a full company model, then see how deals are valued.
What you will be able to do
- Build a linked three-statement model
- Value a company with DCF and multiples
- Model a real company end to end
- Understand M&A and LBO valuation
Syllabus
- A. Excel toolkit (25 lessons)
- B. Valuation fundamentals (10 lessons)
- C. Modelling fundamentals (10 lessons)
- D. Company analysis and the full model (47 lessons)
- E. Mergers, LBOs and deal valuation (10 lessons)
- F. Professional workflow and capstone (16 lessons)
- G. Second sector and special cases (8 lessons)
How you are assessed
Phase tests, graded assignments and a capstone
About 74 hours of study. Level: Intermediate.