XIRR
XIRR (Extended Internal Rate of Return) is a financial function that calculates the annualised rate of return for a series of cash flows — investments and redemptions — occurring at irregular time intervals, making it the correct metric for measuring the actual return earned by a mutual fund investor through SIPs, STPs, or partial withdrawals.
The standard CAGR (Compounded Annual Growth Rate) metric assumes a single lumpsum investment at the start and a single redemption at the end. This is inadequate for systematic investors who make multiple contributions at different points in time — which is the dominant mode of investing in Indian mutual funds, with over 10 crore active SIP accounts as of 2024. For these investors, XIRR provides the answer to: 'Given all the money I put in on various dates and what I received (or currently have) on exit, what was my effective annual return?'
XIRR is computed iteratively. It finds the discount rate at which the net present value (NPV) of all cash flows — both outflows (investments, which are negative in sign) and inflows (redemptions or current portfolio value, which are positive) — equals zero. This rate is expressed as an annualised percentage. The XIRR function is available natively in Microsoft Excel, Google Sheets, and most financial calculators, making it accessible to retail investors.
In practice, XIRR computation requires two inputs: a series of cash flows (investment amounts as negative numbers and redemption amounts as positive numbers) and the corresponding dates of each cash flow. For example, an investor who invested Rs 5,000 monthly via SIP for 36 months and redeemed the full corpus after 36 months would have 36 negative cash flows and one positive cash flow. The XIRR of this series represents the true return earned, which may differ from the fund's trailing 3-year CAGR because the money was deployed over time rather than as a single lumpsum at the start.
A critical nuance: a fund's quoted NAV-based CAGR and the investor's actual XIRR on a SIP in the same fund for the same period will typically differ. If the fund rose sharply in the early period and was flat later, the XIRR of the SIP (which deployed money through the expensive phase) may be lower than the fund's stated CAGR. Conversely, if markets fell initially and rose sharply later, the SIP investor's XIRR benefits from rupee cost averaging and may exceed the fund's stated CAGR.
AMFI and SEBI do not mandate AMCs to disclose XIRR for their schemes, as it varies for every investor based on their specific cashflow dates. However, mutual fund platforms — Zerodha Coin, Groww, Kuvera, INDmoney, MF Utilities — typically display the investor's portfolio XIRR, allowing investors to see their personal rate of return across all investments.
For goal planning, XIRR is the correct metric to use when projecting future corpus from a SIP. Financial planners in India use reverse XIRR calculations — given a target corpus and time horizon, what monthly SIP amount (at an assumed XIRR) is needed — to set investment targets. The SIP calculator tools available across financial websites use XIRR-based logic for these projections.