Returns & Performance Metrics

XIRR vs CAGR: Which Number Actually Tells You What Your Mutual Fund Returned

Q: What is the difference between XIRR and CAGR for mutual funds?

CAGR (Compound Annual Growth Rate) measures how a fund's NAV grew between two specific dates — it's a time-weighted return that ignores when you personally invested. XIRR (Extended Internal Rate of Return) is a money-weighted return that accounts for the exact timing and amount of every cash flow: each SIP instalment you made, each lump sum, each redemption. For a lump-sum investment held for exactly the same period as the CAGR calculation, CAGR and XIRR will be identical. For a SIP investor who invested at different times, XIRR is the correct measure of personal return — and it will differ from the fund's CAGR based on whether your SIPs were timed with or against market movements.

Q: How do I calculate XIRR for my mutual fund SIP in Excel?

In Excel, XIRR uses two arrays: cash flows (negative for investments, positive for redemptions/current value) and corresponding dates. For a SIP: enter each monthly instalment as a negative number with its date. In the final row, enter the current portfolio value as a positive number with today's date. Then use =XIRR(cash_flows_range, dates_range) — Excel will calculate your annualised money-weighted return. Example: if you invested ₹10,000 on Jan 1, ₹10,000 on Feb 1, and your portfolio is worth ₹21,500 on Mar 1, =XIRR({-10000,-10000,21500}, {Jan1,Feb1,Mar1}) returns your annualised return. For large portfolios, downloading your CAS and using a tool like FundSageAI is significantly faster.

Q: Why is my SIP XIRR lower than the fund's CAGR?

Several reasons cause your XIRR to be lower than the fund's CAGR: (1) You started SIPs when the market was already high — initial instalments bought units at expensive NAVs. (2) You paused SIPs during corrections — missing the cheap-unit accumulation phase. (3) You added lump sum top-ups at market peaks. (4) You redeemed early or partially. In all these cases, your actual investment timing worked against you, even if the fund's overall CAGR looks attractive. The fund delivered those returns to investors who were fully invested throughout. The XIRR measure captures where your specific timing differed.

Q: Which is more useful — XIRR or CAGR — for evaluating a mutual fund?

Use both, for different purposes. CAGR (specifically, rolling CAGR across multiple periods) tells you how the fund performs as an investment vehicle — its consistency, benchmark outperformance, and manager skill over time. This is what you use to select or evaluate a fund for future investment. XIRR tells you how you personally performed in that fund — your actual return based on your investment timing. This is what you use to evaluate whether your strategy is working and to measure goal progress. Comparing your XIRR against the fund's benchmark CAGR for the same period is the most honest performance evaluation for a SIP investor.

Q: What is a good XIRR for a mutual fund SIP in India?

Context matters significantly. For an equity SIP over 7–10 years in India: an XIRR of 12–15% is generally considered good for large-cap/index funds; 14–18% for mid-cap; 14–20% for small-cap. These ranges reflect India's historical equity returns and the benefit of rupee-cost averaging in volatile categories. For comparison, fixed deposits typically deliver 6–7% (pre-tax). The more important benchmark is: is your XIRR tracking above the return rate required to reach your specific financial goal by your specific deadline? That goal-adjusted view is more actionable than comparing to an absolute percentage target.

Q: Can XIRR be negative for mutual fund investments?

Yes. XIRR can be negative if you invested primarily at market highs and the current NAV is still below your average purchase price. This can happen after significant market corrections or when you've invested in a fund category at the peak of a valuation cycle. A negative XIRR at any point-in-time is not cause for immediate alarm — equity investments are volatile on short time horizons. However, a negative XIRR after 5+ years in a diversified equity fund warrants review: either the fund itself is underperforming significantly, or your investment timing was systematically bad (e.g., large lump sums at peak markets), or your holding period has simply been too short for equity returns to smooth out.

CAGR tells you how the fund performed. XIRR tells you how you personally performed. For SIP investors, these two numbers diverge significantly — and using the wrong one leads to decisions based on returns you never actually earned.

