Systematic Investment Plans (SIPs) involve investing a fixed amount in a mutual fund at regular intervals, often every month. Because money enters the investment at different dates, measuring the return from an SIP is different from measuring the return on a one-time investment.
This is why XIRR (Extended Internal Rate of Return) is widely used to evaluate the performance of SIP investments. XIRR takes into account the amount and timing of each cash flow, making it particularly useful when an investor makes multiple investments on different dates and eventually has a current portfolio value or redemption amount.

For investors who want to understand how effectively their actual invested money has performed over time, XIRR can provide a more meaningful annualised return measure than simply comparing total investment with current value.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
It calculates an annualised rate of return for investments where cash flows occur at irregular or different dates.
This is especially relevant to SIPs because each instalment is invested separately.
For example, suppose an investor invests ₹5,000 every month:
- January: ₹5,000
- February: ₹5,000
- March: ₹5,000
- April: ₹5,000
- May: ₹5,000
The January instalment has been invested longer than the May instalment.
Therefore, treating the entire ₹25,000 as though it was invested on one date would not accurately represent the investor’s actual cash-flow pattern.
XIRR accounts for those different investment dates.
Why SIPs Need a Different Return Calculation
A lump-sum investment is relatively straightforward.
Suppose an investor invests ₹1 lakh once and the investment becomes ₹1.30 lakh after three years.
The investor can calculate an annualised return using a conventional compound-growth calculation such as CAGR.
But an SIP works differently.
With a ₹5,000 monthly SIP, the investor does not invest ₹60,000 at the beginning of the year. Instead, the ₹60,000 enters the investment gradually through multiple instalments.
Some instalments may be invested for several years, while the latest instalments may have been invested for only a few months.
This makes a simple total-return calculation less informative.
How XIRR Works for an SIP
XIRR treats each investment instalment as a separate cash flow.
From the investor’s perspective, each SIP instalment is generally treated as a negative cash flow because money is leaving the investor’s bank account.
The current value or redemption proceeds are treated as a positive cash flow.
XIRR then finds the annualised rate that makes the present value of these cash flows balance.
The calculation therefore incorporates:
- Amount invested
- Date of each investment
- Current value or redemption value
- Date of the final valuation or redemption
This makes it particularly suitable for SIP performance analysis.
Example of XIRR in an SIP
Suppose an investor invests ₹10,000 every month for one year.
The total amount invested is:
₹10,000 × 12 = ₹1,20,000
After the investment period, the portfolio value becomes ₹1,32,000.
A simple calculation might suggest:
Profit = ₹1,32,000 − ₹1,20,000 = ₹12,000
That represents a 10% gain relative to the total amount invested.
However, the investor did not have the entire ₹1,20,000 invested for the full year.
The first ₹10,000 was invested much earlier than the final ₹10,000.
Therefore, saying that the SIP “returned exactly 10%” does not properly account for the timing of the investments.
XIRR incorporates those dates and produces an annualised return that better reflects the actual cash flows.
Why CAGR Is Not Ideal for SIPs
CAGR (Compound Annual Growth Rate) works particularly well for a single initial investment followed by a final value.
For example:
₹1,00,000 invested once → ₹1,50,000 after five years.
CAGR can calculate the annualised growth rate over that period.
But SIPs contain multiple cash flows.
Using CAGR on the total amount invested can therefore give a misleading impression because it treats the investment as though the entire amount was invested at one point.
XIRR solves this problem by considering each instalment separately.
XIRR vs Absolute Return
Absolute return simply measures the total gain or loss relative to the amount invested.
The basic formula is:
Absolute Return = (Current Value − Invested Amount) ÷ Invested Amount × 100
This can be useful for a quick snapshot.
However, it does not properly account for the amount of time each instalment remained invested.
An SIP running for three years and another running for eight years can have the same absolute return but very different annualised performance.
XIRR provides a time-adjusted annualised figure.
Why XIRR Is Useful for Long-Term SIPs
SIPs are often designed for long-term financial goals such as:
- Retirement
- Children’s education
- Home purchase
- Wealth creation
- Financial independence
Over long periods, investors may make dozens or hundreds of instalments.
Manually evaluating every instalment would be difficult.
XIRR provides a single annualised figure that summarises the return generated by those cash flows.
For example, if an investor has made 60 monthly SIP investments, XIRR can consider all 60 investment dates and the current portfolio value.
This makes the metric practical for long-term investment tracking.
XIRR Also Works When SIP Amounts Change
Real-world SIPs are not always identical.
An investor might start with:
₹5,000 per month
and later increase the SIP to:
₹7,500 per month
or make occasional additional investments.
XIRR can handle these different cash flows as long as their dates and amounts are included.
This is another reason it is useful for real investment portfolios rather than only textbook examples.
XIRR Can Include Withdrawals
XIRR is also useful when an investor partially withdraws money from a mutual fund.
Suppose an investor has been investing through an SIP but withdraws ₹50,000 midway through the investment period.
The withdrawal becomes a positive cash flow from the investor’s perspective, while subsequent investments remain negative cash flows.
The calculation can incorporate these different transactions.
This makes XIRR more flexible than a simple return percentage.
XIRR and Mutual Fund Performance Are Not the Same Thing
One important point is that an investor’s XIRR is not necessarily the same as the mutual fund’s published return.
A mutual fund may report returns using different methodologies and benchmark comparisons.
The investor’s XIRR depends on:
- Their actual SIP dates
- Their investment amounts
- Additional purchases
- Withdrawals
- The current portfolio value
Two people investing in the same mutual fund can therefore have different XIRRs.
For example, one investor may have started investing during a market downturn, while another began much later.
Their cash-flow timings can produce different investor-level returns.
How to Calculate XIRR
Spreadsheet applications such as Microsoft Excel and Google Sheets can calculate XIRR.
A typical spreadsheet formula is:
=XIRR(values, dates)
The values column contains the cash flows, while the dates column contains the corresponding transaction dates.
For example:
| Date | Cash Flow |
| 10 Jan | -₹5,000 |
| 10 Feb | -₹5,000 |
| 10 Mar | -₹5,000 |
| 10 Apr | -₹5,000 |
| 10 May | -₹5,000 |
| 10 Jun | -₹5,000 |
| 10 Jul | -₹5,000 |
| 10 Aug | -₹5,000 |
| 10 Sep | -₹5,000 |
| 10 Oct | -₹5,000 |
| 10 Nov | -₹5,000 |
| 10 Dec | -₹5,000 |
| 31 Dec | +₹65,000 |
Entering these cash flows and dates into an XIRR calculation provides the annualised return for the actual investment pattern.
Limitations of XIRR
Although XIRR is highly useful, it should not be treated as the only measure of investment quality.
First, XIRR is backward-looking. A high historical XIRR does not guarantee future returns.
Second, a short investment period can produce an unusually high or low annualised figure.
Third, XIRR does not tell you whether a mutual fund is suitable for your risk profile.
Investors should also consider volatility, benchmark performance, asset allocation, expenses, investment objective and investment horizon.
Why Investors Should Track XIRR
Tracking XIRR helps investors answer a practical question:
“What annualised return have I actually earned on the money I have invested at different times?”
This can be more useful than looking only at the mutual fund’s NAV growth.
For example, an investor may have made SIP investments during both rising and falling markets. XIRR reflects the investor’s actual cash-flow history rather than assuming that all money entered the fund on the same date.
Conclusion
XIRR is one of the most appropriate metrics for evaluating SIP returns because it accounts for the timing and amount of each investment. Unlike a simple absolute-return calculation, it recognises that every SIP instalment has a different investment period.
CAGR is highly useful for lump-sum investments, but it is generally less suitable when there are multiple contributions over time. XIRR addresses this problem by treating every investment, withdrawal and final portfolio value as dated cash flows.
For SIP investors, XIRR can therefore provide a clearer picture of their actual annualised investment performance. It is particularly useful for long-term SIPs, step-up SIPs, additional investments and portfolios containing withdrawals.
However, XIRR should not be used in isolation. Investors should also consider risk, volatility, benchmark performance, fund costs, asset allocation and financial goals.
The key advantage of XIRR is simple: it evaluates returns according to when your money actually entered and left the investment. That makes it a practical and meaningful metric for understanding the performance of a real-world SIP portfolio.