XIRR, or Extended Internal Rate of Return, is the only accurate way to measure the annualized return on an investment with multiple cash flows at different dates. For a SIP where you invest Rs. 5,000 each month for three years, every installment enters the market at a different time and has a different compounding period. A single overall return percentage that ignores these different entry points would be meaningless. XIRR accounts for exactly that. It tells you what annualized return rate, applied to each individual cash flow on its specific date, produces the final value you see in your portfolio today.
Most salaried investors look at their mutual fund app and see a return percentage without knowing whether it is XIRR, CAGR, or absolute return. This distinction matters because the same investment can show 18% CAGR and 14% XIRR simultaneously, and the 14% figure is the honest one.
What Is XIRR and Why Does It Matter for Mutual Funds?
Consider how a lumpsum investment differs from a SIP. If you invest Rs. 1 lakh on January 1, 2023, and the value on January 1, 2026, is Rs. 1.40 lakh, the calculation is straightforward: 12% CAGR over three years, compounded annually. Every rupee was invested on the same day, so one compounding rate applies to the entire amount.
A SIP is different. Your January 2023 installment has been invested for 36 months. Your January 2025 installment has been invested for 12 months. Your January 2026 installment has been invested for zero months. These are not the same investment. Applying a single CAGR to the pooled final value ignores the fact that your later installments had far less time to grow. XIRR handles this correctly by treating each cash outflow (your monthly investment) on its actual date and finding the rate that makes the sum of those discounted outflows equal to the final portfolio value.
What does this mean practically? XIRR is lower than CAGR when markets have been rising, because your later, more expensive installments (bought at higher NAV) have not had time to appreciate as much as the early ones. XIRR is higher than CAGR during falling markets, because your later installments were bought at lower prices and recovered more sharply.
XIRR vs CAGR: Which One Should You Trust?
A concrete example settles this. Suppose you invested Rs. 5,000 per month in a diversified equity fund for 3 years, starting January 2023. By January 2026, your total investment is Rs. 1.80 lakh and the portfolio value is Rs. 2.2 lakh. Your absolute return is 22.2% on the total invested.
The CAGR calculation, applied naively, takes Rs. 1.80 lakh as the starting value and Rs. 2.2 lakh as the ending value over 3 years, giving approximately 6.9% CAGR. That number is already misleading because the Rs. 1.80 lakh was never all invested at once. Some mutual fund apps calculate a different CAGR by using the first investment date and the final value, which inflates the figure.
The XIRR for this same portfolio, accounting for each Rs. 5,000 installment on its actual date, would come out to approximately 14 to 16% depending on market movement across the period. That 14% is what you actually earned, annualized and time-weighted correctly. Use the CAGR Calculator to understand CAGR for lumpsum-style calculations, and the XIRR Calculator for your actual SIP portfolio.
How to Calculate XIRR on Your Mutual Fund SIP
You do not need the underlying formula. What you need is a list of your cash flows: each date you invested, each amount, and the date and value of your current portfolio. Feed those into an Excel sheet using the XIRR function, or use a dedicated calculator.
Most modern mutual fund platforms already show XIRR. Zerodha Coin shows your XIRR in the portfolio returns tab. Groww displays it alongside absolute returns. Paytm Money and Kuvera both compute it in their portfolio analytics sections. If your platform does not show it, you can export your statement in CAMS or Karvy format and upload it to a portfolio tracker like Kuvera or Scripbox to get the XIRR immediately.
The XIRR Calculator handles this without a spreadsheet. Input your monthly investment amounts and dates, then enter your current portfolio value. It returns your actual annualized return, which is the number worth paying attention to.
What Is a Good XIRR for Mutual Funds in India?
This question has honest ranges rather than fixed targets, because fund category matters enormously. For large-cap equity funds, a strong XIRR over a five-year SIP period is 11 to 14% annually. The Nifty 50 has delivered approximately 13% CAGR over the past 20 years with dividends reinvested, so expecting XIRR in this range from a diversified large-cap fund over long periods is reasonable.
Mid-cap and small-cap funds have delivered higher historical XIRR (14 to 18% for some funds over 10-year periods), but with significantly higher volatility, meaning your XIRR after just 2 to 3 years can look terrible even if the long-term outcome is excellent. Debt funds and liquid funds operate in the 6 to 8% XIRR range, which makes them appropriate for capital preservation rather than wealth building. Hybrid and balanced advantage funds typically land in the 9 to 11% XIRR range over 5-year periods.
One critical point: comparing XIRR across different investment periods is unfair. A 3-year XIRR during a bull market will look artificially high, while a 3-year XIRR that includes a sharp correction will look low. The meaningful benchmarks are 5-year and 10-year XIRR compared against the category average and the benchmark index return. Run your SIP numbers through the Mutual Fund Calculator to project expected returns for your contribution amount and tenure.
Can XIRR Be Negative? What Does That Mean?
Yes, XIRR can be negative, and this confuses a lot of investors. A negative XIRR means that, on an annualized basis, your portfolio has lost money relative to the cash you invested. This is most common in the first 12 to 24 months of a SIP when the market has fallen sharply, because your installments have not had enough time to recover.
A specific scenario: you started a monthly Rs. 10,000 SIP in January 2022. By June 2022, after the broad Indian and global market correction, your portfolio value of Rs. 5.8 lakh might have been lower than the Rs. 6 lakh you invested over six months. XIRR would show a negative number, maybe negative 10 to 20%, depending on the drawdown. This does not mean the investment is failing. It means the market fell faster than your regular investments could recover.
Negative XIRR in early years is a known feature of SIP investing during volatile periods, not a signal to stop. The SIP vs Lumpsum guide covers exactly this dynamic: why SIP investors who continue through bear markets typically end up with significantly better long-run XIRR than those who pause or withdraw during downturns.
The only return number worth tracking for your SIP portfolio is XIRR, viewed over a minimum of 5 years. Check yours today using the same XIRR calculator.
Why You Should Check Your XIRR at Least Annually
Most investors check their portfolio balance frequently but their XIRR rarely. The balance tells you what your investment is worth today. XIRR tells you whether your fund manager (or market) is delivering adequate returns for the risk you are taking. If your equity fund XIRR over 5 years sits below 10%, you may be better off in a low-cost Nifty 50 index fund. That comparison is only possible if you know your actual XIRR. Check it once a year.
Author Profile
Written by Calcinova Team
The Calcinova team builds free, accurate financial calculators to help you make smarter money decisions. Our tools are used by thousands of investors, borrowers, and planners across India and beyond.