NPV, IRR and payback period calculator
Enter the investment and yearly cash flows: NPV, IRR, simple and discounted payback.
NPV, IRR and paybackIs this project worth the investment?
NPV$5,988.79
IRR12.7%
Payback3.6 years
Discounted payback4.6 years
MeaningThe project adds value at this discount rate
✓ NPV at the IRR = 0
USD
%
| Year | Cash flow (USD) | |
|---|---|---|
| Cumulative | |
|---|---|
| Year 0 | -80,000 |
| Year 1 | -63,636 |
| Year 2 | -45,455 |
| Year 3 | -26,672 |
| Year 4 | -8,913 |
| Year 5 | 5,989 |
Highest Year 5: 5,989 USD · lowest Year 0: -80,000 USD
| Year | Cash flow | Present value | Cumulative (discounted) |
|---|---|---|---|
| 0 | -$80,000.00 | -$80,000.00 | -$80,000.00 |
| 1 | $18,000.00 | $16,363.64 | -$63,636.36 |
| 2 | $22,000.00 | $18,181.82 | -$45,454.55 |
| 3 | $25,000.00 | $18,782.87 | -$26,671.68 |
| 4 | $26,000.00 | $17,758.35 | -$8,913.33 |
| 5 | $24,000.00 | $14,902.11 | $5,988.79 |
What you enter is kept in this browser; a share link carries exactly these numbers.
Run it on your own figures
Upload your orders or report to DataMimi and ask in plain English — this calculator opens prefilled with the prices, volumes and costs from your own file, and every figure shows which rows it came from.
Open DataMimi