Blog · Territory, capacity and quota planning · Finance and FP&A teams
A capital project cash-flow projection connects investment dates, operating drivers and terminal cash. Build a checked base case and change one assumption to see how the result moves.
A capital budgeting cash flow projection estimates when a proposed investment uses cash and when it returns cash to the company. Start with equipment payments and operating assumptions, then add taxes, working capital and terminal effects. Compare a checked base case with clearly labeled alternatives so management can see which assumptions change the decision.
Capital budgeting asks whether future project cash justifies an investment today, as OpenStax's capital budgeting introduction explains. A useful projection makes the source and timing of that cash visible before anyone interprets a return measure.
Define the business without the project first. The projection should capture the difference caused by accepting it, including displaced sales, additional support costs and uses of existing assets. The capital budgeting and cash-flow analysis guide covers the construction of those incremental rows and the exclusion of sunk costs.
Next, define the first payment date, the operating start, the ramp-up and the end condition. A project that closes and sells its assets has different terminal cash from one that continues operating. Put that distinction in the assumptions before filling the final year.
Net project cash flow in a period = Operating cash after tax − Capital outlays − Increase in operating working capital + After-tax disposal proceeds
A working capital decrease is a negative increase, so subtracting it adds cash.
Operating cash here is measured before working capital changes. Keep that definition on the worksheet; starting with a cash figure that already includes those changes and subtracting them again would double count them.
Annual columns can support investment appraisal, but they can hide funding gaps during construction or launch. OpenStax's financial budget guidance connects capital expenditure plans to the company cash budget and emphasizes cash timing. Feed the project's actual payment dates into the wider cash-flow forecast.
The project sponsor owns the operating case. Sales confirms achievable demand and price; operations confirms capacity and unit cost; procurement verifies purchase commitments; finance confirms taxes, investment outlays and collection assumptions. FP&A should preserve the approved version and the evidence used to support it.
Keep inputs separate from calculations. An assumption register can be short:
| Input | Supporting file or record | Owner's question |
|---|---|---|
| Unit volume and launch dates | Historical sales and demand assumptions | Can the project reach the planned volume on time? |
| Realized selling price | Invoice history and customer terms | Does the price include discounts and returns? |
| Variable cost per unit | Purchase and production records | Does cost move with the same units as sales? |
| Fixed operating costs | Staffing and contract schedules | Which costs remain if volume falls? |
| Equipment and installation | Supplier quotations and milestones | When does each payment leave the business? |
| Working capital | Receivables, stock and payable schedules | What balances must be funded before sales occur? |
Avoid extending an unusual historical working capital movement mechanically. NYU Stern's working capital guidance recommends connecting future requirements to the operating drivers rather than assuming a volatile past change will repeat.
A US manufacturer proposes a three-year production line. Equipment costs $180,000 at the start. Initial operating working capital is $40,000, rising to $50,000 before Year 2 and $60,000 before Year 3. At closeout the full $60,000 is recovered; equipment has no disposal proceeds.
The project sells at $30 per unit and incurs $18 of variable cash cost per unit. Annual fixed cash costs are $40,000. Assume tax depreciation of $60,000 per year and an illustrative 25% cash tax rate, with tax paid in the same year. Actual tax deductions and timing require the company's tax schedule.
| Operating calculation | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Units sold | 10,000 | 12,000 | 14,000 |
| Revenue: units × 30 (USD) | 300,000 | 360,000 | 420,000 |
| Variable cash cost: units × 18 (USD) | 180,000 | 216,000 | 252,000 |
| Fixed cash cost (USD) | 40,000 | 40,000 | 40,000 |
| Tax depreciation (USD) | 60,000 | 60,000 | 60,000 |
| Taxable operating profit (USD) | 20,000 | 44,000 | 68,000 |
| Cash tax: profit × 25% (USD) | 5,000 | 11,000 | 17,000 |
| Operating cash before NWC (USD) | 75,000 | 93,000 | 111,000 |
Year 1 taxable operating profit is 300,000 − 180,000 − 40,000 − 60,000 = $20,000. Operating cash is 20,000 − 5,000 + 60,000 = $75,000. The depreciation charge is added back because it is not a cash payment. All figures are exact whole dollars with no rounding.
Now date the cash effects. The additional working capital is funded at the end of the preceding operating year.
| Cash component | Start (USD) | End Year 1 (USD) | End Year 2 (USD) | End Year 3 (USD) |
|---|---|---|---|---|
| Operating cash before NWC | 0 | 75,000 | 93,000 | 111,000 |
| Equipment payment | -180,000 | 0 | 0 | 0 |
| Working capital cash effect | -40,000 | -10,000 | -10,000 | 60,000 |
| Net project cash flow | -220,000 | 65,000 | 83,000 | 171,000 |
| Cumulative project cash flow | -220,000 | -155,000 | -72,000 | 99,000 |
The cumulative row adds each period to the prior cumulative balance. It shows that the project remains cash-negative through Year 2 under these annual timing assumptions. It does not reveal the exact within-year recovery date.
Test volume at 10% below the base case in each operating year. Selling price, unit variable cost, fixed costs, equipment outlay, tax assumptions and committed working capital balances stay unchanged. This isolates demand risk when the company cannot promptly reduce its stock and credit commitments.
Revenue and variable costs change automatically with units. These are consequences of changing volume, rather than separate manual overrides.
| Downside operating calculation | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Units: base units × 90% | 9,000 | 10,800 | 12,600 |
| Revenue: units × 30 (USD) | 270,000 | 324,000 | 378,000 |
| Variable cost: units × 18 (USD) | 162,000 | 194,400 | 226,800 |
| Fixed cost (USD) | 40,000 | 40,000 | 40,000 |
| Tax depreciation (USD) | 60,000 | 60,000 | 60,000 |
| Taxable operating profit (USD) | 8,000 | 29,600 | 51,200 |
| Cash tax at 25% (USD) | 2,000 | 7,400 | 12,800 |
| Operating cash before NWC (USD) | 66,000 | 82,200 | 98,400 |
The resulting comparison is:
| Cash date | Base project cash (USD) | Lower-volume project cash (USD) | Difference (USD) |
|---|---|---|---|
| Start | -220,000 | -220,000 | 0 |
| End Year 1 | 65,000 | 56,000 | -9,000 |
| End Year 2 | 83,000 | 72,200 | -10,800 |
| End Year 3 | 171,000 | 158,400 | -12,600 |
| Undiscounted net cash | 99,000 | 66,600 | -32,400 |
The proof is the operating bridge: the cash reductions of $9,000, $10,800 and $12,600 total $32,400. Investment and working capital cash are identical, so the same reduction must appear in total project cash. Independently, −220,000 + 56,000 + 72,200 + 158,400 = $66,600.
Positive undiscounted cash alone does not establish an acceptable investment. Apply the company's required return and selection criteria to the dated schedule; the capital versus operating budget guide covers those appraisal methods.
Before approval, identify which assumptions need evidence or protection, such as committed customer demand, a staged equipment payment or a lower stock commitment. A cash-flow forecast chart can help explain when funding is tied up, provided it uses the same checked rows.
After approval, compare actual units, price, unit costs and payment dates with the approved case. Retain that baseline and maintain a current estimate separately. The distinction between budget and forecast keeps revised expectations from erasing the original commitment.
Bring your project projection and a sample of your own sales, cost and working capital records to Covirage. Covirage maps the columns, and its tools compute and check the figures across the supplied scenarios; 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 data.
See Covirage for finance teams for the wider planning and review context.
Use the period during which the investment changes company cash flows, including construction, ramp-up and closeout. If operations continue beyond the explicit forecast, document a consistent continuing-value approach. A convenient forecast end date is not itself a reason to liquidate the project.
The project projection isolates cash differences caused by a proposed investment, often over several years. A company cash budget brings together all expected cash receipts and payments to assess liquidity. The project's dated payments and receipts should feed that wider budget.
Start by changing one driver to identify its effect, then build combined scenarios that reflect plausible business conditions. Keep linked calculations consistent. Lower volume changes revenue and variable costs automatically, while staffing, committed inventory and payment dates may remain unchanged.