XIRR (Extended Internal Rate of Return)

XIRR stands for Extended Internal Rate of Return.

It is a method of calculating returns on investments where there are multiple cash flows (deposits and withdrawals) happening at irregular intervals. While CAGR is used for a single investment made at the beginning, XIRR is used when you invest at different points in time — as in a Systematic Investment Plan (SIP) in mutual funds. What is XIRR? XIRR solves the problem that CAGR cannot handle: multiple cash flows at different dates. When you invest ₹10,000 in a mutual fund SIP on the 5th of every month, and then redeem ₹1.5 lakhs after 3 years, the cash flows are spread over 36 months. XIRR calculates a single rate of return that makes the net present value of all these cash flows equal to zero. For example, if your SIP of ₹10,000 per month for 36 months (total ₹3.6 lakhs invested) grows to a redemption value of ₹5.2 lakhs, the XIRR would be approximately 17.8% per annum. This accounts for the fact that the first ₹10,000 was invested 36 months ago and earned returns for 36 months, while the last ₹10,000 was invested just one month ago and earned returns for only 1 month. In India, XIRR is the most accurate way to measure SIP returns because it treats each SIP installment as a separate investment made on a different date, with its own holding period. This is particularly important because the market conditions at the time of each investment vary — buying at a market low vs a market peak gives very different outcomes, and XIRR captures this nuance. Most mutual fund apps and financial planning tools automatically calculate XIRR for SIP investments. When manually calculating, Excel's XIRR function or Google Sheets' XIRR function is used, with the syntax requiring the cash flow amounts (negative for investments, positive for redemptions) and their corresponding dates. XIRR is especially powerful for comparing a SIP to a lump sum investment or to other investment options. For instance, investing ₹5 lakhs as a lump sum at the beginning of a 5-year period might give a CAGR of 14%. But investing the same ₹5 lakhs in 60 monthly SIPs of ₹8,333 might give an XIRR of 16.5% if you invested during market corrections — the cost-averaging effect of SIPs working in your favour. XIRR accounts for this timing benefit accurately.