NPV, IRR and payback calculator
Net present value, internal rate of return and payback period of any series of cash flows.
Enter your data: no value is filled in for you.
Result
Enter the discount rate.
Calculation version: finance@1.0.0. The calculation runs in your browser: we don't send or store the amounts you enter. We only count, without identifying you, that the tool has been used.
How to use it
- 1Period 0 is the moment of the investment, usually a negative cash flow.
- 2All periods must be the same length (for example, years).
- 3The discount rate must match that same length.
How it calculates
- NPV = Σ Fₜ / (1 + r)ᵗ, from t = 0 to n
- IRR = the rate r that makes NPV = 0, calculated by bisection between −99.99% and 1,000%.
- Payback = last period with a negative cumulative total + interpolated fraction.
Verifiable example
Cash flows −1,000, 300, 400 and 500 at 10%: NPV = −€21.04; IRR ≈ 8.90%; payback in 2.6 periods.
Limitations
- With several sign changes there may be several IRRs; the calculator returns one of them.
- If there are no cash flows of different signs, the IRR doesn't exist and this is stated.
- Cash flows at the end of each period.
What the paid levels will add
Compare the levels →Keep exploring
Related moduleVentureLabAssess and prioritise projects with operational, financial and risk models.View the module
- Break-even pointUnits and revenue needed to cover fixed costs, with the contribution margin.
- Currency converter with ECB ratesConvert between 30 currencies with the European Central Bank's official reference rates, with their date and history.
- Mortgage calculatorMonthly payment, total interest and amortisation schedule with the French system.
- Rental yield of a flatGross and net yield, annual cash flow and return on equity.
- Levelised cost of energy (LCOE)Average cost per MWh of an energy project with degradation and a discount rate.
- Compound interest calculatorHow much savings grow with monthly contributions and an assumed return, also in today's euros.
Indicative result
It doesn't constitute financial, tax or investment advice. Check important decisions with a professional.