Financial Modelling in Excel
Overview
Financial models support budgets, investment decisions, valuations and scenarios. This hands-on course teaches how to build clear, flexible and reliable financial models in Excel, following good modelling practice from structure and assumptions to three-statement models, scenarios and checks.
Who should attend
Financial analysts, accountants, investment and planning staff, and finance managers.
Training methodology
Interactive presentations, practical exercises, case studies, group discussions, role-plays where relevant, and a personal action plan that participants apply in their own work.
Objectives
By the end of this course, participants will be able to:
- Apply good financial modelling standards
- Structure models with clear inputs, calculations and outputs
- Build an integrated three-statement model
- Add scenarios and sensitivity analysis
- Check, document and present models
Course outline
Day 1Modelling Principles
- Uses of financial models
- Modelling standards
- Model structure
- Excel tools for modellers
- Hands-on setup
Day 2Assumptions and Revenue
- Input sheets
- Revenue drivers
- Cost drivers
- Timing and periods
- Hands-on lab
Day 3Three-Statement Model
- Income statement
- Balance sheet
- Cash flow
- Linking and balancing
- Hands-on lab
Day 4Scenarios and Valuation
- Scenario switches
- Sensitivity tables
- Discounted cash flow
- Funding scenarios
- Hands-on lab
Day 5Checking and Presenting
- Error checks
- Model review
- Documentation
- Charts and summary outputs
- Final model
