Skip to content
MutualFundAdvisor.in logo markMutualFundAdvisor.in
Choosing & Comparing Mutual Funds · Intermediate · 5 min read

What Is XIRR and Why Does It Matter for SIP Investors?

The short answer

XIRR — Extended Internal Rate of Return — is the annualised return of a series of cash flows that occurred on different dates. It is the correct measure for a SIP or any real portfolio, because each instalment has been invested for a different length of time and there is no single start date for CAGR to measure from. XIRR finds the one annual rate that makes every dated inflow and outflow consistent with the portfolio's current value.

Written and reviewed by Amit Chadha, Mutual Fund Distributor at MutualFundAdvisor.in · AMFI ARN: 349461. Last reviewed .
This article is investor education only. It is not investment advice, a scheme recommendation or an assurance of returns.

If you have ever compared your own SIP return with the return printed on a fund's factsheet and concluded something was wrong, XIRR is the concept that resolves it.

Nothing was wrong. The two numbers were answering different questions.

Why CAGR breaks for a SIP

CAGR answers: at what constant annual rate would one amount have had to grow to get from a starting value to an ending value over a given period? It needs exactly one start date and one end date.

A SIP has neither. Your first instalment may have been invested for five years, your most recent for one month. Treating the total invested as though it all went in on day one badly overstates the time your money was actually working, and produces a return figure that is simply wrong.

What XIRR does instead

XIRR takes every cash flow with its actual date — each purchase as a negative flow, each redemption as a positive one, and the current portfolio value as a final positive flow — and solves for the single annualised rate that makes their present values net to zero.

In effect, it gives every rupee credit for exactly as long as it was invested, no more and no less. That is why it is the right figure for a real portfolio, which almost never consists of one investment made once.

What the number means once you have it

An XIRR of 11% means your actual dated cash flows are consistent with an 11% annualised return. It is a money-weighted figure: amounts invested when you invested more carry more influence on the result.

That is exactly what you want for judging your own outcome, and exactly what you do not want for judging a fund manager — because the timing of your contributions was your decision, not theirs.

Why your XIRR differs from the fund's reported return

A fund's published return is time-weighted: it assumes one investment at the start of the period, held untouched to the end, and deliberately strips out the effect of money moving in and out so that manager performance can be compared fairly.

Your XIRR is money-weighted, and depends on your dates. If you invested more after a strong run and less after a fall, your XIRR will lag the fund's figure — not because the fund misreported, but because your money arrived at less favourable moments. Comparing the two tells you something useful about your own behaviour.

Reading it honestly

XIRR over a short period can look extreme in either direction, because annualising a few months of movement projects it onto a full year. A 4% gain over two months annualises to a number that means very little.

It is also entirely historical. A high XIRR tells you what your past cash flows produced under past market conditions; it carries no information about what the next period will do.

Key takeaways

  • XIRR annualises a series of cash flows that happened on different dates.
  • CAGR needs a single start and end date, which a SIP does not have.
  • XIRR is money-weighted — it reflects your timing as well as the fund's performance.
  • A fund's published return is time-weighted and assumes one investment held throughout.
  • A gap between the two is normal and usually reflects when you invested.
  • XIRR over short periods can be misleading, and is always historical.

Put this to work on your own numbers

  • XIRR Calculator

    Enter your own dated transactions and get your actual annualised return.

  • CAGR Calculator

    For a single lump sum with one start and one end date, CAGR is the right tool.

For illustration only. Not investment advice. Mutual fund investments are subject to market risks; read all scheme related documents carefully. Returns assumed are hypothetical and not guaranteed.

Frequently asked questions

Sources and editorial review

Checked against the primary sources below on . Scheme terms, tax rules and regulatory requirements change — confirm the current position before acting on anything here.

What to read next

Mutual Fund BasicsHow Mutual Fund Returns Actually WorkAbsolute vs annualised returns, CAGR vs XIRR, point-to-point vs rolling returns, and why the return a fund reports is often not the return an investor experienced.Common Investor MistakesHow to Review an Existing Mutual Fund PortfolioA structured review that starts with what you own and why, checks allocation drift, overlap, cost and your actual XIRR — and separates a fund that is underperforming from one that is simply out of favour.SIP & Systematic InvestingWhat Is SIP (Systematic Investment Plan) and How Does It Work?A plain-language guide to what a SIP is, how instalments turn into units, what rupee-cost averaging does, and what a SIP does not guarantee.

Want to talk this through with a person?

Amit Chadha is a Mutual Fund Distributor (ARN: 349461). The first conversation is free and educational.

Risk Factors – Investments in Mutual Funds are subject to Market Risks. Read all scheme-related documents carefully before investing. Mutual Fund Schemes do not assure or guarantee any returns. Past performance of any Mutual Fund Scheme may or may not be sustained in the future. There is no guarantee that the investment objective of any suggested scheme will be achieved. All existing and prospective investors are advised to check and evaluate the exit loads and other cost structure (TER) applicable at the time of making an investment before finalizing any investment decision for Mutual Fund Schemes. We deal in Regular Plans only for Mutual Fund Schemes and earn a trailing commission on client investments. Disclosure of commission earnings is made to clients at the time of investment. The option of a Direct Plan for every Mutual Fund Scheme is available to investors and offers the advantage of a lower expense ratio. We are not entitled to earn any commission on Direct Plans; hence, we do not deal in Direct Plans.