CAGR works well when you invest a lump sum once and leave it invested for several years.
But SIPs are different.
With a Systematic Investment Plan (SIP), you invest money on different dates ₹5,000 this month, another ₹5,000 next month, and so on. Because every instalment stays invested for a different length of time, a simple CAGR calculation may not correctly represent the return on the entire investment.
This is where XIRR becomes useful.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
In simple terms, XIRR calculates the annualised return on investments when money goes in or comes out on different dates.
It considers:
The amount invested
The date of each investment
The final value or withdrawal
The time each cash flow remained invested
That makes XIRR especially useful for SIPs and other investments involving multiple transactions.
What Does XIRR Tell an Investor?
XIRR tells you the single annualised rate of return that makes all your investment cash flows and the final value mathematically balance.
In easier words, it answers:
“Considering that I invested different amounts on different dates, what annualised return did my overall investment generate?”
This is different from simply comparing how much you invested with how much the investment is worth today.
Why Is XIRR Important for SIP Investments?
Suppose you invest ₹5,000 every month for one year.
The first ₹5,000 remains invested for almost the entire year.
The final ₹5,000 may have been invested for only a few weeks.
Clearly, every instalment has not had the same amount of time to grow.
That is why applying a simple CAGR calculation to the total amount invested can give a misleading picture.
XIRR accounts for the exact timing of each cash flow, making it more appropriate for investments such as SIPs.
How Is XIRR Calculated?
XIRR is calculated by finding the annualised discount rate at which the present value of all cash flows becomes zero.
The calculation uses both the amount and exact date of every transaction.
The basic idea is:
Sum of all cash flows adjusted for their dates = 0
Unlike CAGR, there is no simple one-step arithmetic formula that most investors calculate manually. XIRR is usually calculated using financial software, spreadsheets or investment platforms.
Simple XIRR Example with a Monthly SIP
Suppose you invest:
₹5,000 on January 1
₹5,000 on February 1
₹5,000 on March 1
₹5,000 every month after that
By the end of the year, you have invested ₹60,000.
Now imagine the investment is worth ₹65,000 on December 31.
Your total gain is ₹5,000.
However, it would not be correct to simply say:
₹5,000 ÷ ₹60,000 = 8.33% annual return
because the entire ₹60,000 was not invested for the full year.
XIRR considers the date of every ₹5,000 investment and calculates an annualised return accordingly.
The exact XIRR would depend on the precise investment dates and final valuation date.
XIRR vs CAGR: What’s the Difference?
| Basis | XIRR | CAGR |
|---|---|---|
| Cash Flows | Multiple investments or withdrawals | Usually one beginning and one ending value |
| Dates | Uses exact transaction dates | Uses overall investment period |
| Best For | SIPs, irregular investments, withdrawals | Lump sum investments |
| Result | Annualised return | Annualised compounded growth rate |
| Complexity | Usually calculated using software | Easy to calculate manually |
In simple terms:
CAGR works well for one-time investments. XIRR works better when money moves in or out at different times.
XIRR vs Absolute Return
Absolute return simply tells you how much your investment has increased or decreased overall.
For example:
Total invested: ₹1,00,000
Current value: ₹1,20,000
Absolute return:
20%
But absolute return does not consider whether the money was invested for six months, two years or five years.
XIRR considers both the amount and timing of each cash flow.
This makes it more useful for evaluating investments made over multiple dates.
When Should You Use XIRR?
XIRR is useful when an investment involves several cash flows at different times.
Common examples include:
SIP Investments
Monthly or periodic mutual fund investments.
Irregular Investments
When you invest different amounts at different times.
Partial Withdrawals
If money is withdrawn from an investment during the holding period.
Additional Lump Sum Investments
If you add extra money to an existing investment at different dates.
In these situations, XIRR provides a more meaningful annualised return than a simple CAGR calculation.
How to Calculate XIRR in Excel or Google Sheets
Both Microsoft Excel and Google Sheets provide an XIRR function.
The basic structure is:
=XIRR(values, dates)
Example
Suppose your spreadsheet contains:
| Date | Cash Flow |
| 01-Jan-2025 | -₹5,000 |
| 01-Feb-2025 | -₹5,000 |
| 01-Mar-2025 | -₹5,000 |
| 31-Dec-2025 | ₹16,500 |
Investments are entered as negative values because money is going out of your pocket.
The final investment value or withdrawal is entered as a positive value.
You can then use:
=XIRR(B2, A2)
The spreadsheet calculates the annualised return based on the exact dates.
Microsoft’s official documentation states that XIRR calculates the internal rate of return for cash flows that do not necessarily occur at regular intervals.
Is a Higher XIRR Always Better?
Not necessarily.
A higher XIRR means the investment generated a higher annualised return during the measured period.
However, it does not automatically mean the investment was better or more suitable.
You should also consider:
Risk
Higher returns may have come with higher investment risk.
Time Period
Compare XIRR over similar investment periods.
Benchmark
For mutual funds, compare performance with an appropriate benchmark where relevant.
Investment Objective
A high-return equity fund and a low-volatility debt fund serve very different purposes.
Consistency
One short period of high XIRR should not be treated as proof that similar returns will continue.
Past performance does not guarantee future returns.
Limitations of XIRR
It Does Not Show Volatility
XIRR gives one annualised return figure.
It does not tell you how sharply the investment moved up or down during the period.
It Depends on Accurate Cash-Flow Dates
Incorrect investment dates or amounts can produce an incorrect result.
Short-Term XIRR Can Look Extreme
When the investment period is very short, annualising the return can produce unusually high or low figures.
This may not represent long-term investment performance.
It Does Not Measure Risk
Two investments can have the same XIRR but completely different levels of risk.
Historical XIRR Does Not Predict Future Returns
XIRR tells you what happened during the measured period. It cannot tell you what returns will be earned in the future.
Common Mistakes When Interpreting XIRR
Comparing XIRR With Absolute Return Directly
These metrics measure different things.
Absolute return shows total growth, while XIRR annualises returns while considering the dates of cash flows.
Ignoring the Investment Period
An XIRR calculated over a few months should not be compared casually with a return calculated over several years.
Treating XIRR as a Guaranteed Return
XIRR is a historical calculation, not a promise of future performance.
Entering Cash Flows With the Wrong Sign
In spreadsheet calculations, investments are generally entered as negative cash flows and withdrawals or final values as positive cash flows.
Comparing Completely Different Investment Categories
A high-risk equity fund and a debt fund should not be judged only by which one has the higher XIRR.
FAQs
What is XIRR?
XIRR stands for Extended Internal Rate of Return. It calculates an annualised return when investments and withdrawals happen on different dates.
Why is XIRR used for SIPs?
SIP instalments are invested on different dates and remain invested for different periods. XIRR accounts for this timing.
Is XIRR better than CAGR?
It depends on the investment.
CAGR is generally suitable for a single lump sum investment, while XIRR is more appropriate when there are multiple cash flows at different dates.
Is XIRR the same as absolute return?
No.
Absolute return measures total gain or loss, while XIRR calculates an annualised return considering the timing of cash flows.
Can XIRR be negative?
Yes.
If the value of an investment falls sufficiently relative to the cash flows invested, XIRR can be negative.
Can I calculate XIRR in Excel?
Yes.
Microsoft Excel provides the XIRR function:
=XIRR(values, dates)
Does a higher XIRR mean a better mutual fund?
Not necessarily.
Risk, benchmark, fund category, investment objective, costs and the period being measured should also be considered.
Is XIRR guaranteed?
No.
XIRR measures historical investment performance. It does not guarantee future returns.
Conclusion
XIRR is one of the most useful return measures for SIP investors because it accounts for something CAGR cannot—the exact timing of multiple investments.
If you invest different amounts on different dates, simply comparing the total invested amount with the current value does not provide the complete picture. XIRR converts those irregular cash flows into a single annualised return.
However, XIRR should not be viewed in isolation. Investors should also consider risk, benchmark performance, investment objective, costs and the time period involved.
Most importantly, XIRR is a measure of past performance, not a prediction of future returns.
