Net Present Value, Explained

After reading this you will be able to discount a series of future cash flows to their present-day value, subtract what you paid, and decide whether a project clears your required rate of return.

What net present value measures

Net present value (NPV) answers one question: is a stream of future cash worth more than the money you have to spend now to get it, once you account for the fact that a dollar next year is worth less than a dollar today?

Suppose someone offers you a deal. Pay 10000 now and receive 3000, 4000, 5000, then 3000 at the end of each of the next four years. The nominal total coming back is 15000, so it looks like a gain of 5000. But you could have invested that 10000 elsewhere at, say, 8% a year. NPV converts every future payment into present value at that 8% rate and then checks whether the sum still beats what you paid. In this case it does, but by less than the raw arithmetic suggests.

The single most important idea is the time value of money: cash arriving later is discounted because you lose the chance to earn a return on it in the meantime.

When to use it, and when not

NPV fits any decision where you can write down the cash amounts and the timing: buying a machine, launching a product, choosing between two lease terms, valuing a bond. If you can list what goes out and what comes in period by period, NPV gives you a single number in present-day currency.

It works less well when the cash flows are highly uncertain, when the timing is fuzzy, or when the right discount rate is genuinely unknown. NPV does not create certainty; it processes the numbers you feed it. Garbage inputs produce a confident-looking but wrong answer.

The formula and the intuition behind it

Each future cash flow is divided by a growth factor that compounds the discount rate over the number of periods until it arrives.

Here C_0 is the initial investment paid at time zero, C_t is the cash flow at the end of period t, r is the discount rate per period expressed as a decimal (8% becomes 0.08), and n is the number of periods.

The term (1+r)^t is the same compounding factor used for savings, run in reverse. Money grows by (1+r) each period, so a payment t periods away is worth (1+r)^t times less now. A payment of 5000 arriving in year 3 at 8% is worth 5000 / 1.08^3 = 3969.16 at present.

The minus sign on C_0 reflects that the initial investment leaves your pocket at time zero, when no discounting applies. If a later period also has an outflow (a repair, a top-up), you enter it as a negative cash flow and the same formula discounts it.

Worked example with the demo numbers

How the discount rate reshapes the answer

NPV is highly sensitive to the rate you choose. Raise the rate and future cash flows shrink faster, so the same project can flip from a clear yes to a no. With the demo flows, NPV is 2381 at 8% but falls to roughly 1218 at 15% and turns negative above about 18%.

The rate at which NPV crosses zero is the internal rate of return. For these numbers it is close to 18.5%. Any required rate below that gives a positive NPV; any rate above it gives a negative one.

Reading and interpreting the result

The rule is simple. If NPV is greater than zero, the project earns more than your discount rate, so it adds value. If NPV is below zero, the money would do better in the alternative the rate represents. If NPV is exactly zero, the project earns precisely your required rate and you are indifferent on the numbers alone.

The size of a positive NPV matters, not just the sign. An NPV of 2381 on a 10000 outlay means the project creates about 2381 of present-day value beyond what 8% elsewhere would give you. When ranking mutually exclusive projects, prefer the higher NPV, but check that the investments are comparable in scale and horizon.

Common mistakes

Several errors quietly corrupt NPV results.

Mismatched period and rate

If cash flows are monthly, the rate must be monthly too. An 8% annual rate is about 0.643% per month, not 8% per month. Mixing the two overstates or understates the discount by orders of magnitude.

Double-counting the initial investment

Enter the outlay in the investment field only. Do not also list it as a first negative cash flow, or you subtract it twice.

Ignoring inflation

If your cash flows are stated in present-day prices, use a real discount rate; if they include expected price rises, use a nominal rate. See the Inflation-Adjusted Return Calculator for the Fisher relationship between the two.

Forgetting timing conventions

This tool discounts each flow at the end of its period. If a payment truly arrives at the start of the period, its value is one period less discounted, which changes the total.

Related tools

NPV sits inside a family of return measures. The ROI Calculator gives a simple percentage gain without discounting, useful for a quick check. The CAGR Calculator turns a start and end value into an annual growth rate. For projecting a portfolio with regular contributions, use the Investment Growth Calculator, and to see how fees erode that growth over decades, the Investment Fee Impact Calculator.

Related tools

CAGR Calculator

Compound annual growth rate between two values.

Dollar-Cost Averaging Calculator

Project a regular investing plan’s future value.

Investment Growth Calculator

Portfolio projection with monthly contributions.

Options Strategy Lab

Build multi-leg option strategies and see the payoff curve, Greeks and probability of profit update live.

ROI Calculator

Return on investment, simple and annualized.

Capital Gains Tax Calculator

Profit and tax on a sold investment.