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.