Understanding Returns — CAGR, XIRR & Rolling Returns
CAGR for lumpsum, XIRR for SIP, rolling returns vs point-to-point, and real vs nominal returns explained simply.
Understanding Mutual Fund Returns: Absolute, CAGR, XIRR & More
"This fund gave 45% returns!" Sounds amazing, right? But was that 45% in 1 year or 5 years? Understanding return types is essential to comparing funds correctly and setting realistic expectations.
Absolute Returns
Formula: Absolute Return = ((Current Value - Invested Amount) / Invested Amount) × 100
The problem: Absolute returns are misleading for periods longer than 1 year. A "45% return" over 3 years is very different from 45% in 1 year.
Use absolute returns only for investments held for less than 1 year.
CAGR: The Standard for Lumpsum
Formula: CAGR = ((Final Value / Initial Value) ^ (1/Years)) - 1
Priya invested ₹1,00,000 in a fund. After 3 years, it's worth ₹1,45,000.
- Absolute Return: 45% (misleading for 3-year period)
- CAGR: (1,45,000/1,00,000)^(1/3) - 1 = 13.2% per year
CAGR of 13.2% tells the true annualized story. Much more useful for comparison.
CAGR assumes a smooth growth path. A fund might have returned -20% in year 1, +40% in year 2, and +30% in year 3. CAGR smooths these bumps into one number. Real journey might be bumpy.
XIRR: The Right Metric for SIPs
CAGR works for lumpsum. But for SIPs where you invest at different times, you need XIRR.
Ramesh runs a ₹10,000/month SIP for 3 years (36 installments):
- Total invested: ₹3,60,000
- Current value: ₹4,52,000
- Absolute return: 25.6%
But each ₹10,000 installment was invested at a different time. The first installment was invested for 36 months, the last for just 1 month.
- XIRR: 15.8% per year (correctly weights each installment)
This is higher than what simple CAGR would show, because each SIP installment has a different holding period.
Rolling Returns: The Most Honest Metric
Why rolling returns matter:
- Point-to-point returns can be misleading (what if start/end dates were lucky?)
- Rolling returns show consistency — how often did the fund beat its benchmark?
- They reveal the range: "5-year returns ranged from 8% to 22%"
| Return Type | Best For | Accounts for Time? | Multiple Cash Flows? |
|---|---|---|---|
| Absolute | Less than 1 year | No | No |
| CAGR | Lumpsum investments | Yes | No |
| XIRR | SIP investments | Yes | Yes |
| Rolling | Fund consistency check | Yes | No |
Real vs Nominal Returns
Anita's fund shows 12% CAGR over 10 years. But inflation averaged 6%.
- Nominal return: 12%
- Real return: (1.12/1.06) - 1 = 5.66%
- ₹1,00,000 grew to ₹3,10,585 nominally
- But in today's purchasing power, it's worth about ₹1,73,400
The fund tripled in numbers but less than doubled in real value. That's why beating inflation by at least 4-5% matters.
Benchmark Comparison
Always compare a fund's returns against its benchmark:
- Large-cap fund benchmark: Nifty 50 or BSE 100
- Mid-cap fund benchmark: Nifty Midcap 150
- Flexi-cap fund benchmark: Nifty 500
If a large-cap fund returned 14% but Nifty 50 returned 13%, the fund generated just 1% alpha. Is that worth the 1% higher expense ratio compared to an index fund? Often, it isn't.
How to Use Return Data Correctly
- Short-term (under 1 year): Use absolute returns
- Lumpsum (1+ years): Use CAGR
- SIP returns: Always use XIRR
- Fund comparison: Use 5-year and 10-year rolling returns
- Wealth planning: Use real returns (after inflation)
- Don't chase: Last year's top performer is rarely next year's
Key Takeaways
- Absolute returns ignore time — use only for sub-1-year periods
- CAGR is the standard for lumpsum comparison (annualized, compounded)
- XIRR is the only correct metric for SIP returns
- Rolling returns show consistency — always check the range
- Real returns (after inflation) show actual wealth growth
Which return metric should you use to evaluate SIP performance?
Calculate your SIP XIRR: SIP Calculator | Compare lumpsum: Lumpsum Calculator
Try Our Free Tools
Put what you've learned into action with our calculators and courses.