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
| Inputs | Result |
|---|---|
| Initial investment ($)10000Discount rate (% per year)8Cash flow for each year ($)4000, 4500, 5000 | NPV: $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, 22000 | NPV: $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, 2000 | NPV: $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
| CFₜ | Cash flow in year t |
| r | Discount 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.