Blog · Territory, capacity and quota planning
Include working-capital investment, later changes, and terminal recovery in project NPV. Follow a complete cash-flow schedule, discount each period, and test a lower-recovery scenario.
An NPV calculation example with working capital must show when cash is invested, how the required balance changes, and when any recovery arrives. Subtract working-capital increases from project cash flow, add releases, and discount those movements alongside operating cash flows and capital spending.
Project analysis usually needs operating working capital rather than every current asset and liability. For this example, it is trade receivables plus inventory minus trade payables. There are no other operating current accounts.
Aswath Damodaran's noncash working-capital discussion explains the exclusion of cash and interest-bearing current debt in valuation analysis. Cash is not an additional operating investment just because the business holds it, and borrowing belongs in the financing assumptions rather than being counted again in project operating cash flow.
The historical working-capital formula answers the balance-sheet question. Project NPV adds a timing question: how much of that balance must be funded at each date? For the opening requirement specifically, see initial working capital.
Project cash flow at time t = After-tax operating cash flow before working-capital changes − Capital spending − Increase in operating working capital + Separate terminal recovery
NPV = CF₀ + CF₁ / (1 + r) + CF₂ / (1 + r)² + … + CFₙ / (1 + r)ⁿ
Here, CF means net project cash flow, r is the discount rate per period, and n is the final period. A decrease in working capital is a negative increase, so subtracting it adds cash. If the final decrease already includes the full unwind, do not add a separate recovery again.
A fictional US equipment distributor is evaluating a project lasting three years. It pays $500,000 for equipment at time zero. The supplied forecast has after-tax operating cash inflows of $240,000 at each year-end, before working-capital changes. Those inflows already include the forecast's tax effects; depreciation is not subtracted again as a cash payment.
Assume no equipment-sale proceeds or further capital spending. Use an assumed annual discount rate of 10%, matched to these annual after-tax project cash flows. This is a calculation assumption, not a recommended hurdle rate.
The project needs these balances at time zero and subsequent year-ends. The final column is immediately before the project closes; the terminal unwind is shown separately below.
| Operating balance (USD) | Time zero | Year 1 | Year 2 | Year 3 before closure |
|---|---|---|---|---|
| Trade receivables | 60,000 | 75,000 | 90,000 | 90,000 |
| Inventory | 70,000 | 85,000 | 100,000 | 100,000 |
| Less: trade payables | 30,000 | 40,000 | 50,000 | 50,000 |
| Required working capital | 100,000 | 120,000 | 140,000 | 140,000 |
| Increase from previous balance | 100,000 | 20,000 | 20,000 | 0 |
The opening balance before the project is zero. Each required balance equals receivables plus inventory less payables. The increases are $100,000 initially, then $120,000 less $100,000, then $140,000 less $120,000.
Full recovery at the final year-end is an explicit assumption: receivables are collected, inventory converts to cash at its recorded amount, and payables are settled. The net release is $90,000 plus $100,000 less $50,000, or $140,000. The project has no remaining operating working capital afterward.
Use separate columns for capital spending, operating cash, working-capital investment, and recovery. This lets a reviewer trace the cash-flow sign without reading a narrative assumption into a cell.
| Period | Operating inflow (USD) | Capital spending (USD) | Working-capital increase (USD) | Terminal recovery (USD) | Net cash flow (USD) |
|---|---|---|---|---|---|
| Time zero | 0 | 500,000 | 100,000 | 0 | −600,000 |
| Year 1 | 240,000 | 0 | 20,000 | 0 | 220,000 |
| Year 2 | 240,000 | 0 | 20,000 | 0 | 220,000 |
| Year 3 | 240,000 | 0 | 0 | 140,000 | 380,000 |
The net cash-flow column applies the formula above. Notice that Year 2 deducts only the additional $20,000, not the full $140,000 balance. Year 3 includes the cash from closing the operating balances alongside that year's operating inflow.
Working capital and equipment also belong in different planning schedules. The capital versus operating budget guide explains that boundary; both still contribute to the project's cash appraisal.
| Period | Net cash flow (USD) | Discount divisor at 10% | Present value (USD) |
|---|---|---|---|
| Time zero | −600,000 | 1.000 | −600,000.00 |
| Year 1 | 220,000 | 1.100 | 200,000.00 |
| Year 2 | 220,000 | 1.210 | 181,818.18 |
| Year 3 | 380,000 | 1.331 | 285,499.62 |
| NPV | 67,317.81 |
Calculate with unrounded values and round the final amounts to cents. The displayed period values can differ from the final total by a cent because each is rounded separately. Discounted future inflows are $667,317.81; subtracting the initial $600,000 gives an NPV of $67,317.81.
Two undiscounted checks help catch schedule errors. Working-capital movements total −$100,000 − $20,000 − $20,000 + $140,000 = zero under full recovery. Total project cash is −$600,000 + $220,000 + $220,000 + $380,000 = $220,000; this is not NPV because it ignores time.
In Excel, put the four net cash flows in B2:B5, starting with time zero, and enter:
=B2+NPV(10%,B3:B5)
The NPV function documentation states that periodic values occur at period-end and that a beginning cash flow is added separately. Including B2 inside that function would delay the initial payment by a period. Covirage is not affiliated with Microsoft.
Suppose only $70,000 is recovered at the end, with every other cash assumption unchanged. The final cash flow becomes $240,000 + $70,000 = $310,000. Losing $70,000 at Year 3 reduces present value by $70,000 / 1.331 = $52,592.04, giving revised NPV of $14,725.77.
That variation represents lower net terminal cash after all associated settlement effects. It does not silently assume an additional tax benefit. Finance should document whether collection losses, disposal costs, or taxes change other forecast rows before approving a real scenario.
Upload a scenario workbook or Google Sheet containing the cash-flow dates, operating assumptions, capital spending, and working-capital balances; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the scenario differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own project file.
See FP&A reporting for the supporting finance workflow.
Yes, when the project needs inventory, customer credit, or other operating balances before it generates cash. Subtract the net initial requirement at time zero alongside capital spending. Use operating balances and exclude financing already represented through the chosen valuation approach.
An increase means more cash is tied up in operating assets after allowing for operating liabilities. Inventory bought before sale and sales awaiting collection absorb cash. Supplier credit offsets part of that requirement, so use the net change rather than asset additions alone.
Only if the closing assumptions support it. Receivables may suffer losses, inventory may sell below carrying value, and supplier liabilities still need settlement. Use the expected net cash release and its date; a continuing operation may retain working capital rather than release it.
No. After the initial investment, subtract increases and add releases. Subtracting the entire required balance each year repeatedly charges the same investment. A balance schedule and a separate cash-movement schedule make this error easier to detect.