Building Your First Three-Statement Financial Model

A three-statement model connects the income statement, balance sheet and cash flow statement so that a single assumption — say, revenue growth — flows correctly through all three. It’s the backbone of valuation, budgeting and scenario planning.

Start with the income statement

Build revenue from clear drivers (volume × price), then layer in costs as percentages or fixed amounts. Keep assumptions in their own clearly labelled section — never hard-code numbers inside formulas.

Link the balance sheet

Working capital, debt schedules and equity roll forward from the income statement. This is where discipline pays off: every line should trace back to a driver.

Let cash flow fall out

The cash flow statement is largely a by-product of the other two. If your model is linked correctly, the balance sheet will balance automatically — the single best check that your logic holds.

• Colour-code inputs, formulas and links so reviewers can navigate quickly.
• Add error checks (does the balance sheet balance? is cash consistent?).
• Build one clean scenario before adding sensitivity toggles.

Master the mechanics once and every future model becomes faster and more reliable.