XIRR Calculator India 2025-26 SIP Return Calculator — Extended IRR for Mutual Funds, SIP, NPS & Irregular Investments

Updated: 17 Jun 2026  |  SIP mode · Custom cashflows · SEBI / AMFI aligned  |  Newton-Raphson XIRR engine

₹5,000
₹500₹1L
5 years (60 months)
1 yr30 yrs
₹4,50,000
₹10K₹5 Cr
Total Invested₹3,00,000
Wealth Gain₹1,50,000
Absolute Return50.0%

Your XIRR

13.2%

Annualised return on your SIP

Equivalent CAGR*

—%

*lumpsum at same final value

XIRR vs CAGR Gap

—

—

Your XIRR vs Indian fund benchmarks

Year-by-year SIP growth projection

Year Invested (₹) Value at XIRR (₹) Gain (₹) Return %

How XIRR is Calculated in India — Formula, SIP Returns & Difference from CAGR

XIRR (Extended Internal Rate of Return) is the standard method used by SEBI, AMFI, and all Indian mutual fund platforms — Groww, Zerodha Coin, Kuvera, Paytm Money — to report SIP returns. Unlike CAGR (which works only for a single lumpsum investment), XIRR handles multiple cashflows at irregular dates, making it the only mathematically correct measure for SIP investments where each instalment is invested at a different NAV on a different date.

XIRR Formula — Newton-Raphson Iteration

Solve for r:   Σ [ Cᵢ ÷ (1+r)^(dᵢ/365) ] = 0
Cᵢ = Each cashflow (negative for SIP payments, positive for redemption/current value)
dᵢ = Days from first cashflow date to each cashflow date
r = XIRR (solved iteratively using Newton-Raphson method)

Step-by-Step: XIRR for ₹5,000/month SIP

  1. 1Enter all SIP payments as negative cashflows (money going out): Jan 1 → −₹5,000; Feb 1 → −₹5,000; …
  2. 2Enter current portfolio value as a positive cashflow on today’s date: Jun 17 → +₹4,50,000
  3. 3XIRR iteratively finds the rate r that makes the sum of all discounted cashflows equal zero
  4. 4Result: r = 13.2% XIRR — your true annualised return on all SIP investments

Why XIRR ≠ Fund’s CAGR

Fund’s CAGR = point-to-point NAV growth (e.g., Jan 2020 NAV to Jan 2025 NAV). It’s the same regardless of when you invested.
Your XIRR = personalised return on your specific investments at your specific dates. Two SIP investors in the same fund can have different XIRR.
If you started SIP in a bull market peak (e.g., Jan 2008, Jan 2020), your XIRR is lower than the fund’s CAGR. If you started in a bear market trough, your XIRR may be higher.
AMFI’s XIRR standard: AMFI India mandates that all mutual fund platforms display XIRR (not CAGR or absolute return) for SIP portfolio performance. When you see “returns” on Groww, Zerodha Coin, or MFCentral for your SIP portfolio, it’s always XIRR — the only fair measure for staggered investments.

3 Real Indian XIRR Examples — SIP, Irregular Investments & PPF vs ELSS Comparison

Practical XIRR calculations showing why your personal return differs from the fund’s advertised CAGR.

1

Rahul Gupta — ₹5,000/month SIP in Mirae Asset Large & Midcap Fund, Pune 📈

Started SIP on Jan 1, 2020. Continued uninterrupted through COVID crash. Checking XIRR as of Jun 2025 (66 months).

Total Invested
₹3,30,000
66 × ₹5,000
Portfolio Value
₹6,28,000
Jun 2025
Absolute Return
90.3%
Gain: ₹2,98,000
XIRR
19.4% p.a.
vs Fund CAGR ~17%
Why Rahul’s XIRR (19.4%) exceeds the fund’s 5-year CAGR (~17%): Rahul’s SIP started just before the COVID crash (March 2020 saw a 38% fall). His Feb–May 2020 SIP instalments bought units at extremely low NAVs — effectively getting a bonus “discount.” When the market recovered strongly in 2020–2021, these discounted units appreciated sharply, boosting his personal XIRR above the fund’s point-to-point CAGR. This is rupee cost averaging (RCA) working in his favour — buying more units when NAV is low. Had he started SIP in Jan 2018 (pre-correction), his XIRR would have been lower than fund CAGR.
2

