XIRR calculator

XIRR is the yearly return on money that went in and came out on different dates. It is what mutual fund statements show for SIPs, and what Excel and Google Sheets calculate with the XIRR function. Enter each amount with its date: money in as negative, money out and today's value as positive.

DateAmount (₹)
Money you put in is negative (−50000). Money you take out, and today's value, are positive.
XIRR (yearly return)
11.71%
Total put in₹1,00,000 (1.00 lakh)
Total taken out or value now₹1,40,000 (1.40 lakh)
Gain or loss₹40,000

How XIRR is worked out

XIRR is the rate r that makes the present value of all cash flows zero: the sum of each amount ÷ (1 + r)^(days since the first date ÷ 365) equals 0. There is no direct formula, so the calculator searches for r: it starts from a guess and improves it with Newton's method, and if that does not settle it narrows the answer down by halving the range.

Worked example

DateAmountWhat it was
10 April 2023−₹50,000First investment
12 October 2023−₹25,000Top-up
5 June 2024−₹25,000Top-up
20 March 2025₹10,000Part withdrawal
2 November 2026₹1,30,000Value of the holding

₹1,00,000 went in and ₹1,40,000 came back or is held, a gain of ₹40,000. Because the money went in at different times, the XIRR is 11.71% a year.

More stock market tools

Questions people ask

What is the difference between XIRR and CAGR?

CAGR suits one amount invested once and valued later. XIRR handles many amounts on many dates, such as a SIP. For a single investment and a single value, the two give the same answer. See the CAGR calculator.

How do I use this for a SIP?

Add one negative row for each instalment with its date, then one positive row with today's value of the holding and today's date.

Why does XIRR look very high for short periods?

XIRR is a yearly rate. A 5% gain in one month works out to about 80% a year if it carried on at that pace, which it rarely does. For holdings under a year, look at the actual gain too.

Will this match Excel?

Yes. It uses the same day count as Excel's XIRR (actual days ÷ 365). Microsoft's own example (−10,000 on 1 January 2008, then 2,750, 4,250, 3,250 and 2,750 on 1 March 2008, 30 October 2008, 15 February 2009 and 1 April 2009) gives 37.34% here, the same as Excel.

Need help with tax, GST or your accounts?

A tax professional can call you back. Asking is free.

Get help

More calculators

Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.