April 27, 202610 min readBy FundSageAI

Ask most mutual fund investors what their fund returned and they'll quote the number from the fund factsheet — CAGR over 1 year, 3 years, 5 years. This is a clean, understandable number. It's also probably not the return you personally earned, unless you invested once as a lump sum at the exact start of the period and held without any additions or withdrawals.

For SIP investors — which is most retail investors in India — the relevant return metric is XIRR: Extended Internal Rate of Return. It accounts for when you invested each rupee, not just whether the fund as a whole went up. A fund can show 15% CAGR over 5 years while an investor who started SIPs mid-way through earned 10% XIRR, because they invested mostly during the higher-NAV phase.

This guide explains both metrics precisely, shows how they diverge for SIP investors, and gives you a practical framework for using each one correctly.

In This Article

1What CAGR Is and What It Actually Measures
2What XIRR Is and Why It's Different
3A Concrete Example: The Same Fund, Two Different Returns
4When CAGR and XIRR Converge (and When They Diverge Most)
5How to Calculate Your XIRR in Practice
6XIRR vs. Benchmark CAGR: The Right Comparison for SIP Investors
7Common Misuses of Return Metrics
8What Absolute Returns Are (and When They Matter)
9Reading Fund Factsheets: Which Number to Use for What
10Making Decisions with the Right Metric

1What CAGR Is and What It Actually Measures

CAGR — Compound Annual Growth Rate — measures the smooth annual growth rate that would take an investment from its starting value to its ending value over a given period. It's a time-weighted return: it answers the question "if ₹100 invested on Date A became ₹200 on Date B, what was the annualised growth rate?"

The formula: CAGR = (Ending Value / Starting Value)^(1/years) − 1

Example:

NAV on Jan 1, 2019: ₹100

NAV on Jan 1, 2024: ₹220

CAGR = (220/100)^(1/5) − 1 = 17.1%

This is the fund's 5-year CAGR. It measures the fund's NAV growth — independent of when you invested.

CAGR is a fund-level metric. It tells you about the fund's performance — not about your experience as an investor. For an investor who invested once on Jan 1, 2019 and sold on Jan 1, 2024, their return would match the CAGR. For anyone who invested at any other time, or made multiple investments, CAGR is not their return.

2What XIRR Is and Why It's Different

XIRR — Extended Internal Rate of Return — is a money-weighted return that accounts for the timing and amount of every individual cash flow. It answers: "given that I invested specific amounts on specific dates and my portfolio is worth X today, what is my annualised return?"

For a SIP investor, each monthly instalment is a separate cash flow with its own date. The XIRR calculation accounts for all of them simultaneously. Units bought during low-NAV periods have had more time to grow; units bought during high-NAV periods have contributed less. XIRR reflects this timing precisely.

CAGR: "The fund grew from ₹100 to ₹220 NAV over 5 years. CAGR = 17.1%."

XIRR: "You invested ₹10,000/month for 60 months. Your portfolio is now worth ₹9.3 lakh. XIRR = 14.8%."

Both statements can be true simultaneously. The fund CAGR is 17.1%. Your personal XIRR is 14.8%. The gap exists because you invested progressively over time, not all at the beginning.

3A Concrete Example: The Same Fund, Two Different Returns

Consider two investors in the same fund over the same 5-year period:

Investor A: Lump Sum

Invested ₹6L on Jan 1, 2019 (NAV: ₹100)
Held without changes for 5 years
Portfolio value Jan 2024: ₹13.2L (NAV: ₹220)

XIRR = CAGR = 17.1%

Because there's one cash flow, XIRR = CAGR exactly.

Investor B: Monthly SIP

Invested ₹10,000/month from Jan 2019 to Dec 2023
Total invested: ₹6L (same as Investor A)
Portfolio value Jan 2024: ₹9.3L

XIRR ≈ 14.8%

