The Three-Statement Financial Model, Explained
By Newtown Analytics · · 8 min read
For finance, fp&a & accounting managers
A three statement financial model links the income statement, the balance sheet and the cash flow statement so that a change in one flows correctly through the others. Revenue and costs produce profit; profit, working capital, investment and financing produce cash; cash and everything else sit on the balance sheet, which must balance. Because the statements are linked by formula, you can ask what happens to cash if customers pay later or what happens to profit if you borrow more, and the answer is consistent. This guide explains the links, builds a complete one-year example whose balance sheet balances, shows how a single assumption change moves all three statements, covers circular references and checks, and lists common errors. It is part of budgeting and forecasting and leads into how to build a financial model, the model template and the individual statements: income statement forecast and balance sheet forecast.
What each statement does
| Statement | Question it answers | Basis |
|---|---|---|
| Income statement | Did we make a profit over the period? | Accrual: revenue when earned, costs when incurred |
| Balance sheet | What do we own and owe at a point in time? | Snapshot at period end |
| Cash flow statement | Where did cash come from and go? | Explains the change in cash between two balance sheets |
How they link
| From | To | Link |
|---|---|---|
| Net income | Balance sheet equity | Added to retained earnings |
| Net income | Cash flow statement | Starting point for operating cash flow |
| Depreciation | Income statement, balance sheet, cash flow | Expense on income statement; reduces fixed assets; added back in cash flow because it is non-cash |
| Change in receivables, inventory, payables | Cash flow statement | Increase in an asset uses cash; increase in a liability provides it |
| Capital expenditure | Balance sheet, cash flow | Increases fixed assets; cash outflow from investing |
| Debt borrowing or repayment | Balance sheet, cash flow | Changes debt; financing cash flow |
| Interest | Income statement | Calculated from debt balance and rate |
| Dividends | Equity, cash flow | Reduces retained earnings; financing outflow |
| Ending cash on cash flow statement | Balance sheet cash | Must equal |
A complete one-year example
All figures are in thousands of dollars and are hypothetical.
Opening balance sheet (end of Year 0)
| Assets | Liabilities and equity | ||
|---|---|---|---|
| Cash | 210 | Accounts payable | 120 |
| Accounts receivable | 150 | Debt | 300 |
| Inventory | 240 | Equity | 580 |
| Fixed assets, net | 400 | ||
| Total assets | 1,000 | Total liabilities and equity | 1,000 |
Year 0 revenue was 1,000 and cost of goods sold was 600.
Assumptions for Year 1
| Item | Assumption |
|---|---|
| Revenue | 1,200 |
| Cost of goods sold | 60% of revenue |
| Operating expenses (cash) | 240 |
| Depreciation | 50 |
| Interest | 6% of opening debt |
| Tax | 25% of profit before tax |
| Receivables | 15% of revenue |
| Inventory | 40% of cost of goods sold |
| Payables | 20% of cost of goods sold |
| Capital expenditure | 80 |
| Debt repayment | 30 |
| Dividends | 40 |
Interest is calculated on the opening debt to avoid a circular reference (more on this below).
Income statement, Year 1
| Line | Calculation | Amount |
|---|---|---|
| Revenue | 1,200 | |
| Cost of goods sold | 60% × 1,200 | (720) |
| Gross profit | 480 | |
| Operating expenses | (240) | |
| Depreciation | (50) | |
| Operating profit (EBIT) | 190 | |
| Interest | 6% × 300 | (18) |
| Profit before tax | 172 | |
| Tax | 25% × 172 | (43) |
| Net income | 129 |
Working capital balances at the end of Year 1
| Item | Calculation | Opening | Closing | Change |
|---|---|---|---|---|
| Receivables | 15% × 1,200 | 150 | 180 | +30 |
| Inventory | 40% × 720 | 240 | 288 | +48 |
| Payables | 20% × 720 | 120 | 144 | +24 |
Cash flow statement, Year 1
| Line | Amount |
|---|---|
| Net income | 129 |
| Add back depreciation | 50 |
| Increase in receivables | (30) |
| Increase in inventory | (48) |
| Increase in payables | 24 |
| Cash from operations | 125 |
| Capital expenditure | (80) |
| Cash from investing | (80) |
| Debt repayment | (30) |
| Dividends | (40) |
| Cash from financing | (70) |
| Net change in cash | (25) |
| Opening cash | 210 |
| Closing cash | 185 |
Check: 129 + 50 - 30 - 48 + 24 = 125. 125 - 80 - 70 = -25. 210 - 25 = 185.
Closing balance sheet (end of Year 1)
| Assets | Liabilities and equity | ||
|---|---|---|---|
| Cash | 185 | Accounts payable | 144 |
| Accounts receivable | 180 | Debt (300 - 30) | 270 |
| Inventory | 288 | Equity (580 + 129 - 40) | 669 |
| Fixed assets, net (400 + 80 - 50) | 430 | ||
| Total assets | 1,083 | Total liabilities and equity | 1,083 |
Total assets: 185 + 180 + 288 + 430 = 1,083. Liabilities and equity: 144 + 270 + 669 = 1,083. The balance sheet balances, and the difference is zero. Notice that profit was 129 yet cash fell by 25. The reason is visible in the cash flow statement: 102 of cash went into receivables and inventory net of payables (30 + 48 - 24), and 80 into equipment. Profit is not cash, and a model that shows both is the reason to build one.
One change, three statements
Suppose customers pay more slowly and receivables are 20 percent of revenue instead of 15.
- Receivables = 20% × 1,200 = 240, an increase of 90 (not 30).
- Cash from operations = 125 - 60 = 65, so closing cash falls to 185 - 60 = 125.
- The income statement does not change at all: profit is still 129.
- The balance sheet: assets are cash 125 + receivables 240 + inventory 288 + fixed assets 430 = 1,083. Total assets are unchanged, because 60 of cash became 60 of receivables. Liabilities and equity are unchanged, so the balance sheet still balances.
The example shows that slower collections do not touch profit but cost 60 of cash. If the company had minimum cash requirements or loan covenants, the model would flag the problem. See cash flow management.
Circular references
The classic circularity is interest on average debt or cash: interest depends on the average balance, the balance depends on cash flow, and cash flow depends on interest. Options:
| Option | Trade-off |
|---|---|
| Interest on opening balances | Simple, no circularity, slightly less precise |
| Iterative calculation with a circuit-breaker switch | More precise, but can become unstable; always include a switch to turn it off |
| Algebraic solution | Exact but harder to audit |
For most business planning, opening balances are sufficient. Use the simplest approach that the decision requires.
Financing: revolvers and cash sweeps
Real models often include a revolving credit line that draws automatically when cash would fall below a minimum and repays when there is surplus cash. Build it as a separate section: required cash minus available cash before the revolver gives the draw or repayment. Add interest on the revolver and watch for circularity. Do not use cash as the plug that makes the balance sheet balance; the balance should result from correct logic.
Checks every model needs
| Check | Rule |
|---|---|
| Balance sheet balances | Assets minus liabilities and equity equals zero in every period |
| Cash reconciles | Closing cash on the cash flow statement equals cash on the balance sheet |
| Retained earnings roll | Opening + net income - dividends = closing |
| Fixed assets roll | Opening + capex - depreciation = closing |
| Debt rolls | Opening + borrowings - repayments = closing |
| Signs | Increases in assets reduce cash; increases in liabilities add cash |
| No hard-coded plugs | Search for typed numbers in formula rows |
See the financial model audit checklist for a fuller review list.
When you need a three-statement model
| Situation | Need? |
|---|---|
| Raising debt or equity | Yes, lenders and investors expect it |
| Planning with significant working capital or capex | Yes |
| Covenant forecasting | Yes |
| Simple service business with no balance sheet complexity | Often an income statement and cash forecast suffice |
| Short-term cash only | A 13-week cash forecast is more useful |
Link to operations and unit economics
The statements are only as good as the operational drivers that feed them: volumes, prices, costs, lead times and payment terms. Link the model to a sales forecast and, where relevant, a demand and inventory plan. See demand planning and inventory optimization and unit economics.
Common errors
- Forgetting to add back depreciation in the cash flow.
- Reversing the sign of working capital changes.
- Using closing balances for ratios when averages are intended, or the reverse, inconsistently.
- Hard-coding a balancing figure.
- Ignoring tax payment timing, accrued expenses and prepaid items.
- Letting interest, debt and cash create an unmanaged circularity.
- Mixing units or periods.
- Building a model so complex that the owner cannot explain it.
FAQs
What is a three statement financial model?
A model that links the income statement, balance sheet and cash flow statement so that changes in assumptions flow through all three and the balance sheet balances.
Why does the balance sheet need to balance?
Because every transaction has two sides. If it does not balance, there is an error in the logic.
Why does net income differ from cash flow?
Because of non-cash items such as depreciation, changes in working capital, investment and financing flows.
What is a circular reference in a financial model?
A formula chain that depends on itself, often interest calculated on balances that depend on interest. Avoid it by using opening balances or add a switch if you iterate.
Do small businesses need three statements?
Not always, but anyone raising money, managing covenants or carrying significant working capital benefits from one.
Keep reading
This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.