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

Enter to calculate Esc to clear

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.

0 = −C0 + C1 ÷ (1 + r)
  + 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 triedNPV
10%+1,675.43
11%+728.45
12%−190.19
≈ 11.79%0
  1. Try a rate. At 10% the NPV is +1,675.43, so the true rate is higher.
  2. Try a higher rate. At 12% the NPV is −190.19, so the rate lies between 11% and 12%.
  3. Narrow it down. Keep halving the gap until the NPV is 0. The calculator does this for you.
  4. Check. At 11.79%, the three inflows are worth 16,101.55 + 16,003.70 + 17,894.75 = 50,000 today.
−50,000 18,000 20,000 25,000 Year 0 Year 1 Year 2 Year 3 At r ≈ 11.79%, inflows are worth 50,000 today
The IRR is the rate that makes the money in (above the line) worth exactly the money out (below it).

IRR Examples

Invest → years 1, 2, 3IRR
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

  1. Enter the initial investment. Type the amount invested today, such as 50,000. It must be more than 0.
  2. 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.
  3. Read the IRR. The internal rate of return appears as you type, with the total cash in, the net gain and the cash multiple.
  4. 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?

InvestorsCompare opportunities
Business OwnersJudge new projects
Property InvestorsMeasure rental returns
Financial AnalystsCapital budgeting
Finance StudentsPractise IRR problems

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

Use our IRR Calculator to see the yearly return hidden in any set of cash flows.