How To Calculate NPV

Net present value is the sum of all an investment's cash flows, each discounted to today at the rate of return you require. The upfront cost enters as a negative at time zero; every future inflow enters as a positive discounted by how far away it is.

A positive NPV means the investment returns more than the required rate, so it adds value and should be accepted. A negative NPV means it returns less than the required rate and should be rejected. An NPV of zero means it exactly meets the requirement, leaving you indifferent.

The discount rate is the crux. It should reflect the opportunity cost of the money, which is what you could earn on an investment of comparable risk. Using too low a rate makes bad projects look good; using too high a rate rejects sound ones.

Because NPV is expressed in money rather than as a ratio, it tells you the size of the gain, not just the rate. A project with a high percentage return but a tiny NPV adds little value, while a large NPV on a modest percentage return can be worth far more in absolute terms.

Discounting is what separates NPV from simple payback. A pound received in five years is worth less than a pound today, because today's pound could be earning a return in the meantime. Ignoring that difference overstates long-horizon projects badly.

The internal rate of return is the discount rate at which NPV equals zero. If the IRR exceeds your required rate, the NPV is positive. NPV and IRR usually agree, but NPV is preferred because it handles scale and multiple sign changes without ambiguity.

NPV assumes cash flows are reinvested at the discount rate, which is a simplification. A very high discount rate assumes you can reinvest at that same high rate, which may not be realistic. Sensitivity analysis, running the numbers across a range of rates, guards against overconfidence.

The model here assumes level annual cash flows after the initial cost. Real projects often ramp up or tail off, and each year's flow can be discounted separately if you extend the calculation to a full schedule of uneven flows.

Terminal value captures what happens beyond the forecast window. When a project keeps producing cash after the last modelled year, analysts add a terminal value, often as a perpetuity grown at a modest rate, and discount it back like any other far-off flow. It can easily be the largest single component, so it deserves the same scrutiny as the explicit years.

NPV is additive, which is one of its great strengths. If you can value two projects separately, the NPV of doing both is the sum of their individual NPVs, so you can build up a portfolio decision from its parts. IRR does not have this property and can mislead when capital is rationed across several competing projects.

Capital rationing is where NPV shines. When you cannot fund every positive-NPV project, rank them by NPV per unit of the scarce resource, whether that is money or a bottleneck machine hour, and take the highest first. This maximises the total value created from a limited budget.

Real options go beyond a single accept-or-reject call. Many projects carry the option to expand, delay, or abandon, and those choices have value that a static NPV misses. A project with a slightly negative base-case NPV may still be worth starting if it opens the door to a much larger follow-on investment.

Always pair the headline number with a sensitivity table. Recompute the NPV at a range of discount rates and cash-flow assumptions, and report how far the inputs would have to move before the decision flips. A project whose NPV turns negative at the first small slip in assumptions is far riskier than one that stays positive across the whole plausible range.