How to Build a Three-Statement Financial Model

The three-statement model — an integrated forecast of the income statement, balance sheet and cash flow statement — is the foundation on which valuation models, merger models and LBO models are built. Master it, and every other model becomes a variation on a theme.

Step 1: Lay the foundation

Start with three to five years of historical financial statements. Build a clean timeline: columns are periods, rows are line items, and the convention never varies. Create a dedicated assumptions section — every forecast input lives here, formatted distinctly (blue font for hardcodes is the classic convention), never buried inside formulas.

Step 2: Forecast the income statement

Revenue drives everything. Forecast it from drivers where possible — volume times price, customers times average revenue — rather than a bare growth rate. Then layer in costs: variable costs scale with revenue, fixed costs grow in steps. The result is a projected path from revenue down to operating profit.

Step 3: Build the supporting schedules

The balance sheet cannot be forecast line by line; it needs schedules:

• Working capital — receivables, inventory and payables forecast in days (DSO, DIO, DPO)
• Fixed assets — opening balance plus capex minus depreciation
• Debt — opening balance plus drawdowns minus repayments, with interest computed on the appropriate balance
• Tax — the statutory rate applied to profit before tax, adjusted for permanent differences

Step 4: Articulate the statements

Articulation is the discipline of linkage. Net income flows from the income statement into equity and into the top of the cash flow statement. Working capital changes flow from the balance sheet into operating cash flow. Capex flows to investing cash flow. Debt movements flow to financing cash flow. And the closing cash balance on the cash flow statement becomes the cash line on the balance sheet.

Step 5: Prove it works

Two checks are non-negotiable, visible on every sheet, and must always equal zero: the balance check (assets minus liabilities minus equity) and the cash check (closing cash on the cash flow statement minus cash on the balance sheet). When a model breaks, the first broken period is where the error lives — trace it upstream from there.

The craft beyond the mechanics

The mechanics take weeks to learn. The craft takes years: knowing which assumptions matter, where businesses leak cash, how growth consumes working capital, and why a model that balances can still be wrong. That judgement comes from building, reviewing and — above all — being wrong and finding out why.

Next: use the model as the engine for a DCF valuation, and pressure-test it with the best practices checklist.