Chapter 6 of 15
Understanding Returns — XIRR, CAGR, Absolute
Three ways returns are measured and when to use each.
Suresh had been invested in an equity fund for 2 years. His friend showed him a WhatsApp forward claiming a fund had given "40% returns" while his fund was showing only "28% returns." Suresh was ready to switch — until a fee-only advisor pointed out that his friend's "40% return" was an absolute return over 2 years while his own "28% return" was an annualised return. Suresh was actually earning significantly more. Misreading returns is one of the most common and costly mistakes Indian investors make.
The Three Return Metrics You Must Know
There are three primary ways to measure mutual fund returns, and each is appropriate for different situations. Using the wrong metric leads to completely wrong conclusions.
When to Use Absolute Return
Absolute return is only meaningful for investments held less than 1 year, such as a liquid fund you parked money in for 3 months. Beyond 1 year, absolute returns inflate the perception of gains because they do not account for time.
Priya invested ₹1,00,000 in a liquid fund in January. By August (8 months later), her investment is worth ₹1,15,000.
- Absolute Return = ((₹1,15,000 − ₹1,00,000) ÷ ₹1,00,000) × 100 = 15%
This 15% absolute return over 8 months sounds great — but should you compare it to a friend's "10% return" from a fund held for 2 years? Absolutely not. The 15% is for 8 months; if annualised, it is only about 22.5% annualised, while the friend's 10% over 2 years is only 5% annualised (CAGR). Absolute returns from different time periods cannot be compared.
A fund showing 50% absolute return sounds better than 35% — until you realise one held for 3 years and the other for 6 months. Always convert to CAGR or XIRR before comparing. AMFI mandates that funds display returns only as CAGR for periods of 1 year or more.
Understanding CAGR for Lumpsum Investments
CAGR is the gold standard for measuring lumpsum investment returns. It tells you the equivalent constant annual growth rate, smoothing out the volatility of year-to-year returns. When a fund says it has given "15% CAGR over 10 years," it means ₹1 lakh invested 10 years ago is now worth roughly ₹4.05 lakh.
Ramesh invested ₹1,00,000 in Mirae Asset Large Cap Fund (Direct - Growth) 6 years ago. Today it is worth ₹2,00,000.
- CAGR Formula: (Ending Value / Starting Value)^(1/years) − 1
- = (₹2,00,000 / ₹1,00,000)^(1/6) − 1
- = (2)^(0.1667) − 1
- = 1.1225 − 1
- = 0.1225 = 12.25% CAGR
This means the fund compounded at 12.25% every single year for 6 years. This is equivalent to a fixed deposit giving you exactly 12.25% per year — but your actual year-by-year returns could have been 8%, −5%, 22%, 14%, 18%, and 7% in a volatile market. CAGR smooths all of that into one clean annual number. Past performance disclaimer: Returns are illustrative. Actual mutual fund returns are subject to market risk.
XIRR: The Right Metric for SIP Investors
When you invest via SIP, each monthly instalment earns returns for a different duration — your first instalment earns returns for the full period, while the last instalment has barely started. A simple CAGR cannot handle this. XIRR calculates the precise annualised return for each cash flow dated individually.
Most platforms (Groww, Zerodha, CAMS) display XIRR automatically in your portfolio dashboard. You can also calculate XIRR in Excel by listing all SIP payment dates and amounts as negative cash flows, and the final portfolio value as a positive cash flow on today's date.
Anita did ₹10,000/month SIP for 12 months (total invested: ₹1,20,000).
- Her portfolio is now worth ₹1,40,000 (a gain of ₹20,000 or 16.7% absolute).
- But not all ₹1,20,000 was invested for a full year — the first instalment was in for 12 months, the last only 1 month.
- XIRR accounts for each instalment's exact holding period and calculates the effective annualised return ≈ 28–30% XIRR in this scenario.
The XIRR of ~28–30% means each rupee invested earned at that annualised rate for the time it was invested. This is far more meaningful than the 16.7% absolute return figure.
Rolling Returns vs Trailing Returns
When evaluating funds over longer periods, two additional measures matter:
Trailing Returns: Returns calculated from a fixed past date to today. E.g., "3-year trailing return" means from 3 years ago to today. The problem: this is highly sensitive to the start and end dates — a market crash at either point distorts the number.
Rolling Returns: Calculate the return for a specific period (e.g., 3 years) for every possible start date over a long history. This gives you the full distribution of outcomes — what's the average 3-year return? What's the worst 3-year return? Far more robust than trailing returns.
Sites like ValueResearchOnline and Morningstar India show rolling returns for funds. When a fund research site says a fund has "delivered positive returns in 98% of all 5-year rolling periods," that's a rolling return analysis.
| Metric | Best Used For | Limitation | Time Period |
|---|---|---|---|
| Absolute Return | Short-term investments < 1 year | Cannot compare across different time periods | < 1 year |
| CAGR | Lumpsum investments (1+ years) | Ignores cash flow timing; not for SIPs | 1+ years |
| XIRR | SIP or irregular investments | Requires all cash flow dates; complex manual calculation | Any period |
| Rolling Returns | Evaluating fund consistency over history | Historical; past does not guarantee future | Multi-year analysis |
| Trailing Returns | Quick comparison across funds | Sensitive to start/end date; misleading in volatile markets | Fixed point-to-today |
Suresh has been doing a ₹5,000/month SIP in a fund for 3 years. Which return metric should he use to measure his actual annualised returns?
Key Takeaways
- Absolute return is only for investments held less than 1 year — never compare absolute returns from different time periods.
- CAGR converts lumpsum investment returns to a clean annualised rate; a fund that doubles your money in 6 years is earning ~12.25% CAGR.
- XIRR is the most accurate return metric for SIP investors — it accounts for the exact timing of each instalment and gives a true annualised return figure.
- Rolling returns (available on ValueResearchOnline) are far more reliable than trailing returns for evaluating a fund's long-term consistency.