XIRR is the annualised rate of return that equates the money put in and taken out of an investment, on the actual dates of each cash flow. It is the standard way to measure returns on SIPs, top-ups and withdrawals.
How it works
XIRR finds the rate r that makes the present value of all cash flows equal zero: the sum of CFi / (1 + r)(daysi / 365) = 0. Money invested counts as negative and money received, including the final value of the portfolio, as positive. There is no simple formula, so spreadsheets and software solve it by trial.
An illustrative example
| Date | Cash flow |
|---|---|
| 1 Jan 2023 | -Rs 1,00,000 (invested) |
| 1 Jul 2023 | -Rs 50,000 (added) |
| 31 Dec 2023 | +Rs 1,80,000 (portfolio value) |
Total invested is Rs 1,50,000 and the final value is Rs 1,80,000, a gain of Rs 30,000. Because Rs 1,00,000 was invested for the full year but Rs 50,000 for only half of it, the money worked on average capital of about Rs 1,25,000, and the XIRR works out to about 24.3% a year. The figures are illustrative.
XIRR compared with other measures
| Measure | What it reflects | Best for |
|---|---|---|
| XIRR | The return you earned, including the timing of your own deposits and withdrawals | Your personal return on SIPs and top-ups |
| CAGR | Growth between two values, with no cash flows in between | A lump sum left alone |
| Time-weighted return | The strategy's return, with the effect of cash flows removed | Judging the manager or strategy |
Cautions
- Timing affects it. Two investors in the same strategy can have different XIRRs because they added money on different dates.
- Short periods mislead. Annualising a gain from a few weeks can produce a very large number that will not be repeated.
- Signs and dates must be right. Mixing up inflows and outflows is the commonest cause of wrong results.
Frequently asked questions
What is XIRR?
It is the annualised return on an investment with cash flows on irregular dates, calculated so that the dated deposits, withdrawals and final value balance at that rate.
What is the difference between XIRR and CAGR?
CAGR assumes a single investment and a single final value. XIRR handles several dated cash flows, so it suits SIPs and top-ups.
Why is my XIRR different from the fund's return?
A fund's published return is time-weighted and ignores when you invested. Your XIRR depends on the dates and size of your own cash flows.
Can XIRR be misleading?
Yes. Over a short period it can annualise a small gain into a very large figure, and it reflects the timing of your own flows as well as the investment's performance.