Net present value (NPV)
Net present value (NPV) is the present value of an investment's cash inflows minus the present value of its cash outflows. It measures the value a project is expected to add after accounting for timing and a required return.
Key takeaways
- A positive NPV means the projected cash flows exceed the chosen required return. A negative NPV means they fall short.
- Use incremental cash flows, not revenue or accounting profit. Include the cash spent to generate the returns.
- NPV measures value, not liquidity. A project can have a positive NPV and still leave a business short of cash.
How net present value works
Money received later is worth less today because you must wait for it and bear the risk of not receiving it. Discounting converts future cash flows into comparable present-day amounts.
For an investment paid upfront:
NPV = -Initial investment + Σ[CF_t / (1 + r)^t]
Here, CF_t is the net cash flow in period t, and r is the discount rate per period. The sum covers every forecast period. Annual cash flows need an annual rate; monthly cash flows need a monthly rate.
Count cash flows that change because you take the project. Exclude sunk costs already paid, and include additional working capital, maintenance and any proceeds when the project ends.
A $100,000 investment creates $22,765 of present value
A company spends $100,000 now on automation. It forecasts after-tax net cash savings of $40,000, $50,000 and $60,000 over three years, received at each year-end. There is no resale value or other cash flow.
The company uses a hypothetical 10% annual discount rate.
| Timing | Net cash flow | Present value at 10%, rounded |
|---|---|---|
| Today | -$100,000 | -$100,000 |
| End of year 1 | $40,000 | $36,364 |
| End of year 2 | $50,000 | $41,322 |
| End of year 3 | $60,000 | $45,079 |
| Total | $50,000 | $22,765 |
The calculation is:
NPV = -$100,000 + $40,000/1.10 + $50,000/1.10² + $60,000/1.10³
NPV = $22,765, rounded
The project produces a $50,000 undiscounted cash surplus, but adds $22,765 of value after accounting for the 10% required return.
That conclusion depends on the forecast. If every future saving is 20% lower, the present value of those savings falls to $98,212. NPV becomes approximately -$1,788.
How it reads in a spreadsheet
Microsoft's Excel documentation specifies that NPV() treats its cash flows as equally spaced, end-of-period amounts. An immediate investment belongs outside the function:
=NPV(10%,40000,50000,60000)-100000
Putting the upfront $100,000 inside NPV() discounts it as though it happens one period later, which changes the answer.
For cash flows on specific, unevenly spaced dates, use XNPV() with the amounts and their dates.
What to question before approving a project
There is no universal discount rate for every business. The example's 10% is not a standard startup hurdle rate. Choose a rate appropriate to the cash flows' risk, rather than one that produces approval.
Question a model that counts revenue without delivery costs, ignores cash tied up in inventory, or forecasts benefits beyond the asset's useful life.
For a cash-constrained startup, check the cash balance throughout the project. A positive three-year NPV cannot pay next month's payroll.
NPV versus IRR
| Point | NPV | Internal rate of return (IRR) |
|---|---|---|
| Result | Value in dollars | A percentage return |
| Calculation | Discounts cash flows at a chosen rate | Finds a rate at which NPV equals zero |
| Main caution | Depends on the forecast and discount rate | Can misrank projects of different sizes or produce multiple answers |
Questions people ask
How do you determine net present value?
List the incremental cash flows and when they occur, choose a suitable discount rate, discount each flow to today and add the results. Treat cash paid out as negative and cash received as positive.
If the NPV is negative, should I invest in the project?
Not on the modeled financial returns alone. Negative NPV means the project misses your required return, not necessarily that it loses money before discounting. If important benefits are missing from the model, assess them explicitly rather than lowering the rate to force approval.
Does net present value account for inflation?
Not automatically. Use cash flows that include expected inflation with a nominal discount rate. Use inflation-adjusted cash flows with a real discount rate. Mixing the two gives an inconsistent valuation.
What is the relationship between NPV and IRR?
IRR is the discount rate that makes NPV zero. When mutually exclusive projects have conflicting rankings, NPV at an appropriate discount rate is the better test of which creates more dollar value.
