What is the difference between XIRR and CAGR?

CAGR measures the annualised return of a single lump-sum investment over a period. XIRR measures the annualised return when there are multiple investments (and possibly withdrawals) on different dates. For a one-time investment, use CAGR; for SIPs or any series of dated cash flows, use XIRR. XIRR is essentially CAGR generalised to handle irregular, multiple cash flows.

Is a higher XIRR better?

Yes — a higher XIRR means a higher annualised return on your invested money, accounting for timing. For equity funds, a long-term XIRR of 12% or more is generally good. However, always compare XIRR over the same time period and against the fund's benchmark; a high XIRR over a short bull-market window is less meaningful than a steady XIRR over 5+ years across different market conditions.

How do I calculate XIRR?

The easiest way is a spreadsheet: list every SIP instalment as a negative amount with its date, add today's portfolio value as a positive amount with today's date, then use the formula =XIRR(values, dates). Most broker apps and your Consolidated Account Statement (CAS) also show XIRR automatically. The spreadsheet method gives you full control and the most precise figure.

What Is XIRR in Mutual Funds?

When you check your mutual fund returns, you'll often see a number labelled "XIRR" — and it's usually different from the simple "absolute return" figure. XIRR is the most accurate way to measure your actual return when you've invested at multiple points in time (like a SIP). Understanding it tells you what your money is truly earning, accounting for the timing of every investment.

Short answer

XIRR (Extended Internal Rate of Return) is the annualised return of an investment that accounts for multiple cash flows at irregular dates. For SIPs — where you invest different amounts on different dates — XIRR is the correct measure of return. A simple "total return %" overstates or understates your real performance because it ignores when each rupee was invested.

Why Simple Returns Mislead for SIPs

Imagine a SIP where you invest ₹10,000/month for 12 months. By year-end you've invested ₹1,20,000 and it's worth ₹1,30,000. A naive calculation says "8.3% return." But that's wrong — because your first installment was invested for 12 months while your last installment was invested for only 1 month.

XIRR (Extended Internal Rate of Return):

XIRR is the single annualised rate of return that makes the present value of all your investments (outflows) equal to the present value of your current corpus (inflow), accounting for the exact date of each cash flow. It effectively answers: "What annual interest rate, applied to each investment from its own date, would produce my current value?"

Because each SIP installment has been invested for a different length of time, you cannot simply divide total gain by total investment. XIRR handles this by weighting each cash flow by its duration.

Absolute Return vs CAGR vs XIRR

Metric	What It Measures	When to Use
Absolute Return	Total % gain, ignoring time	Quick snapshot of total profit
CAGR	Annualised return for a single lump-sum over a period	Lumpsum investments held for a fixed period
XIRR	Annualised return accounting for multiple dated cash flows	SIPs, additional purchases, partial withdrawals

Rule of thumb:

One-time lumpsum, held for N years → use CAGR
Regular SIP or multiple investments at different dates → use XIRR

A Worked Example

Why XIRR ≠ absolute return

Deepa invests ₹10,000/month for 12 months in an equity fund. Total invested: ₹1,20,000. Year-end value: ₹1,32,000.

Absolute return: (₹1,32,000 − ₹1,20,000) ÷ ₹1,20,000 = 10%

But this 10% was earned in just one year on money that, on average, was invested for only ~6.5 months (the first installment for 12 months, the last for 1 month).

XIRR: ~18–19% annualised.

The XIRR is much higher than the absolute return because most of the money was invested for less than a full year. XIRR tells Deepa her fund is actually delivering ~18% annualised — far more useful than the misleading 10% absolute figure.

This is the key insight: for SIPs, XIRR is usually higher than the absolute return in a rising market, because your money was invested for shorter average durations than the full period.

How XIRR Is Calculated (Conceptually)

You don't need to compute XIRR by hand — your platform does it. But conceptually:

List every cash flow with its date: each SIP installment as a negative (outflow), and the current value as a positive (inflow) on today's date.
Find the single annual rate r such that the sum of all cash flows, each discounted to present value at rate r, equals zero.
That r is your XIRR.

In Excel or Google Sheets, the XIRR(values, dates) function does exactly this. Most fund platforms (Zerodha Console, Groww, MF Central) show XIRR automatically in your portfolio.

Where to Find Your XIRR

Platform	Where XIRR Appears
Zerodha Console	Holdings → returns column shows XIRR
Groww	Portfolio → fund detail → returns (XIRR)
MF Central / CAS	Consolidated Account Statement returns
Excel / Google Sheets	=XIRR(amounts_range, dates_range)

What's a "Good" XIRR?

There's no universal answer, but context helps:

Equity funds (long term): 11–15% XIRR is a healthy long-term result, roughly matching or beating the Nifty 50
Debt funds: 6–8% XIRR is typical
Below the benchmark: If your equity fund's XIRR consistently trails its benchmark index over 5+ years, consider switching to an index fund

Don't over-react to short-term XIRR

XIRR over short periods (under 3 years) can look extreme — very high in a bull run, negative in a correction — because it annualises recent moves. A -25% XIRR after six months of investing doesn't mean a bad fund; it reflects a recent market dip annualised. Judge equity fund XIRR over 5+ year periods for meaningful conclusions.

Key Takeaways

XIRR is the accurate annualised return for investments made at multiple dates, like SIPs
Simple "absolute return" misleads for SIPs because it ignores how long each installment was invested
Use CAGR for lumpsum; use XIRR for SIPs and multi-date investments
For SIPs in a rising market, XIRR is usually higher than the absolute return
Platforms (Zerodha Console, Groww, MF Central) and Excel's XIRR() function compute it automatically
Judge equity fund XIRR over 5+ years; short-term XIRR can look misleadingly extreme

Use the SIP Calculator to project returns, and read How to Check Mutual Fund Returns to track your actual XIRR over time.

Quick Quiz

You invest ₹5,000/month via SIP for 1 year (₹60,000 total). Year-end value is ₹66,000. Your absolute return is 10%. Will your XIRR be higher or lower than 10%, and why?

Sources

AMFI India. Return calculation methodology, XIRR vs absolute return guidance; amfiindia.com
SEBI Mutual Fund Disclosure Norms. Standardised return reporting requirements for fund factsheets
Microsoft / Google Sheets Documentation. XIRR() function specification for irregular cash flow returns
Zerodha Varsity. Educational material on XIRR and SIP return measurement