Priya Nair — Irregular Bonus + Monthly SIP in Axis Midcap Fund, Mumbai 💼

Regular ₹3,000/month SIP + lumpsum top-ups on annual bonuses. Mix of regular and irregular investments — only XIRR can compute her true return.

Monthly SIP
₹3,000/mo
for 48 months
Annual Top-ups
₹25,000 × 3
FY22, FY23, FY24
Total Invested
₹2,19,000
SIP + bonuses
XIRR
14.8% p.a.
Portfolio: ₹3,02,000
CAGR cannot compute this: Priya’s investment has 51 different cashflow events (48 SIPs + 3 lumpsum top-ups) on 51 different dates at 51 different NAVs. There is no single “investment date” to apply CAGR. Only XIRR can handle this. Her 14.8% XIRR correctly accounts for the fact that her bonus top-up in April 2022 was invested at a higher NAV (mid-cycle) vs her regular SIPs which span the full cycle. Priya verifies her XIRR monthly on Zerodha Coin’s portfolio dashboard — it uses the identical Newton-Raphson algorithm as this calculator.
3

Arun Sharma — PPF Annual vs ELSS Monthly SIP XIRR Comparison, Jaipur 🆚

Comparing ₹1.5L/year PPF investment (12 years) vs ₹12,500/month ELSS SIP (same total amount). Which gave better XIRR?

MetricPPF (Annual ₹1.5L)ELSS SIP (₹12,500/mo)
Total Invested₹18,00,000₹18,00,000
Maturity / Current Value₹32,89,000₹52,40,000
XIRR (approx)7.1%13.8%
Post-tax XIRR (30% bracket)7.1% (EEE)~12.4% (LTCG 12.5%)
RiskZero (Govt backed)Market risk
Interpretation: ELSS SIP XIRR of 13.8% post-LTCG (12.4% effective) substantially outperforms PPF’s 7.1% EEE XIRR over 12 years. The ₹19.51L gap (₹52.4L vs ₹32.89L) represents the equity risk premium Arun earned for tolerating volatility. However, PPF’s 7.1% XIRR is risk-free and government-guaranteed — a different risk profile entirely. The right choice depends on risk tolerance, not just XIRR comparison. SEBI-registered advisers typically recommend: PPF as the fixed-income foundation + ELSS SIP for long-term equity allocation.

5 Expert Tips to Interpret and Improve Your XIRR on Indian SIP Investments

Strategies used by SEBI-registered advisers and seasoned Indian SIP investors to accurately measure and maximise XIRR.

01

Never Compare Your SIP XIRR to a Lumpsum CAGR — They Measure Different Things

The most common XIRR misinterpretation in India: investors see their Groww portfolio XIRR of 13% and feel disappointed because a friend claims 18% “returns” — not realising the friend’s 18% is the fund’s point-to-point CAGR, not a personal SIP XIRR. These numbers are not comparable. The fund’s 5-year CAGR assumes ₹1 lakh invested on day 1; your XIRR accounts for ₹5,000 invested every month at different NAVs. A fair comparison: your SIP XIRR vs the same fund’s SIP XIRR over the same period (available on AMFI’s website and fund factsheets). The fund’s reported rolling XIRR for SIP is the correct benchmark for your personal XIRR.

02

Low XIRR in the First 2 Years is Normal — Judge SIP XIRR Only After 5+ Years

XIRR for a SIP is highly sensitive to the current market level. If you started a SIP 2 years ago and the market is flat or down, your XIRR will look poor — even if the fund is excellent. Example: A Nifty 50 SIP started in Oct 2021 would have shown negative XIRR in Jun 2022 (after 34% correction) despite being in India’s best index fund. By Jan 2024, the same SIP was showing 14%+ XIRR. The XIRR stabilises and becomes meaningful only after 5+ years as market cycles average out. Don’t stop a SIP based on short-term negative XIRR — historically, continuing SIPs through downturns produces the highest long-term XIRR due to the RCA (rupee cost averaging) effect.

