XIRR vs CAGR: Calculating Mutual Fund Returns
If you look at your mutual fund dashboard and see a "50% Return", you might be getting tricked by bad math. Understanding the difference between Absolute Return, CAGR, and XIRR is the most critical skill for any Indian investor.
While CAGR measures lump-sum growth between two points in time, XIRR calculates the exact annualized internal rate of return for multiple dated SIP cash flows.
- ✓ Why CAS Statements Use XIRR: Your mutual fund account statement shows XIRR because SIP installments bought units at varying NAVs over time.
- ✓ Why Factsheets Show CAGR: AMC scheme factsheets show point-to-point CAGR assuming a single ₹10,000 lump sum on the start date.
- ✓ Avoiding Comparison Errors: Never compare your personal SIP XIRR directly against the Nifty 50 point-to-point CAGR without matching cash flow dates.
Measure Your Portfolio's True Speed
Use our calculator to find the exact XIRR of your chaotic, real-world mutual fund SIPs and redemptions.
1. The Deception of Absolute Return
Absolute return is the simplest math: (Current Value - Invested Amount) / Invested Amount.
If you invested ₹1 Lakh and it is now worth ₹1.5 Lakhs, your absolute return is 50%. The problem is that Absolute Return completely ignores Time. A 50% absolute return achieved in 6 months is spectacular. A 50% absolute return achieved over 12 years is actually terrible (it wouldn't even beat inflation).
Therefore, any metric that does not account for time is useless for evaluating financial performance.
2. CAGR: The Gold Standard for Lumpsum
Compound Annual Growth Rate (CAGR) solves the time problem. It tells you the exact, smoothed-out annual rate at which your money grew every single year to reach its final value.
When to use CAGR: You should ONLY use CAGR when you have made a single, one-time (lump-sum) investment, and you have not added or withdrawn any money since.
- You invested ₹1 Lakh in an FD in 2015.
- In 2025, it matured at ₹2 Lakhs.
- The CAGR is exactly 7.18%.
You can verify this math instantly using our CAGR Calculator.
3. Why CAGR Fails for SIPs
If you apply the CAGR formula to a Systematic Investment Plan (SIP), the math shatters. Let's look at why:
Suppose you start a ₹10,000/month SIP for 1 year (Total invested = ₹1,20,000). At the end of the year, the value is ₹1,30,000. If you mistakenly plug ₹1,20,000 as the starting value and ₹1,30,000 as the ending value into a CAGR calculator, it will show a depressing ~8.3% return.
This is wrong because you didn't invest the full ₹1.2 Lakhs on Day 1!
- The first ₹10,000 was invested for 12 months.
- The sixth ₹10,000 was invested for only 6 months.
- The last ₹10,000 was invested for just 1 month.
Since the money had very little time in the market, the actual annualized return of that portfolio is much higher than 8.3%.
4. Enter XIRR: The Supreme Metric
Extended Internal Rate of Return (XIRR) is the only metric that can handle the chaotic reality of human investing. XIRR calculates an annualized return while accounting for multiple cash inflows (SIPs, lump-sum top-ups) and cash outflows (withdrawals) happening on random, specific dates.
| Metric | Accounts for Time? | Handles Multiple Cash Flows? | Best Used For |
|---|---|---|---|
| Absolute Return | No | No | Bragging rights on Twitter. |
| CAGR | Yes | No | Fixed Deposits, one-time Mutual Fund Lumpsums, Real Estate buys. |
| XIRR | Yes | Yes | SIPs, SWPs, entire multi-asset portfolios. |
If you want to evaluate whether a Mutual Fund is actually beating the index, you must compare its XIRR over 3, 5, or 10 years. You can evaluate historical fund performance using our Mutual Fund Returns Calculator.
Conclusion
Stop looking at the "Absolute Return" percentage in your brokerage app. If you invested a lump sum, calculate the CAGR. If you run a monthly SIP or frequently add cash on market dips, XIRR is the only mathematical truth of your portfolio's performance.
Why Mutual Fund Statements Use XIRR and Factsheets Use CAGR
Understanding why fund houses report different metrics across different documents is critical for accurate performance appraisal:
- Fund Factsheet (CAGR): When an AMC publishes that a fund returned 14.5% over 5 years, it is calculating the point-to-point CAGR of the scheme's NAV assuming ₹10,000 was invested on Day 1 and held continuously without addition or withdrawal.
- Investor CAS Statement (XIRR): Your personal Consolidated Account Statement (CAS) calculates XIRR because you invested money across multiple dates at varying NAVs. XIRR solves for the internal discount rate that equates your specific historical cash outflows with today's folio valuation.
Calculate Your Exact Numbers
Put the formulas and strategies from this guide into practice with our free financial calculators:
XIRR Calculator
Calculate exact extended internal rate of return for your mutual fund SIPs.
CAGR Calculator
Calculate compound annual growth rate for lump sum holdings.
Rolling Returns Calculator
Analyze return consistency across multiple rolling timeframes.
Portfolio Return Calculator
Aggregate returns from multiple mutual fund folios.
Explore Sibling Topics
Deepen your financial planning knowledge with our comprehensive educational guides:
CAGR vs XIRR vs Absolute Return
Comprehensive guide to all three primary investment return metrics.
Rolling Returns Explained
Eliminate point-to-point start/end date bias in fund selection.
Step-Up SIP Explained
How growing annual installments impact portfolio XIRR.
SWP Tax Calculation Guide
Calculate capital gains tax on systematic redemption flows.
Frequently asked questions
Why can't I use CAGR for my SIP investments?
CAGR assumes you invested a single lump-sum amount at the beginning of the period. Because a SIP involves multiple investments at different times (each having a different holding period), CAGR will give you a wildly incorrect and inflated result. You must use XIRR for SIPs.
What is Absolute Return?
Absolute return is simply how much money you made divided by how much you invested, completely ignoring the time it took. A 50% absolute return is amazing if achieved in 1 year, but terrible if it took 10 years.
Is XIRR the same as annualized return?
Yes, XIRR effectively calculates the annualized return (the average yearly growth rate) of a series of irregular cash flows occurring at different intervals.
Why does my SIP show different CAGR and XIRR on Zerodha/Groww?
CAGR assumes a single lump sum invested at the start, whereas XIRR calculates the exact annualized internal rate of return for multiple dated monthly instalments.
Is XIRR reliable for short-term SIPs under 1 year?
XIRR can show wildly exaggerated numbers for short-term cash flows under 6 months; use XIRR for SIP horizons exceeding 12 months.