Internal Rate of Return Calculator
Enter the initial investment and the cash it returns in years 1, 2 and 3 to find the internal rate of return.
Updated
Internal Rate of Return Calculator
Our Internal Rate of Return Calculator finds the yearly rate of return an investment earns from its own cash flows. Enter the amount you invest today and the cash it pays back in each of the next three years. The internal rate of return (IRR) appears at once, with the total cash returned, the net gain and the cash multiple. Compare the IRR with your required rate of return, or with the IRR of another project, to decide which investment is worth making.
Quick answer
The internal rate of return is the discount rate that makes the net present value of all the cash flows equal 0: −50,000 + 18,000, 20,000 and 25,000 gives ≈ 11.79%.
- Cash out: 50,000 invested today (year 0).
- Cash in: 18,000, 20,000 and 25,000 in years 1 to 3.
- IRR: discounting at about 11.79% brings those back to exactly 50,000.
- Decision: with a 10% hurdle rate, 11.79% passes.
What Is the Internal Rate of Return?
The internal rate of return (IRR) is the discount rate at which the net present value (NPV) of an investment is exactly 0. Put another way, it is the yearly return that turns every future cash flow back into today's money and makes the total equal the amount invested. It is used in capital budgeting to rank projects and to check them against a required rate of return.
+ C2 ÷ (1 + r)²
+ C3 ÷ (1 + r)³
- C0: the initial investment, paid today.
- C1, C2, C3: the net cash flows at the end of years 1, 2 and 3. A blank year counts as 0.
- r: the internal rate of return, the rate that solves the equation.
How to Calculate IRR
There is no direct formula for r, so IRR is found by trial and error: try a rate, work out the NPV, and move the rate until the NPV reaches 0. For 50,000 that returns 18,000, 20,000 and 25,000:
| Rate tried | NPV |
|---|---|
| 10% | +1,675.43 |
| 11% | +728.45 |
| 12% | −190.19 |
| ≈ 11.79% | 0 |
- Try a rate. At 10% the NPV is +1,675.43, so the true rate is higher.
- Try a higher rate. At 12% the NPV is −190.19, so the rate lies between 11% and 12%.
- Narrow it down. Keep halving the gap until the NPV is 0. The calculator does this for you.
- Check. At 11.79%, the three inflows are worth 16,101.55 + 16,003.70 + 17,894.75 = 50,000 today.
IRR Examples
| Invest → years 1, 2, 3 | IRR |
|---|---|
| 10,000 → 1,000, 1,000, 11,000 | 10% |
| 20,000 → 0, 0, 26,620 | 10% |
| 100,000 → 30,000, 40,000, 50,000 | ≈ 8.90% |
| 60,000 → 10,000, 20,000, 40,000 | ≈ 6.60% |
| 40,000 → 15,000, 15,000, 5,000 | ≈ −7.41% |
The first row works like a bond paying 10% a year, and the second is 20,000 growing by 10% a year for 3 years (20,000 × 1.1³ = 26,620), so both have an IRR of exactly 10%. In the last row only 35,000 comes back on 40,000, so the IRR is negative.
IRR vs NPV and the Hurdle Rate
IRR and NPV use the same cash flows. NPV discounts them at your required rate of return (the hurdle rate) and gives an amount; IRR gives the rate where that amount is 0. They agree on simple projects:
- IRR above the hurdle rate: NPV is positive, so the project adds value. At a 10% hurdle, the 11.79% example has an NPV of +1,675.43.
- IRR below the hurdle rate: NPV is negative. 100,000 returning 30,000, 40,000 and 50,000 has an IRR of about 8.90% and an NPV of −2,103.68 at 10%.
- IRR equal to the hurdle rate: NPV is 0, and the project just earns its cost of capital.
When two projects compete, NPV is the safer guide, because a small project can have a higher IRR but add less value in total.
Limitations and Common Mistakes
- Several IRRs. If a later cash flow is negative, the sign changes more than once and there can be more than one IRR, or none.
- Reinvestment assumption. IRR assumes cash received is reinvested at the IRR itself. The modified IRR (MIRR) uses a more realistic rate.
- Scale. IRR is a rate, not an amount. 10,000 returning 4,000 a year and 100,000 returning 40,000 a year both have an IRR of about 9.70%.
- Timing. The calculator treats each cash flow as arriving at the end of its year. Monthly or irregular flows need XIRR.
- Very high results. 5,400 returning 5,500, 7,644 and 10,000 gives about 110.73%. Check such inputs before relying on them.
Key Terms
- IRR
- Rate where NPV equals 0.
- NPV
- Discounted cash in minus cash out.
- Hurdle rate
- Minimum return you require.
- Cash multiple
- Total cash in ÷ investment.
- MIRR
- IRR with a set reinvestment rate.
How to Use the Internal Rate of Return Calculator
- Enter the initial investment. Type the amount invested today, such as 50,000. It must be more than 0.
- Enter the yearly cash flows. Type the net cash received at the end of years 1, 2 and 3, such as 18,000, 20,000 and 25,000. Leave a year blank or type 0 if nothing comes in, or type a negative number for a net outflow.
- Read the IRR. The internal rate of return appears as you type, with the total cash in, the net gain and the cash multiple.
- Compare and copy. Compare the IRR with your required rate of return. Press Copy to copy it, or Clear or Esc to start again.
Example: invest 100,000 and receive 30,000, 40,000 and 50,000 over 3 years. The IRR is about 8.90%, below a 10% hurdle rate.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
What is the IRR formula?
IRR is the rate r that solves 0 = −C0 + C1 ÷ (1 + r) + C2 ÷ (1 + r)² + C3 ÷ (1 + r)³, where C0 is the investment and C1 to C3 are the yearly cash flows. It is found by trial and error.
What is the IRR of 50,000 that returns 18,000, 20,000 and 25,000?
It is about 11.79%. Discounted at that rate, the three cash flows are worth 16,101.55, 16,003.70 and 17,894.75, which add up to 50,000.
What is a good IRR?
A good IRR is one above your required rate of return or cost of capital. If money costs you 10% a year, an IRR of 11.79% passes and an IRR of 8.90% does not.
Can IRR be negative?
Yes. If the cash returned adds up to less than the investment, the IRR is negative. 40,000 returning 15,000, 15,000 and 5,000 has an IRR of about −7.41%.
What is the difference between IRR and NPV?
NPV discounts the cash flows at a chosen rate and gives an amount. IRR is the rate at which that amount is 0. A positive NPV at your hurdle rate means the IRR is above it.
Why can a project have more than one IRR?
When cash flows switch from negative to positive and back again, the NPV equation can have several solutions. Use NPV or the modified IRR in that case.
How is IRR different from ROI?
ROI compares total gain with the cost and ignores timing. IRR is a yearly rate that accounts for when each cash flow arrives, so earlier cash raises it.
Is the IRR Calculator free?
Yes. It is completely free, needs no sign-up, and can be used as many times as you like.
Sources
- Wikipedia. Internal rate of return.
- Wikipedia. Net present value.
- Wikipedia. Modified internal rate of return.
- Corporate Finance Institute. Internal Rate of Return (IRR).
- Wall Street Prep. Internal Rate of Return (IRR).
- WallStreetMojo. Internal Rate of Return (IRR).
Use our IRR Calculator to see the yearly return hidden in any set of cash flows.