CAGR works for a one-time lumpsum, but what happens when you invest a little every month—or mix SIPs with a lumpsum, dividends, or partial withdrawals? XIRR (Extended Internal Rate of Return) is the standard way to compute annualized returns when you have multiple cash flows at uneven dates. Regulators and fund houses emphasize that "with multiple cash flows, the IRR or XIRR approach is usually considered to be better than CAGR." Here's what XIRR means, how it works, and when to use it.
What is XIRR?
XIRR finds the single annualized rate r that makes the net present value of all your cash flows (investments and redemptions) equal to zero. In plain terms: if your money grew at a constant annual rate, what would that rate be?
Each cash flow is discounted by (1 + r)^(days/365) from a base date. Investments go in as negative numbers; redemptions, dividends (if received in cash), or the current portfolio value go in as positive numbers. Excel and Google Sheets do this via =XIRR(values, dates).
XIRR is money-weighted: it reflects your actual timing of investments and withdrawals. Fund platforms typically report XIRR on statements—it is "your personal rate of return" for your real transactions.
XIRR vs IRR vs CAGR
IRR assumes equal time gaps between cash flows (e.g. annual). XIRR uses the actual calendar days between each flow, so it works for monthly SIPs, irregular contributions, or partial redemptions. If you applied simple IRR to an SIP, the result would be wrong.
CAGR works for a single lumpsum: one amount in, one amount out. It ignores intermediate flows. For SIPs or multiple investments, CAGR cannot correctly handle the staggered contributions—experts advise: use CAGR for lumpsum, XIRR for SIPs.
| Metric | Cashflow pattern | When to use |
|---|---|---|
| CAGR | Single investment, no intermediate flows | Lumpsum, point-to-point |
| IRR | Periodic flows at equal intervals | Projects/loans with fixed periods |
| XIRR | Any irregular inflows/outflows | SIPs, SWPs, dividends, partial redemptions |
Learn more in What is CAGR and How to Calculate Mutual Fund Returns.
How to Calculate XIRR
- List all transactions with dates. Every investment (negative) and redemption, dividend, or current value (positive), with the exact date.
- Use Excel or Google Sheets. Enter cash flows and dates in two columns. Use
=XIRR(values_range, dates_range). Ensure dates are sorted chronologically. - Include current value. If still invested, add today's portfolio value as a final positive cash flow with today's date.
Or use our XIRR Calculator to get your annualized return instantly.
Worked Example: Monthly SIP
Suppose you invest ₹10,000 on the 1st of each month for 3 years (36 payments = ₹3,60,000 total) and redeem the entire portfolio. Assume it grows to about ₹4,18,000.
SIP Example (3 years)
- Monthly SIP: ₹10,000
- Total invested: ₹3,60,000
- Final value: ₹4,18,000
- XIRR (annualized): ~10%
A naive total return (4,18,000 − 3,60,000) ÷ 3,60,000 = 16.2% ignores compounding. CAGR of (4,18,000 ÷ 10,000)^(1/3) − 1 would be wildly wrong—it assumes a single ₹10k investment. XIRR correctly gives ~10% annualized for the SIP.
Common Pitfalls
- Wrong signs: Investments must be negative, redemptions/current value positive. One of each is required or Excel errors.
- Short-term distortion: For very short periods (<1 year), XIRR annualizes returns—small gains can look huge. Use absolute return (%) for short spans.
- Missing flows: Any omitted transaction biases XIRR. Record every SIP, lumpsum, withdrawal, and dividend.
Tax and XIRR
XIRR is pre-tax. Equity funds: 10% LTCG on gains above ₹1 lakh/year; 15% STCG if sold within 1 year. Debt funds: gains taxed at your slab. To see net returns, factor these in after computing XIRR.
Frequently Asked Questions
- What is a good XIRR for mutual funds? For long-term equity funds (5+ years), an XIRR of 12–15% is generally considered very good. Compare with the fund's NAV CAGR and your goals.
- Is XIRR better than CAGR? They serve different purposes. Use CAGR for a single lumpsum held over time. Use XIRR for SIPs, SWPs, or any investment with multiple cash flows at different dates.
- Can I use XIRR for a lumpsum? Yes. For a pure lumpsum (one inflow, one outflow), XIRR will equal CAGR. XIRR is simply more flexible.
- Why does my fund statement show XIRR? Fund houses and SEBI- and AMFI-aligned platforms report XIRR because it reflects your actual cash-flow–adjusted return, not just the fund's NAV growth.
Taking Control of Your SIP Math
XIRR is the right metric when you have multiple cash flows: SIPs, lumpsums, dividends, partial redemptions. It uses exact dates and amounts to give your true annualized return. Use CAGR for lumpsums; use XIRR for everything else. Try our XIRR Calculator to see the real performance of your SIP or mixed investments.