Internal Rate of Return (IRR)

A return that respects timing

The Internal Rate of Return (IRR) is the single annualised rate that reconciles all the cash flows of an investment, accounting for *when* each one happened. Technically, it is the discount rate that makes the net present value of all cash flows equal zero. In plain terms, it answers: what constant annual rate of return would explain the money I put in, the money I took out, and the timing of each? Because timing matters enormously — a rupee returned early is worth more than one returned late — IRR is far more accurate than a simple percentage gain for investments with multiple, irregular cash flows.

Why India uses XIRR

For most Indian investors, the practical version is XIRR, the variant that uses exact calendar dates rather than assuming evenly spaced cash flows. This is essential for SIPs, where you invest on dozens of different dates, possibly top up, pause, or make partial redemptions — all landing on irregular dates. A simple CAGR cannot handle multiple dated transactions, which is why XIRR is the SEBI-aligned standard and every major fund house offers an XIRR calculator. In Excel, the formula is `=XIRR(values, dates)`, with investments entered as negatives and redemptions or current value as positives.

A worked example

Suppose you invest ₹10,000 a month for 12 months starting January 2025 — ₹1.2 lakh in total — and by March 2026 it is worth ₹1.45 lakh. A naive calculation might say you gained ₹25,000 on ₹1.2 lakh, about 20%. But XIRR reveals the real annualised return is closer to 26-27%, because the later instalments were invested for only a few months, not the full period. IRR captures that the money was not all working for the same length of time.

Beyond mutual funds

The same logic applies wherever cash flows are uneven and dated — real estate (a purchase, irregular rent, an eventual sale), and private equity, where SEBI's AIF benchmarks report a pooled IRR for fund returns. A commonly cited "good" long-term SIP XIRR in India is in the 10-15% range.

Why it matters. IRR/XIRR is the honest way to measure returns when you invest piecemeal, as almost every Indian investor does through SIPs. It prevents the flattering illusion of a simple gain calculation and gives a true annualised figure you can compare across investments. Whenever cash flows are irregular, reach for XIRR — it is the number that tells you what your money actually earned.