Country: Qatar
You are in the Qatar edition. Type your country to switch.
Nigeria
Middle East
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Qatar edition, with examples in riyals and from Qatar.
Your learning profile
Financial modelling · Lesson 1 of 6
Building a three-statement model
A three-statement model forecasts the income statement, balance sheet and cash-flow statement together from a short list of drivers. The statements are linked so that profit flows into equity, cash flows into the balance sheet, and the balance sheet balances in every period. That check is what makes the model trustworthy.
This lesson is complete in writing. A video for it is on its way.
What you will learn
- By the end you can lay out a financial model with separate inputs, historical figures, calculations and outputs.
- You can forecast the income statement and balance sheet from a short list of drivers.
- You can link the three statements so that profit, cash and the balance sheet stay consistent in every period.
- You can use a balance check to find errors and handle the circular reference that interest on debt and cash can create.
Key terms in this lesson
- Three-statement model
- A financial model that forecasts the income statement, balance sheet and cash-flow statement together, linked so that they stay consistent.
- Income statement
- A financial statement showing a company's revenue, costs and profit over a period.
- Balance sheet
- A snapshot of what a company owns, what it owes and the equity left for shareholders on a given date.
- Forecast driver
- An assumption, such as a growth rate, margin or number of days, from which a model calculates forecast figures.
- Balance check
- A line in a model that subtracts total liabilities and equity from total assets in every period. Any result other than zero means there is an error.
- Revolving credit facility
- A loan a company can draw, repay and draw again up to a limit, often used in models to fund any cash shortfall.
- Circular reference
- A formula that depends, directly or through other cells, on its own result, such as interest that depends on cash that depends on interest.
- Step 1: Why model all three statements, not started
- Step 2: Layout: inputs, history, calculations and outputs, not started
- Step 3: Forecasting from drivers, not started
- Step 4: Linking the statements and the balance check, not started
- Step 5: Debt, interest and the circular reference, not started
About 10 min of reading
Step 1 of 5
Why model all three statements
Opening this step…
Step 2 of 5
Layout: inputs, history, calculations and outputs
This step opens when you finish the one above.
Step 3 of 5
Forecasting from drivers
This step opens when you finish the one above.
Step 4 of 5
Linking the statements and the balance check
This step opens when you finish the one above.
Step 5 of 5
Debt, interest and the circular reference
This step opens when you finish the one above.
Key takeaways
The key takeaways open when you finish every step.
Lesson quiz
6 questions. You need 85% to pass.
The quiz opens when you finish every step.
Read first
Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.
Popular this week: Basics: BeginnerStock market: Intermediate