Skip to content

Financial Modelling and Forecasting in Excel

This hands on programme teaches participants to build robust, flexible financial models from the ground up. Emphasis is placed on clean structure, reliable forecasting and testing outcomes under different assumptions.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Design models with a clear and logical structure
  • Build linked income, balance sheet and cash flow schedules
  • Forecast revenue and costs from sound assumptions
  • Apply scenario and sensitivity techniques
  • Reduce errors through model checks and controls
  • Present model outputs clearly to decision makers

Course outline

  1. 01Principles of good model design and layout
  2. 02Separating inputs, calculations and outputs
  3. 03Core spreadsheet functions for modelling
  4. 04Building the integrated three statement model
  5. 05Driver based revenue and cost forecasting
  6. 06Working capital and financing schedules
  7. 07Scenario, sensitivity and what if analysis
  8. 08Error checking and model auditing
  9. 09Charts and dashboards for model outputs
  10. 10Documenting assumptions and handover

Who should attend

Analysts, accountants, planning staff and finance managers who build or rely on financial models and forecasts.

Dates, venues and fees

DatesVenueDaysFeeCalendarRegister
28 Sep to 2 Oct 2026Cape Town5R18,000Closed
5 to 9 Oct 2026Durban5R18,000Register
12 to 16 Oct 2026Pretoria5R18,000Register
19 to 23 Oct 2026Nairobi5US$1,800Register
26 to 30 Oct 2026Dar es Salaam5US$1,800Register
2 to 6 Nov 2026Lusaka5US$1,800Register
9 to 13 Nov 2026Harare5US$1,800Register
16 to 20 Nov 2026Accra5US$1,800Register
23 to 27 Nov 2026Lagos5US$1,800Register
30 Nov to 4 Dec 2026Dubai5US$1,800Register
7 to 11 Dec 2026Johannesburg5R18,000Register

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Finance and Budgeting

Finance and Budgeting

Budgeting, Forecasting and Cost Control

Build budgets that survive contact with reality. Zero based principles, rolling forecasts and variance investigation are worked through...

Next session
5 to 9 Oct 2026
Venue
Nairobi
5 day programme
FromR18,000
Finance and Budgeting

Financial Statement Analysis and Reporting

Read a set of annual financial statements the way an analyst does. Delegates dissect real style statements prepared under IFRS...

Next session
5 to 9 Oct 2026
Venue
Pretoria
5 day programme
FromR18,000
Finance and Budgeting

Cash Flow and Working Capital Management

Profitable businesses still fail when cash runs out. Forecasting cash with confidence...

Next session
29 Sep to 1 Oct 2026
Venue
Durban
3 day programme
FromR13,000
See all Finance and Budgeting courses