How to Calculate XIRR in Mutual Funds — SIP Return Calculation Explained
XIRR (Extended Internal Rate of Return) calculates annualized return for SIPs with multiple cash flows. For ₹10K monthly SIP for 5 years growing to ₹8.5L: XIRR = ~12%. Excel XIRR function or online calculators provide precise calculation.
On this page▾
XIRR (Extended Internal Rate of Return) is the correct return metric for SIP investments with multiple cash flows — where CAGR fails because it assumes single investment + single final value. XIRR calculates the annualized return that makes the present value of all cash flows equal to zero. For a ₹10,000 monthly SIP over 5 years (₹6 lakh invested) growing to ₹8.5 lakh: XIRR = ~12%. The mathematical complexity makes XIRR difficult to calculate manually — Excel's XIRR function or online calculators are the practical approach. XIRR accounts for: timing of each investment (early investments compound longer), redemptions (partial withdrawals reduce return calculation), dividends/distributions (counted as cash flows). For Indian SIP investors, XIRR is what mutual fund platforms (Zerodha Coin, Groww, ETMoney) display as your "annualized return" — this is the most accurate measure of your SIP's performance. CAGR shown on factsheets applies to lump sum investors only. Freedomwise's SIP Return Calculator computes XIRR for various SIP scenarios.
What is the difference between XIRR and CAGR?
Fundamental distinction:
| Aspect | CAGR | XIRR |
|---|---|---|
| Cash flows | Single lumpsum | Multiple at different times |
| Calculation | Simple formula | Iterative numerical method |
| Use case | Single investment | SIP, regular contributions, withdrawals |
| Manual calculation | Easy | Difficult; requires solver |
| Mutual fund factsheet | Used for fund-level returns | Used for individual investor returns |
Worked comparison: ₹6 lakh invested
Scenario A: ₹6 lakh lumpsum invested 5 years ago, grew to ₹10.5 lakh
- CAGR = (10.5/6)^(1/5) - 1 = 11.84%
- XIRR = same as CAGR for single cash flow scenarios
Scenario B: ₹10K monthly SIP for 5 years (₹6 lakh invested), grew to ₹8.5 lakh
- CAGR (incorrect application) = (8.5/6)^(1/5) - 1 = 7.22% (misleading)
- XIRR = ~12% (correct, because investments compounded for varying periods)
Why XIRR is higher than direct CAGR for SIPs: Each month's investment compounded for different period; early investments grew longer. XIRR captures the true annualized return on each tranche.
How does XIRR mathematically work?
XIRR calculation principle:
Definition: XIRR is the rate at which Net Present Value (NPV) of all cash flows equals zero.
Mathematical formula:
0 = Σ (Cash flow_i / (1 + XIRR)^t_i)
Where:
- Cash flow_i = each investment or withdrawal
- t_i = time (in years) from first cash flow
Numerical method: Excel/calculators iterate through possible XIRR values until the NPV equation balances.
Worked example: Simple 12-month SIP
| Month | Date | Cash flow | Description |
|---|---|---|---|
| 1 | 1-Jan-2025 | -₹10,000 | Investment |
| 2 | 1-Feb-2025 | -₹10,000 | Investment |
| 3 | 1-Mar-2025 | -₹10,000 | Investment |
| ... | ... | ... | (continued) |
| 12 | 1-Dec-2025 | -₹10,000 | Investment |
| 13 | 1-Jan-2026 | +₹1,30,000 | Final value (redemption) |
(Total invested: ₹1.20 lakh; Final value: ₹1.30 lakh; gain ₹10K)
XIRR calculation: ~14.5% annualized
Why so high for 8.33% absolute return?: Each month's investment had varying duration. The ₹10K invested in Jan 2025 grew for 12 months; ₹10K in Dec 2025 grew for 1 month. XIRR captures this differential.
How do I calculate XIRR in Excel?
Excel formula:
=XIRR(values, dates, [guess])
Where:
- values: Cash flows (negative for outflow, positive for inflow)
- dates: Corresponding dates
- guess: Initial estimate (optional; default 10%)
Step-by-step setup:
| Column A (Date) | Column B (Cash flow) |
|---|---|
| 01-Jan-2024 | -10000 |
| 01-Feb-2024 | -10000 |
| 01-Mar-2024 | -10000 |
| ... | ... |
| 01-Dec-2025 | -10000 |
| 31-Dec-2025 | +250000 |
Formula: =XIRR(B1:B25, A1:A25)
Result: XIRR percentage (e.g., 12.5%)
Important:
- Final value must be positive (treating redemption as cash in)
- All investments must be negative (cash out)
- Dates must be in actual date format
- Excel may need "guess" if XIRR doesn't converge
What are the typical XIRR values for Indian mutual funds?
Performance benchmarks (SIPs over 10 years, ending FY 2026-27):
| Fund category | Typical XIRR range | Examples |
|---|---|---|
| Large-cap equity | 11-14% | HDFC Top 100, ICICI Bluechip |
| Multi-cap / Flexi-cap | 12-16% | PPFAS Flexi Cap, Mirae Asset Multi |
| Mid-cap | 13-17% | DSP Midcap, Axis Midcap |
| Small-cap | 14-18% | SBI Small Cap, Axis Small Cap |
| ELSS | 12-15% | Mirae Tax Saver, Axis Long Term |
| Hybrid | 10-13% | HDFC Hybrid Equity, ICICI Equity Debt |
| Debt (short duration) | 7-8% | Various AMC offerings |
| Liquid | 5-6% | Liquid funds across AMCs |
Performance ranking based on long-term XIRR is the basis for choosing funds; one-year XIRR can be misleading due to market cycles.
How does XIRR handle partial withdrawals?
Multiple cash flows scenario:
Example: SIP + partial withdrawal scenario
| Date | Cash flow | Description |
|---|---|---|
| Jan 2020 | -₹10,000 | First SIP |
| Feb 2020 | -₹10,000 | SIP |
| ... | ... | ... |
| Mar 2023 | -₹10,000 | SIP (39 total) |
| Apr 2023 | +₹50,000 | Partial redemption (1 lakh corpus) |
| May 2023 | -₹10,000 | SIP continues |
| ... | ... | ... |
| Dec 2025 | -₹10,000 | Last SIP |
| Jan 2026 | +₹6,80,000 | Final redemption |
XIRR calculation handles this:
- 70 monthly investments totaling ₹7 lakh
- Plus partial withdrawal of ₹50K
- Plus final redemption ₹6.80 lakh
- Total received: ₹7.30 lakh
- Net gain: ₹30K on ₹7L invested
XIRR captures the impact of the partial redemption: if you withdraw during high prices, XIRR reflects that timing benefit/cost.
How does XIRR handle SWPs?
SWP (Systematic Withdrawal Plan) example:
| Date | Cash flow | Description |
|---|---|---|
| Jan 2020 | -₹5,00,000 | Initial lumpsum |
| Feb 2020 | +₹5,000 | SWP withdrawal |
| Mar 2020 | +₹5,000 | SWP withdrawal |
| ... | ... | ... |
| Dec 2025 | +₹5,000 | SWP (71 total) |
| Jan 2026 | +₹3,50,000 | Final redemption |
Total invested: ₹5 lakh; Total received: ₹3.55 lakh + 71 × ₹5,000 = ₹7.10 lakh
XIRR captures:
- Investment time
- Withdrawal timings
- Final residual value
- Effective annualized return on the entire structure
What is the difference between absolute return and XIRR?
For SIP investors, absolute return is misleading; XIRR is accurate.
Example: ₹10,000 monthly SIP for 5 years, final value ₹8 lakh
- Total invested: ₹6 lakh
- Total value: ₹8 lakh
- Absolute return: ₹2 lakh / ₹6 lakh = 33.33%
- This is the period gain, but doesn't represent annualized return
- XIRR: ~12% annualized
The 33.33% absolute return ÷ 5 years = 6.67% per year is also wrong (doesn't account for compounding).
XIRR's 12% accurately represents annualized return on the SIP structure.
What are common XIRR mistakes?
Five errors to avoid:
-
Confusing XIRR and CAGR. For SIPs, only XIRR is correct.
-
Wrong sign convention. Investments must be negative; redemptions positive. Mixing signs gives incorrect XIRR.
-
Missing intermediate cash flows. All investments and withdrawals must be captured. Skipping any creates wrong XIRR.
-
Date format errors. Excel requires proper date format. Text dates produce errors.
-
Comparing XIRR across different funds with different durations. Compare 5-year XIRR with 5-year XIRR, not 5-year with 10-year.
Use this on Freedomwise
- SIP Return Calculator — XIRR-based SIP analysis
- How to Calculate CAGR India — single cash flow
- Stock SIP Return Calculator — equity SIP XIRR
- Financial Jargon Explained — terminology
- General pillar — broader financial literacy
Apply this to your numbers
Calculate your Freedom Score — it's free.
Further reading
Tax-Saving FD vs ELSS vs PPF — Best Section 80C Choice in India
For Section 80C: PPF (7.1%, 15 years, tax-free); ELSS (12-15% expected, 3-year lock-in, LTCG above ₹1.25L); Tax-saving FD (6.5%, 5 years, slab tax). ELSS provides highest expected wealth; PPF provides guaranteed tax-free; FD provides certainty. Combine for diversification.
6 minInvestingEquity Mutual Funds vs Direct Stocks — Which is Better for Indian Investors?
Equity mutual funds provide professional management + 30-100+ stock diversification at 1-1.5% expense ratio. Direct stocks offer full control + zero ongoing fees but require research skill. 80% of retail stock pickers underperform diversified MFs over 10+ years.
6 minTaxRevised ITR FY 2026-27 — How to Correct Errors After Filing
Revised ITR allowed before Dec 31, 2027 for FY 2026-27 — fix calculation errors, missed deductions, or wrong form selection. After Dec 31: Updated ITR (ITR-U) with 25-50% additional tax. Process is straightforward via incometax.gov.in.
7 min