Blog · Territory, capacity and quota planning · Finance and FP&A teams
Build an incremental project cash-flow schedule from revenue, cost and investment records. Separate sunk costs, working capital changes and terminal proceeds, then reconcile the complete case.
Capital budgeting and cash flow analysis measures the incremental cash a company expects from accepting an investment. Build a with-project versus without-project case, then account for operating changes, cash taxes, equipment payments, working capital and closeout proceeds. The result is a dated cash schedule that finance can evaluate and challenge.
The schedule comes before the return calculation. A precise discount rate cannot repair a missing investment, an unsupported cost saving or a cost that would happen anyway.
Write down the alternative to accepting the project. That may be continuing with existing equipment, outsourcing production or abandoning a product. The baseline should include credible future changes; it is not automatically last year's results held flat.
For each revenue or cost line, ask what changes between those alternatives. Exclude unrecoverable spending already incurred. OpenStax's discussion of relevant costs explains why sunk costs and future costs that do not differ between alternatives are irrelevant to the decision.
Include consequences outside the project department. A new product may displace existing sales. An unused building may have a rental alternative. A central support charge matters only to the extent that accepting the project changes the company's cash, rather than simply reallocating an existing cost. The detailed incremental cash-flow analysis guide covers these boundary decisions.
Use the records below to test a proposed project's inputs. Keep the source period, account definition and responsible owner beside each assumption. Historical evidence supports the estimate; it does not prove that the future will repeat.
| Project input | Starting record | Required check |
|---|---|---|
| Additional sales | Invoice and sales exports | Remove displaced sales and unsupported volume |
| Variable production costs | Purchase, payroll and production records | Match the volume and cost basis to projected sales |
| Added fixed costs | Contracts, staffing plan and cost-center detail | Include only costs caused by the project |
| Capital outlays | Supplier quotations and payment milestones | Include installation and dated payments |
| Working capital | Receivables, inventory and payables exports | Forecast incremental balances and their changes |
| Cash taxes and disposal | Tax schedule and disposal assumptions | Confirm deductions, timing and net proceeds |
Set one sign convention: positive project cash is an inflow, negative project cash is an outflow. Keep the investment date separate from operating years. Label annual periods clearly and schedule advance stock purchases when they must actually be funded.
Consider a US packaging business evaluating equipment costing $300,000, paid before Year 1. The project runs for three years. A prior feasibility study cost $20,000 and cannot be recovered. An annual corporate allocation of $15,000 will continue with or without the project. Both are excluded from the decision cash flows.
The company expects the following changes. The opportunity cost is forgone rental income from floor space used by the project. Assume tax depreciation of $100,000 per year and an illustrative combined cash tax rate of 25%, paid in the same year. This is a simplifying assumption, not a statement of statutory rates or available tax deductions.
| Incremental operating item | Year 1 (USD) | Year 2 (USD) | Year 3 (USD) |
|---|---|---|---|
| Revenue after displaced sales | 300,000 | 330,000 | 350,000 |
| Variable operating costs | 155,000 | 165,000 | 175,000 |
| Added fixed cash costs | 25,000 | 25,000 | 25,000 |
| Forgone rental income | 10,000 | 10,000 | 10,000 |
| Cash operating surplus before tax | 110,000 | 130,000 | 140,000 |
| Tax depreciation | 100,000 | 100,000 | 100,000 |
| Taxable operating profit | 10,000 | 30,000 | 40,000 |
| Cash taxes at 25% | 2,500 | 7,500 | 10,000 |
| Operating cash after tax, before NWC | 107,500 | 122,500 | 130,000 |
Operating cash after tax, before working capital = (Incremental revenue − Incremental cash costs − Tax depreciation) × (1 − Cash tax rate) + Tax depreciation
All amounts are exact whole dollars. Year 1's taxable operating profit is 300,000 − 155,000 − 25,000 − 10,000 − 100,000 = $10,000. Cash tax is 10,000 × 25% = $2,500. Operating cash is 10,000 − 2,500 + 100,000 = $107,500.
Damodaran's corporate finance teaching notes describe this bridge from operating earnings to cash: add back noncash depreciation, subtract capital expenditure and subtract increases in noncash working capital.
In a spreadsheet, put the operating table in rows 2 through 10, with Year 1 in column B: revenue in row 2, the three cash cost lines in rows 3 through 5, surplus in row 6, depreciation in row 7, taxable profit in row 8, tax in row 9 and operating cash in row 10. Put the 25% tax assumption in F2.
In B6, calculate the cash operating surplus:
=B2-SUM(B3:B5)
In B8, subtract tax depreciation:
=B6-B7
In B9, calculate the assumed cash tax:
=B8*$F$2
In B10, subtract tax and add back depreciation:
=B8-B9+B7
Copy these spreadsheet formulas across the operating years. If losses occur, replace the simplified tax formula with a finance-approved cash tax schedule; a loss does not automatically produce an immediate cash refund.
The project needs $40,000 of operating working capital before Year 1, another $5,000 before Year 2 and another $5,000 before Year 3. Its final $50,000 is fully released at closeout under the stated collection and inventory assumptions. Noncash working capital guidance explains why increases tie up cash; the project working capital article covers funding and recovery in detail.
Assume equipment is sold at closeout for $40,000 with zero remaining tax basis. Under this example's simplified 25% disposal tax assumption, tax is (40,000 − 0) × 25% = $10,000, leaving $30,000 of after-tax proceeds.
| Project cash item | Start (USD) | End Year 1 (USD) | End Year 2 (USD) | End Year 3 (USD) |
|---|---|---|---|---|
| Operating cash after tax | 0 | 107,500 | 122,500 | 130,000 |
| Equipment payment | -300,000 | 0 | 0 | 0 |
| Working capital cash flow | -40,000 | -5,000 | -5,000 | 50,000 |
| Equipment proceeds after tax | 0 | 0 | 0 | 30,000 |
| Net project cash flow | -340,000 | 102,500 | 117,500 | 210,000 |
With the four components in rows 14 through 17 and each period in a column, the net cash formula is:
=SUM(B14:B17)
Copy it across the periods. The capital budgeting cash-flow projection guide carries this schedule into driver assumptions and scenario comparisons.
Operating cash totals 107,500 + 122,500 + 130,000 = $360,000. Working capital cash totals −40,000 − 5,000 − 5,000 + 50,000 = $0. The project total is therefore 360,000 − 300,000 + 30,000 = $90,000.
The dated schedule gives the same result: −340,000 + 102,500 + 117,500 + 210,000 = $90,000. This is an undiscounted reconciliation, not evidence that the project meets the required return. Apply the selection methods in capital versus operating budgets only after the cash-flow checks pass.
Bring your project schedule and a sample of your own sales, cost and working capital exports to Covirage. Covirage maps the columns, and its tools compute and check the figures behind your assumptions; 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 FP&A reporting with Covirage for the finance team's reporting context.
An unrecoverable cost already incurred is excluded from the forward investment decision because accepting or rejecting the project cannot change it. Keep it visible in the historical spending record, but do not subtract it again from future incremental project cash.
Depreciation reduces accounting operating profit but does not itself pay cash in the forecast period. Add it back after calculating taxes. Use the appropriate tax depreciation schedule for cash taxes, which may differ from the financial reporting depreciation schedule.
A project schedule discounted at the weighted average cost of capital generally measures cash before debt financing. Keep borrowing and debt service in a separate financing assessment. If the decision uses equity cash flows instead, use a consistent equity valuation framework.