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.
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
| Date | Amount | What it was |
|---|---|---|
| 10 April 2023 | −₹50,000 | First investment |
| 12 October 2023 | −₹25,000 | Top-up |
| 5 June 2024 | −₹25,000 | Top-up |
| 20 March 2025 | ₹10,000 | Part withdrawal |
| 2 November 2026 | ₹1,30,000 | Value 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.
A tax professional can call you back. Asking is free.
Get helpMore 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.