Blog · Territory, capacity and quota planning · Finance and FP&A teams
A three-statement financial model links profit, balance-sheet movements, and cash. Follow a worked monthly example, enter the statement formulas, and check that cash, equity, and the balance sheet reconcile.
A 3 statement financial model connects the income statement, balance sheet, and cash flow forecast so every forecast movement has a matching financial effect. Build from a reconciled opening balance sheet, calculate profit and cash separately, and prove the links before explaining a variance. A workbook that balances can still contain poor assumptions, but a workbook that does not balance is not ready for review.
Start with the closed trial balance, income statement, balance sheet, receivables and payables schedules, fixed-asset register, and debt schedule. Keep company, account, accounting month, actual or forecast status, and version. The monthly financial report template covers the reporting layout; the task here is connecting forecast movements.
The SEC's guide to financial statements distinguishes period-based income and cash flow from the balance sheet at a point in time. Use a month-end opening position, followed by one consistent forecast period.
This illustrative US distributor starts January 2026 with these balances. Put the amount column in Opening!B2:B8, in the order shown:
| Opening balance | Amount (USD) |
|---|---|
| Cash | 80,000 |
| Accounts receivable | 50,000 |
| Inventory | 60,000 |
| Net property, plant, and equipment | 150,000 |
| Accounts payable | 45,000 |
| Debt | 100,000 |
| Equity | 195,000 |
Opening assets are $80,000 + $50,000 + $60,000 + $150,000 = $340,000. Liabilities plus equity are $45,000 + $100,000 + $195,000 = $340,000. Clear any difference before forecasting.
Put these January forecast inputs and the resulting net income in Income!B2:B8. Expense inputs are positive amounts.
| Income statement line | January (USD) |
|---|---|
| Revenue | 300,000 |
| Cost of goods sold | 180,000 |
| Cash operating expenses | 65,000 |
| Depreciation | 10,000 |
| Interest expense | 5,000 |
| Income tax expense | 8,000 |
| Net income | 32,000 |
Income!B8 =B2-SUM(B3:B7)
The tax expense is a supplied planning assumption, not a tax-rate calculation. This simplified example assumes interest, taxes, and cash operating expenses are paid in January, with no related accrual changes. There are no dividends, equity contributions, asset disposals, or other balance-sheet movements.
Accrual earnings and cash receipts occur on different schedules. The SBA's finance guidance explains that accrual and cash methods record transactions at different times. Do not treat forecast revenue as customer collections. The working capital schedules explain the cash held in receivables and inventory or financed by suppliers.
Management supplies these January movements: receivables increase by $20,000, inventory increases by $15,000, payables increase by $12,000, capital purchases are $25,000, and debt principal repayments are $10,000. The working-capital movements are forecast inputs to this example; a full workbook derives them from collections, inventory, purchasing, and supplier-payment schedules.
Put the following cash flow table in CashFlow!A1:B11. Outflows and asset increases are shown as positive inputs and subtracted in the formulas.
| Cash flow line | January (USD) |
|---|---|
| Net income | 32,000 |
| Depreciation add-back | 10,000 |
| Increase in receivables | 20,000 |
| Increase in inventory | 15,000 |
| Increase in payables | 12,000 |
| Operating cash flow | 19,000 |
| Capital purchases | 25,000 |
| Debt principal repaid | 10,000 |
| Opening cash | 80,000 |
| Closing cash | 64,000 |
CashFlow!B2 =Income!B8
CashFlow!B3 =Income!B5
CashFlow!B7 =B2+B3-B4-B5+B6
CashFlow!B10 =Opening!B2
CashFlow!B11 =B10+B7-B8-B9
Operating cash flow is $32,000 + $10,000 - $20,000 - $15,000 + $12,000 = $19,000. Closing cash is $80,000 + $19,000 - $25,000 - $10,000 = $64,000. Depreciation reduces profit but is added back in operating cash flow; the capital purchase appears separately as an investing outflow.
A standalone cash flow forecast examines receipts and payments in more detail. The integrated workbook must also carry each movement into the closing balance sheet.
Use the same line order as the opening balances in Closing!B2:B8:
| Closing balance | January (USD) | Roll-forward calculation |
|---|---|---|
| Cash | 64,000 | Cash flow closing balance |
| Accounts receivable | 70,000 | 50,000 + 20,000 |
| Inventory | 75,000 | 60,000 + 15,000 |
| Net property, plant, and equipment | 165,000 | 150,000 + 25,000 - 10,000 |
| Accounts payable | 57,000 | 45,000 + 12,000 |
| Debt | 90,000 | 100,000 - 10,000 |
| Equity | 227,000 | 195,000 + 32,000 |
Closing!B2 =CashFlow!B11
Closing!B3 =Opening!B3+CashFlow!B4
Closing!B4 =Opening!B4+CashFlow!B5
Closing!B5 =Opening!B5+CashFlow!B8-Income!B5
Closing!B6 =Opening!B6+CashFlow!B6
Closing!B7 =Opening!B7-CashFlow!B9
Closing!B8 =Opening!B8+Income!B8
Assets total $374,000. Payables and debt total $147,000; adding $227,000 of equity also gives $374,000. =SUM(Closing!B2:B5)-SUM(Closing!B6:B8) must return zero. Separately check =Closing!B2-CashFlow!B11 and =Closing!B8-Opening!B8-Income!B8; both return zero here.
Keep check cells separate from inputs. Never change cash or equity solely to erase an error.
Suppose January actuals match every assumption except collections: an additional $15,000 remains unpaid by customers. Receivables close at $85,000, operating cash flow falls to $4,000, and closing cash falls to $49,000. Net income remains $32,000 because the revenue was already earned.
The extra $15,000 of receivables exactly offsets the $15,000 cash reduction, so total assets remain $374,000. This is the kind of explanation a finance team needs: unchanged profit, slower collections, and lower cash. Compare account mappings and periods before interpreting differences; AI for financial analysis explains the importance of checking computed figures before trusting their explanation.
Bring your prepared three-statement forecast and actual results in a file or Google Sheet, with matching accounts and periods. Covirage maps the columns, and its tools compute and check the figures and differences; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own financial records.
See FP&A reporting for the supporting finance workflow.
Begin with a reconciled opening balance sheet and operating assumptions, then forecast the income statement and supporting schedules. Use working-capital, capital-spending, debt, and equity movements to calculate cash flow and closing balances. Building from a balanced opening position makes errors easier to isolate.
Profit includes revenue before some customers pay and excludes some cash outflows, such as capital purchases and debt principal repayments. Inventory growth also uses cash before related goods are sold. The cash flow statement makes those timing and classification differences visible.
Cash should come from the cash flow calculation. A balance-sheet difference is an error to investigate, not an amount to hide in cash. Model a funding shortfall explicitly, including its timing and assumptions, rather than inventing a cash balance or unexplained borrowing.
No. A forecast records assumptions about future activity. Monthly actual statements come from closed accounting records and reconciliations. Compare the two using consistent periods and account mappings, then explain changes in profit, working capital, funding, and closing cash.