What Is XIRR in Mutual Fund?
XIRR stands for Extended Internal Rate of Return. In the context of mutual fund SIP investments, XIRR is the most accurate way to calculate the annualised return when there are multiple cash flows (investments and withdrawals) at different dates. Unlike simple absolute return or CAGR (which assumes a single investment), XIRR accounts for the timing and amount of each SIP instalment, giving the true compounded annual return on your SIP portfolio.
Why XIRR Is Used for SIP Calculations
Consider a monthly SIP of Rs 5,000 over 2 years (24 instalments). The first instalment was invested 24 months ago and has compounded for 24 months; the last instalment was invested this month and has compounded for zero months. Simple return calculation cannot account for this. XIRR takes each cash flow and its timing into account, providing the equivalent fixed annual return that would produce the same final portfolio value.
How to Calculate XIRR
XIRR is calculated using Microsoft Excel or Google Sheets with the =XIRR function:
- Column A: Cash flows (SIP amounts as negative values for outflows; redemption value as positive).
- Column B: Corresponding dates for each cash flow.
- Formula: =XIRR(A1:A25, B1:B25) gives the annualised return.
Example: 24 SIP payments of -Rs 5,000 each + final redemption value of Rs 1,35,000. XIRR might show 12-14% annually depending on actual performance.
XIRR vs. CAGR vs. Absolute Return
| Metric | Use Case | Limitation |
|---|---|---|
| Absolute return | Total gain percentage regardless of time | Does not account for time; misleading for comparison |
| CAGR | Annualised return for single lump sum investment | Not suitable for SIPs with multiple cash flows |
| XIRR | Annualised return for SIPs with multiple cash flows at different dates | Requires spreadsheet calculation; not available everywhere |
Good XIRR for Equity SIPs
Historically, equity mutual fund SIPs in India have delivered XIRR of:
- Large-cap funds: 10-14% XIRR over 10+ year SIPs.
- Mid-cap funds: 13-18% XIRR over 10+ year SIPs.
- Small-cap funds: 14-20% XIRR over 10+ year SIPs (with higher volatility).
These figures are historical and not guaranteed. XIRR varies significantly based on the start date, market cycles during the investment period, and the specific fund.
Key Takeaway
XIRR is the gold standard for measuring SIP returns because it accounts for the timing and amount of each investment. Always use XIRR (not absolute return or simple average) when evaluating your mutual fund SIP performance. Use the Lemonn app to track your portfolio XIRR and understand the true compounded return on your investments over time.
