XIRR Calculator India

What is XIRR? Meaning, Formula and Why It Matters for Indian SIP Investors

The most common mistake Indian mutual fund investors make is calculating returns the wrong way. You invest Rs 10,000 every month for three years, your portfolio grows to Rs 4.2 lakh, and you think: "I invested Rs 3.6 lakh and now I have Rs 4.2 lakh: that is a 16.7% return." That number is meaningless because it ignores time. The XIRR calculator above solves this in seconds by computing your true annualised return on any SIP, step-up SIP, or irregular mutual fund investment. XIRR meaning: Extended Internal Rate of Return, the actual annualised yield on every rupee you invested, weighted by the exact date it entered the market.

The correct metric is XIRR (Extended Internal Rate of Return). XIRR for SIP investments is the annualised return: the single annual percentage that, when applied to each of your investments from the exact date it was made, explains your current portfolio value. XIRR in mutual funds is the standard because it is the only return metric that correctly handles SIPs, partial withdrawals, and lumpsum top-ups at irregular intervals.

Your CAMS statement and mutual fund apps like Groww and Zerodha show XIRR rather than absolute return for exactly this reason. This calculator runs the same Newton-Raphson algorithm that Excel uses for its =XIRR() function, and updates results live as you type.

When XIRR is Negative: What It Means and What to Do

A negative XIRR on your mutual fund SIP means the current portfolio value is lower than the time-weighted cost of your instalments. This most commonly happens in two situations: you started investing recently before a sharp market correction, or the fund has genuinely underperformed across your entire holding period. A negative XIRR is not a reason to stop the SIP. In fact, stopping locks in the loss permanently by preventing future lower-NAV purchases from recovering the average cost. Check XIRR only after a minimum of 2 to 3 years before making any exit decision on an equity fund SIP.

What Happens to XIRR When You Stop a SIP Mid-Way

Stopping a SIP during a market correction is the most damaging thing an Indian investor can do to their XIRR, and the damage is permanent, not temporary. Here is why. When markets fall 30%, NAVs drop. A continuing SIP buys more units at the lower price. When markets recover, those units bought at the bottom contribute disproportionately to your total return. A stopped SIP misses exactly those low-NAV months.

Real numbers: an investor who ran Rs 10,000/month from January 2020 to April 2026 (including the COVID crash) ends up with approximately Rs 12.1 lakh invested and a portfolio value of roughly Rs 19.8 lakh (an XIRR of around 17.2%). An investor who paused for 6 months during March to August 2020 (the crash period) invested Rs 10,600/month to catch up but ends up with an XIRR of approximately 14.8%, which is 2.4 percentage points lower, permanently, because the cheapest units were never bought. The gap compounds every year thereafter.

XIRR vs CAGR: The Comparison Every Indian Investor Needs

The fund house shows you a 5-year CAGR of 18%. Your personal XIRR on the same fund over the same period is 14%. Both numbers are correct. They measure different things. CAGR measures the fund's performance; XIRR in mutual funds measures your personal experience as an investor: what you actually earned based on when you bought and how much. The full XIRR vs CAGR comparison breaks down exactly when each metric applies and why they diverge so significantly on a typical Indian SIP portfolio.

For choosing funds, use CAGR on Value Research or AMFI. For evaluating your portfolio, use XIRR. If you made a single lumpsum investment with no top-ups or withdrawals, CAGR and XIRR will give you the same result. Read more about XIRR vs CAGR in depth, what CAGR means, and how the SIP vs lumpsum comparison changes your actual XIRR outcome.

Worked Example: Why CAGR Misleads on a SIP

Take a simple 3-year SIP of Rs 10,000/month. Total invested: Rs 3.6 lakh. Current value: Rs 4.5 lakh.

Absolute return calculation: (4.5 - 3.6) / 3.6 x 100 = 25%. Sounds good.

CAGR calculation (incorrectly applied): Treating the entire Rs 3.6 lakh as if invested on day one: (4.5/3.6)^(1/3) - 1 = 7.7%. This is wrong because it ignores that instalments were added monthly, not all at once.

