HomeGuides and ArticlesIRR: what internal rate of return measures

IRR: what internal rate of return measures

Understand periodic IRR, check it against NPV and account for timing, scale and multiple possible rates.

Content by Calculaderia · Updated on

Methodology and reviewReport an error

IRR, or internal rate of return, is the discount rate that makes a cash flow’s net present value (NPV) zero. Its time unit matches the intervals between the values you enter.

What the rate measures

Discount each future cash flow by a rate r. IRR is the value of r for which the discounted sum is zero. Calculators and spreadsheets usually find it by numerical approximation. It describes the entered cash flows; it does not measure risk, liquidity or how likely projected receipts are.

A two-period example

Enter an outflow of R$ 1,000 at period 0, zero at period 1 and an inflow of R$ 1,210 at period 2. Keep the zero so the final receipt stays two periods away.

The identity 1210/1.21 = 1000 independently confirms the solution. The actual Calculaderia function returns 9.999996%, within 0.00001 percentage point of 10%, due to its numerical tolerance.

Periodicity changes the interpretation

If each interval is a year, the example gives 10% annually. If each is a month, it gives 10% monthly. Convert a monthly rate to an annual equivalent using (1 + monthly rate)^12 - 1. A monthly 10% is approximately 213.84% annually; multiplying by 12 does not preserve compounding.

Comparing with a required return

Put IRR and your required return in the same unit. For a conventional cash flow, an initial outflow followed by receipts, an IRR above that reference corresponds to positive NPV; equality means zero NPV, and a lower IRR corresponds to negative NPV. The chosen reference and the future receipts remain assumptions.

IRR and NPV answer different questions

IRR finds a rate. NPV first chooses a discount rate and measures value in money. A smaller project can have a higher IRR while a larger one creates more NPV in reais. Use both when scale and absolute value matter.

Limits and irregular dates

Several changes of cash-flow sign can produce multiple rates or no useful answer. Ordinary IRR assumes equal intervals. For irregular dates, Excel’s XIRR uses actual dates and returns an annual rate based on 365 days. Neither method automatically includes risk or liquidity.

Calculate and check

Enter every receipt and payment in order and preserve zero periods. The calculator returns periodic IRR and its annual equivalent; check NPV separately at the rate relevant to your decision. For cell formulas, blank cells and spreadsheet errors, use the IRR in Excel tutorial.

Sources

Related calculators

Frequently Asked Questions

What does IRR mean?
Internal rate of return is the periodic discount rate that makes the net present value of the cash flows zero.
Is IRR monthly or annual?
It follows the interval between cash flows. Monthly flows give a monthly rate; annual flows give an annual rate.
How do IRR and NPV differ?
IRR finds an implied rate. NPV uses a chosen discount rate to express value in money. They answer different questions.
Is a higher IRR always better?
No. It does not describe absolute value created, risk, liquidity or scale. Different project sizes can rank differently by IRR and NPV.
Can there be several IRRs?
Yes. Multiple sign changes can produce several roots or no useful solution. Check the cash flows and NPV rather than selecting a rate in isolation.