This article explains common return calculation methods for educational purposes. It does not evaluate or recommend any specific fund or investment.
Three different metrics, CAGR, absolute return, and XIRR, show up across mutual fund fact sheets, investment platforms, and statements, each measuring "return" in a genuinely different way. Comparing a fund quoted in one metric against another quoted differently, without converting to a common basis, leads to conclusions that can be meaningfully wrong.
Absolute Return: The Simplest, Least Useful Metric
Absolute return simply measures the total percentage gain or loss over a period, with no adjustment for how long that period actually was. If you invested ₹1 lakh and it grew to ₹1.5 lakh, your absolute return is 50%, regardless of whether that growth happened over 2 years or 10 years. This is the least useful metric for comparing investments with different holding periods, since a 50% absolute return over 2 years represents a considerably better annual performance than the same 50% over 10 years, but the raw number looks identical.
CAGR: Annualising the Return for Fair Comparison
Compound Annual Growth Rate (CAGR) converts a total return over any period into an equivalent annualised rate, answering "what constant annual growth rate would have produced this same total result?" This makes CAGR far more useful for comparing investments held over different time periods, a 50% absolute return over 2 years translates to roughly 22.5% CAGR, while the same 50% over 10 years translates to roughly 4.1% CAGR, a meaningfully different picture than the identical absolute return figures suggested.
Why CAGR Alone Still Has Limitations
CAGR assumes a single lump sum invested at the start and held throughout the entire period, with no additional contributions or withdrawals along the way. This makes it a poor fit for evaluating a SIP investment, where money was added at different times, each contribution having its own effective holding period and growth trajectory, a single CAGR figure calculated as if it were one lump sum doesn't accurately capture this.
XIRR: Built Specifically for Irregular Cash Flows
Extended Internal Rate of Return (XIRR) is designed specifically to handle multiple cash flows occurring at different dates, exactly the situation with a SIP, where you're contributing at various intervals, or with any investment involving partial withdrawals along the way. XIRR calculates the effective annualised return accounting for the specific timing and amount of every individual cash flow, giving a genuinely accurate picture of your actual return experience for an investment with an irregular contribution or withdrawal pattern.
A Worked Example Showing the Difference
Say you've been running a SIP for 3 years, contributing ₹5,000 monthly, and your current value is ₹2.2 lakh against total contributions of ₹1.8 lakh. Absolute return would show roughly 22% (the simple percentage gain on total contributed), but this tells you almost nothing useful, since your money was invested for varying periods, the first instalment for the full 3 years, the most recent instalment for barely any time at all. XIRR, calculated properly accounting for each instalment's specific date, gives you the genuinely comparable annualised rate this SIP has delivered, the metric you'd actually want when comparing this SIP's performance against another investment option quoted in annualised terms.
Why This Matters When Comparing Options
If you're comparing a lump sum investment's CAGR against a SIP's XIRR, you're comparing genuinely similar things (both are annualised rates), a fair comparison. But if you're comparing a fund's quoted CAGR against another platform's quoted absolute return without converting one to match the other, you risk drawing a conclusion that has nothing to do with which investment actually performed better on a comparable, annualised basis.
Where to Find These Figures for Your Own Investments
Most investment platforms and mutual fund statements now display XIRR specifically for SIP investments, recognising that CAGR alone doesn't accurately represent a series of contributions. For a straightforward lump sum investment, CAGR (sometimes simply labelled "annualised return") is the more commonly quoted and appropriate metric. Absolute return is still often shown too, mainly useful for a quick sense of total gain, but not for meaningful comparison across different holding periods or contribution patterns.
Practical Takeaway
Whenever comparing investment performance, whether across different funds, different platforms, or your own past decisions, confirm you're looking at the same type of metric on both sides of the comparison, and specifically use XIRR rather than a simple absolute or CAGR figure whenever the investment involved multiple contributions or withdrawals over time, since that's the only one of these three metrics actually designed to handle that situation accurately.
Frequently Asked Questions
Can I calculate XIRR myself, or do I need special software?
Spreadsheet programs like Excel and Google Sheets have a built-in XIRR function that calculates this automatically once you input your cash flow dates and amounts, you don't need specialised financial software, though many investment platforms calculate and display it for you automatically for SIP investments.
Is a higher XIRR always better than a lower one when comparing two funds?
Generally yes for a straightforward comparison of returns, but remember that XIRR (like CAGR) doesn't account for the risk taken to achieve that return, a higher XIRR achieved through a considerably more volatile or concentrated investment isn't automatically "better" without considering the risk involved to get there.
Does absolute return have any genuine use, given its limitations?
It's useful for a quick, simple sense of total gain on a specific holding, particularly for very short holding periods where annualising doesn't add much meaningful insight, or for illustrating the ultimate power of a long-term compounding story where the sheer total gain is itself the point, alongside the CAGR figure, not instead of it.
Why do some fund platforms show different XIRR figures for the same fund at the same time?
This can happen if the calculation period, exact contribution dates used, or whether dividends/IDCW payouts are factored in differently across platforms, worth checking the specific calculation methodology and date range each platform is using if you notice a meaningful discrepancy.
