Highlights:

  • Understand how CAGR measures fund performance while XIRR tracks your actual investment returns
  • Learn why SEBI mandates CAGR for mutual fund reporting periods exceeding one year
  • Discover how XIRR accounts for multiple cash flows in SIPs, unlike CAGR’s single investment assumption
  • Compare when to use CAGR for lumpsum investments versus XIRR for periodic contributions

Introduction

Most mutual fund investors check their returns and assume the number they see reflects how their money has actually grown. However, the fund’s reported return and your personal return can diverge significantly, depending on when and how you invested.

The answer lies in two metrics: CAGR and XIRR. One tells you how the fund performed, and the other reveals how your investment performed. For anyone contributing through SIPs (Systematic Investment Plans) or making multiple transactions over time, understanding this difference is essential.

What is CAGR?

Compound Annual Growth Rate (CAGR) represents the smoothed annual rate at which an investment grows from start to end, assuming steady compounding throughout. SEBI mandates that mutual funds report returns for periods exceeding one year as CAGR, making it the standard metric for fund performance comparison.

Imagine you invest ₹1 lakh in January 2023. By January 2026, it grows to ₹1.5 lakh. CAGR calculates the steady annual growth rate, approximately 14.5%, as though returns are compounded each year uniformly.

This metric works perfectly for lump-sum investments held continuously without additional contributions or withdrawals. The limitation is equally clear: CAGR assumes you invested the entire amount once and left it untouched. The moment you add money periodically, as most investors do through SIPs, CAGR stops reflecting your personal experience.

What is XIRR?

Extended Internal Rate of Return (XIRR) calculates annualised returns for investments involving multiple cash flows at different dates. It is the annualised internal rate of return for investments involving multiple cash flows on different dates, and accounts for both the amount and timing of every investment, withdrawal or redemption.

This matters because your ₹5,000 invested in January performs differently from ₹5,000 invested in June. The January instalment has more time in the market. The June instalment has less. XIRR accounts for this timing difference across every single transaction in your portfolio.

You can calculate XIRR using Excel’s built-in XIRR function by entering transaction amounts and dates. The tool handles complex iterations instantly, giving you accurate returns that reflect your actual investment timeline.

XIRR vs CAGR: Key Differences

The core distinction is straightforward: CAGR tells you how the fund performed; XIRR tells you how your investment performed.

CAGR assumes a one-time investment held continuously. It smooths out volatility into a single growth rate, making fund comparisons straightforward. XIRR handles multiple transactions, investments, withdrawals, or dividend reinvestments at different dates.

Consider monthly ₹10,000 SIPs over three years versus a single ₹3.6 lakh lumpsum investment. Both might produce similar ending values, but their returns differ. The lumpsum investor’s entire capital compounds for three full years. The SIP investor’s first instalment compounds for 36 months, while the last compounds for just one month. XIRR captures this timing effect precisely. CAGR cannot.

When to Use CAGR vs When to Use XIRR

Use CAGR for: Lumpsum investments without additional contributions or withdrawals. It is perfect for comparing mutual fund schemes’ published performance or evaluating fixed deposits. When you want to know how a scheme fared over a given period, CAGR is the answer.

Use XIRR for: Any investment pattern involving multiple cash flows. This includes SIPs, systematic transfer plans, dividend reinvestments, and partial redemptions. Since most mutual fund investors in India invest through SIPs rather than lump sums, XIRR is the more relevant metric for tracking personal portfolio returns.

Fund houses report CAGR for regulatory and comparison purposes; XIRR reflects what your specific money actually earned based on when you invested it.

Making Sense of Your Returns

CAGR and XIRR are not competing metrics; they answer different questions. CAGR offers standardised comparisons across funds; whether the fund is worth staying in. XIRR reveals your personalised experience, answering if you are getting what you expected from the fund. For investors building portfolios through regular contributions, XIRR is often the more honest number. It accounts for market timing, cash flow patterns, and real-world investing behaviour. Used together, both metrics give you a complete picture of where you stand.

FAQs

1. Which is better, XIRR or CAGR?

Neither is categorically better. XIRR suits investments with multiple cash flows like SIPs. CAGR works best for single lump-sum investments held continuously. The right choice depends on your investment pattern.

2. Can XIRR be converted to CAGR?

No, direct conversion is not possible. They calculate returns based on different assumptions – CAGR assumes a one-time investment, while XIRR accounts for multiple cash flows at different dates.

3. Why is XIRR used for SIP returns instead of CAGR?

SIPs involve periodic investments at different NAVs. XIRR considers the timing and size of each instalment, making XIRR more accurate for SIPs where each contribution has a different period of compounding.

4. Are annualised return and CAGR the same?

CAGR is a type of annualised return suited to lumpsum investments. For multiple or irregular cash flows, XIRR provides an annualised return that accounts for each transaction’s timing.

5. How do I calculate XIRR for my mutual fund portfolio?

Use Excel’s XIRR function by entering transaction dates in one column and amounts in another. Include investments as negative values and the current portfolio value as positive. Excel calculates your annualised return instantly.