XIRR Calculates Annualised Returns on Staggered Investments

Extended internal rate of return (XIRR) calculates annualised returns on staggered investments by using the date of every cashflow. On two Rs 10,000 Nifty 50 contributions valued on 7 September 2026, the holding showed a 3.55% total loss but a 6.50% negative XIRR, reflecting the different time each contribution was invested.

Those two numbers describe the same money. The gap between them is why XIRR exists, and why a total-return figure on a portfolio built up over time is close to meaningless.

What does XIRR mean and how is it calculated?

XIRR means extended internal rate of return, the annual rate at which a series of dated cashflows discounts back to zero. “Extended” is the operative word: plain IRR assumes cashflows arrive at even intervals, while XIRR takes each cashflow with its own calendar date.

This makes XIRR usable for real investing, where money is invested whenever it becomes available. There is no closed-form expression: XIRR is the rate that makes the net present value of every dated cashflow sum to zero, so it is solved numerically rather than calculated in one step.

Every cashflow is discounted by the exact number of days between it and a reference date. A solver searches for the single rate that brings the schedule back into balance at zero, which is why XIRR exists as a spreadsheet function rather than something investors calculate by hand.

Why use XIRR instead of CAGR or IRR?

XIRR is needed because CAGR uses only a starting value, an ending value and a number of years, while XIRR uses the date of every contribution and withdrawal. Those three CAGR inputs describe one amount invested once, not an amount arriving in twelve instalments across a year through a SIP.

Putting a total-invested figure into a CAGR calculation treats the last instalment as though it had been invested from the start. That can flatter or punish the result depending on the market’s direction. The difference between CAGR and a plain total return is a separate issue.

The difference between XIRR and IRR is the dates. IRR assumes evenly spaced cashflows, while XIRR uses their actual calendar dates. On a monthly SIP paid on the same day each month, they converge closely. With an irregular lump sum, top-up or partial redemption, IRR misprices the timing in a way XIRR does not.

XIRR, IRR and simple return agree when there is one cashflow in, one cashflow out and a year between them. Add a second dated contribution and they separate. The wider the spread of dates and the more volatile the underlying index, the further apart they can move. NSE Indices has computed the Nifty 50 on free-float market capitalisation since 26 June 2009.

What does XIRR show for staggered Nifty 50 investing in 2026?

XIRR shows a materially different result from total return for the same money and dates when investments are staggered. Consider two Rs 10,000 contributions to the Nifty 50 at its actual levels, valued at the close on 7 September 2026.

Index levels: NSE, as of the dates shown. Arithmetic is reproducible from the three levels.

Total investment was Rs 20,000 and the holding was worth Rs 19,289.10 at the NSE close of 7 September 2026, for a simple return of 3.55% negative. XIRR was 6.50% negative.

The XIRR loss is larger because the second Rs 10,000 was invested for only a month. Averaging it with a contribution exposed for a full year understates how quickly the money lost ground.

A Rs 20,000 lump sum invested on 5 September 2025 and held until 7 September 2026 provides a third view of the same period. Over 367 days, it lost 3.89% in absolute terms, which annualises to an XIRR of 3.87% negative.

The 3.87% figure is the like-for-like comparison with the staggered 6.50% because both are annualised XIRRs. Comparing the staggered result with the lump sum’s 3.89% absolute loss would repeat the timing error. The difference between 3.87% and 6.50% is timing, with the same index, window and Rs 20,000 invested. Start and end-date sensitivity also affects comparisons such as the Nifty against the S&P 500 over ten years and where that decade is measured from.

Where can XIRR be calculated across stocks and funds?

XIRR can be calculated by any tool that stores every transaction and its date, but not by a tool that holds only current positions. The practical question is whether a tool keeps the dates or only balances: a broker statement showing current holdings cannot produce XIRR without the buy dates.

In India, tools fall into four capability classes based on the data they structurally have access to. This determines whether a single cross-asset XIRR is possible.

A classification by the data each class of tool structurally has access to, as at September 2026. It is not a ranking, a quality comparison or a recommendation, and it is not a statement that any named app reports an XIRR figure. Whether a given app exposes XIRR, and whether it spans equities and funds in one number, changes between releases. Confirm on the provider’s own current documentation.

