Blog · Forecast and pipeline · Finance and FP&A teams
Build a multiyear cash forecast from operating drivers, working capital, investment and debt schedules. A linked annual example shows why rising sales can still leave a funding gap.
Long term cash flow forecasting connects operating plans, investment commitments and financing over several years to show whether the business can fund its strategy. Build linked annual schedules rather than extending one monthly cash pattern indefinitely. The result should explain both the cash generated by operations and the funding needed after investment and debt payments.
Use the shorter-term cash flow forecast to manage near-term receipts and payments. The strategic version answers a different question: whether growth, capacity investment and financing assumptions remain compatible across the planning horizon.
Start with a decision such as adding capacity, entering a market or refinancing debt. State the planning horizon, legal entities, reporting currency and required cash buffer. Identify which assumptions management can change and which are contractual commitments.
The SBA's business-plan guidance calls for a prospective financial outlook including forecast income statements, balance sheets, cash flow statements and capital expenditure budgets. These schedules need to agree. A sales plan that requires more inventory must also show how the inventory is funded.
Collect annual sales by volume and price, operating cost assumptions, opening receivables and inventory, supplier balances, capital spending milestones, debt maturities and funding commitments. Use approved plans and ledger exports as the starting evidence. Keep the source and owner beside each assumption.
For the market assumptions behind volume, use long-term demand forecasting. Here, the task is to translate those supplied volumes into cash movements, then test the consequences of changing them.
Consider an illustrative US industrial components business. It begins Year 1 with $100,000 usable cash and $180,000 operating working capital. The example uses annual periods and USD throughout, with exact whole-dollar calculations.
Its supplied operating drivers are:
| Driver | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Units sold | 10,000 | 12,000 | 14,400 |
| Price per unit (USD) | 100 | 100 | 100 |
| Revenue (USD) | 1,000,000 | 1,200,000 | 1,440,000 |
| Cash gross margin | 30% | 30% | 30% |
| Closing operating working capital / revenue | 20% | 20% | 20% |
| Closing operating working capital (USD) | 200,000 | 240,000 | 288,000 |
The cash gross margin is a planning measure: earned revenue less period product expense excluding noncash charges, divided by revenue. Sales are assumed billed when earned. Product expense is measured before collection and purchasing payment-timing adjustments. The separate working-capital bridge converts these accrual amounts into cash using receivables, inventory and payables.
Working capital here means trade receivables plus inventory minus trade payables. An increase consumes cash. Year 1 needs $20,000 above the opening $180,000; later increases are $40,000 and $48,000. Keep taxes and financing balances out of that schedule because they have separate lines below.
Capital spending comes from the equipment payment schedule, not a constant percentage added without support. Debt principal follows the signed repayment schedule. Cash taxes are supplied payment assumptions; no tax rate is implied by these illustrative amounts.
The fixed cash spending row includes overhead and cash interest. It excludes depreciation, capital purchases, principal repayments and the cash taxes shown separately. That definition prevents the same cash use from appearing in two places.
Operating cash = Cash gross profit − Fixed cash spending − Cash taxes − Increase in operating working capital
Closing cash = Opening cash + Operating cash − Capital spending − Debt principal + New funding
No new funding is assumed in this base case.
| Schedule line | Year 1 (USD) | Year 2 (USD) | Year 3 (USD) |
|---|---|---|---|
| Revenue | 1,000,000 | 1,200,000 | 1,440,000 |
| Cash gross profit at 30% | 300,000 | 360,000 | 432,000 |
| Fixed cash spending, including interest | 180,000 | 200,000 | 220,000 |
| Cash surplus before taxes and working capital | 120,000 | 160,000 | 212,000 |
| Cash taxes | 20,000 | 30,000 | 40,000 |
| Increase in operating working capital | 20,000 | 40,000 | 48,000 |
| Operating cash | 80,000 | 90,000 | 124,000 |
| Capital spending | 120,000 | 80,000 | 90,000 |
| Operating cash less capital spending | -40,000 | 10,000 | 34,000 |
| Debt principal | 30,000 | 30,000 | 30,000 |
| Opening cash | 100,000 | 30,000 | 10,000 |
| Closing cash | 30,000 | 10,000 | 14,000 |
The operating-cash-less-capital-spending row is the free cash flow measure used here. It still precedes the principal repayments in this schedule, so a positive number does not establish that the bank balance will rise.
Put Year 1 in column B and subsequent years in C and D. For the main table above, use rows 2 through 13 in the listed order: revenue in row 2, cash gross profit in row 3 and closing cash in row 13. Put the 30% cash margin assumption in B16 and copy the assumption across as appropriate.
The first year's gross profit, surplus, operating cash and investment-adjusted cash are:
=B2*B16
=B3-B4
=B5-B6-B7
=B8-B9
Those formulas belong in B3, B5, B8 and B10 respectively. Closing cash in B13 and the following year's opening cash in C12 are:
=B12+B10-B11
=B13
Keep working capital in its own linked schedule. If revenue is B2, the working capital ratio is B17 and opening working capital is B18, the Year 1 increase in B7 is:
=B2*B17-B18
For Year 2, reference the prior year's closing requirement rather than reusing the original opening balance:
=C2*C17-B2*B17
The lowest annual closing balance is =MIN(B13:D13). Microsoft's MIN documentation describes the smallest-number calculation. Covirage is not affiliated with Microsoft.
Across the horizon, operating cash totals $294,000, capital spending totals $290,000 and principal repayments total $90,000. The independent bridge is $100,000 opening cash plus $294,000 minus $290,000 minus $90,000, equaling the final $14,000 balance.
With a supplied minimum buffer of $25,000, annual headroom is $5,000, negative $15,000 and negative $11,000. The base case therefore needs a funding or spending response even though revenue increases every year. The lowest annual closing balance is $10,000 in Year 2.
For a focused sensitivity, reduce only Year 1 cash gross margin from 30% to 27%. Keep revenue, working capital, taxes and scheduled payments unchanged to isolate the margin effect:
| Year 1 measure | Base (USD) | Margin sensitivity (USD) |
|---|---|---|
| Cash gross profit | 300,000 | 270,000 |
| Operating cash | 80,000 | 50,000 |
| Closing cash | 30,000 | 0 |
The margin change removes $30,000 from cash gross profit and closing cash. A broader downside scenario should also change any linked taxes, purchases or investment dates that management expects to move. Do not call an isolated sensitivity a complete operating scenario.
Bring a sample of your own annual operating plan, working capital schedule, capital spending and debt payment file to Covirage. Covirage maps the columns; its tools compute and check the supplied balances and scenario comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring the assumptions behind your funding requirement.
See forecast analysis for the supporting approach.
Choose a horizon that covers the investment, debt maturity or strategic decision being evaluated. Use more detail near the present and explicitly label uncertainty in later years. Annual totals should connect to shorter-term schedules whenever payment timing could change the funding decision.
Growth can require additional inventory and receivables before customer cash arrives. Equipment investment and debt repayments may also exceed operating cash generation. A multiyear forecast should connect those requirements to sales assumptions rather than treating revenue growth as an equal increase in available cash.
No. A cash forecast estimates business cash movements and funding needs. A valuation may use forecast cash flows alongside discount rates and other assumptions to estimate value. An undiscounted liquidity schedule should not be presented as a business valuation.
Depreciation does not itself represent a current cash payment. If starting from accounting profit, adjust noncash charges appropriately. If starting from cash revenue and cash costs, do not subtract depreciation again; include equipment payments in the capital spending schedule when paid.