Net Present Value Calculator
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
Enter the initial investment, the expected cash flow of each year (0 for a year without one) and your discount rate.
Result
Net present value (NPV)
Present value of the cash flows
- Profitability index (PV ÷ investment)
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Discount rate, in % / year: enter a number from 0 to 100.
- Initial investment, in dollars: enter 0.01 or more.
- Cash flow, year 1, in dollars: enter a number.
- Cash flow, year 2, in dollars: enter a number.
- Cash flow, year 3, in dollars: enter a number.
- Cash flow, year 4, in dollars: enter a number.
- Cash flow, year 5, in dollars: enter a number.
- Read the result: Net present value (NPV); the panel also shows Present value of the cash flows and Profitability index (PV ÷ investment).
How this calculator works
NPV = −C0 + CF1 ÷ (1 + r) + CF2 ÷ (1 + r)^2 + … + CF5 ÷ (1 + r)^5, where C0 is the initial investment, CFt the cash flow at the end of year t and r the discount rate, usually the required return or cost of capital.
A positive NPV means the cash flows earn more than the discount rate; a negative NPV means less. The profitability index is the present value of the cash flows ÷ the investment, above 1 when NPV is positive. Enter a negative cash flow for a year with a net outflow.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Discount rate | % / year | |
| Initial investment | $ | |
| Cash flow, year 1 | $ | |
| Cash flow, year 2 | $ | |
| Cash flow, year 3 | $ | |
| Cash flow, year 4 | $ | |
| Cash flow, year 5 | $ | |
| Present value of the cash flows | $ | |
| Net present value (NPV) | $ |
Worked example
| Discount rate | 8 % / year |
|---|---|
| Initial investment | $10,000 |
| Cash flow, year 1 | $3,000 |
| Cash flow, year 2 | $3,500 |
| Cash flow, year 3 | $4,000 |
| Cash flow, year 4 | $4,000 |
| Cash flow, year 5 | $0 |
| Present value of the cash flows | $11,893.91 |
|---|---|
| Profitability index (PV ÷ investment) | 1.19 |
Net present value (NPV) $1,893.91
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What does a negative NPV mean?
The investment returns less than your discount rate. It may still earn money, just less than the alternative the rate represents.
What discount rate should I use?
The return you could earn elsewhere at similar risk; companies often use their weighted average cost of capital (WACC).