The data-coverage column, not the brand, decides the cross-asset question. A broker knows only trades it executed and cannot see a fund folio held elsewhere; an aggregator using registrar feeds has the reverse blind spot. Two correct XIRRs from separate tools cannot be added because each is solved from a separate schedule of cashflows.

A single cross-asset XIRR requires one place that holds every dated transaction across both asset types. Spreadsheets are the fallback because they have no structural blind spot: XIRR(values, dates) in Excel or Google Sheets can solve any schedule entered by the investor, though it must be maintained by hand. Holdings are available in Multibagg’s portfolio section, with individual instruments on the stocks hub.

How should XIRR be judged against a benchmark and TWRR?

An XIRR is meaningful only against a benchmark measured over the same dates, and it differs from TWRR because it includes the investor’s cashflow timing. Asking whether a 15% XIRR is good cannot be answered by the number alone.

The Nifty 50 rose from its base value of 1,000 at the close of 3 November 1995 to 23,779.15 on 7 September 2026, a price-index CAGR of 10.82% over roughly 30 years. This is a historical record rather than a forecast, and it excludes dividends. Against that record, a long-run SIP XIRR in the low teens is broadly in line with the benchmark’s history, while a much higher figure over a short period usually reflects the window rather than the strategy.

The narrower comparison is what the same cashflows, on the same dates, would have earned in the benchmark. A SIP with an 11% XIRR underperformed if identical contributions to the Nifty 50 returned 13%; it would also have underperformed if it returned 20% while the index returned 25%.

Short periods exaggerate XIRR because they annualise small moves, explaining how the example produced a 6.50% negative XIRR on a 3.55% total loss. A running SIP can understate returns early because the newest instalments have barely been invested. XIRR is net of expenses and exit load only when the cashflows entered are the actual amounts that left and returned to the bank account.

XIRR is a money-weighted return, also called MWRR, whereas time-weighted return, or TWRR, is the other way to measure the same portfolio. A money-weighted return lets the amount and timing of each contribution affect the result, making XIRR a measure of what the investor’s money earned. A time-weighted return chains sub-period returns to remove contribution timing, making it a measure of what a fund manager achieved.

A scheme’s published return and an investor’s XIRR on that scheme can therefore differ without either being wrong. Published scheme performance is based on the scheme’s NAV between two dates and removes investor cashflow timing, allowing funds to be compared without investor deposit habits deciding the result.

What mistakes should investors avoid when using XIRR?

Investors should avoid reporting total return on a portfolio built up over time, using CAGR on instalments, comparing annualised and absolute returns, and ignoring the sign of a return. These errors account for most misread portfolio-return figures.

The worked example shows why the distinction matters: the same Rs 20,000 and the same index period produce different measures depending on whether the calculation accounts for cashflow dates. Annualised figures should be compared only with other annualised figures based on comparable periods.

• Reporting total return on a staggered portfolio: at the 7 September 2026 close, the Rs 20,000 example lost 3.55% in total and 6.50% on XIRR. Only the XIRR is comparable with another annualised return.
• Using CAGR on instalments: CAGR assumes one amount was invested for the full period, which a SIP is not.
• Comparing XIRR with an absolute return: the lump sum’s 3.89% loss was an absolute 367-day figure, while its 3.87% negative XIRR is the comparable figure beside the staggered 6.50% negative XIRR.
• Ignoring the sign: XIRR reports losses and gains on the same annualised scale, and a short holding period magnifies both.

Conclusion

XIRR is the suitable return measure when money enters or leaves a portfolio on different dates, because it annualises each cashflow according to the time it was invested. It cannot be replaced by a total return, CAGR or an IRR calculation that assumes regular intervals, and a cross-asset figure requires a complete transaction record across holdings.

The practical takeaway is to retain every purchase, redemption, dividend and valuation date, then compare the resulting XIRR with a benchmark calculated from the same cashflows and dates. Check whether any app’s current documentation confirms both XIRR availability and the data coverage needed for equities and funds.

Disclaimer: This article is for informational and educational purposes only and is not investment, financial, legal or tax advice. Multibagg AI does not recommend whether to buy, sell or hold any security. Figures are as of the dates stated and may change. Consult a SEBI-registered investment adviser before making any investment decision.