Skip to content
Edition NigeriaGlobal
Country: Burkina Faso

You are in the Burkina Faso edition. Type your country to switch.

Set up your profile

You are learning in the Burkina Faso edition, with examples in cfa francs and from Burkina Faso.

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.

Advanced11 min read5 steps

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 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.

Up next

Financial data & analyticsBuilding a DCF in a modelRead nowBuilding a DCF in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsChecking a financial modelRead nowChecking a financial modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsCommon financial modelling errorsRead nowCommon financial modelling errorsFinancial data & analytics · Advanced · 15 minValuation & company analysisReading the three financial stat…Read nowReading the three financial statements togetherValuation & company analysis · Intermediate · 15 minFinancial data & analyticsBuilding a simple valuation mode…Read nowBuilding a simple valuation model from dataFinancial data & analytics · Intermediate · 15 minValuation & company analysisWorking capital: receivables, in…Read nowWorking capital: receivables, inventory and payablesValuation & company analysis · Intermediate · 15 minFinancial data & analyticsReturns, CAGR and volatility in …Read nowReturns, CAGR and volatility in a spreadsheetFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsPresenting a financial modelRead nowPresenting a financial modelFinancial data & analytics · Advanced · 15 minFinancial data & analyticsPivot tables for financial dataRead nowPivot tables for financial dataFinancial data & analytics · Intermediate · 15 min
English