IRR Calculator

Investing and getting back a year for years is an internal rate of return (IRR) of 10.25% a year. At a required return, its NPV is $3,906.73, and it pays back in 4.3 years, or 5.5 years discounted.

Work backward

Find the that makes the NPV : ...

Start over
Year by year

Free calculator by ROI.fyi

What IRR tells you

The internal rate of return (IRR) is the yearly return an investment earns, counting when each dollar comes back. It is the discount rate at which the investment's net present value is exactly zero. If your required return is below the IRR, the project creates value. If it's above, you'd do better elsewhere. Our example invests $50,000 and gets $12,000 back a year for 6 years.

That is an IRR of 11.53% a year. At an 8% required return, the net present value is $5,475, and the money pays back in 4.2 years, or 5.3 years once each payment is discounted. At 12%, the NPV turns negative at -$663, because 12% is above the IRR. Open More options to change the required return.

Real projects rarely pay the same each year. Choose Different each year and list each year's cash, separated by commas. The same $50,000 paid back as $5,000, $10,000, $15,000, $15,000, $15,000 and $12,000 still totals $72,000, but the IRR drops to 10.25%, because more of the money arrives later. Timing matters as much as the total.

IRR is the standard way to compare investments with cash coming in over several years: rental property, equipment, a business, a private loan. It has blind spots. It assumes the cash you get back can be reinvested at the same rate, and it says nothing about size, so a small project with a high IRR may add fewer dollars than a large one with a lower IRR. Look at NPV alongside it.

The IRR formula

0 = -C_0 + \sum_{t=1}^{n} \frac{C_t}{(1+\text{IRR})^t}

C with a subscript 0 is the upfront cost, C with a subscript t is the cash back in year t, and n is the number of years. There's no direct formula, so the calculator tries rates until the NPV reaches zero. It assumes each payment arrives at the end of its year.

Frequently Asked Questions

How do you calculate IRR?

Find the discount rate that makes the present value of all future cash flows equal to the upfront cost. There is no direct formula, so you try a rate, see whether the NPV is above or below zero, and adjust until it is zero. Spreadsheets and this calculator do it automatically in a fraction of a second.

How do I calculate IRR in Excel?

Put the upfront cost as a negative number in A1 and each year's cash flow in A2 onward. Then enter =IRR(A1:A7). For the example, -50000 followed by six 12000s gives 11.53%. If your cash flows come on specific dates rather than once a year, use =XIRR(values, dates) instead.

What is a good IRR?

A good IRR beats your cost of money or your next best option at similar risk. Many businesses use a hurdle rate of 10% to 15%. Real estate investors often look for 12% to 20% on their cash. For comparison, the S&P 500 has returned about 10% a year with dividends over long periods, with no work and easy selling.

What is the difference between IRR and ROI?

ROI is the total gain as a share of the cost, with no time attached. IRR is a yearly rate that accounts for when each dollar comes back. Our example's ROI is 44% ($22,000 on $50,000), but it is earned over 6 years and comes back gradually, so the IRR is 11.53% a year.

What is the difference between IRR and NPV?

NPV is a dollar amount: what the project is worth today at your required return, minus its cost. IRR is the rate at which NPV is zero. They usually agree on whether a project is worth doing. When choosing between projects, NPV is the safer guide, because IRR ignores size and can rank a small project above a much more valuable large one.

Can IRR be negative?

Yes. If you get back less than you put in, the IRR is negative. $50,000 that returns $8,000 a year for 6 years, $48,000 in all, has an IRR of about -1.15% a year. If none of your money comes back, there's no IRR to speak of.

Why can a project have more than one IRR?

When cash flows change sign more than once, such as an upfront cost, years of income and then a big cleanup cost at the end, the NPV can cross zero at two different rates. Both are mathematically valid. In that case, rely on NPV at your required return, or use the modified IRR (MIRR).

What is MIRR?

The modified internal rate of return assumes the cash you get back is reinvested at a rate you choose, such as your cost of capital, instead of at the IRR itself. It gives one answer even when cash flows change sign several times, and it is usually lower and more realistic than IRR for high-return projects. Excel calculates it with =MIRR.

Is IRR the same as CAGR?

They match when you invest once and collect once. $1,000 that becomes $1,610.51 in 5 years has a 10% IRR and a 10% CAGR. IRR also handles money coming and going in between. For a single start and end value, the CAGR calculator is simpler.

Does IRR include the time value of money?

Yes. That's its main advantage over ROI and the simple payback period. Each future payment is discounted for how long you wait for it. That is why paying back the same total sooner raises the IRR, and paying it back later lowers it.

More return and interest calculators

Measure a return

Turn a result into a yearly rate: CAGR, a run of yearly returns, deposits along the way or uneven cash flows.

Plan a project

What future money is worth today, when a project pays back and how much you need to sell to break even.

Grow savings

What a balance becomes with compounding, an APY, monthly deposits and inflation.

Rates & APR

Simple interest, the rate between two amounts, or what a loan really costs with its fees.