If you’ve invested a lump sum and want to know how fast it grew, CAGR, or Compound Annual Growth Rate, is usually the right return measure. If you have invested money at different times, such as through SIPs, additional purchases, or withdrawals, XIRR, or Extended Internal Rate of Return, gives you a more meaningful picture of your own investment return.
So, XIRR and CAGR are not competing formulas. They answer different questions about your investment.
Here’s how they differ, and when you should use each one.
XIRR vs CAGR (at a glance)
| CAGR | XIRR | |
| Best suited for | A single lump-sum amount | Multiple investments or withdrawals |
| Cash flows | One initial investment and one final value | Multiple cash flows on different dates |
| Timing of investments | Not considered separately | Explicitly considered |
| Common use | Comparing investment or fund performance | Measuring your personal portfolio return |
| SIPs | Not suitable for the overall investment | Suitable |
| Lump-sum investment | Suitable | Can also be used |
| Annualized return | Yes | Yes |
| Return depends on your investment timing | No | Yes |
What is CAGR?
CAGR, or Compound Annual Growth Rate, measures the annualized growth of an investment between two points in time.
The basic formula is:
CAGR = [(Ending Value ÷ Beginning Value)^(1 ÷ Number of Years)] − 1
For example, if you invest ₹1 lakh in a mutual fund and its value grows to ₹1.50 lakh after three years:
CAGR = [(₹1,50,000 ÷ ₹1,00,000)^(1/3)] − 1
CAGR = 14.47%
This means the investment grew at an annualized rate of about 14.47% over those three years.
It does not mean the investment earned exactly 14.47% every year. CAGR takes the total growth over the period and expresses it as an annualized rate.
When does CAGR make sense?
CAGR works well when you have a clear beginning value and ending value, with no additional investments or withdrawals during the period.
For example:
- You invested ₹2 lakh in a stock and did not add or withdraw money.
- You bought ₹5 lakh worth of a mutual fund and held it for five years.
- You want to compare the historical growth of two mutual funds over the same period.
- You want to compare an investment with its benchmark over a fixed period.
CAGR is particularly useful when comparing investments over the same period because it gives you a common annualized measure of growth.
For mutual funds, CAGR is also used in standard performance disclosures. SEBI’s mutual fund performance framework uses CAGR for periods including 1, 3, 5, and 10 years, as well as since inception.
What is XIRR?
XIRR, or Extended Internal Rate of Return, calculates an annualized return when cash flows happen on different dates.
This makes it useful when you invest money at different points in time rather than putting in the entire amount at once.
For example, imagine you invest:
| Date | Cash flow |
| January 1, 2024 | -₹1,00,000 |
| July 1, 2024 | -₹1,00,000 |
| January 1, 2025 | -₹1,00,000 |
| July 1, 2025 | +₹3,60,000 |
The negative amounts represent money invested. The positive amount represents money received when the investment is sold.
Using these dates and cash flows, the XIRR is approximately 19.71%.
The three ₹1 lakh investments were not invested for the same length of time. The first ₹1 lakh was invested much earlier than the third.
XIRR takes those different investment dates into account.
Microsoft’s Excel documentation defines XIRR as the internal rate of return for cash flows that are not necessarily periodic. The function uses the actual dates supplied and a 365-day year for the calculation.
When does XIRR make sense?
XIRR makes sense when your investment has multiple cash flows on different dates.
This includes:
- SIP investments
- Multiple lump-sum investments
- Additional purchases of stocks or mutual funds
- Partial withdrawals
- Systematic withdrawals
- Portfolios with a combination of investments and withdrawals
The important part is that the cash flows happen at different times. For example, if you invest ₹50,000 in January, another ₹25,000 in April, and another ₹75,000 in December, those amounts have not been invested for the same length of time. XIRR uses the actual dates to account for that.
XIRR vs CAGR: What’s the difference?
The key difference is how they treat cash flows during the investment period.
CAGR looks at the beginning value and ending value. It does not separately account for money added or withdrawn during the period.
XIRR considers each investment or withdrawal separately, along with the date on which it happened.
That means the two measures can give different results when money is invested at different times.
For example, if you invest ₹3 lakh in total, but make three investments of ₹1 lakh each over a year.
If the investment grows to ₹3.60 lakh, you cannot treat the entire ₹3 lakh as though it had been invested from the date of the first ₹1 lakh investment. The second and third installments were invested later.
XIRR accounts for this difference.
| If you want to know | Use |
| How a lump-sum investment grew over a period | CAGR |
| How your SIP performed | XIRR |
| How your portfolio performed after multiple investments | XIRR |
| How a mutual fund performed over a fixed period | CAGR |
| How the timing of your investments affected your return | XIRR |
Neither measure is automatically better. The right one depends on what you’re trying to measure.
XIRR vs CAGR for SIP investments
For a SIP, XIRR is generally the more useful measure of your personal return because you are investing a fixed amount at different points in time.
Say you invest ₹10,000 every month for three years. Your first ₹10,000 has been invested for almost three years, while the last ₹10,000 has only been in the investment for a short time.
So, even though you have invested ₹3.60 lakh in total, that entire amount has not been invested for three years. Simply comparing your total investment with the final value does not account for this difference in timing.
That is where XIRR comes in. It uses the amount and date of each SIP installment to work out the annualized return on your money.
This is also why your XIRR may be different from the CAGR shown for the mutual fund scheme. The scheme’s CAGR measures how the fund’s value grew over a particular period, while your XIRR reflects what you earned based on your own investments, withdrawals and their dates.
Both figures can be correct. They are just measuring different things.
Can XIRR and CAGR be the same?
Yes. If there is only one initial investment and one final value, with no additional investments or withdrawals in between, XIRR and CAGR can produce the same annualized return when they use the same dates and values.
For example, suppose you invest ₹1 lakh on January 1, 2024, and receive ₹1.50 lakh on January 1, 2027.
There are only two cash flows:
- -₹1 lakh when you invest
- +₹1.50 lakh when you receive the money
There are no additional cash flows for either method to account for.
In this situation, using XIRR instead of CAGR does not give you a more meaningful return. CAGR is simpler.
XIRR vs CAGR: Which return should you trust?
It depends on what you are measuring.
If you made a single lump-sum investment and want to know how much it grew over a period, CAGR is usually the better measure.
If you invested or withdrew money at different times and want to know how your own money performed, XIRR is usually more useful.
The simplest way to remember the difference is:
Single investment with a clear beginning and end → CAGR.
Multiple investments or withdrawals at different times → XIRR.
If you’re comparing the historical performance of mutual funds, CAGR can help you compare their growth over the same period. If you are checking the performance of your own SIP or portfolio, XIRR is generally the more relevant number.
Neither figure guarantees future returns. Both are ways of expressing historical investment performance based on the values, dates and cash flows used in the calculation.
FAQs
Is XIRR better than CAGR?
Not necessarily. XIRR is better suited to investments with multiple cash flows on different dates, while CAGR is suitable for measuring growth between a beginning value and an ending value.
Can I use CAGR for SIPs?
CAGR is not the right measure for the overall return on a SIP because each installment is invested on a different date. XIRR is generally more appropriate for measuring the return on your SIP.
Can I use XIRR for a lump-sum investment?
Yes. XIRR can calculate the annualized return when there is one initial investment and one final value. In that situation, XIRR and CAGR can produce the same result when the same dates and values are used.
Why is my XIRR different from the mutual fund’s CAGR?
Your XIRR is based on your actual investments, withdrawals and their dates. A mutual fund’s CAGR measures the scheme’s growth over a specified period. Your investment timing can therefore make your XIRR different from the fund’s reported CAGR.
Does a higher XIRR mean I made a better investment?
Not necessarily. XIRR reflects your cash-flow timing as well as the investment’s performance. When comparing investments, look at the same period and consider factors such as risk, benchmark performance and costs rather than relying on one return figure alone.
Is XIRR the same as annual return?
XIRR is an annualized return, not a promise that the investment earned the same percentage every year. It expresses a series of dated cash flows as a single annualized rate.
