XIRR vs CAGR:
Which Return Is Actually Real?

Both CAGR and XIRR measure investment returns. But they answer different questions. Use the wrong one and you'll either overestimate or underestimate your actual wealth creation by a significant margin.

1. What is CAGR - and What Does It Actually Measure?

CAGR stands for Compound Annual Growth Rate. It's the simplest return metric. It only needs two numbers: where you started and where you ended up. It ignores everything in between.

Think of CAGR as a straight, smooth line drawn between two points. It says: "If this investment grew at a perfectly constant rate every year, what would that rate be?" It doesn't care about whether the journey was bumpy, whether you added money halfway through or whether you withdrew some in year 3.

This makes CAGR perfect for one specific situation: a single lumpsum investment with no additions or withdrawals. An FD, a one-time mutual fund purchase, a gold bond. CAGR tells you exactly what you earned annually.

2. The CAGR Formula - Step by Step

Working example:

• Beginning Value: ₹1,00,000
• Ending Value: ₹2,00,000
• Years: 5
• CAGR = (2,00,000 ÷ 1,00,000)^(1/5) − 1 = 2^0.2 − 1 = 14.87% per year

Simple and clean. But notice what CAGR cannot handle: it has no concept of intermediate cash flows. The moment you invest ₹10,000 every month instead of once, CAGR breaks down completely.

3. What is XIRR - and Why SIP Investors Need It

XIRR stands for Extended Internal Rate of Return. Where CAGR ignores the timing of money movements, XIRR is built entirely around it. Every single rupee you invest gets timestamped. XIRR then figures out the one annual return rate that makes all those dated cash flows mathematically consistent with your final portfolio value.

This is exactly what SIP investors need. When you do a monthly SIP, you're making 12 investments a year, every year, each on a different date, at a different NAV. Your ₹10,000 invested in January 2022 has been compounding for a different duration than your ₹10,000 invested in January 2025. CAGR treats them the same. XIRR doesn't.

Think of XIRR as a personalised return. It reflects your specific journey, not the fund's journey. Two investors in the same fund with the same total investment can have different XIRRs if they invested at different times.

4. How XIRR Works - The Intuition Behind the Math

XIRR uses an iterative algorithm to find the discount rate that makes the Net Present Value (NPV) of all your cash flows equal to zero. It's the same principle banks use for loan EMI calculations, but applied in reverse to your investments.

You don't need to calculate XIRR manually. Excel, Google Sheets and every major mutual fund app do it automatically. But understanding the logic helps you interpret the number correctly:

• Each SIP instalment is a negative cash flow (money leaving your pocket on a specific date)
• Your final portfolio value is a positive cash flow (money you'd receive if you redeemed today)
• XIRR finds the rate that makes those cash flows balance out, accounting for exactly how long each instalment had to grow

5. CAGR vs XIRR - The Complete Decision Table

Here's the cheat sheet every Indian investor should bookmark:

6. The Absolute Return Trap - The Mistake 80% of Investors Make

Before XIRR became mainstream on fund apps, most Indian investors calculated their returns the wrong way. Many still do. It's called the absolute return trap, and it silently gives you a wrong number every time.

Here's how it looks:

The correct XIRR for the exact same scenario, where you invested ₹5,000 per month for 24 months and ended with ₹1.5 lakh, is approximately 23.4%. That's a massive difference from the "12.5%" the wrong method gives you.

The second version of this trap: using the total invested amount as "beginning value" in the CAGR formula. That also overstates returns dramatically because it treats the last month's SIP as if it had been invested since day one.

7. Real Indian SIP Scenarios - Same Fund, Different XIRRs

This is the part most investment guides skip, and it's the most important for understanding why your XIRR might differ from your friend's, even if you're in the same fund.

Scenario A: Raj from Mumbai - Started During the 2020 Crash

Raj started a ₹10,000 monthly SIP in March 2020, right at the COVID market bottom. Over 3 years to March 2023, he invested ₹3.6 lakh total. Final value: ₹5.25 lakh. His XIRR: approximately 26%. His early instalments bought NAVs at rock-bottom prices and had 3 full years to compound at post-recovery levels.

Scenario B: Meena from Pune - Started at the 2021 Peak

Meena started the same ₹10,000 SIP in November 2021, right before the mid-cap correction. Same fund. Same 3-year period to November 2024. She invested ₹3.6 lakh total. Final value: ₹4.42 lakh. Her XIRR: approximately 14%. Her early instalments hit peak NAVs and spent the first year underwater.

Same fund. Same investment amount. Same tenure. 26% vs 14% XIRR, purely because of timing. This is why comparing your XIRR with someone else's is rarely useful. Compare it to the fund's benchmark CAGR instead.

Scenario C: Arjun from Bengaluru - The Step-Up SIP

Arjun started with ₹5,000/month and increased by ₹1,000 every year via a step-up SIP. Over 5 years, his total investment was ₹3.9 lakh vs ₹3 lakh for a flat SIP. His XIRR was slightly lower than a flat SIP investor in the same fund, because his larger later-year instalments had less time to compound. But his absolute wealth created was higher. Step-up SIPs build more corpus even if XIRR looks lower.

8. Why Market Timing Changes Your XIRR - Even Without Market Timing

The whole point of SIP investing is that you don't time the market. You invest every month regardless of whether markets are up or down. This is called rupee cost averaging. But here's the nuance most people miss: even without actively timing, the period in which you invest heavily affects your XIRR.

Rupee cost averaging works in your favour when markets are volatile during your SIP period. You automatically buy more units when prices drop. This shows up as a higher XIRR over time. But if your SIP happens to fall entirely in a bull run followed by a correction right before you check your returns, your XIRR will look low even though the strategy is sound.

For a deeper understanding of how real returns compare across asset classes after inflation, read our guide on nominal vs real return, because even a 15% XIRR needs to be adjusted for 6% inflation to understand true wealth creation.

9. Post-Tax XIRR - The Number Nobody Talks About

Here's the part that most fund comparison articles completely ignore: your XIRR is a pre-tax number. For equity mutual funds, gains above ₹1.25 lakh per financial year are subject to 12.5% Long Term Capital Gains (LTCG) tax when you redeem.

*LTCG tax of 12.5% applies to equity gains above ₹1.25 lakh per FY (Budget 2024). Debt fund gains taxed at income slab rate. PPF rate as of Q4 FY2025-26.

For a complete picture of how taxes eat into your returns across all asset classes, see our SIP calculator with LTCG tax guide and the capital gains tax India breakdown.

10. Summary - Which Metric to Use and When

• Single investment (FD, lumpsum fund, gold bond): Use CAGR. It's accurate and simple.
• Monthly SIP or step-up SIP: Always use XIRR. It's the only accurate measure.
• Comparing your return to a fund's published return: The fund shows CAGR in its factsheet. Your app shows your XIRR. They measure different things. Don't compare them directly.
• Checking if your SIP is "beating" an FD: Compare your post-tax XIRR (after LTCG) vs the FD's post-tax CAGR. Both need the same tax treatment to be comparable.
• Long-term wealth planning: Always adjust XIRR for inflation to get your real return, because 12% XIRR at 6% inflation is actually 5.7% real wealth creation.
• Evaluating expense ratio impact: A 1.5% expense ratio silently reduces your XIRR every year. Learn how in our expense ratio guide.