What Is XIRR? Understanding Returns on Irregular Investments

If you invest a lump sum once and let it grow, CAGR gives you a clean picture of your annualized return. But most investors, especially those using SIPs, invest different amounts at different points in time — some months more, some less, sometimes with gaps. This is where Extended Internal Rate of Return, or XIRR, becomes essential, because it accounts for the exact timing and size of every individual cash flow.

XIRR calculates the annualized rate of return for a series of cash flows that occur at irregular intervals and in irregular amounts. Unlike CAGR, which assumes a single investment made at one point in time, XIRR can handle multiple investments, redemptions, and dividends spread across months or years, giving a far more accurate return figure for real-world investment patterns like SIPs.

Behind the scenes, XIRR uses an iterative calculation to find the single discount rate that makes the net present value of all your cash flows (every SIP installment you put in, and the final value you'd get if you redeemed today) equal to zero. In simpler terms, it finds the "effective" annual return rate that reconciles everything you put in with what you'd have today, accounting for exactly when each rupee was invested.

Suppose you invested ₹5,000 every month for three years into a mutual fund through a SIP, and today your total investment is worth significantly more than what you put in. Because each ₹5,000 installment was invested at a different point in time, some units have grown for nearly three years while your most recent installment has barely had time to grow. A simple return calculation would misrepresent your actual annualized gain — XIRR correctly weighs each installment by how long it's actually been invested.

• CAGR assumes a single lump-sum investment at the start and a single value at the end; XIRR handles multiple cash flows at different dates.

• CAGR is simpler to calculate manually; XIRR typically requires a spreadsheet function or calculator due to its iterative nature.

• CAGR is ideal for lump-sum investments; XIRR is the correct metric for SIPs, staggered investments, or portfolios with periodic withdrawals and additions.

• Most mutual fund platforms and apps display your SIP portfolio's returns as XIRR rather than simple percentage gain

• Financial planning tools use XIRR to help you understand the true annualized performance of goal-based investments funded through regular contributions

• Comparing two different SIP portfolios with different contribution patterns is only meaningful using XIRR, not a simple absolute return percentage

A common mistake is comparing XIRR figures across investments with very different durations or contribution patterns and assuming they're directly comparable in every sense. While XIRR does annualize returns, a high XIRR over a very short period (say, a few months) can look deceptively impressive and shouldn't be extrapolated forward as a stable long-term expectation.

Understanding your true XIRR, rather than relying on a rough mental estimate, is critical for evaluating whether your SIP strategy is actually working and whether your fund selections are performing as expected relative to their benchmarks. The Mahir Approach to investing emphasizes measuring what actually matters — and for the millions of Indians investing through SIPs, XIRR, not CAGR, is usually the number that tells the real story.