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.
Educational content only. This article is for learning purposes and does not constitute personalised financial, tax, or investment advice. Investments are subject to market risks. For decisions specific to your situation, consult a SEBI-registered investment adviser. Read our editorial standards.
Understanding Mutual Fund Returns: Because "15% Returns" Could Mean Anything
Ganesh saw it on Instagram. A reel with dramatic background music: "This fund gave 45% returns!" He screenshotted it, showed his roommate, and was ready to throw his entire ₹12,000 savings into it.
His roommate, who'd done exactly one finance course on YouTube, asked: "45% in how long?"
Ganesh blinked. "What do you mean, how long? 45% is 45%."
No, Ganesh. No, it isn't. 45% in one year is incredible. 45% over five years is... okay, about 7.7% per year. 45% over ten years is basically a savings account. The same number can mean completely different things depending on how you measure it.
This is the article Ganesh needed before he invested a single rupee. You probably need it too.
Absolute Returns: The Number That Lies to Your Face
Formula: Absolute Return = ((Current Value - Amount Invested) / Amount Invested) × 100
Here's why this is dangerous:
The Instagram reel said "45% returns." Ganesh did some digging.
Turns out, the fund grew from ₹1,00,000 to ₹1,45,000 over 3 years.
- Absolute return: 45% (the sexy number from the reel)
- Annualized return (CAGR): 13.2% per year (the real number)
13.2% is solid! But it's not the 45%-in-one-year Ganesh had imagined. He'd already mentally bought a new laptop with those "returns."
The rule: Use absolute returns only for periods under 1 year. Anything longer, and you need CAGR.
CAGR: The Standard for Lumpsum Investments
Formula: CAGR = ((Final Value / Initial Value) ^ (1/Number of Years)) - 1
Fund A grew ₹1,00,000 to ₹2,00,000 in 5 years. Fund B grew ₹1,00,000 to ₹2,00,000 in 10 years.
Both have 100% absolute return. Both doubled your money. But:
- Fund A CAGR: 14.9% per year: aggressive growth
- Fund B CAGR: 7.2% per year: barely beating inflation
Same absolute return. Completely different story. CAGR tells you the truth.
CAGR shows a smooth line, but the actual journey might be a mess. A fund could have crashed 30% in year 1, risen 50% in year 2, and crawled 5% in year 3. CAGR averages all that into one clean number. Useful for comparison, but don't mistake it for the actual ride. The ride was bumpy. You just can't tell from the CAGR.
XIRR: The Only Correct Metric for SIP Returns
This is where it gets genuinely tricky, so let me slow down.
CAGR works when you invest a lump sum once. But what if you're doing an SIP, investing ₹5,000 every month? Each installment enters the market at a different time, at a different NAV, and earns returns for a different duration.
Your January investment has been working for 12 months. Your December investment? Just 1 month. CAGR can't handle this. You need XIRR.
Ganesh invests ₹5,000/month for 2 years (24 installments).
- Total invested: ₹1,20,000
- Current value: ₹1,42,000
- Absolute return: 18.3% (but over 2 years, so misleading)
His first ₹5,000 was invested 24 months ago. His last ₹5,000 was invested last month. They've earned returns for completely different periods.
- XIRR: 16.5% per year (correctly accounts for each installment's timing)
This is higher than what simple CAGR on the total would suggest, because the later installments haven't had as much time to grow.
The rule: SIP = always use XIRR. Lumpsum = use CAGR. Mixing them up gives you garbage numbers.
Rolling Returns: The Most Honest Metric Nobody Uses
This is Ganesh's favourite concept now, because it destroyed his Instagram-reel-based investing strategy.
Why rolling returns matter:
- Point-to-point returns can be cherry-picked (start date in a crash, end date in a rally = amazing-looking returns)
- Rolling returns show consistency: "This fund delivered 12%+ in 85% of all 5-year windows"
- They reveal the worst case: "The worst 5-year CAGR was 4%": can you live with that?
| Return Type | Best For | Accounts for Time? | Handles SIP Cash Flows? |
|---|---|---|---|
| Absolute Return | Under 1 year only | No | No |
| CAGR | Lumpsum investments | Yes | No |
| XIRR | SIP investments | Yes | Yes, the only correct SIP metric |
| Rolling Returns | Checking fund consistency | Yes | No, but shows the full range of outcomes |
Real Returns vs Nominal Returns: The Inflation Reality Check
Ganesh's fund shows 12% CAGR over 10 years. He's thrilled. But inflation averaged 6% during that period.
- Nominal return: 12%: the number on the app
- Real return: approximately 5.7%: the actual wealth growth
- ₹1,00,000 grew to ₹3,10,585 on paper
- But in today's purchasing power, that's worth about ₹1,73,400
The fund tripled in rupee terms but less than doubled in real value. A ₹100 biryani in 2015 costs ₹180 in 2025. Your returns need to outrun that.
This is why "beating inflation" isn't just a cliché, it's the minimum bar. Any return that doesn't beat inflation by 3-4% isn't really growing your wealth. It's just keeping score in a currency that's losing value.
Benchmark Returns: The Context You're Missing
Ganesh used to look at a fund's return in isolation. "14%, great!" But great compared to what?
- If the Nifty 50 (the benchmark) returned 16% in the same period, that fund underperformed by 2%
- You would've earned more by buying a dirt-cheap index fund
Always compare a fund's returns to its benchmark:
- Large-cap funds → Nifty 50 or BSE 100
- Mid-cap funds → Nifty Midcap 150
- Flexi-cap funds → Nifty 500
If a large-cap fund returned 14% and the Nifty 50 returned 13%, that's 1% alpha (outperformance). But if the fund's expense ratio is 1.2%, you actually paid 1.2% for 1% of alpha. You lost 0.2%. An index fund at 0.1% expense ratio would've been the smarter choice. Alpha only matters if it exceeds the fees.
How Ganesh Reads Fund Returns Now
Before this article, Ganesh looked at one number: the big green percentage on the app. Now he has a system:
- Short-term check (under 1 year): Absolute return: just to get a quick sense
- Lumpsum comparison: CAGR over 3, 5, and 10 years
- SIP evaluation: XIRR: the only number that counts for monthly investments
- Consistency check: 5-year rolling returns: what's the range?
- Reality check: Real returns (subtract 5-6% inflation)
- Value check: Did it beat the benchmark after fees?
"I feel like I just got prescription glasses," Ganesh said. "Everything was blurry before and I didn't even know it."
That's the thing about financial literacy. You don't know what you're missing until you know.
Key Takeaways
- Absolute returns ignore time: only use for periods under 1 year
- CAGR is the standard for lumpsum comparison: it annualizes and accounts for compounding
- XIRR is the only correct metric for SIP returns: CAGR doesn't work for multiple cash flows
- Rolling returns show a fund's consistency across all possible holding periods: not just one cherry-picked window
- Real returns (after inflation) tell you if your wealth actually grew or just your numbers did
- Always compare fund returns against the benchmark: 14% means nothing if the index gave 16%
Calculate your actual SIP XIRR with our SIP Calculator or check lumpsum growth with the Lumpsum Calculator.
Which return metric should you use to evaluate your SIP performance?
Try Our Free Tools
Put what you’ve learned into action with our calculators and courses.