XIRR, in plain words: how mutual fund returns are worked out

If you invest on different dates, one simple percentage cannot describe your return fairly. XIRR is the usual answer. It is a yearly rate that takes the date of every rupee in and out into account.

Cash flows with dates

Think of your fund as a series of dated cash flows. Money you put in (a lump sum, a SIP instalment) counts as negative, because it left your pocket. Money you take out (a redemption, a payout) counts as positive. The current value of what you still hold counts as a positive flow on today's date, as if you cashed in.

XIRR is the single yearly rate that, applied to every flow from its own date, makes them all add up to zero:

sum of CF_i / (1 + r)^((d_i - d_0) / 365) = 0

Here CF_i is each cash flow, d_i its date, d_0 the date of the first flow, and r the XIRR. There is no formula that gives r directly. A computer finds it by trial, narrowing in until the sum is zero. That is why spreadsheets call the function XIRR, with the X for “extended”, meaning irregular dates.

XIRR, absolute return and CAGR

MeasureWhat it doesWhere it falls short
Absolute return(Value minus invested) divided by invested.Ignores time. 20% over one year and 20% over ten years look the same.
CAGRThe yearly rate from one starting amount to one ending amount.Needs a single investment on a single date. A SIP has many.
XIRRA yearly rate using every dated flow.Needs the full history, and the date of each flow to be right.

For a one-time investment held with no other flows, XIRR and CAGR give the same number. They differ when money goes in or out at different times.

A worked example

This is an invented example with round numbers, to show the idea. It is not a real fund and not a forecast.

Suppose someone invests ₹10,000 on 01-Jan-2021, another ₹10,000 on 01-Jan-2022 and another ₹10,000 on 01-Jan-2023 (to keep it simple, one instalment a year). On 01-Jan-2024 the holding is worth ₹36,410.

DateCash flow
01-Jan-2021−₹10,000
01-Jan-2022−₹10,000
01-Jan-2023−₹10,000
01-Jan-2024+₹36,410 (value of the holding)
  • Absolute return: invested ₹30,000, now worth ₹36,410. Gain ₹6,410, which is about 21.4%. It says nothing about how long that took.
  • CAGR on ₹30,000 over 3 years: about 6.7% a year. This is too low, because it treats all ₹30,000 as if it had been invested on day one. The last ₹10,000 was invested for only one year.
  • XIRR: 10.0% a year. Check: ₹10,000 growing at 10% for 3, 2 and 1 years gives ₹13,310 + ₹12,100 + ₹11,000 = ₹36,410.

Each instalment has been invested for a different length of time, and XIRR gives each its own.

How Sachfolio shows it

Sachfolio builds the cash flows from the transactions in your detailed statement, adds the current value as the closing flow, and solves for the rate, with exact arithmetic, on your device. It shows an XIRR for each scheme and for the whole portfolio, with the list of what was included and what was left out.

  • Switches between your own schemes are matched as transfers, so they are not counted as money in or out of the portfolio.
  • Where the history is shorter than a year, the figure is still shown as a yearly rate, with a note saying so. A short stretch scaled up to a year can look very large or very small, so read it with that note.
  • If the statement does not start at your first investment, or a scheme has too few flows to solve, Sachfolio says so rather than showing a number.

What XIRR is not

XIRR is a measure of past returns, worked out from your own dated flows. It is not a forecast, and it does not say what a fund will return in future. It also does not account for tax you may owe on redemptions. Past performance is not an indicator of future returns.

Questions

Why is my XIRR different from the return shown on the fund's page?

A fund's published return follows one lump sum over a period. Your XIRR follows your own investment dates and amounts, so it can differ widely.

Can XIRR be negative?

Yes. If what you hold is worth less than the dated amounts you put in, the rate is below zero.

Does XIRR include dividends?

Money paid out to you counts as a positive cash flow on its date, so a payout is included. A reinvested dividend (IDCW reinvestment) isn't new money from you, so it isn't counted as money in; its value shows up in the units you hold.

Why does a short period give a very high or low XIRR?

The rate is expressed per year. Scaling a few weeks of movement to a year exaggerates it, which is why Sachfolio adds a note.

See the cash flows behind your own XIRR

Sachfolio lists what was included, with the page where each flow was printed.