What is XIRR in mutual funds?

XIRR (Extended Internal Rate of Return) is a financial function that computes the annualised return on a series of cash flows that occur at irregular intervals. In the context of mutual funds, it is the most accurate measure of your actual portfolio return especially for SIP investors.

It finds the single annualised interest rate that, when applied to all your cash outflows (investments) and inflows (withdrawals/redemptions) on their exact dates, makes the net present value (NPV) of the entire series 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 final portfolio value is treated as a positive cash flow on the date you "redeem" or simply today's date if you're measuring current performance.

You've been investing ₹10,000 every month in an equity mutual fund for three years. The fund's NAV has gone up. Your app shows you a return of 48%. But is that good? And more importantly what is your actual annualised return?

The answer is not as simple as dividing 48% by 3. Because each of your monthly SIP instalments was invested at a different time, earned returns for a different duration, and had a different cash flow. To measure the true performance of such irregular, time-scattered investments, you need XIRR.

Before understanding XIRR, you need to see why the simpler metrics fall short. Consider Priya, who invested ₹10,000 per month for 36 months (3 years) in Axis Blue Chip Fund. Her total investment is ₹3,60,000 and her current portfolio value is ₹4,68,000.

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 of 30% doesn't account for time. The naïve CAGR of 9.1% is wrong because it pretends all ₹3,60,000 was invested at the start but the last ₹10,000 instalment was only invested for 1 month, not 36.

CAGR is designed for a single lump sum investment. Using it for SIPs is like measuring the average speed of a road trip by only looking at your speedometer when you first hit the highway.

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 ₹5,000 monthly SIP in HDFC Mid-Cap Opportunities Fund on 1 January 2022. We'll compute his XIRR as of 1 January 2025 (exactly 3 years, 36 instalments).

Total invested: ₹1,80,000. Current portfolio value: ₹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) is a positive number on the date it is received. Both the last SIP and the redemption value occur on the same date, so two entries exist for 01-Jan-2025.

When this data is fed into the XIRR function (in Excel, Google Sheets, or a financial calculator), it iteratively finds the rate r that solves the NPV equation. In Rahul's case:

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 returns for the full 3 years, while later instalments barely had time to compound at all.

For a single lump sum, XIRR and CAGR give you the same answer and they should. If Meera invested ₹1,00,000 in Mirae Asset Emerging Bluechip on 1 January 2022 and it grew to ₹1,65,000 by 1 January 2025, both metrics give 18.2% per annum.

The real power of XIRR shows up when investments and withdrawals are irregular — SIPs with top-ups, partial redemptions, or additional lump sum investments mid-way.

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: ₹1,47,000. Total inflows: ₹1,95,000. In this scenario, CAGR is meaningless as there's no single start/end point. Only XIRR can compute the true return. The answer: XIRR = 16.8% p.a.

If you make a partial withdrawal, enter it as a positive number in the XIRR table. The function treats it as cash returning to you, exactly like a partial redemption should be treated. This is where most manual calculators go wrong.

XIRR is only meaningful in context. A 12% XIRR in a liquid fund is spectacular. A 12% XIRR in a small-cap fund over 7 years is disappointing. Here's a rough benchmark guide based on long-run market data:

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–5-year investment horizon and reflect post-tax, post-expense returns. Short-term XIRR figures (under 2 years) can be highly misleading. A fund that gained 40% in 6 months will show a spectacular XIRR that no one should expect to sustain. Always compute XIRR over full market cycles (5–10 years) for meaningful comparisons.

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 net of expenses). But they do not account for your personal tax liability on capital gains. For equity funds held over 1 year, subtract 12.5% LTCG tax on gains above ₹1.25 lakh.

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 rose 18% in 4 months, XIRR ≈ 70%. No fund sustains this. Always compare XIRR across equal time horizons.

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. XIRR tells you your return; alpha (outperformance vs benchmark) is a separate calculation.

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 cash flow table, your XIRR will be wrong. Only include dates when money actually left your account.

5. XIRR assumes reinvestment at the same rate

Like all IRR-family metrics, XIRR implicitly assumes that interim cash flows (like dividends in a dividend-pay out plan) are reinvested at the same XIRR rate. For growth plans, this is generally fine. For dividend plans, XIRR can overstate your effective compounded return.

Here's what a ₹5,000/month SIP across different fund types would have yielded over 10 years (Jan 2014 – Jan 2024), based on representative category performance:

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: ₹6,00,000 (120 months × ₹5,000). Returns are illustrative, based on category averages. Past performance does not guarantee future results.

Most mutual fund apps display a metric called "Annualised Return" or "XIRR" on your portfolio page but many actually show CAGR on the total invested amount, which is subtly wrong for SIP portfolios. The difference can be 3–6 percentage points, enough to make a mediocre fund look good or a great fund look average.

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 wealth manager comparing fund performance across clients, XIRR is the right tool. Use it consistently, compute it over full market cycles, and compare it against your benchmark index.

The difference between a 12% and 18% XIRR over 20 years isn't 6 percentage points. It's the difference between ₹98 lakh and ₹2.1 crore on a ₹10,000/month SIP. That's what time-weighted, compounded, honest returns look like. That's XIRR.