Guide
3 statement model
How to build an integrated income statement, balance sheet and cash flow model that balances in every period and in every scenario — and the checks that prove it does.
Written by CA Pranay Bhansali, Founder & Principal, Volaxi — Chartered Accountant (ICAI), former senior buy-side research analyst.
Last reviewed September 2026 · LinkedIn
The short answer
A three-statement model links the income statement, balance sheet and cash flow statement so one set of drivers moves all three — and the balance sheet still balances.
Build it in order: assumptions, operating build, working capital, fixed assets, debt schedule, cash flow statement, balance sheet. Calculate interest on opening balances so the model stays non-circular. Then prove it with a balance check that holds in every period and every scenario. Everything below is that sequence in detail.
The guide in summary
| Topic | What it covers |
|---|---|
| What it is | Income statement, balance sheet and cash flow statement linked so one set of drivers moves all three. |
| Build order | Assumptions, operating build, working capital, fixed assets, debt schedule, then cash flow and the balance sheet. |
| The link that matters | Net income flows to retained earnings; the cash flow statement's closing cash becomes the balance sheet cash line. |
| Circularity | Interest on opening debt balances keeps the model non-circular and reviewable. |
| Proof it works | Assets equal liabilities plus equity in every period, in every scenario — not just the base case. |
| Typical build time | A clean single-entity model: one to three days. Multi-entity or messy ledgers take longer. |
01
Structure before formulas
A three-statement model is judged on whether someone else can audit it in an hour. That is decided by structure, not by cleverness. One tab for inputs, one for the build, one for outputs, one for checks — and nothing typed into a calculation tab, ever.
Colour discipline does the rest: blue for inputs, black for formulas, green for links to other tabs. A reviewer who sees black where blue should be knows immediately that someone has hardcoded over a formula.
Assumptions
Every input the model uses, on one tab, with units and source noted against each.
Model
Operating build, working capital, fixed assets, debt, then the three statements themselves.
Outputs
Summary, returns or valuation — read-only, sourced entirely from the model tab.
Checks
Balance check, cash check, sign checks, and one master line that reads TRUE or FALSE.
02
The income statement: drivers, not growth rates
Revenue built as a single percentage growth rate is not a model, it is a guess in a spreadsheet. Build revenue from the units the business actually manages — volume and price, customers and ARPU, contracts and realisation — because those are the only lines an operator can argue with or defend.
Below revenue, split costs into variable and fixed. Depreciation comes from the fixed asset schedule, not typed in. Interest comes from the debt schedule. Tax is calculated on profit before tax with a separate cash tax rate where the two diverge.
03
Working capital: where the cash flow is won or lost
Receivables, inventory and payables are forecast on days — DSO, DIO, DPO — applied to revenue or cost of sales. The movement in net working capital, not the balance, is what hits cash flow. Getting the sign wrong here is the single most common error in a model that otherwise looks professional: an increase in receivables is a cash outflow.
Where a business has seasonality, annual days will understate the swing. Model monthly or, at minimum, disclose that the annual view hides a peak funding requirement.
04
Fixed assets and the debt schedule
The fixed asset schedule rolls opening net book value plus capex less depreciation to closing. The debt schedule rolls opening balance plus drawdowns less mandatory amortisation less any cash sweep to closing.
Calculate interest on the opening balance. Calculating it on the average of opening and closing creates a circular reference — cash drives debt, debt drives interest, interest drives cash — and a model that needs iterative calculation switched on is a model nobody else will trust. Where precision genuinely matters, the average-balance refinement belongs in a documented, optional switch, not the default.
05
The cash flow statement is the joint
Build it indirect: net income, add back non-cash charges, less the movement in working capital, less capex, plus or less financing movements. Closing cash is opening cash plus the net movement — and that closing cash figure is what the balance sheet cash line points to.
This is the link that makes the model integrated. Everything else is arithmetic; this is the joint that makes the three statements one model rather than three schedules sitting next to each other.
06
The checks that prove it
A three-statement model that does not balance is not a model. Put the checks on their own tab, and put one master line at the top of every other tab so a failure is impossible to miss.
Balance check
Total assets less total liabilities and equity equals zero, in every forecast period.
Cash check
Balance sheet cash equals the cash flow statement's closing cash.
Retained earnings
Opening retained earnings plus net income less dividends equals closing.
Debt roll
Closing debt on the balance sheet equals the debt schedule's closing balance.
Scenario check
The model balances under upside and downside too — not only the base case.
No hardcodes
No typed numbers anywhere outside the assumptions tab.
07
The mistakes that get models rejected
In review work, the same faults recur. None of them are exotic.
Plugs
A balancing figure inserted to force the balance sheet to tie. It hides the real error and destroys credibility the moment it is found.
Hardcodes inside formulas
A number typed into the middle of a calculation cannot be found by a reviewer and will not flex in a scenario.
Circular interest
Iterative calculation switched on, and a model that breaks into #VALUE! the first time an input is changed.
Working capital signs
An increase in receivables shown as a cash inflow — silently overstating cash generation every period.
No scenario architecture
Scenarios pasted over inputs instead of driven by a switch, so the base case is lost the first time downside is run.
Depreciation typed in
Not driven by the fixed asset schedule, so capex changes without any effect on profit.
Common questions
What is a 3 statement model?
A financial model in which the income statement, balance sheet and cash flow statement are linked by formulas, so that changing one assumption flows correctly through all three and the balance sheet still balances.
What order should you build a 3 statement model in?
Assumptions first, then the operating build down to EBITDA, then working capital, fixed assets and the debt schedule, then the cash flow statement, and the balance sheet last — because the balance sheet is where every prior schedule has to reconcile.
Why does my 3 statement model not balance?
Almost always one of four things: a working capital movement with the wrong sign, depreciation added back inconsistently, a debt movement recorded in the cash flow statement but not rolled on the balance sheet, or retained earnings not picking up net income. Check those four before looking anywhere else.
Should interest be calculated on opening or average debt balances?
Opening balances. Average balances create a circular reference between cash, debt and interest, which requires iterative calculation and makes the model fragile and hard for a third party to review.
How long does it take to build a 3 statement model?
A clean single-entity model from reliable historical accounts takes one to three days. Multi-entity groups, poor ledger quality or reconstructed historicals take considerably longer, and that reconstruction is usually the real work.
Discuss an Engagement
If you require support with financial modelling, business valuation or financial due diligence for a live transaction or strategic engagement, we'd be pleased to discuss your requirements.