XIRR vs CAGR: Key Differences, Formulas & SIP Examples
The difference between XIRR and CAGR comes down to cash flows: did you invest once, or add and withdraw money along the way? Knowing that distinction helps you read your mutual fund statement without confusing total profit with yearly growth.
Extended Internal Rate of Return (XIRR)
XIRR measures the annualised return on a series of dated investments and withdrawals. It accounts for both the amount invested and how long that money was invested. That makes it useful for a Systematic Investment Plan (SIP).
Think of it this way: money invested in January gets more time in the market than money invested in December. XIRR brings those different holding periods into one annual return.
Importance of XIRR
Your actual transaction dates can change your personal return, even if someone else owns the same fund. XIRR helps you review a portfolio with SIP instalments, extra purchases or redemptions using one annualised measure.
• XIRR Calculation: A Simple Example
Example: You invest ₹10,000, add another ₹10,000 a year later, and then check the portfolio value. Each deposit has had a different amount of time to grow.
| Date | Cash flow | Meaning |
|---|---|---|
| 1 January 2023 | −₹10,000 | First investment |
| 1 January 2024 | −₹10,000 | Additional investment |
| 31 December 2024 | +₹23,100 | Portfolio value on the valuation date |
For these dates, the XIRR is 10% annualised. At that equivalent rate, the first ₹10,000 accounts for ₹12,100 and the second for ₹11,000: a total of ₹23,100.
=XIRR(values, dates).Compound Annual Growth Rate (CAGR)
CAGR expresses growth between a starting value and an ending value as an equivalent annual rate. It assumes a smooth growth path for comparison, even though markets rarely move smoothly. Read our guide to compounding for the idea behind growth on growth.
Here, n is the holding period in years. Multiply the result by 100 to express it as a percentage.
Example: You invest ₹1,00,000 once, and it becomes ₹1,21,000 after two years. That is a 21% total gain, or a 10% CAGR. The annual figure makes the growth easier to understand.
Importance of CAGR
A total gain means little without a holding period: doubling money in five years is different from doubling it in fifteen. CAGR puts growth on an annual basis. For fund comparisons, still check the same dates, plan and option, alongside risk.
Differences Between XIRR and CAGR
| Factor | XIRR | CAGR |
|---|---|---|
| Inputs | Each cash flow and its date | Starting value, ending value and years |
| Cash flows | Handles multiple deposits and withdrawals | Does not account for interim cash flows |
| Useful for | SIPs, top-ups and partial redemptions | A lump sum with no interim cash flows |
| Perspective | Return on your dated investments | Smoothed growth between two values |
| Limitation | Needs complete transaction records | Hides fluctuations along the way |
XIRR or CAGR: Which Should You Use?
For your SIP statement, check XIRR. For an untouched lump sum, CAGR is simpler. When comparing funds, align the dates, plan, option and return method. A fund's published CAGR and your personal XIRR may differ because your transaction history differs.
Planning a future goal? Try our SIP calculator or lump sum calculator. Their assumed returns are planning inputs; they do not measure your actual transaction history.
Frequently Asked Questions
Is XIRR better than CAGR for SIP returns?
Yes, XIRR is more appropriate for SIPs because each instalment has its own investment date. CAGR applied to total contributions misses that timing.
Can XIRR and CAGR be the same?
Yes. For one investment and one ending value, they agree when the elapsed-year convention is the same. Leap years or different day-count conventions can cause small differences.
Is XIRR always higher than CAGR?
No. There is no fixed ordering. Check the cash flows, dates and calculation basis before comparing the numbers.
Does a 10% CAGR mean I earned 10% every year?
No. CAGR shows an equivalent steady growth rate between the starting and ending values. Actual yearly returns can be higher, lower or negative.
Why is my SIP XIRR different from the fund's CAGR?
The fund's CAGR tracks growth between two values over a stated period. Your SIP XIRR also reflects when each instalment was invested and any withdrawals. They describe different investment histories, so they need not match.
Is XIRR the same as absolute return?
No. Absolute return describes the overall percentage gain or loss without annualising it. XIRR accounts for dated cash flows and expresses the result as an annual rate.
Conclusion
Use XIRR to understand returns when money moves in or out on different dates. Use CAGR for growth from one starting amount to one ending value. Read the number alongside your goals, holding period and risk, rather than judging an investment by return alone.
Need help understanding your mutual fund statement? Speak with Ideas2Invest, an AMFI Registered Mutual Fund Distributor, ARN-113588.