๐Ÿงฐ UtlKit

How to Calculate IRR: The Formula, a Worked Example & IRR vs ROI

What Is IRR?

IRR (internal rate of return) is the annualized discount rate that makes the net present value of a series of cash flows equal to zero. In other words: it is the rate of return a project actually earns per year, taking into account when each dollar comes in or goes out.

The IRR is the rate r that solves:

0 = CFโ‚€ + CFโ‚/(1+r) + CFโ‚‚/(1+r)ยฒ + โ€ฆ + CFโ‚™/(1+r)โฟ

where CFโ‚€ is usually negative (your initial outlay) and later cash flows are the returns. If you can set up that equation, you can describe the IRR โ€” what makes it "internal" is that r is found from the cash flows themselves, not imposed from a market rate.

Worked example: a five-year project

You invest $100,000 today and receive $30,000 at the end of each of the next five years.

  • CFโ‚€ = โˆ’$100,000
  • CFโ‚ โ€ฆ CFโ‚… = +$30,000 each year

Try a rate of 15%: 30,000 ร— (1 โˆ’ 1.15โปโต)/0.15 โˆ’ 100,000 = +$565. The NPV is positive, so 15% is too low. Try 16%: the same calculation gives โˆ’$1,771. The NPV is now negative, so the IRR lies between 15% and 16%. Refining (or letting a calculator do it) gives:

IRR โ‰ˆ 15.24%

Check: at 15.24%, the present value of the five $30,000 inflows is exactly $100,000 โ€” the project breaks even at that rate, which is precisely what IRR means.

How is IRR actually calculated?

Unlike ROI, the IRR has no simple algebraic formula once there are more than two cash flows. In practice it is found numerically:

  1. Bracket it โ€” pick two trial rates whose NPVs have opposite signs (15% gave +$565, 16% gave โˆ’$1,771).
  2. Narrow it โ€” test rates between the bracket until the NPV is near zero.
  3. Refine it โ€” use linear interpolation or Newton's method for the exact value.

Spreadsheets (IRR and XIRR functions) and calculators automate all three steps. Our IRR Calculator takes your cash-flow list and returns the IRR, plus the NPV at any rate you choose for comparison.

IRR vs ROI

For the same five-year project: total inflows are $150,000, so ROI = (150,000 โˆ’ 100,000) รท 100,000 = 50% over the whole period. That single number hides the fact that the money comes back in installments. The IRR of 15.24% tells you the annual pace โ€” and it is higher than the CAGR of 8.45% you would get if the entire $50,000 profit arrived only at year 5, because the installments arrive earlier and can be reinvested sooner. See our ROI guide for the other side of this comparison, and the CAGR Calculator for the lump-sum version.

IRR Caveats

  • Reinvestment assumption โ€” IRR assumes intermediate cash flows are reinvested at the IRR itself, which can overstate realistic returns for high-IRR projects.
  • Multiple IRRs โ€” if cash flows change sign more than once (for example, a large cost at the end of a project), the equation can have two or more solutions. A single "the IRR" no longer exists.
  • Scale blindness โ€” a 40% IRR on $100 and a 40% IRR on $1,000,000 are the same percentage but very different in dollars. Compare the NPV or absolute profit as a second check.
  • Use alongside, not instead of โ€” the ROI Calculator gives the total return in one number; the IRR gives the annual pace. Both together tell the full story.

Calculating IRR Fast

Enter your cash flows โ€” the initial investment followed by yearly returns, with negatives for outflows โ€” into the IRR Calculator. It returns the IRR instantly, and you can sweep through discount rates to see the NPV curve. Everything runs in your browser; nothing is sent to a server.

Related Tools

Frequently Asked Questions

What is IRR in simple terms?

IRR is the annual interest rate a project earns on the money invested, computed so that the discounted value of all future cash flows exactly equals the money you put in. If IRR is 15%, the project "breaks even" at a 15% discount rate โ€” it earns 15% per year on your capital.

How is IRR calculated if there is no closed formula?

By iteration: compute the NPV at a trial rate, see if it is positive or negative, adjust the rate, and repeat until the NPV is zero. In practice you bracket the answer with two rates of opposite sign, then narrow โ€” or let software (spreadsheets, the IRR Calculator) run Newtonโ€™s method for you.

What is a good IRR?

A good IRR beats your cost of capital plus a risk premium. For a funded investor comparing projects, 15-25% is a common benchmark range for private equity; for a personal project, it must beat what your money could earn elsewhere (typically the risk-free rate plus a margin). Always compare the IRR against your alternatives, not against zero.

When should I use IRR instead of ROI?

Use IRR whenever money flows in and out at different times โ€” a project with yearly returns, a loan with installments, a machine that pays over several years. ROI works when there is essentially one outflow and one inflow. IRR captures the timing; ROI does not.

Related Articles