Overview

Net present value judges an investment by comparing what you pay now with the present value of what you will receive. A positive NPV means it beats your required return.

Enter the upfront cost, a discount rate and the expected cash flow for each year, for up to 100 years.

Worked examples

InputsResult
Initial investment ($)10000Discount rate (% per year)8Cash flow for each year ($)4000, 4500, 5000NPV: $1,530.89Positive NPV: the investment earns more than your discount rate.Present value of cash flows: $11,530.89Profitability index: 1.15
Show 2 more examples
Initial investment ($)50000Discount rate (% per year)10Cash flow for each year ($)15000, 18000, 20000, 22000NPV: $8,564.99Positive NPV: the investment earns more than your discount rate.Present value of cash flows: $58,564.99Profitability index: 1.17
Initial investment ($)8000Discount rate (% per year)6Cash flow for each year ($)2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000NPV: $4,419.59Positive NPV: the investment earns more than your discount rate.Present value of cash flows: $12,419.59Profitability index: 1.55

How it works

Each year’s cash flow is divided by (1 + rate)^year and added up. The initial investment is subtracted.

The formula

NPV = −Investment + Σ CFₜ ÷ (1 + r)ᵗ
CFₜCash flow in year t
rDiscount rate

Practical tips

  • Investing $10,000 for cash flows of $4,000, $4,500 and $5,000 at an 8% discount rate gives an NPV of $1,530.89.
  • The profitability index is the present value of inflows divided by the investment; above 1 means value is created.
  • Pick the discount rate carefully: small changes can flip the answer.

Frequently asked questions

What does a negative NPV mean?

The project returns less than your required rate and would reduce value.

NPV or IRR?

NPV is generally more reliable for choosing between projects of different sizes.