XIRR Decoded: The Ultimate Metric for Irregular Portfolios
Understanding why CAGR fails for real-world investing and how to measure the true annualized velocity of your capital.
The CAGR Fallacy in a Staggered World
Most investors use CAGR (Compound Annual Growth Rate) to measure their performance. While CAGR works perfectly for a 'one-time investment,' it fails miserably the moment you add more money or take some out. If you invest ₹1 Lakh in 2020 and another ₹1 Lakh in 2023, a simple CAGR from the 2020 start date will severely understate your actual performance.
Extended Internal Rate of Return (XIRR) was created to solve this specific problem. It treats every single cash flow—whether an investment (money out) or a dividend (money in)—as its own mini-investment with its own unique time duration.
XIRR: The Truth About Your Market Timing
XIRR is essentially the interest rate that makes the 'Net Present Value' (NPV) of all your cash flows zero. In plain English: it is the 'Average Yearly Speed' your money traveled at, accounting for exactly *when* each rupee entered or exited the market.
This makes it the final authority on market timing. If you consistently invest when the market is low, your XIRR will be significantly higher than the market's standard CAGR. Conversely, if you 'buy high' at every peak, your XIRR will reflect the drag of that poor timing.
Money In vs. Money Out: The Sign Protocol
The most common mistake when using an XIRR calculator is getting the positive and negative signs wrong. In financial math, an investment is a 'Negative' cash flow (because the money is leaving your wallet), while a redemption or the current portfolio value is a 'Positive' cash flow.
To get an accurate result, you must include a final entry representing the 'Current Value' of your portfolio as of today. Without this 'Terminal Value,' the calculator thinks you have spent all your money and never got any back, resulting in a -100% return.
Handling Dividends and Withdrawals
Dividends should be entered as positive cash flows on the date they hit your bank account. However, if you chose the 'Dividend Reinvestment' (IDCW) option, you shouldn't enter them separately, as they are already reflected in the growing value of your units.
Similarly, partial withdrawals (selling some shares to pay for a vacation) are positive cash flows. XIRR is the only metric that can seamlessly blend these 'Leakages' back into your total performance history to show you if you are actually outperforming a simple bank deposit.
The 'Failed to Converge' Error: When Math Breaks
XIRR is solved through an 'Iterative' process—the computer makes a guess, checks the result, and refines the guess. Occasionally, if you have very wild cash flows (e.g., investing ₹10 and then withdrawing ₹10 Million the next day), the math cannot find a single stable percentage.
If you see a 'Failed to Converge' error, check your dates and amounts. Ensure you don't have multiple entries for the same date and that your final 'Current Value' is realistic. For 99% of normal investing patterns, XIRR will provide a precise, sober look at your wealth-creation velocity.