All courses
Financial Modeling Masterclass
Build investor-ready three-statement models, DCF valuations and sensitivity analyses in Excel.
Duration
3 days (21 hours)
Fee
KES 32,500
per participant
About this course
A practitioner-led Financial Modeling course in Nairobi for finance professionals, analysts, CFOs and consultants. You will build a complete three-statement model from a blank workbook, link income statement, balance sheet and cash flow with audit-grade formulas, run a discounted cash flow valuation, and stress-test assumptions through scenario and sensitivity analysis. Delivered with real Kenyan and East African company case studies.
Class goals
- Structure a clean, auditable financial model from scratch
- Link the three statements with self-balancing checks
- Forecast revenue, costs, working capital and capex with defensible assumptions
- Build a DCF valuation with WACC, terminal value and sensitivity tables
- Present model outputs in a professional executive summary
Course outline
- 1Model design principles & best-practice formatting
- 2Three-statement model build (P&L, BS, CF)
- 3Revenue, cost & working capital forecasting
- 4DCF valuation, WACC & terminal value
- 5Scenario, sensitivity & data tables for stress testing
Delivery
Live online
Interactive virtual classroom from anywhere.
In person
At our venue, or at your office for corporate groups.