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
| Inputs | Result |
|---|---|
| Initial investment ($)10000Cash flow for each year ($)4000, 4500, 5000 | IRR: 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, 22000 | IRR: 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, 1000 | IRR: 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 |
| IRR | The 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.