Skip to main content
Blog home
Newsletter
News
Video
Podcast
Reading list
Wright Brief
Sign In

What is XIRR?

A plain-language explanation of XIRR, with a worked example, common pitfalls and the questions people ask most.

Listen to this article
Audio · ~2 min
Add as a preferred source on Google

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

DateCash 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

MeasureWhat it reflectsBest for
XIRRThe return you earned, including the timing of your own deposits and withdrawalsYour personal return on SIPs and top-ups
CAGRGrowth between two values, with no cash flows in betweenA lump sum left alone
Time-weighted returnThe strategy's return, with the effect of cash flows removedJudging 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.

Further reading

  1. Microsoft. XIRR function (Excel documentation).
Browse the full Quant Glossary →

Disclaimer: Investment in securities market are subject to market risks. Read all the related documents carefully before investing. Registration granted by SEBI, membership of a SEBI recognized supervisory body (if any) and certification from NISM in no way guarantee performance of the intermediary or provide any assurance of returns to investors.

The content in these posts/articles is for informational and educational purposes only and should not be construed as professional financial advice and nor to be construed as an offer to buy/sell or the solicitation of an offer to buy/sell any security or financial products. Users must make their own investment decisions based on their specific investment objective and financial position and using such independent advisors as they believe necessary.

Wryght Research & Capital Pvt (Brand name: Wright Research) is a SEBI Registered Portfolio Manager Reg No: INP000007979 (Validity: Apr 03, 2023 – Perpetual) and a SEBI Registered Research Analyst No: INH000017295 (Validity: Jul 03, 2024 – Perpetual), with its registered office at 103, Shagun Vatika Prag Narayan Road, Lucknow, UP, 226001 India and CIN: U67100UP2019PTC123244. Past performance may or may not be sustained in future. Performance provided there in is not verified by SEBI. Investment in securities is subject to market and other risks, and there is no assurance or guarantee that the objectives of any of the strategies of the Portfolio Management Services will be achieved. Registration granted by SEBI, enlistment as RA with Exchange and certification from National Institute of Securities Markets (NISM) in no way guarantee performance of the intermediary or provide any assurance of returns to investors. Please read the Disclosure document carefully before investing. Securities quoted are for illustration only and are not recommendatory. Charts shown are for illustration only. For more information and disclosures, visit our disclosures page here.

Found this useful? Share it.
Wright PMS · Portfolio Management Service

Put this research to work

The same 300+ factor research engine behind this article — applied to a professionally managed portfolio, end to end.

300+
Factors tracked
2L+
Investors
₹1,200+ Cr
Invested
SEBI
Registered PMS