03

Step-Up SIP Increases XIRR by Deploying More Capital During Early Compounding Years

A Step-Up SIP (also called top-up SIP) increases your monthly SIP by 10–15% each year, matching salary growth. Mathematical effect on XIRR: larger investments in early years compound for longer, disproportionately boosting the final corpus and XIRR. Example: ₹5,000/month flat SIP for 20 years at 13% XIRR → corpus ₹52.1L. Same ₹5,000 starting SIP with 10% annual step-up → corpus ₹1.26 crore at similar XIRR — 2.4× more wealth from the same fund. Step-up SIP also forces you to invest proportionally more in bull markets (higher amounts at higher NAV) which slightly tempers the RCA benefit but substantially increases wealth due to the larger capital base. Use our Step-Up SIP Calculator to model this.

04

Calculate After-Tax XIRR — Budget 2024’s LTCG Change Affects Equity Fund XIRR by ~0.5–1.5%

Budget 2024 increased LTCG tax on equity from 10% to 12.5% on gains above ₹1.25 lakh (revised from ₹1 lakh). For SIP investors with large portfolios: on ₹50L corpus with ₹25L gains, LTCG tax = 12.5% × (₹25L − ₹1.25L) = ₹2.97L. This reduces effective XIRR by approximately 0.5–1.5% depending on gain quantum. Always compute after-tax XIRR = [(Post-tax redemption value − Total invested) ÷ Total invested] applied via the XIRR formula. For 30% bracket investors, the post-tax XIRR gap between equity (12.5% LTCG) and PPF (0% tax, EEE) narrows but equity still outperforms by 4–6% real XIRR over 15+ year horizons. Consult a CA before large SIP redemptions to plan LTCG optimally.

05

Use XIRR (Not Absolute Return) to Make SIP Continuation vs Redemption Decisions

Indian investors frequently make two XIRR-ignorant mistakes: (1) Redeeming when XIRR looks low in a market correction — precisely when they should be buying more via SIP to lower their average cost. (2) Stopping SIP when absolute return crosses 100% — ignoring that XIRR may still be below their target hurdle rate. Correct decision framework: if your SIP XIRR over 3+ years is below your hurdle rate (typically 10–12% for equity), investigate the fund — not the market. Switch the fund if XIRR lags category average for 3+ consecutive years. Continue and increase SIP if XIRR temporarily dips during market corrections. Use XIRR as a fund manager scorecard, not a market timing signal. AMFI’s data shows investors who continued SIPs through the 2020 COVID crash earned 40–60% XIRR over 2020–2022.

Frequently Asked Questions — XIRR Calculator, SIP Returns, AMFI & Mutual Fund Norms India