Later SIPs had less time to grow. XIRR reflects this timing effect.

Both investors were in the same fund. The fund delivered 17.1% CAGR. Investor A achieved 17.1%. Investor B achieved 14.8%. This isn't because Investor B made a mistake — a SIP is usually the correct strategy for most investors. It's because SIP returns are inherently different from lump-sum returns. Using the fund's 17.1% CAGR to evaluate Investor B's performance would be misleading.

4When CAGR and XIRR Converge (and When They Diverge Most)

Scenario	CAGR vs XIRR	Reason
One-time lump sum, held the full period	Identical	Single cash flow — time-weighted = money-weighted
Regular SIP, consistent market exposure	XIRR slightly lower	Later SIPs had shorter compounding time
SIP paused during market crash	XIRR significantly lower	Missed cheap-unit accumulation; recovery went to earlier investors
Lump sum added at market peak	XIRR lower	Large cash flow at high NAV drags money-weighted return
SIP increased during correction	XIRR higher than fund CAGR	More capital deployed at low NAVs benefited from full recovery
Partial redemptions at market peaks	XIRR higher than fund CAGR	Sold at high NAV; remaining investment continued to compound

5How to Calculate Your XIRR in Practice

Three methods, in order of effort:

Excel / Google Sheets (Manual)

1List every investment transaction: date in column A, amount as negative in column B (e.g., -10000 for ₹10,000 SIP)
2In the final row: today's date in column A, current portfolio value as positive in column B
3In an empty cell: =XIRR(B2:B_last, A2:A_last) — this returns your annualised XIRR
4For percentage display: format the cell as percentage

Most accurate if you have all transaction dates. Time-consuming for multi-year portfolios.

Portfolio platforms (Kuvera, Coin, Groww)

1Most platforms show XIRR alongside absolute gain in your portfolio dashboard
2Check whether the platform is computing XIRR per fund or across the portfolio
3Note: platform XIRR only covers investments made through that platform — not your complete portfolio

Convenient but incomplete if you have investments across multiple platforms.

FundSageAI (CAS-based, complete)

1Upload your CAS statement (all transactions across all AMCs in one file)
2XIRR is calculated per fund and for the complete portfolio
3Benchmarked against the fund's benchmark for the same period
4No manual data entry — all transactions extracted from the CAS automatically

Most complete method. Covers all funds regardless of which platform they were purchased through.

6XIRR vs. Benchmark CAGR: The Right Comparison for SIP Investors

For SIP investors, the most useful return comparison is: your XIRR vs. what you would have earned if you'd made identical SIPs into the benchmark index over the same period. This isolates the fund's contribution to your returns vs. pure market beta.

Comparing your XIRR to the fund's point-to-point CAGR is misleading — they're measuring different things. The correct comparison is: your XIRR in the fund vs. XIRR you'd have earned in the benchmark index with identical investment timing and amounts. If your XIRR in an active fund is 15% but XIRR in the Nifty 50 index with the same SIP schedule would have been 13%, the active fund added 2% value net of fees. That's meaningful outperformance.

Also see: Why Mutual Fund Investors Underperform Their Own Funds — which covers how investment timing (not fund selection) is typically the primary driver of the gap between fund CAGR and investor XIRR.

7Common Misuses of Return Metrics

These mistakes lead to both bad fund evaluations and bad self-assessments:

Using 1-year CAGR to evaluate a long-term fund

Problem: One-year returns are heavily influenced by market timing. A fund that underperformed last year in a category rotation may be one of the best long-term performers.

Fix: Use rolling 5- and 7-year CAGR relative to benchmark and category median. Single-year CAGR is noise for long-term fund evaluation.

Comparing your XIRR to someone else's CAGR quote

Problem: "My friend's fund gave 20% CAGR" is a point-to-point fund return. Your 12% XIRR is a money-weighted personal return. They're not comparable without knowing the investment timeline and cash flow pattern.

