Blog · Finance metrics and formulas · Finance and FP&A teams
Estimate project cash flows by comparing the business with and without the project. Build an incremental operating, capital, working-capital and terminal cash schedule, with spreadsheet formulas and a reconciliation.
Estimating cash flows for project appraisal means comparing the company's future cash with the project against its future cash without it. Include only differences caused by the decision, with their payment dates. Build operating cash, capital spending, working capital and terminal proceeds separately so reviewers can test the assumptions before judging the investment.
Export the current sales plan, operating-cost budget, equipment quotations, inventory requirements and customer and supplier payment assumptions. Add a tax schedule approved by the company's tax team. Keep the baseline and project case in the same currency, price basis and periods.
Record each row's project, period, source, owner and with-project and without-project amounts. Their difference is the incremental input. Reallocating existing headquarters expense does not automatically create cash spending.
NYU's capital-budgeting materials distinguish incremental costs from sunk costs and existing allocations. They also identify opportunity costs: using space or equipment can forgo cash the company could otherwise earn. Include that forgone benefit even when it does not appear as a new ledger payment.
A company-wide cash-flow forecast answers the broader liquidity question; this schedule isolates one decision.
Project cash flow = Incremental operating cash flow - Capital spending - Increase in operating working capital + After-tax terminal proceeds
Operating cash flow = Incremental revenue - Incremental cash operating costs - Incremental cash taxes
Use the second formula when revenue and operating costs are stated before working-capital timing adjustments. If you instead start with scheduled customer collections and supplier payments, do not subtract the same receivables and payables movements again.
For this purpose, operating working capital generally includes receivables plus inventory, less operating payables. Exclude financing debt. NYU's working-capital guidance explains why valuation cash flows typically separate noncash working capital from cash holdings and interest-bearing debt. Document any necessary operating cash balance separately.
The definition resembles free cash flow, but retain the project's boundary and assumptions.
An illustrative US manufacturer is considering a production cell. It costs $300,000 immediately and operates for three years. All figures below are incremental to the approved without-project baseline. The schedule is unlevered: financing receipts, interest and principal are excluded.
The tax team's assumed depreciation is $80,000 annually. For this teaching case, cash tax equals 25% of positive taxable operating profit and positive disposal gain, paid in the same period. No loss carryforwards, credits or other tax adjustments apply. Actual tax depreciation and disposal treatment require the company's approved tax schedule; IRS Publication 946 explains the separate tax-depreciation rules.
Use labels in A and periods in B through E, with headings in row 1. Table row numbers match worksheet rows. All amounts are exact USD without rounding.
| Row | Input or calculation | Time 0 (USD) | Year 1 (USD) | Year 2 (USD) | Year 3 (USD) |
|---|---|---|---|---|---|
| 2 | Revenue | 0 | 450,000 | 500,000 | 500,000 |
| 3 | Cash operating costs | 0 | 290,000 | 320,000 | 320,000 |
| 4 | Tax depreciation | 0 | 80,000 | 80,000 | 80,000 |
| 5 | Assumed tax rate | 25% | 25% | 25% | 25% |
| 6 | Taxable operating profit | 0 | 80,000 | 100,000 | 100,000 |
| 7 | Operating cash tax | 0 | 20,000 | 25,000 | 25,000 |
| 8 | Operating cash flow | 0 | 140,000 | 155,000 | 155,000 |
| 9 | Capital spending | 300,000 | 0 | 0 | 0 |
| 10 | Required working capital after period | 50,000 | 60,000 | 65,000 | 0 |
| 11 | Increase in working capital | 50,000 | 10,000 | 5,000 | -65,000 |
| 12 | Equipment sale proceeds | 0 | 0 | 0 | 75,000 |
| 13 | Tax basis of equipment disposed | 0 | 0 | 0 | 60,000 |
| 14 | Assumed disposal cash tax | 0 | 0 | 0 | 3,750 |
| 15 | Net project cash flow | -350,000 | 130,000 | 150,000 | 291,250 |
Time 0 funds the initial operating cycle. The year-end working-capital balances fund subsequent activity; the final period assumes complete collection, sale or consumption of inventory and settlement of operating liabilities. Check that this timing matches the operating plan.
Calculate taxable profit, cash tax and operating cash flow in B6, B7 and B8, then fill across:
=B2-B3-B4
=MAX(B6,0)*B5
=B2-B3-B7
Initial working-capital investment in B11 is =B10. The movement in C11 is =C10-B10; fill that formula across. For this example's assumed disposal treatment, B14 is =MAX(B12-B13,0)*B5, filled across. Net cash flow in B15 is:
=B8-B9-B11+B12-B14
Fill across through E15. Terminal tax basis is $300,000 minus three years of $80,000 depreciation, or $60,000. The disposal gain is $75,000 - $60,000 = $15,000; assumed cash tax is $3,750. After-tax disposal proceeds are therefore $71,250.
Operating cash totals $140,000 + $155,000 + $155,000 = $450,000. Working-capital movements sum to $50,000 + $10,000 + $5,000 - $65,000 = zero because the full investment is recovered. Total undiscounted project cash is $450,000 - $300,000 + $71,250 = $221,250, matching the sum of row 15.
Now increase only year 2 working capital from $65,000 to $80,000. The additional $15,000 reduces year 2 cash from $150,000 to $135,000. Full recovery raises final-year cash from $291,250 to $306,250. Undiscounted cash remains $221,250, but receipt is delayed; the appraisal must retain that timing difference.
Finance owns the completed schedule. Operations validates capacity and costs, commercial teams validate revenue, and treasury validates collection and payment timing. The approved discount rate and investment decision follow this input review. A positive undiscounted sum alone does not establish an acceptable return.
Use the 13-week cash-flow layout when payment dates within the first operating year need a closer liquidity check.
Upload a workbook containing the baseline, incremental assumptions, working-capital balances and terminal schedule. Covirage maps the columns, and its tools compute and check the cash-flow bridge; the external AI model explains assumption differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See project cost control for the supporting business context.
Costs already incurred and unrecoverable do not change when the project is accepted, so exclude them from the decision cash flows. Retain them in the supporting records so reviewers can see why they were excluded rather than assume the finance team overlooked them.
Depreciation reduces accounting or taxable profit without being a current cash payment. If the calculation begins with after-tax profit, add it back once. If it begins with cash revenue less cash costs and taxes, depreciation is already excluded from cash operating costs.
Deduct the increase in required operating working capital, not the entire balance each year. An initial investment is an outflow, a later increase is another outflow, and a recoverable reduction releases cash. Support any terminal release with assumptions about collections, inventory disposal and supplier settlement.
Match the cash-flow definition to the appraisal perspective. An unlevered project schedule generally excludes borrowing, interest and principal payments. An equity cash-flow schedule includes financing effects. Mixing the two can count financing costs inconsistently with the discount rate selected by finance.