Net present value (NPV)

Metrics and finance4min readNPV calculator

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.

TimingNet cash flowPresent 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

PointNPVInternal rate of return (IRR)
ResultValue in dollarsA percentage return
CalculationDiscounts cash flows at a chosen rateFinds a rate at which NPV equals zero
Main cautionDepends on the forecast and discount rateCan 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.

Related terms

Sources

  1. OpenStax, Principles of Finance, 2022.
  2. Microsoft Support, "NPV function."
  3. Microsoft Support, "XNPV function."