Personal Finance Insurance Credit Score Credit Cards Loans Investing Calculators All guides Subscribe

Internal Rate of Return (IRR) Calculator

This IRR calculator finds the internal rate of return on a series of cash flows, along with the modified internal rate of return (MIRR) and the total net cash. Use it to compare investments, rental properties or business projects whose money comes in and goes out at different times.

What is the internal rate of return?

The internal rate of return is the annual rate of return that makes the net present value (NPV) of all of an investment’s cash flows equal to zero. Put simply, it is the compound growth rate your money effectively earned, taking into account exactly when each dollar went in and came out. A project that requires $100,000 today and returns cash over five years has an IRR that summarizes all of those flows in a single percentage.

IRR is popular because it is easy to compare with a hurdle rate, such as your cost of capital or the return you could get elsewhere. If the IRR is higher than the hurdle, the investment adds value; if it is lower, you would do better with the alternative. It has known weaknesses, though, which is why this calculator also reports MIRR.

How to use the IRR Calculator

  1. Period 0 (initial investment, negative) — the upfront cost, entered as a negative number, for example −100000.
  2. Period 1 cash flow through Period 10 cash flow — the net cash received (positive) or paid (negative) in each later period. Include a final sale price or salvage value in the last period. Trailing zeros are ignored.
  3. Period length — Years, Months or Quarters. For monthly or quarterly flows the calculator annualizes the result.
  4. Finance rate (for MIRR) — the rate at which negative cash flows are financed, often your borrowing cost.
  5. Reinvestment rate (for MIRR) — the rate you could realistically earn on cash received. Both MIRR rates apply per period.

How IRR is calculated

There is no direct formula for IRR. The calculator searches for the rate that sets NPV to zero, narrowing the range until it converges.

IRR = the rate r that solves 0 = CF0 + CF1 ÷ (1 + r) + CF2 ÷ (1 + r)2 + … + CFn ÷ (1 + r)nwhere CFt is the net cash flow in period t; annualized IRR = (1 + r)periods per year − 1; MIRR = (Future value of positive flows at the reinvestment rate ÷ Present value of negative flows at the finance rate)1/n − 1

The results show the IRR (annualized when periods are months or quarters), the IRR per period, the MIRR, the undiscounted net cash and the number of periods. A bar chart displays each period’s cash flow.

Worked example

A small business owner is considering $100,000 of equipment that is expected to produce extra cash flow of $25,000, $30,000, $35,000, $40,000 and $30,000 over the next five years. Her cost of capital is 8%.

Item Value
Initial investment (year 0) −$100,000
Cash flows, years 1–5 $25,000, $30,000, $35,000, $40,000, $30,000
Net cash (undiscounted) $60,000
NPV at 8% $26,471
MIRR (8% finance and reinvestment rates) 13.19%
IRR 17.07%

The IRR of about 17.1% comfortably beats her 8% hurdle, and the positive NPV confirms the equipment adds value. The lower MIRR reflects a more realistic assumption that cash received is reinvested at 8%, not at 17%.

Interpreting the results

  • Accept projects whose IRR exceeds your hurdle rate, and treat results close to the hurdle with caution, since small changes in forecasts can flip the decision.
  • IRR assumes interim cash is reinvested at the IRR itself. For high-IRR projects that is often unrealistic, so MIRR is usually the more conservative figure.
  • If cash flows change sign more than once, for example a large repair cost in a later year, there can be more than one IRR or none at all. Rely on NPV or MIRR in that case.
  • When comparing projects of different sizes, a higher IRR does not always mean more value. A large project with a lower IRR can produce a bigger NPV.
  • Use consistent cash flows: after-tax figures for after-tax returns, and include any sale proceeds or closing costs.

Keep in mind: IRR is only as reliable as the cash flow forecast behind it. It also says nothing about risk; two projects with the same IRR can have very different chances of delivering it.

Frequently asked questions

What is a good IRR?

A good IRR is one that clearly exceeds your cost of capital or the return available on comparable investments with similar risk. Many businesses set a hurdle rate several points above their borrowing cost. There is no single number that works for every investment.

What is the difference between IRR and NPV?

NPV discounts cash flows at a chosen rate and gives the value added in dollars. IRR is the discount rate at which NPV equals zero and is expressed as a percentage. When the two disagree on ranking projects, NPV is generally the better guide because it measures total value.

What is MIRR and why use it?

The modified internal rate of return assumes positive cash flows are reinvested at a rate you choose and negative ones are financed at a rate you choose, rather than at the IRR. It produces a single answer even when cash flows change sign more than once and is usually more realistic.

Can IRR be negative?

Yes. If the total cash returned is less than the amount invested, the IRR is negative, meaning the investment lost money on a time-weighted basis. If cash flows never turn positive, there may be no IRR at all.

How do I calculate IRR for monthly cash flows?

Enter each month as a period and set the period length to Months. The calculator finds the monthly IRR and annualizes it by compounding over 12 months. Enter the MIRR finance and reinvestment rates as monthly rates in that case.

Results are estimates for educational purposes and are not financial, tax or legal advice. Figures reflect 2026 rules where noted; confirm details with official sources or a qualified professional.

Scroll to Top