Fix: Either compare XIRR to XIRR (both calculated over identical investment patterns) or compare fund CAGR to fund CAGR.

Assuming fund CAGR = your return if you're a SIP investor

Problem: This is the most common error. The fund returned 18% CAGR over 7 years. Your XIRR is 13%. You assume you're underperforming — but actually, the 13% XIRR is simply a consequence of SIP timing, and you need to compare it against a SIP into the benchmark to know whether it's good or not.

Fix: Calculate your XIRR and then calculate what XIRR you'd have earned in the benchmark with identical SIPs.

8What Absolute Returns Are (and When They Matter)

You'll sometimes see "absolute return" figures alongside CAGR and XIRR. Absolute return is simply: (Current Value − Invested Amount) / Invested Amount × 100. It doesn't annualise. A 100% absolute return over 1 year is very different from a 100% absolute return over 10 years.

When absolute return is useful

Holdings shorter than 1 year (CAGR annualises incorrectly for sub-year periods)
Quick sanity check: 'Did I make or lose money in absolute terms?'
Tax calculations: capital gains are calculated on absolute gain, not CAGR

When absolute return is misleading

Comparing two funds with different holding periods
Evaluating long-term SIP performance (doesn't account for time)
Comparing equity returns vs. FD returns (FD interest compounds differently)

9Reading Fund Factsheets: Which Number to Use for What

Fund factsheets publish multiple return metrics. A quick reference:

Metric in factsheet	What it measures	Use for
1Y / 3Y / 5Y CAGR	Fund NAV growth for that exact trailing period	Comparing fund performance against benchmark and category peers
SIP returns (factsheet)	XIRR of a hypothetical SIP of ₹10,000/month for N years, ending today	Rough estimate of SIP return — uses idealised amounts and timing, not your actual SIPs
Since inception CAGR	Fund performance from launch date to today	Long-term fund quality assessment; sensitive to launch date chosen
Rolling returns	Average CAGR across all rolling N-year windows	Most robust indicator of fund consistency — less affected by start/end date bias
Alpha vs. benchmark	Excess return generated above benchmark, adjusted for risk	Evaluating active manager skill; positive alpha = value added over index

10Making Decisions with the Right Metric

A practical framework for using returns metrics in actual investment decisions:

Decision

Should I add this fund to my portfolio?

Use: Rolling 5-year and 7-year CAGR vs. benchmark and category median. Look for consistency, not just the peak CAGR window.

Decision

Am I on track for my financial goal?

Use: Your XIRR in the portfolio vs. the required return rate for your goal. If XIRR < required rate, you need to save more, invest longer, or reassess the goal.

Decision

Is my fund underperforming?

Use: Your XIRR in the fund vs. XIRR you'd have earned in the benchmark index with identical SIP amounts and timing. Fund switching is only justified if the fund's alpha, not your timing, is the problem.

Decision

How much have I made in absolute terms?

Use: Absolute return for quick math. But always contextualise: 50% absolute over 10 years = 4.1% CAGR, which is below inflation. Absolute return without time context is meaningless for evaluation.

Decision

Should I continue this SIP?

Use: Your XIRR over the investment horizon relative to your goal's required return. If XIRR is tracking above the required rate, the SIP is working. Don't stop because short-term NAV is down.

Frequently Asked Questions

Common questions about XIRR, CAGR, and how to calculate mutual fund returns in India.

What is the difference between XIRR and CAGR for mutual funds?

CAGR (Compound Annual Growth Rate) measures how a fund's NAV grew between two specific dates — it's a time-weighted return that ignores when you personally invested. XIRR (Extended Internal Rate of Return) is a money-weighted return that accounts for the exact timing and amount of every cash flow: each SIP instalment you made, each lump sum, each redemption. For a lump-sum investment held for exactly the same period as the CAGR calculation, CAGR and XIRR will be identical. For a SIP investor who invested at different times, XIRR is the correct measure of personal return — and it will differ from the fund's CAGR based on whether your SIPs were timed with or against market movements.

How do I calculate XIRR for my mutual fund SIP in Excel?

In Excel, XIRR uses two arrays: cash flows (negative for investments, positive for redemptions/current value) and corresponding dates. For a SIP: enter each monthly instalment as a negative number with its date. In the final row, enter the current portfolio value as a positive number with today's date. Then use =XIRR(cash_flows_range, dates_range) — Excel will calculate your annualised money-weighted return. Example: if you invested ₹10,000 on Jan 1, ₹10,000 on Feb 1, and your portfolio is worth ₹21,500 on Mar 1, =XIRR({-10000,-10000,21500}, {Jan1,Feb1,Mar1}) returns your annualised return. For large portfolios, downloading your CAS and using a tool like FundSageAI is significantly faster.

Why is my SIP XIRR lower than the fund's CAGR?

Several reasons cause your XIRR to be lower than the fund's CAGR: (1) You started SIPs when the market was already high — initial instalments bought units at expensive NAVs. (2) You paused SIPs during corrections — missing the cheap-unit accumulation phase. (3) You added lump sum top-ups at market peaks. (4) You redeemed early or partially. In all these cases, your actual investment timing worked against you, even if the fund's overall CAGR looks attractive. The fund delivered those returns to investors who were fully invested throughout. The XIRR measure captures where your specific timing differed.

Which is more useful — XIRR or CAGR — for evaluating a mutual fund?

Use both, for different purposes. CAGR (specifically, rolling CAGR across multiple periods) tells you how the fund performs as an investment vehicle — its consistency, benchmark outperformance, and manager skill over time. This is what you use to select or evaluate a fund for future investment. XIRR tells you how you personally performed in that fund — your actual return based on your investment timing. This is what you use to evaluate whether your strategy is working and to measure goal progress. Comparing your XIRR against the fund's benchmark CAGR for the same period is the most honest performance evaluation for a SIP investor.

What is a good XIRR for a mutual fund SIP in India?

Context matters significantly. For an equity SIP over 7–10 years in India: an XIRR of 12–15% is generally considered good for large-cap/index funds; 14–18% for mid-cap; 14–20% for small-cap. These ranges reflect India's historical equity returns and the benefit of rupee-cost averaging in volatile categories. For comparison, fixed deposits typically deliver 6–7% (pre-tax). The more important benchmark is: is your XIRR tracking above the return rate required to reach your specific financial goal by your specific deadline? That goal-adjusted view is more actionable than comparing to an absolute percentage target.

Can XIRR be negative for mutual fund investments?

Yes. XIRR can be negative if you invested primarily at market highs and the current NAV is still below your average purchase price. This can happen after significant market corrections or when you've invested in a fund category at the peak of a valuation cycle. A negative XIRR at any point-in-time is not cause for immediate alarm — equity investments are volatile on short time horizons. However, a negative XIRR after 5+ years in a diversified equity fund warrants review: either the fund itself is underperforming significantly, or your investment timing was systematically bad (e.g., large lump sums at peak markets), or your holding period has simply been too short for equity returns to smooth out.

Your Real Returns, Calculated Automatically

Stop Guessing. See Your Actual XIRR.

Calculating XIRR manually across a multi-year SIP portfolio with multiple funds requires exporting transaction histories, setting up an Excel model, and updating it every time you check. Most investors don't do this — and as a result, they have no idea whether they're actually on track.

FundSageAI computes XIRR per fund and across your complete portfolio automatically from your CAS statement. You also get: XIRR vs. benchmark comparison to see if active fund fees are justified, goal-progress tracking showing whether your current XIRR is sufficient to meet your target corpus, and rolling return analysis to identify funds with genuine consistency.

All from one CAS upload. No spreadsheets. No manual data entry.

Calculate My XIRR See How It Works

FundSageAI is an analytics platform. Content on this blog is for educational purposes only and does not constitute financial advice. Always consult a SEBI-registered investment advisor for personalised recommendations.