Financial Modeling Masterclass
Build investor-ready three-statement models, DCF valuations and sensitivity analyses in Excel.
3 days (21 hours)
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.
Frequently asked questions
Related courses
More Microsoft & data training delivered in Nairobi and live online across Kenya.
- Beginner
Microsoft Excel — Basic
Build a confident foundation: navigate workbooks, format data and write your first formulas.
1 day (7 hours)KES 10,000 - Intermediate
Microsoft Excel — Intermediate
Move beyond the basics with conditional logic, lookups, charts and pivot tables.
2 days (14 hours)KES 15,500 - Advanced
Excel Advanced — Power User
Power user techniques: dynamic arrays, LAMBDA, Solver, VBA automation and decision-ready dashboards.
2 days (16 hours)KES 22,500