Finance, Treasury and Credit Risk

FP&A Modelling

Develop practical capabilities in planning, forecasting and management reporting.

2 daysUS$200 per delegate
Overview

What the programme covers

Move from raw actuals to a live, driver-based FP&A model. You build budgets, rolling forecasts and scenarios, automate variance analysis, and produce board-ready reporting packs, ready for month-end.

Practical modelling with Python and AI-assisted development

Use AI tools, including Claude Code, to accelerate model development, testing and documentation.

Curriculum

What you will learn

01

FP&A foundations

Understand the driver-based planning framework

  • FP&A cycle overview
  • Driver-based approach
  • Data requirements
02

Driver-based budgeting

Build a driver-based budget from raw actuals

  • Driver identification
  • Budget build
  • AI-assisted modelling
03

Rolling forecasts and scenarios

Build a rolling forecast with scenario flexing

  • Rolling forecast mechanics
  • Scenario and sensitivity analysis
  • AI-assisted modelling
04

Variance analysis

Automate variance analysis against budget and prior period

  • Variance analysis techniques
  • Root-cause commentary
  • Testing and reconciliation
05

Board reporting and reconciliation

Produce a board-ready reporting pack

  • Reporting pack design
  • Testing and reconciliation
  • Reconciliation
How you build it

The tools and the method

Claude Code, Codex and agentic AIBuild → Analyse → Model → Calculate → Report
The principle

Use AI to speed up the build.

Use testing and reconciliation to prove the numbers.

Use FP&A expertise to make the judgement.

Who it is for

Built for these roles

  • FP&A Analysts and Managers
  • Finance Business Partners
  • Budget Owners
What you leave with

You will have worked through a practical end-to-end AI-assisted FP&A build, from raw actuals through driver-based budgeting, rolling forecasts, variance analysis and board-ready reporting.

Programme details

The practical details

Duration2 days
DeliveryInstructor-led with live demonstrations and practical exercises
InvestmentUS$200 per delegate
Group bookings20% discount
PrerequisitesLaptop, working knowledge of finance and Excel
ToolsPython and AI-assisted development, including Claude Code
FacilitatorTafirei Mashamba, PhD
Next intakeAsk us for the next intake. We reply by email or WhatsApp.
Keep going

Related programmes

Need this built for your institution instead? See Business Intelligence and Analytics.

Ready to register?

Book your seat, or ask about training your whole team. Group bookings receive a 20% discount.