3 Statement Modelling
Build a 3 statement financial model for a real listed company, not with mock numbers.
of video content
build lessons
instantly-graded questions
integrity checks
What you will be able to do
By the end of this course, you will be able to understand a company's public disclosures and build a financial forecast grounded in reality.
Find the figures you need in the income statement, balance sheet, cash flow statement and notes, and enter three years of history.
Profit flows into retained earnings, balance sheet movements drive the cash flow, and closing cash returns to the balance sheet.
PP&E, leases, intangibles, working capital, tax, dividends, share-based payments and debt, with the accounting mechanics explained as you build each one.
Drive revenue, margins, capital expenditure, working capital days and dividends from one assumptions sheet.
See why interest on a revolving credit facility creates a loop, and how a circularity switch breaks it without breaking the model.
Eight checks and a total, and how to find the first error when one fails.
Who it's for
Build the practical modelling know-how that interviews and case studies test.
Tighten the structure and the checks in the models you already build.
Perfect for your Continuing Professional Development and on-the-job learning.
Walk into your first modelling test having already built the real thing.
What's inside
One company, start to finish: 1h38m of video across 24 lessons, with a model that checks itself at every step.
From the annual report to a model that balances
Circularity, debt, and the checks that catch your mistakes
The point of this course
"Real annual reports are messier than templates, so if you can build this model and explain every number in it, you can handle the modelling tests that come up in interviews and on the job."
A full model of a real listed company, built by you, balancing in every forecast year.