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.

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

DatesVenueDaysFeeCalendar
17 to 21 Aug 2026Lusaka5US$1,800
24 to 28 Aug 2026Kigali5US$1,800
31 Aug to 4 Sep 2026Nairobi5US$1,800
7 to 11 Sep 2026Durban5R18,000
14 to 18 Sep 2026Johannesburg5R18,000
28 Sep to 2 Oct 2026Mauritius5US$1,800
5 to 9 Oct 2026Dubai5US$1,800
12 to 16 Oct 2026Lagos5US$1,800
19 to 23 Oct 2026Harare5US$1,800
26 to 30 Oct 2026Kampala5US$1,800
2 to 6 Nov 2026Dar es Salaam5US$1,800
9 to 13 Nov 2026Pretoria5R18,000
16 to 20 Nov 2026Cape Town5R18,000
30 Nov to 4 Dec 2026Online5US$900
7 to 11 Dec 2026Mozambique5US$1,800
14 to 18 Dec 2026Cairo5US$1,800
21 to 25 Dec 2026Accra5US$1,800

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
31 Aug to 4 Sep 2026
Venue
Dubai
5 day programme
FromUS$900
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, trace the...

Next session
31 Aug to 4 Sep 2026
Venue
Johannesburg
5 day programme
FromUS$900
Finance and Budgeting

Cash Flow and Working Capital Management

Profitable businesses still fail when cash runs out. Forecasting cash with confidence, shortening the cash conversion cycle and releasing...

Next session
31 Aug to 2 Sep 2026
Venue
Kigali
3 day programme
FromUS$900
See all Finance and Budgeting courses