When you check your mutual fund statement, you see a return percentage. But is that number accurate for a SIP? No — and that's exactly where XIRR comes in.
XIRR (Extended Internal Rate of Return) is the most accurate way to measure returns when you invest at different times — like monthly SIPs. Understanding XIRR can completely change how you evaluate your investments.
What is XIRR in Mutual Funds?
XIRR is an annualised return metric that accounts for the timing of each cash flow. When you invest ₹10,000 every month for 2 years, each instalment has been invested for a different duration — your first SIP has grown for 24 months, your last only 1 month. Simple return calculations ignore this entirely.
XIRR solves this by calculating the single annualised rate that makes the present value of all your investments exactly equal to your final redemption value.
XIRR vs CAGR — What's the Difference?
| Metric | Best For | Handles Multiple Cash Flows? |
|---|---|---|
| CAGR | Lumpsum investments | ❌ No |
| Absolute Return | Short-term comparison | ❌ No |
| XIRR | SIPs & irregular investments | ✅ Yes |
If your SIP portfolio shows 18% CAGR, that's calculated on the total corpus — ignoring that your first instalment grew for 10 years but your last grew for only 1 month. Your true XIRR may be significantly different.
How to Calculate XIRR — Step by Step
What you need:
- Date and amount of every SIP instalment (outflow — enter as negative)
- Date and current value of your redemption (inflow — enter as positive)
Example:
| Date | Amount | Type |
|---|---|---|
| 01-Jan-2024 | -₹10,000 | SIP (outflow) |
| 01-Feb-2024 | -₹10,000 | SIP (outflow) |
| 01-Mar-2024 | -₹10,000 | SIP (outflow) |
| 01-Jan-2026 | +₹2,80,000 | Redemption (inflow) |
The XIRR on these cashflows gives you the true annualised return — factoring in exactly when each ₹10,000 was invested.
Don't do this math manually. Our XIRR Calculator uses the Newton-Raphson algorithm for precise results. Add your cashflows or use the Quick Fill button to auto-generate monthly SIP entries. Get your XIRR in seconds.
What is a Good XIRR for a SIP in India?
| XIRR Range | Interpretation |
|---|---|
| Below 6% | Poor — below FD rates, switch funds |
| 6–10% | Average — comparable to debt/hybrid funds |
| 10–15% | Good — beating market benchmarks |
| 15–20% | Excellent — top quartile performance |
| Above 20% | Exceptional — likely bull market or concentrated bet |
For context, the Nifty 50 has delivered approximately 12–14% CAGR over the last 20 years. A diversified large-cap SIP should target 12–15% XIRR over a long term.
XIRR in Mutual Fund Statements
Most fund houses now show XIRR in your account statement and the MF Central portal. However, these numbers reset every time you do a partial redemption or switch. For a comprehensive view across all your funds, calculate XIRR manually using all combined cashflows.
Common XIRR Mistakes
- Using absolute return instead of XIRR: If you invested for 3 years, an absolute return of 60% looks great — but the XIRR is only ~17% annually
- Ignoring the date column: XIRR is highly sensitive to dates. Getting the date wrong gives a completely wrong answer
- Forgetting to enter outflows as negative: SIP payments must be negative, redemption must be positive
- Calculating fund-by-fund instead of portfolio-wide: Your true XIRR is across your entire portfolio, not individual funds
Try India's Most Complete Investment Calculator — Free!
SIP, FIRE, Semi-FIRE, XIRR, Home Loan, PPF, NPS and 12 more calculators. No login, no ads.
🧮 Open SIPKaro Calculator →