XIRR calculation: Each Rs 10,000 instalment is weighted by its actual time in the market: the first instalment for 36 months, the second for 35 months, and so on down to the last instalment for 1 month. The Newton-Raphson algorithm solves for the rate that makes all these time-weighted cash flows equal to the current value. Result: approximately 13.1% XIRR.

The 13.1% XIRR is the honest number. The 25% absolute return is misleading, and the 7.7% CAGR is incorrect methodology. This is why every serious mutual fund platform shows XIRR.

What is a Good XIRR in India? (2026 Benchmarks)

For XIRR on mutual fund SIPs in the debt category, 6 to 8 percent is reasonable. For hybrid funds, 8 to 12 percent is the target range. Investors building a long-term retirement corpus should track XIRR annually. A sustained XIRR below 10% on an equity SIP over a 15-year horizon can leave a significant shortfall against target. Switching from regular to direct plans to reduce expense ratio drag is the easiest way to structurally improve XIRR by 0.5 to 1.5% annually without changing the fund. Understanding nominal vs real return is essential for interpreting whether your XIRR is truly building wealth after inflation. Use the Real Return Calculator to see the purchasing power gap.

Why XIRR Benchmarks Vary by Investment Horizon

A 5% XIRR on a 6-month-old SIP is not cause for panic. A 5% XIRR on a 10-year equity SIP is a serious problem. Horizon is everything when interpreting XIRR. In the first 1 to 2 years of a SIP, even excellent funds may show XIRRs that look low or negative simply because recent instalments dominate the cash flow and have had little time to compound. By year 5 and beyond, the XIRR stabilises and reflects the fund's true long-run return.

ELSS funds: XIRR on ELSS (tax-saving) funds should be interpreted carefully. Because units are locked for 3 years from each instalment date, SIP investors in ELSS cannot access the oldest units until 3 years after the first instalment. A 13% XIRR on an ELSS SIP held for 4 years is genuinely excellent, since the lock-in means you stayed invested through volatility by design, which is the single biggest driver of XIRR improvement.

NPS and EPF: XIRR cannot be directly calculated on NPS or EPF using this calculator because contribution dates are spread across payroll months and the current value includes accrued interest that is not separately visible. Use your annual NPS or EPF statement to see the internal rate of return reported by the scheme directly.

How XIRR is Calculated: The Newton-Raphson Method

XIRR solves for the rate r that makes the Net Present Value of all your cash flows equal to zero:

Where CFi is each cash flow (negative for investments, positive for redemptions or current value), di is the date of that cash flow, and d0 is the date of your first cash flow. The solution uses Newton-Raphson iterative method with a bisection fallback, the same approach Excel uses for =XIRR().

XIRR vs IRR: What is the Difference?

IRR (Internal Rate of Return) is the parent concept. It assumes all cash flows happen at equal intervals, meaning every period is exactly one unit long. XIRR is an extension of IRR that uses actual calendar dates for each cash flow, making it far more accurate for real-world investments where money goes in on different days every month. For a monthly SIP where instalments fall on the 1st, the 5th, or the 10th depending on weekends and holidays, IRR would be wrong by a measurable margin. XIRR, by dividing the day difference by 365.25, accounts for the exact elapsed time per instalment. This is why Excel has a separate =XIRR() function alongside =IRR(), as they solve different problems.

Step-by-Step XIRR Calculation: A 3-Instalment Example

To understand how XIRR actually works, take the simplest possible case: three monthly SIP instalments of Rs 10,000 each, with a current value of Rs 32,500.

XIRR solves for rate r such that:

Simplifying: -10000 - 9914 - 9838 + 32500/(1+r)^0.162 = 0, which gives (1+r)^0.162 = 32500/29752 = 1.0924, so r = 1.0924^(1/0.162) - 1 = approximately 75% annualised.