What is XIRR in mutual funds India?+
XIRR (Extended Internal Rate of Return) is the annualised return metric for investments with multiple cashflows at different dates — such as monthly SIP. AMFI India and all SEBI-regulated platforms (Groww, Zerodha Coin, Kuvera, MFCentral) use XIRR for SIP portfolio returns. It’s the only mathematically correct measure for staggered investments where each instalment is invested at a different NAV on a different date.
What is the difference between XIRR and CAGR for SIP?+
CAGR = point-to-point NAV growth; same for all investors regardless of when they bought. XIRR = personalised return on your specific SIP dates. Two investors in the same fund starting on different dates will have different XIRR. SEBI mandates XIRR for SIP returns and CAGR for lumpsum returns in factsheets — they are not comparable to each other.
What is a good XIRR for SIP in India 2025-26?+
Good XIRR benchmarks (5+ years): Large cap 12–15%; Flexi cap 13–17%; Mid cap 15–19%; Small cap 16–22%; Nifty 50 SIP 13–15%; PPF 7.1%. Compare your XIRR to your fund’s category average on AMFI’s website for the most meaningful benchmark.
How to calculate XIRR in Excel for my SIP?+
Formula: =XIRR(values, dates, 0.1). Enter each SIP as a negative number in one column with the date in the adjacent column. Add today’s portfolio value as a positive number with today’s date at the end. Result is decimal — multiply by 100 for %. Without a positive inflow at the end, Excel returns #NUM! error.
Why is my SIP XIRR different from the fund’s stated returns?+
The fund’s stated return is CAGR from a fixed historical date; your XIRR is personalised to your investment dates. If you invested during a market peak your XIRR will be lower; if during a trough (COVID 2020) it may exceed the fund’s CAGR. AMFI mandates separate “SIP returns” (XIRR) in factsheets — compare your XIRR to that, not to the lumpsum CAGR.
Can XIRR be negative — should I worry?+
Yes, XIRR can be negative — it means portfolio value is below total invested at current market prices. Normal and expected for SIPs under 3 years evaluated during a market downturn. AMFI data: Nifty 50 SIP XIRR turns positive within 24 months for 95%+ of 5-year periods. Don’t stop SIP based on short-term negative XIRR.
How to check XIRR on Groww, Zerodha Coin, and Kuvera?+
Groww: Portfolio → fund → returns tab. Zerodha Coin: Dashboard → Portfolio → fund card. Kuvera: Portfolio → fund details. MFCentral: Login with PAN + Aadhaar OTP → download CAS. All use the same Newton-Raphson XIRR algorithm as this calculator — results match within 0.1%.
What is the Nifty 50 SIP XIRR over 5 and 10 years?+
Nifty 50 SIP XIRR (mid-2025 approx): 5-year (2020–25) ~18–22% (includes COVID recovery); 7-year (2018–25) ~14–16%; 10-year (2015–25) ~13–15%; 15-year (2010–25) ~13–14%. Official SIP return data published by AMFI at amfiindia.com under ‘SIP Returns’ section — updated monthly.
What is the XIRR for PPF annual investment?+
PPF XIRR ≈ the PPF interest rate = 7.1% p.a. (FY 2025-26). Fully tax-free (EEE status) — so post-tax XIRR = 7.1%. Invest before April 5 each year to earn interest for the full month and maximise compounding. Compare to ELSS: nominal XIRR ~13–15%, post-LTCG ~11–13% — equity outperforms but with market risk.
How does rupee cost averaging affect XIRR?+
RCA buys more units at low NAV (bear market) and fewer at high NAV. In volatile markets this improves XIRR — bear-market SIPs buy discounted units that appreciate strongly in recovery. AMFI data: investors who continued SIPs through COVID 2020 crash earned 40–60% XIRR over 2020–2022. In steadily rising markets with no corrections, lumpsum may produce higher returns than RCA.
Is 12% XIRR good for Indian SIP?+
Yes — 12% XIRR gives real return of ~6.2% (after ~5.5% inflation). Beats PPF (7.1%), FD (7%), and savings account (3.5%) substantially. ₹5,000/month SIP at 12% XIRR for 20 years = ₹49.3L corpus vs ₹12L invested. Top Indian midcap/small cap SIPs have delivered 16–20% XIRR over 10+ years — 12% is solid but not peak equity performance.
What is XIRR vs IRR — which to use for SIP?+
IRR assumes equal time intervals between cashflows. XIRR handles any irregular dates. For monthly SIP, use XIRR because months differ in length (28–31 days). Excel’s =IRR() assumes equal periods; =XIRR() takes specific dates. Always use XIRR for SIP, real estate investment analysis, and any portfolio with irregular cashflow timing.
Does stopping a SIP midway affect XIRR?+
Yes — you lose future compounding on new instalments and miss the RCA benefit of bear-market SIPs. Investors who stopped SIPs during COVID 2020 missed some of the highest-XIRR instalments in recent history (those units bought at market bottom appreciated 100%+ within 12 months). Pause SIP only in genuine cash flow emergencies; never stop due to market fear.
How to use XIRR for my NPS account?+
Enter each NPS contribution as a negative cashflow on its date; enter current NPS corpus as a positive cashflow with today’s date. Use this calculator’s Custom Cashflows mode or Excel =XIRR(). NPS Tier I equity (E tier) has delivered ~12–14% XIRR for investors since 2009. NPS portal doesn’t show XIRR directly — compute from your annual statements.
How does budget 2024 LTCG change affect my SIP XIRR?+
Budget 2024 raised equity LTCG from 10% to 12.5% on gains above ₹1.25L (up from ₹1L). On ₹50L corpus with ₹25L gains: LTCG = 12.5% × ₹23.75L = ₹2.97L tax. Reduces effective XIRR by ~0.5–1.5% depending on gain quantum. Compute after-tax XIRR by using post-tax redemption value in the calculator. Plan redemptions to stay within ₹1.25L LTCG-free limit annually where possible.
Is XIRR shown in CAS from CAMS and KFintech?+
Yes. Download CAS from CAMS (camsonline.com), KFintech (kfintech.com), or MFCentral (mfcentral.com) using PAN + Aadhaar OTP. CAS shows XIRR per fund and total portfolio. This is the most authoritative XIRR as it covers all transactions across all fund houses under your PAN — more complete than any single platform’s app.
Can I use XIRR for evaluating direct stock portfolio returns?+
Yes — enter each buy as a negative cashflow, dividends received as positive cashflows on payment dates, and current portfolio value as positive on today’s date. Compare your portfolio XIRR to Nifty 50 SIP XIRR over the same period. If you’re not beating the index by 2–3% XIRR consistently, a low-cost Nifty 50 index fund is likely the better choice.
What is the minimum SIP period for XIRR to be reliable?+
Under 18 months: XIRR is highly volatile (a single month’s market move swings it 10–20%). After 3 years: more stable, useful for direction. After 5 years: meaningful for comparison and fund evaluation. After 7+ years: most reliable long-term indicator. AMFI uses 5, 7, and 10-year XIRR as standard reporting periods — don’t make fund-switching decisions based on less than 3 years of XIRR.
How does XIRR handle dividends from mutual funds?+
Dividends paid to you = positive cashflows on their payment dates in the XIRR formula. Growth option: no dividend cashflows, simpler calculation. Platforms typically show XIRR for growth option. For dividend payout mode, use Custom Cashflows mode here — enter dividends received as positive cashflows with their dates. Growth option XIRR generally exceeds dividend option XIRR for long-term equity due to compounding and lower tax drag.
What is the XIRR target for goal-based SIP (child education, retirement)?+
Conservative planning targets: Child education (15 years): 12–13% XIRR (large cap + midcap); Retirement (25+ years): 11–13% XIRR (diversified equity); Emergency fund: 6–7% XIRR (liquid fund); House down payment (5–7 years): 10–12% XIRR. SEBI’s MFRT (Mutual Fund Return Tool) on sebi.gov.in allows XIRR simulation for different fund categories and goal timelines.

