FINANCE · FINANCIAL MODELING
Three-Statement Forecast: Build a Connected Financial Model
A three-statement forecast connects the income statement, balance sheet, and cash-flow statement through one set of operating and financing assumptions. It helps answer three questions together: Will the business earn a profit? What resources and obligations will it carry? Will it have enough cash?
← Finance hub · Rolling forecasts · Working capital
How the three statements connect
| Connection | Where it goes | Why it matters |
|---|---|---|
| Net income | Starts indirect operating cash flow and increases retained earnings | Profit affects cash and equity through different paths. |
| Receivables, inventory, and payables | Balance-sheet movements adjust operating cash flow | Sales and expenses do not always become receipts and payments immediately. |
| Capital expenditure and depreciation | Asset schedule, investing cash flow, and income statement | Buying equipment uses cash; depreciation allocates its cost over time. |
| Borrowing, principal repayment, and dividends | Financing cash flow and debt or equity balances | Principal and dividends are not operating expenses. |
If these distinctions are new, start with profit vs. cash flow and the cash-flow statement guide.
Build the model in seven steps
- Start with a reliable opening balance sheet. Complete reconciliations and the month-end close. Confirm that opening assets equal liabilities plus equity.
- Set the forecast horizon and assumptions. Use consistent monthly, quarterly, or annual periods. Separate assumptions from calculations. Forecast revenue from volume and price where practical; document collection terms, supplier terms, inventory needs, staffing, and investment plans.
- Forecast the income statement. Calculate revenue, cost of goods sold, operating expenses, depreciation, interest, taxes, and net income. Keep depreciation out of other cost lines if it is shown separately.
- Build working-capital schedules. Forecast receivables from collection behavior, inventory from stock needs, and payables from purchase and payment timing. Days-based assumptions are useful approximations; seasonal businesses may need detailed monthly schedules.
- Roll forward assets, debt, and equity. Net fixed assets equal opening net fixed assets plus capital spending less depreciation and disposals. Debt equals opening debt plus borrowing less principal repayments. Retained earnings equal opening retained earnings plus net income less dividends.
- Calculate cash flow and ending cash. Reconcile profit to operating cash, then add investing and financing movements. Feed the resulting ending cash into the balance sheet.
- Run checks and scenarios. Reconcile every statement, review liquidity, and test collection delays, weaker margins, or investment changes before choosing an action.
Worked example: profitable, but cash falls
This original simplified annual forecast uses $000 throughout: 24 means $24,000. It assumes no disposals, new borrowing, equity issuance, other assets or liabilities, or noncash transactions. All operating expenses, interest, and taxes are paid during the year except the changes captured in receivables, inventory, and trade payables. Interest and income taxes are classified as operating cash flows in this illustration; adapt classification to the applicable reporting framework.
The business forecasts revenue of 240, cost of goods sold at 60% of revenue, cash operating expenses of 48, depreciation of 10, interest of 6, and income tax expense of 8. The interest assumption is an explicit input based on the debt payment schedule; it is not calculated from an ending debt balance. Taxes are an illustrative input, not a jurisdiction-specific tax calculation.
| Forecast income statement | $000 |
|---|---|
| Revenue | 240 |
| Cost of goods sold | (144) |
| Gross profit | 96 |
| Cash operating expenses | (48) |
| Depreciation | (10) |
| Operating profit | 38 |
| Interest expense | (6) |
| Profit before tax | 32 |
| Income tax expense | (8) |
| Net income | 24 |
Forecast closing receivables of 40, inventory of 48, and payables of 30 from the collection, stocking, and supplier plans. The business will spend 20 on equipment, repay 12 of debt principal, and pay dividends of 5. Those last three cash uses do not reduce this year’s net income in full.
| Indirect cash-flow forecast | $000 | Calculation |
|---|---|---|
| Net income | 24 | From income statement |
| Add depreciation | 10 | Noncash expense |
| Increase in receivables | (10) | 40 − 30 |
| Increase in inventory | (8) | 48 − 40 |
| Increase in payables | 5 | 30 − 25 |
| Operating cash flow | 21 | 24 + 10 − 10 − 8 + 5 |
| Investing: equipment purchases | (20) | Capital expenditure |
| Financing: debt principal repaid | (12) | Reduces debt |
| Financing: dividends paid | (5) | Reduces retained earnings |
| Change in cash | (16) | 21 − 20 − 12 − 5 |
| Opening cash | 20 | Opening balance sheet |
| Ending cash | 4 | 20 − 16 |
| Balance sheet | Opening $000 | Forecast closing $000 | Link or schedule |
|---|---|---|---|
| Cash | 20 | 4 | Cash-flow forecast |
| Accounts receivable | 30 | 40 | Collection schedule |
| Inventory | 40 | 48 | Inventory schedule |
| Net fixed assets | 100 | 110 | 100 + 20 − 10 |
| Total assets | 190 | 202 | Sum of assets |
| Accounts payable | 25 | 30 | Supplier payment schedule |
| Debt | 60 | 48 | 60 − 12 |
| Contributed capital | 80 | 80 | No new equity |
| Retained earnings | 25 | 44 | 25 + 24 − 5 |
| Liabilities plus equity | 190 | 202 | 30 + 48 + 80 + 44 |
| Balance check | 0 | 0 | Assets − liabilities − equity |
Check the model before using it
- Balance sheet: Assets − liabilities − equity must equal zero in every period.
- Cash: Opening cash + operating + investing + financing cash flow must equal closing cash, which must match the balance sheet.
- Retained earnings: Opening retained earnings + net income − dividends must reconcile to closing retained earnings.
- Assets and debt: Reconcile additions, depreciation, disposals, borrowing, and repayments to their closing balances.
- Assumptions: Check units, signs, period lengths, and whether collections and payments reconcile to revenue, purchases, and outstanding balances.
These checks verify internal consistency. A perfectly balanced model can still use unrealistic assumptions. Compare forecast results with actual outcomes using variance analysis, and review liquidity and leverage using financial ratios.
Test the assumptions that move cash
If closing receivables increase by another 10 while revenue and all other assumptions stay fixed, operating cash flow falls from 21 to 11 and ending cash falls from 4 to −6. That negative cash result signals an unresolved financing need. Model a real funding action, its capacity limits, and its interest cost; do not treat a negative cash balance as usable money or insert unexplained debt just to make the balance sheet balance.
A simple first model can use a fixed financing schedule and interest input. A more advanced model may link borrowing to a minimum cash requirement, which can create circularity between debt, interest, profit, and cash. Resolve that deliberately through a documented calculation approach. Do not enable iteration merely to conceal a broken formula.
Frequently asked questions
Is this the same as a cash-flow forecast?
A cash-flow forecast focuses on receipts, payments, and liquidity. A three-statement forecast also connects accrual profit and financial position. Use a 13-week cash-flow forecast for near-term payment timing alongside a monthly or annual integrated model.
How often should I update it?
Choose a review cycle that matches the decision. Replace completed periods with reconciled actuals, explain changes, and update future assumptions. A rolling forecast extends the horizon as each period closes.
Does a positive year-end cash balance mean there is no shortage?
No. A yearly model can hide a cash shortfall earlier in the year. Add monthly detail and a weekly cash schedule when collection delays, seasonality, payroll, or large payments matter.
Sources and learning notes
For further reading on integrated planning, see Oracle’s balance-sheet and cash-flow planning tutorial. The simplified business, assumptions, tables, and scenarios on this page are original educational examples. Adapt account detail, tax treatment, financing terms, and cash-flow classification to the actual business and its reporting requirements.