Rounding Robin

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.

$
%
Net present value$7,198.96
Internal rate of return
16.16%
Payback period (years)
2.85
YearCash flowPresent valueCumulative 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

NPV = −Initial investment + Σ Cash flow in year t ÷ (1 + r)^t
IRR = the rate r at which NPV equals zero

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:

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

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.