What is Extended Internal Rate of Return (XIRR)?
Extended Internal Rate of Return (XIRR) is a mathematical methodology used to calculate the annualized return rate for a series of irregular cash flows occurring at arbitrary intervals.
It is the industry-standard metric for measuring returns on mutual fund SIPs, portfolio assets, and complex transactional investments.
How it Works
Unlike CAGR (which assumes a single start and end date), XIRR accounts for multiple transactions.
Each SIP installment, dividend payout, or partial redemption represents a cash flow. XIRR models all of these transactions at their specific dates and solves for a single annualized return rate.
XIRR Solver Formula
XIRR is solved numerically by finding the discount rate r that sets the Net Present Value (NPV) of all cash flows to zero:
Official Calculation Formula
Where:
- CF_j is the cash flow amount of transaction j
- d_j is the date of transaction j
- d_1 is the initial investment date
- r is the annualized internal rate of return (XIRR)
Worked Example
Consider an initial outflow of ₹1,00,000 at Year 0, followed by inflows of ₹20,000 (Yr 1), ₹30,000 (Yr 2), ₹40,000 (Yr 3), and a final redemption of ₹50,000 (Yr 4).
- Total Outflow: ₹1,00,000
- Total Inflows: ₹1,40,000
- Net Profit: ₹40,000
- Annualized XIRR Return: 12.83%
Advantages & Limitations
Advantages
- Irregular Cash Flows: Perfect for evaluating SIPs, STPs, and arbitrary stock transactions.
- Accuracy: Resolves exact annualized return percentages based on transactional timing.
Limitations
- Mathematical Solver Required: Cannot be computed using simple algebraic formulas (requires iterative numerical solvers).
- Multiple Roots: In rare cases with highly volatile positive/negative flips, the equation can have multiple mathematical roots.
Tax Implications
XIRR is a metric of return rate and has no direct tax implications. However, redemptions that comprise cash inflows are subject to capital gains tax as per standard mutual fund rules.
Best Use Cases & Common Mistakes
Best Use Cases
- Reviewing mutual fund portfolio performance via CAS (Common Account Statement).
- Calculating returns on investments with irregular dividend payouts.
Common Mistakes
- Treating cash inflows as outflows (all outflows/investments must be entered as negative numbers in standard tools).
- Comparing XIRR directly with simple absolute returns.
FAQs
When should I use XIRR instead of CAGR?
Use XIRR when you make multiple transactions (SIP, partial withdrawals). Use CAGR when you have a single one-time lumpsum investment with no intermediate transactions.
What is a good XIRR for mutual funds?
An XIRR of 12% P.A. or higher over the long term (5+ years) is generally considered very good for equity mutual fund portfolios.