What is XIRR (Extended Internal Rate of Return)?
Extended Internal Rate of Return (XIRR) is the standard financial metric used to calculate the annualized rate of return for investments with multiple, irregular cash flows occurring at non-uniform time intervals.
While simple metrics like Absolute Return or CAGR (Compound Annual Growth Rate) work well for a single point-to-point investment (e.g. buying a bond on Day 1 and selling it 5 years later), real-world mutual fund SIPs, dividend reinvestments, step-up contributions, and partial redemptions involve complex cash flow schedules. XIRR normalizes all cash inflows and outflows to compute your true annual compounding rate.
How XIRR Works: Mathematical Formula & Newton-Raphson Iteration
XIRR calculates the discount rate \(r\) that equates the Net Present Value (NPV) of all series cash flows (\(C_i\)) occurring on dates (\(d_i\)) to zero:
Where:
- Ci = Cash flow amount at transaction \(i\) (negative for investment purchases, positive for redemptions/current value).
- di = Transaction date for cash flow \(i\).
- d0 = Initial baseline investment date.
- r = The XIRR rate being solved.
Because \(r\) cannot be isolated directly using algebraic rearrangement, financial calculators (including Pocketsense and Microsoft Excel) employ the Newton-Raphson numerical optimization algorithm to iteratively converge on the precise rate within milliseconds.
XIRR vs. CAGR vs. Absolute Return: Key Differences
| Metric | Cash Flow Structure | Time Sensitivity | Best Used For |
|---|---|---|---|
| Absolute Return | Single inflow/outflow | Ignores holding period duration | Ultra short-term holdings (< 1 year) |
| CAGR | Single initial investment & single exit | Considers exact start and end years | Lumpsum investments (FDs, bonds, single buy-sell) |
| XIRR | Multiple irregular inflows & redemptions | Considers exact daily calendar timestamps | SIPs, SWPs, Mutual Fund portfolios, Stock trades |
Step-by-Step Worked Numerical Example
Suppose an investor buys mutual fund units across 3 irregular dates and checks their portfolio value today:
- 01-Jan-2024: Invested ₹50,000 (Cash flow: -₹50,000)
- 15-Jun-2024: Invested ₹30,000 (Cash flow: -₹30,000)
- 10-Nov-2024: Invested ₹20,000 (Cash flow: -₹20,000)
- 01-Jan-2025: Current Portfolio Value is ₹1,12,000 (Cash flow: +₹1,12,000)
Although the total invested capital is ₹1,00,000 and total profit is ₹12,000 (12% absolute return), the money was invested for varying fractions of the year. Solving the NPV equation yields an XIRR of ~21.4% p.a., accurately reflecting the higher annualized velocity of capital invested later in the year.
Common XIRR Calculation Errors to Avoid
- Incorrect Sign Conventions: Investments (money leaving your pocket) MUST be entered as negative numbers (\(-\)). Redemptions or current portfolio valuations MUST be entered as positive numbers (\(+\)). Incorrect signs cause calculation failure.
- Missing Current Portfolio Value Row: XIRR requires a terminal positive cash flow representing current valuation on today's date to measure unrealized gains.
- Annualizing Short Horizons (< 1 Year): XIRR annualized returns over short periods (e.g. 2 weeks) can show deceptive numbers (like +300% p.a.). Always evaluate XIRR over 1+ year horizons for meaningful insights.
Frequently Asked Questions (FAQ)
Why does XIRR differ from my Mutual Fund portfolio CAGR?
CAGR assumes money was invested all at once on day 1. If you invested via monthly SIPs over 3 years, your latest monthly installment has only been compounding for 30 days. XIRR accounts for the exact age of each individual installment, producing an accurate performance measure.
What is considered a good XIRR in India?
For equity mutual fund portfolios, an XIRR of 12%–15% over a 5 to 10 year horizon is considered healthy performance in India. For debt mutual funds, an XIRR of 6%–8% is standard.
Does XIRR include dividend receipts?
Yes, provided you enter dividend payout dates and amounts as positive cash inflows (\(+\)) on the specific dates they were received in your bank account.