What is XIRR in mutual funds?

Last Reviewed and Updated: 17 Aug 2026

XIRR (Extended Internal Rate of Return) is a financial function that computes the annualised return of an investment where cash flows happen at irregular intervals. In the context of mutual fund SIP investing, where you add money at different times and potentially make withdrawals at others, it is the only mathematically honest way to measure your actual returns.

It finds the single annualised interest rate that, when applied to all your cash outflows (investments) and inflows (redemptions or the current value), makes the net present value of those cash flows equal to zero.

Formula

NPV = Σ [ Cᵢ / (1 + r)^(dᵢ - d₀)/365 ] = 0

Where:

  Cᵢ  = Cash flow at period i  (negative = investment, positive = redemption)

  dᵢ  = Date of cash flow i

  d₀  = Date of first cash flow

  r   = XIRR  (the annualised rate we are solving for)

Cash flows into a fund (your SIP investments) are negative (money leaving your pocket). The redemption amount or current portfolio value is positive (money returning to you). XIRR solves for the rate that ties them all together into a single annualised figure.

You have been investing Rs 10,000 every month in an equity mutual fund for three years. The fund has grown, and your portfolio is now worth more than you put in. But exactly how much more, on an annualised basis? The answer is not as simple as dividing the total gain percentage by 3, because each of your monthly SIP instalments was invested for a different length of time and experienced a different slice of the fund’s performance.

Before understanding XIRR, you need to see why the simpler metrics fall short.

Total invested ₹3.6L 36 × ₹10,000 SIP

Current value ₹4.68L After 3 years

Absolute return 30% Simple gain / cost

Naïve CAGR ~9.1% Assumes 1 lump sum

Neither number is accurate. The absolute return percentage doesn’t account for time. The naive annualisation of dividing by years doesn’t account for the fact that each SIP instalment was invested for a different duration.

CAGR is designed for a single lump sum investment. Using it for SIPs is like measuring the speed of multiple runners in a relay race by dividing the total distance by only one runner’s time.

The three metrics, side by side:

Absolute return	CAGR	XIRR
Formula: (Current − Invested) ÷ Invested × 100 Easy to understand Ignores time completely Useless for comparing funds	Formula: (End/Start)^(1/years) − 1 Accounts for time Assumes single investment Wrong for SIP portfolios	Formula: IRR with exact dates Handles irregular cash flows Works for SIPs, SWPs, STPs Annualised & comparable

Let's take Rahul, who started a Rs 5,000 monthly SIP in HDFC Mid-Cap Opportunities Fund on 1st January 2022 and continued for 36 months until December 2024.

Total invested: Rs 1,80,000. Current portfolio value: Rs 2,43,600.

Date	Cash flow	Nature
01-Jan-2022	−₹5,000	SIP instalment 1
01-Feb-2022	−₹5,000	SIP instalment 2
01-Mar-2022	−₹5,000	SIP instalment 3
…	−₹5,000/mo	30 more monthly instalments
01-Dec-2024	−₹5,000	SIP instalment 35
01-Jan-2025	−₹5,000	SIP instalment 36
01-Jan-2025	+₹2,43,600	Redemption / Portfolio Value

Investment outflows are entered as negative numbers. The final portfolio value (or actual redemption amount if withdrawn) is entered as a positive number. XIRR is then calculated across all these dated cash flows.

When this data is fed into the XIRR function (in Excel, Google Sheets, or a financial calculator), the output is the annualised rate of return.

Absolute Return 35.3% Gain ÷ Invested

Naïve CAGR 10.6% Wrong for SIP

XIRR (Correct) 22.4% True annual return

The XIRR of 22.4% is the correct answer. It accounts for the fact that early instalments earned more (since they were invested for longer) and later ones earned less (since they had less time).

For a single lump sum, XIRR and CAGR give you the same answer and they should. If Meera invested Rs 1 lakh on 1st January 2021 and her portfolio is worth Rs 1.82 lakh on 31st December 2023, both XIRR and CAGR correctly return approximately 22.2% per annum. The divergence appears when multiple cash flows are involved.

The real power of XIRR shows up when investments and withdrawals are irregular, SIPs with missed instalments, lump sum top-ups, or partial withdrawals at different points.

The complex case: SIP + lump sum + partial withdrawal

Consider Arjun’s portfolio in a Flexi cap fund:

Date	Cash flow	Event
01-Apr-2021	−₹50,000	Initial Lump Sum
01-May-2021 – 01-Apr-2023	−₹72,000	24 monthly SIP instalments (₹3,000/mo)
15-Aug-2022	−₹25,000	Additional top-up on market dip
01-Jan-2023	+₹30,000	Partial redemption (medical emergency)
01-Apr-2024	+₹1,65,000	Full Redemption / Today's Value

