About this course
Overview
Most models fail not because the maths is wrong but because nobody else can follow them. Starting from an empty workbook, you build a linked three-statement model to review standard, then add scenarios, checks and the structural habits that keep it from breaking the first time someone changes an assumption.
What you will be able to do
Learning outcomes
- Build a linked three-statement model
- Run and compare scenarios cleanly
- Trace and resolve model errors
- Present model outputs to reviewers
- Maintain a model that holds up under review
What the course sets out to do
Course objectives
- Structure a three-statement model from scratch
- Link income statement, balance sheet, and cash flow
- Design scenarios and sensitivity switches
- Apply modelling standards and formatting discipline
- Build in checks that catch errors early
Who it is for
Target audience
Financial analysts, controllers, and finance business partners who build or review models.
Before you start
Prerequisites
Confident Excel use. You should know your way around formulas and referencing before you arrive.