XIRR Calculator
Calculate the annualised return (XIRR) on investments with irregular cashflows. Add multiple investments and redemptions with their exact dates.
Cashflows
Enter negative amounts for investments (outflows) and positive amounts for redemptions or current value (inflows). For a holding not yet sold, the last entry is its current value with today's date.
Your XIRR
23.78%
Annualised return on your cashflows
Total Invested
₹1,20,000
Total Received
₹1,35,000
Net Profit/Loss
+₹15,000
Benchmark Comparison
What Is XIRR and How Is It Used for SIP Returns?
XIRR stands for extended internal rate of return. It measures the annualised return on investments with cashflows on irregular dates. Simple return and CAGR suit a single lumpsum; most portfolios have several transactions on different dates: monthly SIPs, occasional top-ups, partial withdrawals and final redemptions. XIRR takes all of these and gives one annualised figure.
Technically, XIRR is the rate at which the present value of all cashflows, money paid in (investments) and money received (redemptions and the current value), adds up to zero. This calculator finds it with the Newton-Raphson method, an iterative method that refines an estimate step by step. Because it uses the date of every cashflow, not only the amount, it handles irregular investment patterns that CAGR cannot.
Why CAGR Does Not Fit SIPs
CAGR (compound annual growth rate) applies to one investment made on one date and measured on another, with nothing added or taken out in between. Rs 1 lakh that becomes Rs 2 lakh in 5 years has a CAGR of 14.87%. If Rs 1 lakh was invested, Rs 50,000 added after 2 years and Rs 30,000 withdrawn after 4 years, CAGR cannot express the return; XIRR can.
In a SIP, each monthly instalment is invested for a different length of time: the first for the longest, the last for perhaps a month. XIRR weights each cashflow by its time in the investment and gives one annualised return across all of them.
A fund factsheet may show a 5-year CAGR of 15% while an investor's own XIRR in the same fund is 9%. Both can be accurate: the CAGR describes a lumpsum held for the whole period, and the XIRR describes the investor's own dates and amounts.
How to Calculate XIRR: The Mathematics
Each transaction needs an amount and a date. Money paid in is entered as a negative amount, and money received, including the current value, as a positive amount. For a holding not yet sold, the last entry is its current market value with today's date, as if it were redeemed today.
The calculator finds the rate r that satisfies: sum of [cashflow_i / (1 + r)^(t_i)] = 0, where t_i is the number of days from the first cashflow divided by 365, the same day count as the XIRR function in spreadsheets. It stops when successive estimates differ by less than 0.000001%, within at most 200 steps.
XIRR vs IRR
IRR (internal rate of return) assumes cashflows at equal intervals: monthly, quarterly or yearly. XIRR works with any dates, which is why it is called “extended”. For a SIP with equal monthly instalments and no gaps or extra transactions, IRR and XIRR give nearly the same result.
When an instalment is missed, an extra lumpsum is added, a partial withdrawal is made or a step-up changes the amount, the cashflows are no longer regular. XIRR still measures the return correctly in these cases; an IRR that assumes equal intervals does not.
Interpreting XIRR
A positive XIRR means the money received and the current value are worth more than the money invested, after allowing for timing; it is a nominal return, before inflation. There is no standard XIRR for a fund category: it depends on the fund, the market over the period and the investor's own cashflows, and past results do not set future ones.
A fair comparison uses the same dates and cashflows: for example, the XIRR of the same SIP in an index fund or the fund's benchmark over the same period. Comparing an XIRR with a figure for a different period or cashflow pattern can mislead.
Over short periods, annualising can give large numbers. A 5% gain in 3 months annualises to about 21.6%, and a short-term loss to a large negative figure. Neither says much about what a longer period would show.
XIRR for Property and Other Investments
XIRR works for any investment with dated cashflows: property (purchase, rent, maintenance, sale), shares bought on several dates with dividends received, portfolio management services, and deposits with partial withdrawals.
For property, enter the purchase price and costs such as stamp duty, brokerage and renovation as negative cashflows; rent received as positive cashflows on the dates received; maintenance and property tax as negative cashflows when paid; and the sale proceeds or current value as the final positive cashflow. The XIRR then reflects both the change in value and the rent, with the timing of each.
Getting the Inputs Right
Transaction dates and amounts are in the Consolidated Account Statement or the broker's transaction history. XIRR depends on dates as well as amounts, so exact dates give a more accurate result than approximate ones.
For the current value, use the value at the latest declared NAV on the date of the calculation. Running the calculation again later, with the new cashflows and value, shows how the annualised return has changed.
Frequently Asked Questions
Related Calculators
Explore other tools on related topics — each one is free to use and built for Indian financial contexts.