An integrated three-statement model forecasts the income statement, balance sheet and cash flow statement together, with every line linked so that a change in one assumption flows through all three. It is the backbone of business plans, lending proposals, valuations and transaction analysis. Its great strength is internal consistency: if the model balances, profit, cash and financial position all tell the same story.
What you will learn
- Explain how the three statements link in a forecast
- Build a forecast in a logical order from assumptions to a balanced balance sheet
- Use cash as the balancing item and add a revolving facility for shortfalls
- Diagnose a balance sheet that does not balance
How the statements link
Links in a three-statement model
- AssumptionsGrowth, margins, working capital days, capex, financing
- Income statementRevenue to net profit
- Supporting schedulesWorking capital, fixed assets, debt, equity
- Cash flow statementProfit adjusted to cash; closing cash
- Balance sheetAssets = liabilities + equity
The essential links:
- Net profit from the income statement → starts the cash flow statement (indirect method) and adds to retained earnings.
- Depreciation → reduces profit, is added back in the cash flow statement and reduces fixed assets.
- Working capital balances → their changes appear in operating cash flow.
- Capital expenditure → investing cash flow and fixed assets.
- Borrowing and repayment → financing cash flow and debt balances; interest → income statement.
- Dividends and share issues → financing cash flow and equity.
- Closing cash from the cash flow statement → cash on the balance sheet.
Building it in order
- Historical statements — enter two or three years, cleaned of one-off items, as a base.
- Assumptions — revenue growth or drivers, margins, working capital days, capital expenditure, depreciation rates, interest rates, tax rate, dividend policy.
- Income statement down to operating profit, using revenue and expense forecasts.
- Supporting schedules — fixed assets and depreciation, working capital, debt and interest, equity — see debt and depreciation schedules.
- Complete the income statement — interest and tax.
- Cash flow statement — profit, add-backs, working capital changes, investing and financing flows.
- Balance sheet — every line from a schedule or from the cash flow statement; cash from the cash flow statement.
- Check — total assets minus total liabilities and equity must equal zero in every period.
Worked example
Worked example: a one-year integrated forecast
Opening balance sheet (illustrative figures): cash 100, receivables 200, inventory 150, fixed assets 500 (total 950); payables 120, debt 300, share capital 200, retained earnings 330 (total 950).
Assumptions for the year: revenue 1,200; cost of sales 720; operating expenses 250; depreciation 60; interest 10% of opening debt; tax 25%; receivables 15% of revenue; inventory 20% of cost of sales; payables 15% of cost of sales; capital expenditure 90; debt repayment 50; dividends 40.
Income statement: EBIT = 1,200 − 720 − 250 − 60 = 170; interest = 30; profit before tax = 140; tax = 35; net profit = 105.
Working capital: receivables 180 (down 20), inventory 144 (down 6), payables 108 (down 12).
Cash flow statement:
| Net profit | 105 |
| Add depreciation | 60 |
| Decrease in receivables | +20 |
| Decrease in inventory | +6 |
| Decrease in payables | −12 |
| Operating cash flow | 179 |
| Capital expenditure | −90 |
| Debt repayment | −50 |
| Dividends | −40 |
| Change in cash | −1 |
Closing balance sheet:
| Assets | Liabilities and equity | ||
|---|---|---|---|
| Cash (100 − 1) | 99 | Payables | 108 |
| Receivables | 180 | Debt (300 − 50) | 250 |
| Inventory | 144 | Share capital | 200 |
| Fixed assets (500 + 90 − 60) | 530 | Retained earnings (330 + 105 − 40) | 395 |
| Total | 953 | Total | 953 |
The balance sheet balances, confirming that the three statements are consistent.
Cash as the balancing item, and the revolver
In a correctly linked model, cash is not "plugged" — it is calculated by the cash flow statement, and the balance sheet balances as a result. But forecasts can produce negative cash, which is impossible in reality. The usual solution is a revolving credit facility (revolver) in the debt schedule: when cash would fall below a minimum, the revolver draws the shortfall; when cash is in surplus, it repays. This keeps cash at or above the minimum and shows how much short-term funding the plan needs — the same insight as a cash budget, over a longer horizon.
Circularity
Interest depends on debt; debt (through the revolver) depends on cash; cash depends on interest. Calculating interest on average balances creates a circular reference. Options: calculate interest on opening balances (simple, slightly less accurate); allow iterative calculation with a circuit-breaker switch that can set interest to zero if the loop breaks; or calculate interest in a way that avoids circularity. Whatever the choice, document it — see modelling best practices.
When the balance sheet does not balance
- Find the first period where the difference appears.
- Check whether the difference equals a specific item (a dividend, depreciation, a change in a working capital line) — or twice an item, which suggests a sign error.
- Check that every balance sheet movement has a corresponding cash flow line, and vice versa.
- Confirm that cash on the balance sheet comes from the cash flow statement, not typed in.
- Never force the balance with a plug.
Using the model
Once built, a three-statement model supports DCF valuation, ratio analysis of the forecast, covenant tests for lenders, and scenario analysis. Its consistency means a pessimistic sales assumption automatically shows the effect on margins, working capital, borrowing and leverage.
Common mistakes
- Plugging the balance sheet with a balancing figure.
- Forgetting a link — for example dividends deducted from cash but not from retained earnings.
- Ignoring negative cash instead of adding a revolver.
- Forecasting working capital as a fixed amount when it should move with sales.
- Letting circularity break the model without a switch.
Key terms
- Integrated model — a model in which the three financial statements are fully linked.
- Supporting schedule — a calculation for one area, such as debt or fixed assets, feeding the statements.
- Revolving credit facility — a flexible borrowing line that draws and repays as cash requires.
- Circular reference — a calculation loop, such as interest depending on debt that depends on interest.
- Plug — a forced balancing figure; a sign of an incomplete model.
Frequently asked questions
Why must the balance sheet balance?
Because every transaction has equal effects on both sides of the accounting equation. If a correctly linked model does not balance, a link is missing or wrong.
Should I forecast monthly or annually?
Annual for strategic plans and valuations; monthly or quarterly when liquidity, seasonality or covenant testing matters.
Is it acceptable to calculate interest on opening balances?
Yes, if documented. It avoids circularity at the cost of small inaccuracy when balances change a lot during the year.
Key takeaways
- A three-statement model links profit, cash and financial position through supporting schedules.
- Build in order: assumptions, income statement, schedules, cash flow, balance sheet, checks.
- Cash is calculated, not plugged; a revolver handles shortfalls.
- If the balance sheet does not balance, trace the first difference to a missing or wrong link.