That high number is correct: a 3-month SIP that returns 8.33% absolute in 2 months annualises to a very high number because of the short time frame. This is why XIRR on very short SIPs looks extreme in either direction. The metric is most meaningful after 2 to 3 years when enough cash flows are present to produce a stable result. This calculator automatically handles all of this arithmetic; the worked example is simply to demystify what happens under the hood.

Three Real SIP Investors: What Their XIRR Reveals

When to Use XIRR

Use XIRR whenever your investment involves more than one cash flow: all SIP portfolios, SIPs with lumpsum additions or partial withdrawals, step-up SIPs, SWP redemptions against a corpus, real estate investments with rent and EMI, ESOPs with staggered vesting. Use CAGR only for true single lumpsum investments with no further additions or withdrawals.

For planning future SIP corpus, use the SIP Calculator or Step-Up SIP Calculator. XIRR measures what already happened; those tools project what will happen. If you hold multiple equity funds, run a portfolio overlap check. Duplicate expense ratios across overlapping funds silently reduce your effective XIRR every year. When you identify funds to consolidate or exit, calculate your LTCG tax liability before switching, and use the portfolio rebalancing calculator to set target allocations after the switch.

XIRR for ELSS, ULIPs and Insurance-Linked Investments

XIRR is especially useful for evaluating ELSS (Equity Linked Savings Scheme) funds, where the 3-year lock-in per instalment makes simple return calculations unreliable. Enter each ELSS SIP instalment as a negative cash flow and the current redeemable value as a positive. XIRR will correctly account for the fact that different instalments became redeemable at different times.

For ULIPs and traditional endowment insurance plans, XIRR is the only honest way to evaluate what the product actually returned. Enter premium payments as negative cash flows and the current surrender value or maturity value as a positive. Most ULIPs sold in India between 2005 and 2015 show XIRRs of 4 to 7% after charges, well below what a comparable mutual fund SIP would have delivered. The XIRR comparison is the number your insurance agent will never show you.

What XIRR cannot calculate: EPF and NPS where contributions are deducted from payroll and the interest is credited on an accrual basis not visible as discrete cash flows. For these, use the return rate disclosed in your annual statement.

How to Find Your XIRR from CAMS or KFintech

1. Go to camsonline.com or kfintech.com
2. Request a Consolidated Account Statement with today as valuation date
3. The PDF shows each fund's XIRR under "Returns"
4. Your total portfolio XIRR appears at the bottom of the statement

The XIRR in your CAS statement uses the same Newton-Raphson method this calculator uses. It should match our Custom Mode output if you enter every transaction accurately.

How to Calculate XIRR in Excel

The XIRR Excel formula is the most widely used method for Indian investors with transaction histories from CAMS or KFintech. Enter all investment amounts as negative numbers in column A and their dates in column B. Add today's portfolio value as a positive number in the last row. In any empty cell, type =XIRR(A1:A37,B1:B37) (the XIRR Excel function returns a decimal, so multiply by 100 or format as percentage) to get the percentage directly. For a 3-year monthly SIP, you will have 36 instalment rows plus one current-value row, making 37 rows total. If Excel returns a #NUM! error, it means the cash flows are all negative or all positive. Check that the current value row is entered as a positive number.

XIRR on Groww, Zerodha Coin and Other Platforms

Groww: Go to Portfolio > select a fund > tap "Returns". Groww shows XIRR as "Annualised Returns" for each fund and for your total portfolio separately. The number updates daily as NAVs change.

Zerodha Coin: Log in to coin.zerodha.com > Holdings > click any fund > scroll down to see "XIRR" displayed alongside absolute returns. Coin is one of the few platforms that labels it correctly as XIRR rather than using softer language.

ET Money: Portfolio tab > tap any fund > Returns section shows XIRR. ET Money also shows a "Smart Score" that factors in XIRR alongside risk metrics.

MF Utilities (MFU): Download your transaction statement and use the Custom Mode of this calculator to enter each transaction. MFU does not display XIRR directly in its interface.