Related Calculators

📈
CAGR Calculator
Compound annual growth
 💰
ROI Calculator
Return on investment
 📐
IRR Calculator
Internal rate of return
 🔍
MF Overlap Checker
Portfolio concentration
 🎯
Goal-Based SIP
Tax-adjusted SIP goal
 ⚖️
ELSS vs PPF
80C comparison

Disclaimer — XIRR Calculator (CalcWise Finance)

The XIRR calculations provided by this tool are indicative and for educational purposes only. CalcWise Finance is not a SEBI-registered investment adviser, mutual fund distributor, or portfolio manager. XIRR results depend on the accuracy of cashflow amounts and dates entered — verify all inputs against your official fund statements before making investment decisions.

Mutual fund investments are subject to market risks. Past XIRR is not indicative of future returns. Tax calculations referenced are as per Finance Act 2024 — consult a chartered accountant for your specific tax liability. LTCG and STCG rates are subject to change in future Union Budgets.

Regulatory authorities: Mutual fund investments in India are regulated by the Securities and Exchange Board of India (SEBI) — sebi.gov.in. Official SIP return data, fund categorisation norms, and XIRR guidelines are published by the Association of Mutual Funds in India (AMFI) — amfiindia.com. For investor grievance redressal, use SEBI SCORES — scores.sebi.gov.in.

CalcWise Finance assumes no liability for investment decisions based on this calculator’s output. Last Updated: 17 Jun 2026.