Skip to main content

What Is XIRR in Mutual Funds?

XIRR explained simply: why it is the correct way to measure SIP returns, how it differs from absolute return and CAGR, and how to calculate XIRR for your portfolio.

Intermediate8 min readUpdated
By Kousigan A · Learn. Share. Grow together.

XIRR, or extended internal rate of return, is the annualised return on money invested at different dates, such as SIP instalments. It weights each rupee by how long it was invested, so it's the right measure for SIP returns. A simple total-return figure misleads because it ignores when each instalment went in.

You'll see it labelled "XIRR" in your mutual fund app, usually next to a different "absolute return" number. Understanding the gap tells you what your money is truly earning.

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

Comparison table: Metric, What It Measures, When to Use
MetricWhat It MeasuresWhen to Use
Absolute ReturnTotal % gain, ignoring timeQuick snapshot of total profit
CAGRAnnualised return for a single lump-sum over a periodLumpsum investments held for a fixed period
XIRRAnnualised return accounting for multiple dated cash flowsSIPs, 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:

  1. 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.
  2. Find the single annual rate r such that the sum of all cash flows, each discounted to present value at rate r, equals zero.
  3. 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

Comparison table: Platform, Where XIRR Appears
PlatformWhere XIRR Appears
Zerodha ConsoleHoldings → returns column shows XIRR
GrowwPortfolio → fund detail → returns (XIRR)
MF Central / CASConsolidated 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 and 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

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

Frequently asked questions

What is XIRR in mutual funds?

XIRR (Extended Internal Rate of Return) is the annualised return of an investment that has multiple cash flows on different dates, exactly the case with SIPs, where each instalment enters on a different day and compounds for a different duration. XIRR gives one single annual percentage that correctly accounts for the timing of every investment, making it the most accurate measure of your true SIP return.

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. But 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.

Try Our Free Tools

Put what you’ve learned into action with our calculators and courses.

Continue Learning

This guide is part of our Mutual Funds course. Start with the related chapter:

Understanding Returns - XIRR, CAGR, Absolute

Related guides