When you check the performance of your investments, two numbers appear most often: CAGR and XIRR. Both show annualized returns, yet they work differently and can yield very different results for the same portfolio. Understanding the difference helps one read statements correctly and avoid incorrect conclusions.
Read Also: Power of Compounding Interest
Table of Contents
What Is CAGR?
CAGR refers to the Compound Annual Growth Rate. It shows the constant annual rate at which an investment would have grown if it had compounded smoothly from the starting value to the ending value.
CAGR assumes:
- One initial investment
- One final value
- No intermediate deposits or withdrawals
- Even growth every year
CAGR Formula
CAGR=(Final ValueInitial Value)1n−1\text{CAGR} = \left( \frac{\text{Final Value}}{\text{Initial Value}} \right)^{\frac{1}{n}} – 1CAGR=(Initial ValueFinal Value)n1−1
where n n n = the number of years.
Example You invest ₹1,00,000. After 5 years the value becomes ₹1,61,051.
CAGR=(1,61,0511,00,000)15−1=10%\text{CAGR} = \left( \frac{1,61,051}{1,00,000} \right)^{\frac{1}{5}} – 1 = 10\%CAGR=(1,00,0001,61,051)51−1=10%
Investment grew at an average rate of 10% per year.
What Is XIRR?
The Extended Internal Rate of Return (XIRR) is a measure of the profitability of investments. It calculates the annualized return when money is invested or withdrawn on different dates and in different amounts.
Read Also: What Is NAV in Mutual Funds
XIRR considers:
- Exact date of every cash flow
- Amount of every investment and withdrawal
- The final portfolio value on a specific date
Because the calculation is complex, it is normally performed using Excel’s XIRR function or an online calculator.
Key Differences Between XIRR and CAGR
| Basis | CAGR | XIRR |
|---|---|---|
| Full Form | Compound Annual Growth Rate | Extended Internal Rate of Return |
| Cash Flows | Single investment + final value | Multiple investments and withdrawals |
| Timing of Money | Ignored | Fully considered |
| Best For | Lump-sum investments | SIPs, irregular investments, partial redemptions |
| Calculation Difficulty | Simple (manual formula) | Requires spreadsheet or tool |
| Assumption | Smooth, constant growth | Real-world timing of cash flows |
| Suitability for SIPs | Not accurate | Accurate |
When to Use CAGR
Use CAGR when:
- You made one lump-sum investment
- You held it for a clear period without adding or withdrawing money
- You want to compare the historical growth of two funds or indices over the same period
- You need a simple annualised growth number for reporting
When to Use XIRR
Use XIRR when:
- You invest through SIPs
- You make additional lump-sum investments on different dates
- You withdraw money partially during the investment period
- You want the true annualised return of a portfolio with irregular cash flows
For most mutual fund investors who use SIPs, XIRR is a more meaningful number.
Practical Example: Why the Numbers Differ
In the lump-sum case, an investment of ₹1,00,000 grows to ₹1,61,051 in 5 years. Both CAGR and XIRR yield the same result: 10%.
In an SIP case, you invest ₹10,000 every year for five years. The final value was ₹70,000.
- The CAGR becomes misleading because there is no single starting amount.
- XIRR correctly accounts for the different investment dates and provides the actual annualized return.
This is why mutual fund statements usually show the XIRR for SIP investments and the CAGR for pure lump-sum holdings.
Limitations of CAGR and XIRR
Limitations of CAGR
- Ignores the timing of any intermediate cash flows
- Assumes smooth growth and does not show volatility
- Cannot be used accurately for SIPs or irregular investments
Limitations of XIRR
- Sensitive to the exact dates entered
- Requires accurate cash-flow data
- Can produce extreme numbers for very short periods (annualisation effect)
- Assumes that any money withdrawn is reinvested at the same rate (which may not happen in real life)
Neither metric alone indicates the risk or consistency of returns.
Common Misconceptions
- “Higher XIRR always means better performance” — Not necessarily. The number depends on the cash flow timing.
- “CAGR shows the actual yearly return every year”-It only shows the average rate that connects the start and end values.
- “XIRR and CAGR can be directly converted into each other” — They cannot because they use different assumptions.
- “A negative XIRR means you have lost the same percentage of your total capital” — The percentage is annualized and weighted by timing, so the absolute loss can be smaller.
Key Takeaways
- The CAGR works best for a single lump-sum investment held for a fixed period with no additional deposits or withdrawals.
- XIRR is designed for multiple cash flows on different dates (SIPs, additional investments, and partial withdrawals).
- The CAGR can be easily calculated manually. The XIRR usually requires a spreadsheet or calculator.
- Using the wrong metric can make returns look better or worse than they actually are.
Final Thoughts
CAGR and XIRR both express returns in an annualized form, but they answer different questions. CAGR answers: “If I had invested a lump sum and left it untouched, what average yearly growth would I have earned?” XIRR answers: “Given the exact dates and amounts I actually invested and withdrew, what annualised return did I achieve?”
For a single lump-sum investment held continuously, CAGR is sufficient and easy to calculate. For SIPs, additional investments, or partial withdrawals, XIRR is the correct metric to use. Using the correct one helps evaluate performance accurately and make better decisions based on real cash-flow patterns.
FAQs
What is the main difference between the XIRR and CAGR?
CAGR assumes a single investment made at the beginning and calculates the average annual growth until the end value. The XIRR considers multiple investments and withdrawals made on different dates and calculates the true annualized return based on the exact timing of each cash flow.
When should I use CAGR?
Use CAGR when you have made only one lump-sum investment and have not added or withdrawn any money during that period. It is ideal for comparing the historical performance of two funds or an index over the same time frame.
When should I use XIRR?
Use XIRR when you invest through SIPs, make additional investments on different dates, or partially withdraw money. This is the correct metric for most mutual fund portfolios with irregular cash flows.
Why do SIP returns show XIRR instead of CAGR?
SIPs involve multiple investments on various dates. The CAGR assumes that all money was invested at once, which is not true for SIPs. XIRR accounts for the timing and amount of each instalment, providing a more accurate annualized return.
Can CAGR and XIRR yield the same results?
Yes, when there is only one investment and one final value with no intermediate cash flows. In this case, both metrics produce the same number. The numbers usually differ when multiple cash flows appear.
