How to Build a Three-Statement Financial Model: A Step-by-Step Guide

What Is a Three-Statement Model?

A three-statement financial model is the foundation of almost all financial modelling work. It integrates three financial statements — the income statement, balance sheet, and cash flow statement — into a single model where changes in one statement automatically flow through to the others. Once built correctly, you can change a revenue assumption and see the full impact on profit, cash generation, debt levels, and balance sheet position simultaneously.

Why Finance Professionals Need This Skill

Three-statement models underpin budgets, forecasts, M&A analysis, business valuations, and lending decisions. Whether you work in FP&A, corporate finance, investment banking, or commercial finance, you will encounter this structure. CIMA and ACCA qualifications teach the accounting behind each statement — the three-statement model teaches you to make them work together dynamically.

Step 1: Build the Income Statement

Start with revenue. Build a simple revenue model — units times price, or revenue by segment. Then layer in cost of goods sold (COGS) to get gross profit, followed by operating expenses to get EBIT (earnings before interest and tax). Keep interest expense as a placeholder for now — it will be linked to the balance sheet debt balance later. Arrive at profit before tax, apply the tax rate, and calculate net profit.

Step 2: Build the Balance Sheet Structure

Build the balance sheet with assets (fixed assets, working capital, cash) on one side and liabilities plus equity on the other. Fixed assets move based on capex minus depreciation. Working capital items — trade receivables, inventory, trade payables — are driven by the income statement via days metrics (DSO, DIO, DPO). Equity increases by net profit minus dividends. Debt is initially a plug — you will return to it.

Step 3: Build the Cash Flow Statement

The cash flow statement reconciles profit to cash. Start with net profit, add back depreciation (non-cash), then adjust for working capital movements. Add capex as a cash outflow. Add debt drawdowns and repayments, and dividend payments. The closing cash balance must equal the cash on the balance sheet — this is your primary check that the model balances.

Step 4: Link the Statements

This is where the model comes alive. Interest expense on the income statement should be linked to opening debt on the balance sheet multiplied by the interest rate. The closing cash on the cash flow statement must feed into the balance sheet. Net profit flows from the income statement into retained earnings on the balance sheet. The model should now balance — assets equal liabilities plus equity — and any assumption change should cascade through all three statements automatically.

Common Mistakes

Circular references caused by linking interest expense to debt that is itself a function of cash — use an iterative calculation setting or break the circularity with a manual toggle. Hard-coding numbers instead of referencing input cells. Mixing time periods. Forgetting to include all working capital line items. The best models are simple, clearly structured, and fully formula-driven with no hardcoded values in the main model body.