Overview

The internal rate of return is the discount rate at which an investment’s NPV is exactly zero. It is the project’s effective yearly return.

Enter the upfront cost and the cash flow for each year, for up to 100 years.

Worked examples

InputsResult
Initial investment ($)10000Cash flow for each year ($)4000, 4500, 5000IRR: 15.98% per yearTotal cash returned: $13,500 on $10,000 investedAt a discount rate below 15.98% this investment has a positive NPV
Show 2 more examples
Initial investment ($)50000Cash flow for each year ($)15000, 18000, 20000, 22000IRR: 17.19% per yearTotal cash returned: $75,000 on $50,000 investedAt a discount rate below 17.19% this investment has a positive NPV
Initial investment ($)5000Cash flow for each year ($)1000, 1000, 1000, 1000, 1000, 1000, 1000IRR: 9.2% per yearTotal cash returned: $7,000 on $5,000 investedAt a discount rate below 9.2% this investment has a positive NPV

How it works

The calculator searches for the rate where the present value of the cash flows equals the investment, using repeated bisection.

The formula

0 = −Investment + Σ CFₜ ÷ (1 + IRR)ᵗ
CFₜCash flow in year t
IRRThe rate being solved

Practical tips

  • Investing $10,000 for $4,000, $4,500 and $5,000 returns an IRR of 15.98%.
  • Compare the IRR with your required return: higher is better.
  • IRR can mislead when cash flows change sign several times.

Frequently asked questions

Is IRR the same as ROI?

No. ROI is a total percentage gain; IRR is a yearly rate that accounts for timing.

Why might IRR not exist?

If all cash flows have the same sign there is no rate that makes the NPV zero.