Skip to main content

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.

Intermediate12 min readUpdated
By Kousigan A · Learn. Share. Grow together.

"15% returns" means nothing until you know which number it is. Absolute return ignores time and only works under a year. CAGR is the standard for a lump sum. XIRR is the only correct metric for a SIP, because CAGR can't handle a dozen separate investment dates.

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

Absolute Return:
The total percentage gain or loss from start to finish, ignoring time completely. Invested ₹1,00,000 and it became ₹1,45,000? That's a 45% absolute return. Could've taken 1 year or 10 years, this number doesn't care.

Formula: Absolute Return = ((Current Value - Amount Invested) / Amount Invested) × 100

Here's why this is dangerous:

Ganesh's Instagram Fund. The Reality Check

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

CAGR (Compound Annual Growth Rate):
The annualized rate at which your investment would have grown if it grew at a steady pace. It smooths out the bumps and tells you: "On average, your money grew X% per year." This is the standard metric for comparing lumpsum investments.

Formula: CAGR = ((Final Value / Initial Value) ^ (1/Number of Years)) - 1

Two Funds, Same Absolute Return, Very Different CAGR

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.

What CAGR Hides

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.

XIRR (Extended Internal Rate of Return):
The annualized return that correctly weights multiple investments made at different times. Since each SIP installment was invested on a different date, XIRR figures out the single annual return rate that explains your total portfolio value. This is the only honest SIP return metric.
Say Ganesh Runs a ₹5,000/Month SIP

Say 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

Rolling Returns:
Returns calculated for every possible holding period of a given length. Instead of one 5-year return (which depends on your lucky or unlucky start date), you get hundreds of 5-year returns, starting from every possible month. This shows you the full range of outcomes, not just the one the marketing team picked.

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?
Comparison table: Return Type, Best For, Accounts for Time?, Handles SIP Cash Flows?
Return TypeBest ForAccounts for Time?Handles SIP Cash Flows?
Absolute ReturnUnder 1 year onlyNoNo
CAGRLumpsum investmentsYesNo
XIRRSIP investmentsYesYes, the only correct SIP metric
Rolling ReturnsChecking fund consistencyYesNo, but shows the full range of outcomes

Real Returns vs Nominal Returns: The Inflation Reality Check

Real Return:
Your actual gain in purchasing power after accounting for inflation. If your fund earns 12% and inflation is 6%, your real return is roughly 6%. This is what actually makes you wealthier, not the number on your app screen.
The Inflation Illusion That Fooled Ganesh

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
Alpha: The Only Thing Worth Paying For

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.

Quick Quiz

Which return metric should you use to evaluate your SIP performance?

Frequently asked questions

What is the difference between CAGR and XIRR?

CAGR (Compound Annual Growth Rate) measures returns on a single lumpsum investment between two dates. XIRR (Extended Internal Rate of Return) accounts for multiple cash flows at different dates, making it the correct measure for SIP returns. Never use CAGR to evaluate SIP performance as it will give misleading results.

What are rolling returns and why do they matter?

Rolling returns measure returns over every possible holding period of a given length. For example, 5-year rolling returns show the return for every 5-year window in the fund's history. This gives a complete picture of consistency, unlike point-to-point returns which depend heavily on the start and end dates chosen.

What is the difference between absolute and annualised returns?

Absolute return is the total percentage gain or loss (e.g., 50% over 3 years). Annualised return converts this to a yearly equivalent (e.g., 14.5% per year). For periods under 1 year, absolute return is the clearer number, because annualising a few months exaggerates. In fund advertisements, SEBI requires a simple annualised return for schemes 6 to 12 months old and allows no past performance under 6 months. For longer periods, always compare annualised returns to make meaningful comparisons across funds.

Try Our Free Tools

Put what you’ve learned into action with our calculators and courses.

Continue Learning

This guide is part of our Mutual Funds course. Start with the related chapter:

Understanding Returns - XIRR, CAGR, Absolute

Related guides