Saved

Press the star next to a tool's name to save it.

All my tools

IRR Calculator

Enter your cash flows, starting with what you invest as a negative number. You’ll get the internal rate of return, and the net present value at a rate you choose.

Restored your last values ·

Start with what you invest as a negative number. Put a space after each comma between years; 10,000 is read as ten thousand.

%

Your result opens on the next page.

Internal rate of return

8.9%

Enter your cash flows to see the IRR.

What IRR means

The internal rate of return (IRR) is the yearly rate that makes an investment’s net present value (NPV) exactly zero. It’s one way to compare investments whose cash arrives at different times.

NPV = CF₀ + CF₁ ÷ (1 + r) + CF₂ ÷ (1 + r)² + …

IRR is the r where NPV = 0

No simple formula gives IRR directly, so calculators search for it. This one narrows down the rate until NPV is zero.

Worked example

You invest $10,000, then get $3,000, $4,000 and $5,000 over the next three years. Enter -10000, 3000, 4000, 5000. The IRR is 8.90% a year.

Cash flowsIRR
-10000, 3000, 4000, 50008.90%
-10000, 3000, 4000, 5000, 200015.32%
-1000, 500, 500, 50023.38%

How to read it

  • If the IRR is above the return you require, the investment may be worth a closer look.
  • Use NPV alongside it. IRR ignores how large an investment is, so a small project can show a higher rate but earn fewer dollars.

Limits to keep in mind

  • Each entry is one equal period, normally a year. Uneven dates need a different method.
  • If cash flows change sign more than once, there can be several valid answers. The calculator warns you when that happens.

IRR isn’t an EMI. For a loan payment, use the EMI calculator. For regular investing, try the SIP calculator. This isn’t financial advice.

How to use the IRR calculator

  1. List your cash flows in order. In the cash flows box, type one amount for each year, starting with year 0, the day you invest. Separate them with commas, spaces or semicolons.
  2. Make money going out negative. What you invest is usually the first entry, such as -10000. Money coming back is positive.
  3. Enter 0 for a year with no cash. Don’t skip the year, or every later amount moves a year earlier and the rate comes out too high.
  4. Add a rate for net present value if you want one. Use the return you could get elsewhere, such as 8%.
  5. Press Calculate. You see the IRR, the totals in and out, the net profit, the number of years and, if you gave a rate, the NPV.

Worked example: a rental property sold after five years

You buy a small rental for $50,000, collect $4,000 a year in net rent for five years and sell it at the end of year five for $56,000. In the last year you receive the rent plus the sale, so enter -50000, 4000, 4000, 4000, 4000, 60000.

  • Internal rate of return: 9.97% a year
  • Total coming in: $76,000.00, total going out: $50,000.00
  • Net profit: $26,000.00 over 5 years
  • Net present value at 8%: $4,083.50

The NPV is positive at 8% because the IRR is higher than 8%. These are the figures the calculator shows for these entries.

How IRR and NPV fit together

NPV and IRR always agree on one point: the NPV is zero at the IRR. If you discount at a rate below the IRR, the NPV is positive. At a rate above it, the NPV is negative. Take the first example on this page, with an IRR of 8.90%. At 8%, the NPV is $176.29. At 10%, it is −$210.37. So if you need a 10% return, this investment falls short, even though it makes $2,000 of profit.

The two can rank investments differently. Putting in $1,000 and getting $1,500 back a year later has an IRR of 50% and an NPV at 8% of $388.89. Putting in $10,000 and getting $12,000 back has an IRR of only 20%, but its NPV at 8% is $1,111.11. If you can only choose one, the bigger project adds more value, even with a lower rate.

Timing changes the rate

IRR rewards money that comes back sooner. Investing $10,000 and getting $15,000 back after one year gives an IRR of 50%. Getting the same $15,000 back after three years, entered as -10000, 0, 0, 15000, gives 14.47%. The profit is $5,000 both times, but waiting longer cuts the yearly rate a lot. That is why a total-profit figure alone can be misleading. For returns on dated cash flows, such as monthly deposits on set days, try the XIRR calculator.

Common IRR mistakes

  • Running numbers together. A comma followed by exactly three digits is read as a thousands comma, so 10,000 is ten thousand. Put a space after each comma between years, as in -10,000, 3,000, 4,000. Without spaces, 100,200,300 is read as one number, 100200300.
  • Forgetting the minus sign. With only positive amounts, there is no rate that balances the flows, and the tool shows an error.
  • Mixing monthly and yearly amounts. Every entry must cover the same length of time. If you enter monthly flows, the result is a monthly rate. To turn it into a yearly one, add 1, raise it to the power of 12 and subtract 1. A 1% monthly rate is about 12.68% a year.
  • Comparing IRR with a simple return. IRR is a yearly rate that allows for timing. A simple return just divides profit by cost. For that, use the ROI calculator.

How we calculate this

You enter cash flows in order, one per year, separated by spaces, commas or semicolons. The first is usually negative, the money you put in. The IRR is the rate at which the net present value of all flows equals zero, where NPV = the sum of each flow ÷ (1 + rate) raised to its year number.

There is no closed formula, so the tool narrows a range of rates by repeated halving, 300 times, until the NPV crosses zero. It needs at least two flows with both a positive and a negative one, or it reports an error. If the signs change more than once, it warns that more than one answer may exist.

Below the rate it shows total money in, total money out, net profit and the number of years. If you enter a discount rate, it also shows the NPV at that rate.

What next

Use this often? Add IRR to your Home screen.

Frequently asked questions

How do you calculate IRR?

Find the rate that makes the net present value of all cash flows zero. There’s no direct formula, so calculators search for it step by step.

What should I enter first?

Enter what you invest first, as a negative number, followed by what you receive each period. For example: -10000, 3000, 4000, 5000.

What is a good IRR?

It depends on the risk and on what else you could do with the money. Compare it with the return you require.

What’s the difference between IRR and NPV?

NPV gives a value in dollars at a rate you choose. IRR gives the rate at which that value is zero. They’re often used together.

Can the NPV be negative when the IRR is positive?

Yes. If you discount at a rate above the IRR, the NPV is negative. For -10000, 3000, 4000, 5000, the IRR is 8.90%, and the NPV at 10% is −$210.37.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools