Home › Accounting › NPV and IRR Calculator
NPV and IRR Calculator
Enter the upfront cost, your discount rate and the cash flow expected each year, separated by commas.
- Internal rate of return
- 16.16%
- Payback period (years)
- 2.85
| Year | Cash flow | Present value | Cumulative cash |
|---|---|---|---|
| 1 | $15,000.00 | $13,636.36 | -$35,000.00 |
| 2 | $18,000.00 | $14,876.03 | -$17,000.00 |
| 3 | $20,000.00 | $15,026.30 | $3,000.00 |
| 4 | $20,000.00 | $13,660.27 | $23,000.00 |
Formula
How it works
A positive NPV means the project earns more than your discount rate after recovering its cost. The IRR is the break-even discount rate: if it is above your required return, the project clears the bar.
Cash flows are assumed to arrive at the end of each year. Payback counts undiscounted cash and ignores everything after the cost is recovered, so use it as a liquidity check, not a profitability measure.
Worked example
Using the starting figures above (Initial investment: $50,000.00; Discount rate: 10%; Yearly cash flows (comma separated): 15000, 18000, 20000, 20000), the calculator returns:
- Net present value: $7,198.96
- Internal rate of return: 16.16%
- Payback period (years): 2.85
Common questions
What discount rate should I use?
Use the return you could earn on an alternative of similar risk, often the company cost of capital. A higher rate makes future cash worth less today.
Why does IRR show n/a?
If the cash flows never turn the investment positive at any rate in the search range, there is no IRR to report.
Related calculators
- ROI CalculatorCalculate return on investment and annualized return from the amount invested, the amount returned and the holding period.
- Present Value CalculatorCalculate what a future sum of money is worth today at a given discount rate and number of years.
- CAGR CalculatorCalculate compound annual growth rate from a starting value, an ending value and the number of years.
Something look wrong, or missing a calculator you need? Send feedback.
Results are estimates for general information. They are not financial, tax or legal advice. Check important figures with a qualified professional before acting on them.