Financial Modelling & Valuation
Build accurate financial models for valuation and decision-making.
Course
Risk, Security & Operations
Overview
From structuring models to running valuation techniques and scenario testing.
Objectives
- Create dynamic, accurate models
- Apply DCF and comparative valuation methods
- Conduct sensitivity analysis
Audience
Financial analysts, investment professionals, and CFOs.
Methodology
Hands-on Excel work and case studies.
Outline
- Day One: Model Setup
- Structuring financial models
- Input assumptions and drivers
- Linking financial statements
- Day Two: Forecasting
- Revenue and expense projections
- Working capital adjustments
- Capital expenditure planning
- Day Three: Valuation Techniques
- DCF modeling
- Comparable company analysis
- Precedent transactions
- Day Four: Sensitivity and Scenario Analysis
- Data tables and charts
- Stress-testing models
- Interpreting results
- Day Five: Presentation
- Preparing model outputs
- Building investor-ready reports
- Q&A session