One important note: the XIRR shown by apps like Groww reflects all transactions in that fund including any dividend reinvestments, switches, and systematic transfer plan (STP) instalments. If you switched from regular to direct plan in the same fund, the XIRR shown will include both periods. Use Custom Mode here to isolate the direct-plan-only return if you want a clean comparison.

Common XIRR Mistakes Indian Investors Make

XIRR is a precise metric that produces misleading numbers when inputs are wrong. Here are the five most common mistakes and how to avoid them.

Mistake 1: Entering the Current Value as a Negative Number

In Excel and in Custom Mode here, investments are negative (money leaving your pocket) and current value is positive (money coming back to you). The most common data entry error is entering the current portfolio value as -4,50,000 instead of +4,50,000. This causes XIRR to either fail entirely or return a nonsensical number like -99%. Always enter current value as a positive inflow.

Mistake 2: Using NAV CAGR as a Proxy for Personal XIRR

When Groww shows "HDFC Flexi Cap: 18.2% (3Y)", that is the fund's NAV CAGR: the return a single lumpsum investment made exactly 3 years ago would have earned. Your SIP XIRR on the same fund over the same period will almost certainly be different, depending on exactly when you invested each instalment relative to NAV movements. Comparing your SIP performance to a fund's NAV CAGR is not a valid comparison.

Mistake 3: Calculating XIRR on Too Short a Period

XIRR on a SIP that is less than 12 months old is statistically meaningless and mathematically extreme. A 3-month SIP showing 80% XIRR is not performing well. It is simply annualising a short-term gain over very few data points. Interpret XIRR only after 2 years minimum, and ideally after 3 to 5 years, when the result stabilises.

Mistake 4: Including Dividends as Inflows Without Adding Their Reinvestment

If you are in the Growth option, this is not an issue, as all returns are reflected in NAV. If you are in the IDCW (dividend) option, dividends received should be entered as positive cash flows on the date received. Failing to include them understates your XIRR. Failing to include them but still using the post-dividend NAV for current value also distorts the result.

Mistake 5: Comparing XIRR Across Different Time Periods

An investor who started a SIP in January 2020 (right before COVID) and an investor who started in January 2019 will have very different XIRRs on the same fund, not because one is a better investor, but because the 2020 investor's early instalments caught the crash lows. XIRR is a personal metric, not a benchmarkable one. Compare your XIRR to the Nifty 50 SIP XIRR over the same exact period, not to another investor's XIRR over a different period.

How to Structurally Improve Your XIRR

Three levers reliably improve XIRR without requiring you to predict markets or pick the next top-performing fund.

1. Switch from Regular to Direct Plans

A regular plan fund charges a distribution commission (trail fee) of 0.5% to 1.5% annually, deducted from NAV. A direct plan of the same fund charges no commission. Over 10 years, the compounded difference is 8 to 15% of corpus, entirely captured in XIRR terms as approximately 0.7 to 1.2% higher annualised return. This is the single highest-certainty XIRR improvement available to any Indian SIP investor, requiring no market judgement. Read the full direct vs regular fund comparison and the impact of expense ratio on long-term corpus.

2. Never Stop SIPs During Corrections

The months during which markets fall 20 to 40% are precisely the months that generate the highest number of units per rupee invested. Stopping a SIP during a crash to "wait for stability" eliminates the best-value purchases from your cash flow history. The cost of delay is asymmetric. You lose not just the instalments skipped but the compounding of those units over the remaining horizon. Data from Nifty 50 SIP XIRRs consistently shows that investors who maintained SIPs through both the 2020 COVID crash and the 2022 rate-hike sell-off have XIRRs 3 to 5 percentage points higher than those who paused.

3. Eliminate Portfolio Overlap

Holding two large-cap funds that share 60% of their portfolios means paying two expense ratios for one effective portfolio. The extra ER is a direct drag on XIRR that compounds against you every year. A portfolio overlap check takes 30 seconds and typically reveals consolidation opportunities that lift effective XIRR by 0.3 to 0.8% annually simply by eliminating duplicate cost.

Frequently Asked Questions