Three-Statement Model Build Checklist
Executive Summary
Key Takeaways
- ✓ A three-statement model is not complete simply because all three statements are populated — it is complete once the specific structural checks in this list all pass.
- ✓ The balance sheet balancing in every period and the cash flow statement's ending cash tying to the balance sheet are the two most fundamental, mechanically verifiable checks.
- ✓ Circular references, where present, should be identified, documented, and controlled rather than left as an uncontrolled default of the model's iterative calculation setting.
- ✓ This is a construction-time self-check, not a substitute for a full independent structural audit performed once the model is complete.
Objective¶
This checklist sets out the specific structural checks that confirm a three-statement model's income statement, balance sheet, and cash flow statement are correctly integrated. It assumes the individual statements and their supporting schedules (working capital, capex and depreciation, debt, equity) have already been built, and focuses specifically on the linkages between them, as described in full mechanical detail on Statement Linking Mechanics.
This is a construction-time self-check, applied by the model's own builder progressively during assembly, distinct from an independent structural audit performed once the model is complete.
Applicability¶
Applicable to any three-statement financial model, regardless of industry, once the income statement, balance sheet, cash flow statement, and their supporting schedules are in place and connected. Most effective applied after each supporting schedule is connected, rather than only once as a single pass at the end of the build.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | Balance sheet balances (Assets = Liabilities + Equity) in every forecast period | A hard accounting identity — its failure is the clearest, most mechanically verifiable signal of a structural linkage error | Balance sheet check row (Assets minus Liabilities minus Equity) confirmed at zero for every period |
| 2 | Cash flow statement's ending cash ties to the balance sheet's cash line in every period | Confirms the cash flow statement and balance sheet are correctly connected, independent of whether the balance sheet happens to balance for another reason | Ending cash comparison row confirmed at zero variance for every period |
| 3 | Net income flows to retained earnings without a broken or hardcoded link | The primary connection between the income statement and balance sheet | Retained earnings formula trace confirming reference to the income statement's net income cell |
| 4 | Net income is the starting line of the cash flow statement's operating section (indirect method) | Confirms the income statement and cash flow statement reference the identical net income figure | Formula trace confirming both retained earnings and CFO operating section reference the same cell |
| 5 | No uncontrolled circular reference exists between the debt schedule, interest expense, and cash availability | An uncontrolled circularity produces calculation instability that varies with a user's iterative calculation settings | List of any retained circular references with the resolution method and circuit breaker documented |
| 6 | Working capital adjustments in the cash flow statement follow the correct sign convention | A reversed sign produces an operating cash flow figure moving in the wrong direction relative to the underlying balance sheet change | Spot-check of at least one working capital line against the direction its underlying balance actually moved |
| 7 | Depreciation is applied consistently across the income statement, balance sheet, and cash flow statement | All three should reference the same depreciation schedule output; a disconnected figure allows silent divergence | Formula trace confirming all three statements reference the same depreciation schedule cell |
| 8 | Capital expenditure ties to the depreciation schedule's fixed asset roll-forward | Confirms the cash flow statement's investing outflow matches the balance sheet's actual fixed asset build | Capex figure on the cash flow statement reconciled to the depreciation schedule's period additions |
| 9 | Debt schedule's closing balance ties to the balance sheet's debt line, and interest expense ties to the income statement | Confirms the debt schedule is fully connected to both statements it should feed, not left as a standalone assumption | Formula trace from debt schedule closing balance and interest expense to their respective statement lines |
| 10 | Any balancing mechanic (cash sweep or revolver) is disclosed and clearly distinguishable from an undisclosed plug | An undisclosed plug masks a genuine structural error rather than resolving one | Balancing mechanic documented in the model's assumptions or notes |
| 11 | Balance sheet balancing and cash tie-out checks are re-run after every material structural change | Catching an imbalance immediately after the change that caused it is far faster than tracing it back later | Dated log of checks performed alongside major model revisions |
Common Failures¶
- The balance sheet appears to balance because a plug cell has been adjusted to force it, masking a genuine break in the retained earnings or cash flow linkage that would otherwise be visible.
- Depreciation hardcoded independently on the income statement rather than pulled from the depreciation schedule, allowing the two figures to diverge silently as the model is updated.
- A revolver or cash sweep mechanic implemented correctly but never documented, leaving a reviewer unable to distinguish it from an undisclosed plug on inspection alone.
- Working capital sign conventions correct in the model's first built period but broken in a later period after a row insertion or a copied-and-pasted formula that was not fully checked.
Recommended Evidence¶
A completed pass against this checklist should be accompanied by a short note recording the date, the specific periods checked, and any items corrected. Where a circular reference is retained, its resolution method (opening-balance interest calculation, or iterative calculation with a documented circuit breaker) should be recorded explicitly, since a subsequent reviewer or auditor will need this to assess whether the circularity is controlled.
How to Use This Checklist¶
Apply this checklist after each supporting schedule (working capital, capex and depreciation, debt, equity) is connected to the three core statements, rather than waiting until the entire model is believed complete. Confirming Checks 1 and 2 — the balance sheet balancing and the cash tie-out — after every material change is the single highest-value habit this checklist recommends, since both are hard, mechanically verifiable tests that immediately localize a structural error to the change that introduced it.
Continue Reading¶
Related Pillars¶
Related Glossary¶
Related Technical Guides¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
When should this checklist be applied?
Progressively during the build, after each supporting schedule (working capital, capex and depreciation, debt, equity) is connected to the three core statements, and again as a final pass once the model is believed complete.
What is the single most important check on this list?
That the balance sheet balances — Assets equal Liabilities plus Equity — in every forecast period, since this is a hard accounting identity that can be verified mechanically rather than through commercial judgement, and its failure is the clearest signal that a structural error exists somewhere in the model.
Does passing this checklist mean the model's assumptions are correct?
No. This checklist confirms the three statements are structurally integrated and internally consistent. It does not, and cannot, confirm that the underlying commercial assumptions — growth rates, margins, working capital days — are themselves reasonable.
How is this different from a full structural model audit?
This checklist is a construction-time self-check applied by the model's own builder, focused specifically on three-statement integration. A full structural audit is typically performed independently, after the model is complete, and covers a broader set of structural risks beyond statement linkage specifically.
What should I do if the balance sheet does not balance?
Work backward through the specific linkages set out on the Statement Linking Mechanics technical guide — net income to retained earnings, working capital sign conventions, the debt and capex schedule connections — rather than adjusting a cell directly to force the balance sheet to tie out.
How often should the balance sheet balancing check be performed?
After every material structural change to the model, not only once at the end of the build. Catching an imbalance immediately after the change that caused it is significantly faster than tracing it back through an accumulation of subsequent changes.
Is a documented circular reference acceptable in a three-statement model?
Yes, where it reflects a genuine financial simultaneity (such as interest expense depending on average debt balance, which itself depends on cash flow affected by interest expense) and is deliberately controlled with a circuit breaker, rather than an unintended or uncontrolled default of Excel's iterative calculation setting.
Related Articles
Financial Statements in Financial Modelling
The income statement, balance sheet, and cash flow statement are the three financial statements that together describe a company's or project's performance, financial position, and cash movements. In a financial model, these are not three independent outputs — they are dynamically linked, so that a single change in an assumption flows correctly through all three, and the balance sheet balances in every period as a direct consequence of that linkage rather than as a plug engineered to force it. This page is the hub for the Knowledge Centre's financial statements content: what each statement represents, how a three-statement model integrates them, where financial-statement mechanics anchor broader industry models, and how a structural audit tests statement integration for the errors that most commonly break it.
Three-Statement Model
A three-statement model is a financial model in which the income statement, balance sheet, and cash flow statement are dynamically linked into a single integrated system, so that a change in any assumption flows through correctly to all three, and the balance sheet balances in every forecast period as a direct consequence of that linkage rather than as a plug engineered to force it. It is the structural foundation most other financial models — DCF, LBO, project finance — are built on top of.
Statement Linking Mechanics
Statement linking mechanics are the specific formulas and connections that turn three independently understandable statements into one integrated three-statement model. This guide walks through each linkage step by step: net income flowing to retained earnings and to the top of the cash flow statement, the sign conventions that govern working-capital adjustments, capex and debt movements connecting the statements, and the final ending-cash-to-balance-sheet tie-out that confirms the whole structure holds together. It closes with the specific linking errors most responsible for an out-of-balance model.
Balance Sheet
The balance sheet is a snapshot of a company's or project's financial position at a single point in time, structured around the accounting identity Assets equal Liabilities plus Equity. In a financial model, one line — typically cash or a revolving credit facility — is designated the balancing mechanic, absorbing the residual funding surplus or shortfall the rest of the model produces so the identity holds exactly in every period. A balance sheet that fails to balance is the single most diagnostic signal that a model's statement linkage contains a structural error.
Cash Flow Statement
The cash flow statement reconciles the income statement's accrual-based net income to the actual cash generated or consumed over the same period, split into operating, investing, and financing activities. Its output, the net change in cash, added to the opening cash balance, must equal the closing cash balance — which must, in turn, equal the cash line on the balance sheet. In a financial model, this tie-out is one of the clearest mechanical tests of whether the three statements are correctly linked.
Debt Schedule
A debt schedule is the section of a financial model that tracks the periodic movement of a company's debt balances — drawdowns, scheduled and optional repayments, and the resulting interest expense — from an opening balance to a closing balance each period. It is the mechanism connecting the balance sheet's debt balance to the income statement's interest expense and the cash flow statement's financing section. This entry covers the generic corporate debt schedule; for the DSCR-driven repayment profiling used in project finance, see Debt Sculpting Mechanics.
Capital Expenditure
Capital expenditure (capex) is cash spent acquiring, upgrading, or extending the useful life of a fixed asset — property, plant, and equipment. In a financial model, capex is the investing outflow that increases gross fixed assets on the balance sheet, and the resulting depreciation schedule allocates that cost across the asset's useful life as a charge against the income statement. Capex is commonly split into maintenance capex (sustaining the existing asset base) and growth capex (expanding it), a distinction that matters directly for free cash flow and returns analysis.