Total outflows: Rs 1,47,000. Total inflows: Rs 1,95,000. In this scenario, CAGR is meaningless, absolute return is distorted, and only XIRR gives you the truth.

If you make a partial withdrawal, enter it as a positive number in the XIRR table. The function automatically adjusts to account for money that left the investment pool.

XIRR is only meaningful in context. A 12% XIRR in a liquid fund is spectacular. A 12% XIRR in a small-cap fund over a 5-year period is decidedly mediocre. Always benchmark your XIRR against what others in the same category achieved over the same period.

Fund category	Benchmark XIRR range	Rating
Small Cap / Thematic	18% – 26%+	Excellent
Mid Cap	15% – 22%	Excellent
Flexi Cap / Multi Cap	12% – 18%	Good
Large & Mid Cap	11% – 16%	Good
Large Cap / Index	10% – 14%	Market Rate
Balanced Advantage	9% – 13%	Market Rate
Debt / Short Duration	6% – 9%	Conservative
Liquid / Overnight	5% – 7%	Conservative

These ranges assume a minimum 3 to 5 year investment horizon and reflect post-expense, illustrative outcomes.

Five things investors get wrong about XIRR

1. XIRR is post-expense, pre-tax

Fund returns reported via XIRR already account for the fund’s expense ratio (since NAV is calculated after expenses are deducted). But XIRR does not account for the tax you owe on redemptions. Your actual post-tax return will be lower than the XIRR figure, particularly for equity funds where long-term capital gains above Rs 1.25 lakh are taxed at 12.5%.

2. Short-duration XIRR is misleading

An XIRR of 60% over 4 months sounds incredible, but it annualises a short-term gain. If a fund happened to surge 15% in four months, the annualised XIRR appears as roughly 60%. This is mathematically correct but economically misleading. It does not mean you will earn 60% per year if you continue investing.

3. XIRR doesn’t account for benchmark-relative performance

A 14% XIRR in a large-cap fund looks good until you notice the Nifty 50 returned 16% over the same period. Your fund underperformed the passive alternative by 2 percentage points annually, a meaningful gap over a decade. XIRR tells you your absolute return. It doesn’t tell you whether you made the right fund choice.

4. Missed SIP instalments affect XIRR

If your SIP bounced for 2 months due to insufficient funds, and you don’t exclude those dates from your XIRR calculation, the result will be slightly off. Some mutual fund apps handle this automatically; others require manual input. When in doubt, use the actual transaction history from your account statement.

5. XIRR assumes reinvestment at the same rate

Like all IRR-family metrics, XIRR implicitly assumes that interim cash flows (like dividend payouts in the IDCW option) are reinvested at the same rate. In reality, dividend payouts lie idle until you invest them again, which means the actual compounding is slightly lower than XIRR suggests. This is one more reason the growth option generally outperforms IDCW over long periods for wealth creation.

Here’s what a Rs 5,000 per month SIP across different fund types would have yielded over 10 years:

Fund type	Final value	XIRR
Small Cap (Avg Category)	₹18.4L	21.7%
Mid Cap (Avg Category)	₹15.8L	18.3%
Flexi Cap (Avg Category)	₹13.6L	15.4%
Large Cap / Nifty 50 Index	₹11.9L	13.2%
Hybrid — Balanced Advantage	₹10.8L	11.8%
Short Duration Debt	₹8.6L	7.4%

Total Invested: Rs 6,00,000 (120 months x Rs 5,000). Returns are illustrative, based on category averages.

Most mutual fund apps display a metric called ‘Annualised Return’ or ‘XIRR’ on your portfolio dashboard. This is the number you should focus on when evaluating how your SIP has actually performed.

XIRR is not just a formula. It’s the only honest conversation you can have with your portfolio. Whether you’re a new SIP investor checking your returns for the first time, or a seasoned investor managing a complex multi-fund portfolio with partial redemptions, understanding XIRR is non-negotiable.

The difference between a 12% and 18% XIRR over 20 years isn’t 6 percentage points. It’s the difference between financial comfort and genuine wealth. Measure it correctly. Then act on it.

Disclaimer

Disclaimer: This article is for informational and educational purposes only and does not constitute investment advice, a solicitation, or a recommendation to buy or sell any financial instrument. Mutual fund investments are subject to market risks. Past performance is not indicative of future results. Returns data is sourced from AMC websites and AMFI India. Please read all Scheme Information Documents (SID) and Key Information Memoranda (KIM) carefully before investing. Consult a SEBI-registered investment advisor for personalised advice.