IRR and NPV Calculator
NPV 1,307.29, IRR 16.34%
4 cash flows (periods 0 to 3) discounted at 10% a year.
- NPV
- 1,307.29
- IRR
- 16.34%
- Profitability index
- 1.1307
- Simple payback
- 2.41 years
- Discounted payback
- 2.74 years
- MIRR
- 14.6%
- Sum of the cash flows
- 4,000.00
- Cash flows
- 4 (periods 0 to 3)
Each cash flow is divided by (1 + rate)^period, with period 0 undiscounted. IRR is the rate that makes NPV exactly 0, found between −99% and 1,000% per period. An estimate, not financial advice.
The working, period by period
Discount factor = 1 ÷ (1 + rate)^period; present value = cash flow × discount factor. Every row is rounded on its own from the exact value, so a column can differ from its total by a cent.
| Period | Cash flow | Discount factor | Present value | Cumulative PV | Cumulative cash |
|---|---|---|---|---|---|
| 0 | −10,000.00 | 1.000000 | −10,000.00 | −10,000.00 | −10,000.00 |
| 1 | 3,000.00 | 0.909091 | 2,727.27 | −7,272.73 | −7,000.00 |
| 2 | 4,200.00 | 0.826446 | 3,471.07 | −3,801.65 | −2,800.00 |
| 3 | 6,800.00 | 0.751315 | 5,108.94 | 1,307.29 | 4,000.00 |
NPV profile: NPV at other discount rates
| Annual discount rate | NPV | Rule: NPV > 0 |
|---|---|---|
| 0% | 4,000.00 | Accept: NPV above 0 |
| 5% | 2,540.76 | Accept: NPV above 0 |
| 10% | 1,307.29 | Accept: NPV above 0 |
| 15% | 255.61 | Accept: NPV above 0 |
| 20% | −648.15 | Reject: NPV below 0 |
| 25% | −1,430.40 | Reject: NPV below 0 |
| 30% | −2,111.97 | Reject: NPV below 0 |