CAGR works beautifully when you invest a single lump sum once and check the value once at the end. But almost no one actually invests that way. You add money to your SIP every month, you might withdraw some for an emergency, you reinvest dividends at irregular intervals — your cash flows are messy and unevenly spaced. XIRR (Extended Internal Rate of Return) is built specifically for that mess. It finds the single annualized rate of return that makes the present value of every single cash flow you've ever made — both money going in and money coming out — net out to exactly zero.

The "extended" in XIRR refers to the fact that it handles cash flows on irregular dates, unlike its simpler cousin IRR, which assumes equal time periods between flows. XIRR assigns a date to every transaction and weighs each one by exactly how long it's been invested. A dollar you invested 5 years ago and a dollar you invested 5 days ago contribute very differently to your overall annualized return, and XIRR is the only common metric that captures this correctly.

The single most common mistake people make with XIRR is sign confusion. Every cash flow you put INTO the investment (money leaving your pocket) is entered as a negative number. Every cash flow you take OUT (money returning to your pocket) — including the final current value of your remaining holdings, which you're conceptually "cashing out" on the valuation date — is entered as a positive number.

Suppose you made the following investments into a mutual fund:

Solving for the rate that makes the present value of all five flows sum to zero by hand requires trial and error (Newton-Raphson iteration, mathematically) — which is exactly why a calculator does it for you. For this example, the XIRR comes out to approximately 14.2% annualized. Notice how this single number accounts for the fact that the $2,000 added in January 2024 had much less time to grow than the original $5,000 from January 2023 — a simple average return would have treated them identically and given you a misleading number.

Because XIRR is found through iterative approximation rather than a direct algebraic formula, certain unusual cash flow patterns — for example, all-positive flows, all-negative flows, or extremely erratic deposit/withdrawal cycles — can cause the calculation to fail to settle on an answer. If your XIRR result looks wildly implausible (like 400% or a deeply negative number that doesn't match your intuition), double-check that your sign conventions are correct and that you've included the current value as a final positive cash flow.

An XIRR in isolation tells you very little. The real value comes from comparison. Calculate the XIRR of the Nifty 50, S&P 500, or another relevant benchmark index using the exact same dates and amounts you invested (a hypothetical "what if I'd put this money in the index instead" exercise). If your fund's XIRR beats the benchmark's XIRR over the same period, the fund manager (or your stock-picking) added real value above and beyond just being in the market.