Finance and TreasuryFinancial Modelling and Valuation Techniques
A financial model is an argument about the future written in arithmetic, and most of them are wrong in the same way: the structure is sound and the assumptions were never examined. This course attends to both. Delegates work through model design and the layout discipline that makes a model auditable by somebody else, separating inputs, calculations and outputs. Building the three financial statements so they link and balance follows. Working capital, capital expenditure and debt schedules are covered. Assumption setting is treated as the core skill, including where each number came from and what happens when it is wrong. Sensitivity and scenario analysis follow. Valuation is addressed through discounted cash flow, the cost of capital in a high inflation environment, and multiples. Error checking and model review are covered. The course closes on presenting a valuation and on the questions a model must survive.
Course objectives
- Design a model that another person can audit
- Separate inputs, calculations and outputs consistently
- Build linked and balancing financial statements
- Construct working capital, capital expenditure and debt schedules
- Set and document assumptions, then test what breaks
- Run sensitivity and scenario analysis
- Value through discounted cash flow and multiples, and defend the result
Who should attend
- Corporate finance and investment banking analysts
- Private equity and investment fund analysts
- Financial planning and analysis managers building forecasting models
- Business development staff evaluating acquisitions or expansions
- Finance professionals seeking rigorous, hands on modelling practice
Course outline
- 01An argument written in arithmetic
- 02Model design and layout discipline
- 03Inputs, calculations and outputs
- 04Linked financial statements
- 05Working capital, capital expenditure and debt
- 06Assumptions and what breaks them
- 07Sensitivity and scenario analysis
- 08Discounted cash flow, multiples and model review
Scheduled sessions
| Dates | Venue | Format | Price | Register |
|---|---|---|---|---|
| 5 to 7 October 2026 | Port Louis, Mauritius | Classroom | USD 995 per delegate | Register Now |
| 12 to 14 October 2026 | Dar es Salaam, Tanzania | Classroom | USD 995 per delegate | Register Now |
| 2 to 4 December 2026 | Windhoek, Namibia | Classroom | R14,950 per delegate | Register Now |
| 8 to 10 March 2027 | Online | Online | R6,500 per delegate | Register Now |