XIRR vs CAGR: When to Use Which

The Gap CAGR Leaves Open

The previous lesson ended on CAGR's key limitation: it's designed for a single lump-sum investment at one point in time, not for money invested (or withdrawn) at multiple different dates — which describes almost every SIP, every set of staggered investments, and any portfolio with irregular cash flows. XIRR (Extended Internal Rate of Return) exists specifically to solve this.

What XIRR Actually Calculates

XIRR finds the single annualized rate of return that makes the present value of all your cash flows (every investment made and every withdrawal or final value) equal to zero — accounting for the exact date of each transaction. In plain terms: it correctly weighs money that's been invested longer as having had more time to grow, and money invested more recently as having had less time.

Metric	Designed For	Accounts for Timing of Each Cash Flow?
CAGR	A single lump-sum investment	No — only uses start and end values
XIRR	Multiple investments/withdrawals at different dates	Yes — each cash flow's exact date matters

A Worked SIP Example

Say you invested ₹10,000 on the 1st of every month for 12 months into a mutual fund, and at the end of the year your total holding is worth ₹1,30,000. Simply comparing ₹1,20,000 invested to ₹1,30,000 final value and calling it an "8.3% return" ignores something important: the first ₹10,000 had a full 12 months to grow, while the last ₹10,000 had almost no time at all. XIRR correctly weighs each installment by its actual invested duration, producing an annualized return figure that a simple percentage calculation can't.

When to Use CAGR vs XIRR — A Clear Rule

1. Single lump-sum investment, one start date, one end date? Use CAGR — it's simpler and gives the same accurate answer for this specific case.
2. SIP, multiple purchases, any additional investments or partial withdrawals at different times? Use XIRR — it's the only one of the two that correctly accounts for when each cash flow happened.
3. Comparing a SIP's performance against a lump-sum investment or a fixed-rate product like an FD? Use XIRR for the SIP side of the comparison, since it's the only metric that fairly represents staggered investing.

Why This Distinction Actually Matters for Most Investors

Most retail investors in India invest via SIP, not lump sum — which means XIRR, not CAGR, is usually the metric that actually reflects their real investment experience. Many platforms and apps do show XIRR correctly by default, but some simplistic "return" figures shown casually (or calculated by hand) end up being CAGR-style approximations applied incorrectly to SIP data, which can meaningfully misstate actual performance.

A Practical Way to Sanity-Check Your Own Numbers

Question to Ask	What It Tells You
Did I invest this as a single amount on one date?	If yes, CAGR is appropriate and simpler
Did I invest multiple times, or withdraw partially along the way?	If yes, XIRR is the only accurate choice
Is the app/platform's "return %" matching what I'd expect from a rough mental estimate?	If wildly off, double-check which metric is actually being shown

Common Mistakes

1. Applying CAGR logic to a SIP by mistake. Simply comparing total invested to current value and treating it like a lump-sum CAGR calculation ignores the staggered timing of each contribution, distorting the real return figure.

2. Assuming a higher XIRR always means a genuinely better investment. XIRR reflects the return on the specific cash flow pattern you had — comparing XIRR across very different investment styles (aggressive lump-sum vs. conservative SIP) needs some context, not just the raw number.

3. Not checking whether an app's displayed "return" is XIRR, CAGR, or absolute return. These are genuinely different numbers, and not all platforms clearly label which one they're showing — this is exactly why the next lesson covers reading these numbers critically.

Key Takeaway: CAGR works cleanly for a single lump-sum investment; XIRR is built specifically for the real-world pattern most investors actually have — SIPs, staggered purchases, and partial withdrawals — by correctly weighing each cash flow's exact timing. For most SIP investors in India, XIRR is the metric that genuinely reflects their actual return, not CAGR. Next, see How to Calculate Your True Stock Market Return (ROI).

Frequently Asked Questions

Can I use XIRR for a lump-sum investment too?

Yes — XIRR works correctly for a lump sum as well and will give the same result as CAGR in that specific case, since there's only one cash flow date to weigh. CAGR is just simpler when that's all you have.

Does my mutual fund app calculate XIRR automatically?

Many platforms do show XIRR correctly for SIP investments, but it's worth confirming which metric is actually labeled — some simplified "return" displays may not be true XIRR.

Why is my XIRR different from the fund's published CAGR?

A fund's published CAGR typically reflects the fund's overall lump-sum-style performance, while your personal XIRR reflects the specific timing of your own contributions — the two are answering different questions and can reasonably differ.

Does XIRR account for withdrawals, not just investments?

Yes — XIRR treats withdrawals as negative cash flows on their specific date, correctly factoring them into the overall annualized return calculation alongside investments.

Is a negative XIRR possible?

Yes — if your overall investment has lost value relative to what was put in (accounting for timing), XIRR will be negative, similar to how CAGR can be negative for a lump-sum loss.