XIRR vs CAGR: What Is the Difference?
When investors evaluate the performance of their investments, they may come across terms such as CAGR and XIRR. Both are used to measure investment returns, but they are designed for different situations.
CAGR is generally useful for calculating the annualised growth of a lump-sum investment when there is one initial investment and one final value. XIRR is more suitable when an investment involves multiple cash flows occurring on different dates, such as SIP investments.
Knowing the difference between XIRR and CAGR can help investors interpret mutual fund, stock and portfolio returns more accurately.
What Is CAGR?
CAGR stands for Compound Annual Growth Rate.
It measures the annualised rate at which an investment would have grown if it had grown at a constant compounded rate over a particular period.
The formula is:
CAGR = [(Final Value ÷ Initial Value)^(1 ÷ Number of Years) − 1] × 100
For example, suppose you invest ₹1,00,000 in a mutual fund and its value becomes ₹1,61,051 after five years.
The CAGR is approximately 10% per year.
This does not mean the investment actually generated exactly 10% every year. It is an annualised rate derived from the beginning value, ending value and investment period.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
It is used when an investment involves multiple cash flows taking place on different dates.
For example, consider a SIP:
- ₹5,000 invested on 5 January
- ₹5,000 invested on 5 February
- ₹5,000 invested on 5 March
- ₹5,000 invested on 5 April
Each investment remains invested for a different amount of time. XIRR takes the amount and exact date of each cash flow into account when calculating the annualised return.
This makes XIRR particularly useful for SIPs and other investments involving multiple deposits and withdrawals.
CAGR vs XIRR: Key Differences
| Feature | CAGR | XIRR |
| Full form | Compound Annual Growth Rate | Extended Internal Rate of Return |
| Best suited for | Lump-sum investments | Multiple cash flows |
| Uses investment dates | No | Yes |
| Uses individual cash flows | No | Yes |
| Common use | Lump-sum mutual funds, stocks | SIPs, SWPs, portfolios |
| Annualised return | Yes | Yes |
| Handles irregular cash flows | No | Yes |
| Considers timing of investments | No | Yes |
CAGR Example
Suppose an investor makes a lump-sum investment of ₹2 lakh.
After four years, the investment becomes ₹3 lakh.
The total return is:
₹3 lakh − ₹2 lakh = ₹1 lakh
The absolute return is:
50%
The CAGR is approximately 10.67% per year.
Because there is one initial investment and one final value, CAGR provides a straightforward annualised measure.
XIRR Example
Now consider an investor who invests ₹10,000 every month through a SIP.
Over several years, the investor makes dozens of individual investments. The first ₹10,000 remains invested for much longer than the most recent ₹10,000.
If the final portfolio value is ₹8 lakh, simply comparing the total amount invested with the final value does not accurately represent the annualised return.
XIRR considers each ₹10,000 investment and its respective date before calculating the annualised return.
This is why mutual fund platforms commonly show XIRR for SIP investments.
Why Is XIRR Better for SIPs?
A SIP consists of multiple transactions rather than one single investment.
Suppose you invest ₹5,000 every month for three years.
You make 36 separate investments.
The first instalment has been invested for almost three years, while the last instalment may have been invested for only a short period.
CAGR does not account for these individual investment dates.
XIRR does.
Therefore, when evaluating the annualised performance of a SIP, XIRR generally provides a more meaningful figure.
XIRR for Multiple Investments and Withdrawals
XIRR is not limited to SIPs.
It can also be useful for portfolios where there are:
- Multiple lump-sum investments
- SIP investments
- Partial withdrawals
- Additional investments
- Dividend or distribution cash flows
- Final redemption
For example, an investor may invest ₹1 lakh initially, add ₹50,000 after six months and withdraw ₹20,000 two years later.
Because these transactions occur at different times, XIRR can account for the timing of each cash flow.
How to Calculate XIRR in Excel
Microsoft Excel and similar spreadsheet programs provide an XIRR function.
You generally need two columns:
| Date | Cash Flow |
| 01-Jan-2024 | -₹1,00,000 |
| 01-Jul-2024 | -₹50,000 |
| 01-Jan-2025 | -₹25,000 |
| 01-Jan-2026 | ₹2,00,000 |
Investments are normally entered as negative cash flows, while money received or the final portfolio value is entered as a positive cash flow.
The XIRR function can then be used to calculate the annualised return.
A simplified Excel formula is:
=XIRR(B2:B5,A2:A5)
Here, the first range contains the cash flows and the second range contains the corresponding dates.
Can CAGR and XIRR Give Different Returns?
Yes.
They can produce different figures because they use different methods and are suitable for different cash-flow patterns.
For a simple lump-sum investment with one initial investment and one final value, CAGR and an appropriately calculated annualised return can correspond closely.
For a SIP or portfolio containing multiple transactions, XIRR can produce a substantially different result because it considers when each cash flow occurred.
The difference does not necessarily mean one calculation is wrong. It usually reflects the different information being used.
XIRR vs CAGR for Mutual Funds
The appropriate measure depends on how you invested.
Lump-Sum Mutual Fund Investment
If you invested ₹1 lakh once and later redeemed the entire investment, CAGR can be useful for measuring annualised growth over the holding period.
SIP Mutual Fund Investment
If you invested ₹5,000 every month, XIRR is generally more appropriate because each instalment has a different investment date.
Combination of SIP and Lump Sum
If you made both SIP investments and additional lump-sum investments, XIRR can account for the complete cash-flow history.
XIRR vs CAGR for Stocks
CAGR can be useful when you buy a stock once and compare the purchase price with the value or selling price after a specified period.
However, if you repeatedly buy shares, sell some shares and add more investments over time, XIRR can better reflect the timing of those cash flows.
Dividend payments and other cash flows may also need to be considered depending on what return you want to measure.
Limitations of CAGR
CAGR is simple and useful, but it has limitations.
It does not:
- Account for multiple investment dates
- Consider interim withdrawals
- Consider additional investments
- Show yearly volatility
- Reflect the timing of cash flows
Therefore, it should not be used blindly for investments with multiple cash flows.
Limitations of XIRR
XIRR is more flexible but also has limitations.
It:
- Requires accurate dates and cash-flow amounts
- Can be affected by incorrect transaction data
- Does not show the year-by-year path of returns
- Can be difficult to interpret for beginners
- May require spreadsheet software or a financial calculator
XIRR also assumes that the cash-flow pattern can be represented by a rate of return that solves the calculation.
CAGR vs XIRR: Which One Should You Use?
A simple way to choose is:
Use CAGR when:
You have one initial investment and one final value and want to calculate annualised growth.
Use XIRR when:
You have multiple investments, withdrawals or other cash flows occurring on different dates.
For example:
| Investment Situation | Suitable Measure |
| One-time mutual fund investment | CAGR |
| One-time stock investment | CAGR |
| Monthly SIP | XIRR |
| SIP + lump-sum investment | XIRR |
| Portfolio with withdrawals | XIRR |
| Multiple investments at different dates | XIRR |
Frequently Asked Questions
Is XIRR better than CAGR?
Neither is universally better. CAGR is designed for simpler investment structures, while XIRR is designed for investments involving multiple cash flows on different dates.
Is XIRR the same as annual return?
XIRR is an annualised return measure that accounts for the timing of individual cash flows. It should not be interpreted as saying the investment actually earned the same percentage every year.
Why is XIRR used for SIP?
Each SIP instalment is invested on a different date. XIRR considers these dates when calculating the annualised return, making it more suitable for SIP performance measurement.
Can I use CAGR for SIP?
A basic CAGR calculation is generally not appropriate for a SIP because the investment consists of multiple cash flows at different times. XIRR is generally more suitable.
Can XIRR be used for a lump-sum investment?
Yes. However, when there is only one investment and one final value, CAGR is usually simpler and provides the annualised growth rate.
What is the difference between XIRR and absolute return?
Absolute return measures the total percentage gain or loss without annualising it. XIRR calculates an annualised return while considering the timing of multiple cash flows.
Conclusion
CAGR and XIRR are both useful return measures, but they are designed for different investment situations. CAGR is generally suitable for a simple lump-sum investment, while XIRR is more appropriate when there are multiple investments or withdrawals at different dates.
For SIPs, recurring investments and portfolios with multiple cash flows, XIRR generally provides a more relevant annualised return measure. For a single investment held for a defined period, CAGR offers a simpler way to understand annualised growth.
