XIRR (Extended Internal Rate of Return) is a measure of the โ€œannualised returnโ€ on an investment when cash flows happen on different dates. Unlike a regular IRR (Internal Rate of Return), XIRR considers the exact amount and date of each investment, withdrawal, and final value to calculate the annual return earned.

Potentially, XIRR is suitable for SIPs, SWPs, and other investments involving periodic or irregular investments and withdrawals, as it accounts for the exact timing of each cash flow.

A SIP is not a single investment made at one point in time, so using CAGR to measure its returns can give an incorrect estimate. Thatโ€™s largely because CAGR only looks at the beginning and ending values without considering when individual instalments were invested.

A potentially better option? โ€œXIRRโ€ factors in the exact amount and date of each cash flow and may be more appropriate for measuring the actual return earned on SIPs, SWPs, and other investments with multiple cash flows.

Read this article to understand what CAGR is in a mutual fund and why it may be misleading for SIPs. Next, learn how XIRR accounts for the timing of individual cash flows and can be a more appropriate return measure. Finally, compare CAGR vs XIRR returns through a hypothetical example.

What is CAGR in Mutual Funds?

The CAGR full form is โ€œCompounded Annual Growth Rateโ€. It is a return metric, which assumes one inflow at the start and one value at the end. Thus, this method is designed to measure the annualised growth of a โ€œsingle investmentโ€ made at the beginning of a period.

Mathematically, it can be calculated using the following CAGR formula:

Letโ€™s understand better through an example:

  • Suppose โ‚น1 lakh were invested as a lump sum.
  • They potentially became โ‚น1.50 lakh after 3 years.
  • Here, CAGR can be used to calculate the annualised growth as the entire โ‚น1 lakh was invested from the start.
  • In this case, the CAGR would be:

Why CAGR Can Be Misleading for SIPs

An SIP involves multiple investments made on different dates. For example, in a monthly SIP:

  • The first instalment may remain invested for almost the entire investment period.
  • The next instalment remains invested for comparatively less time.
  • The most recent instalment may have been invested for only a few months.

Therefore, there is no single beginning value that was invested for the entire period. Also, each instalment may also purchase mutual fund units at a different NAV.

Now, when you apply CAGR to your SIP investments, you are basically assuming that the total amount invested through SIPs is invested at the beginning of the period. This can result in an โ€œinaccurate return percentageโ€ because CAGR does not account for the different dates on which each SIP instalment was invested.

An instalment invested earlier has more time to earn returns than one invested later, but CAGR treats the entire invested amount as if it had been invested for the full period.

What is XIRR, an Why it May Potentially Be More Appropriate for SIPs?

XIRR is designed for investments where cash flows occur on different dates. It uses the amount and exact date of every cash flow to calculate the annualised return. Mathematically, XIRR can be calculated using the following formula:

Where,

Conceptually, the XIRR formula solves for the rate โ€œrโ€ that makes the present value of all cash outflows and inflows equal to zero.

For an SIP, the investments are generally treated as โ€œcash outflowsโ€, while the final redemption value is treated as a โ€œcash inflowโ€. Since XIRR considers the exact date of each SIP instalment, it is potentially an appropriate method to calculate the SIP returns.

CAGR vs XIRR: Understand The Difference Through a Hypothetical Example

Suppose an investor invests โ‚น10,000 every month for 6 months and makes a total investment of โ‚น60,000. At the end of the sixth month, the investment is potentially worth โ‚น65,000.

Now, these two return methods can produce very different results since they treat the timing of the investments differently. Letโ€™s understand in detail:

A) CAGR Calculation

CAGR assumes that the entire โ‚น60,000 was invested at the beginning and remained invested for the full six-month period. It can be calculated as follows:

Here, 0.5 represents 6 months expressed in years.

So, using the CAGR method, the annualised return would be approximately 17.36%.

However, this calculation does not reflect the actual investment pattern. The investor did not invest โ‚น60,000 on Day 1.

The โ‚น10,000 instalments were invested one month apart. Consequently, the first instalment was invested for the longest period, while the last instalment was invested for only a short period.

B) XIRR Calculation

XIRR accounts for the exact date of every cash flow. For example, assume the six โ‚น10,000 SIP instalments were made on January 1, February 1, March 1, April 1, May 1, and June 1, and the final value of โ‚น65,000 was received on June 30.

The cash flows would be:

DateCash Flow
January 1-โ‚น10,000
February 1-โ‚น10,000
March 1-โ‚น10,000
April 1-โ‚น10,000
May 1-โ‚น10,000
June 1-โ‚น10,000
June 30+โ‚น65,000

In any spreadsheet software, the XIRR can be calculated using the formula โ€œ=XIRR(B2:B8, A2:A8).โ€ Here:

  • โ€œB2:B8โ€ contains the cash flows, including the six negative SIP investments and the positive maturity value.
  • โ€œA2:A8โ€ contains the corresponding dates.

Using these dates and cash flows, the XIRR is approximately 31.79% per year.

An Important Observation

CAGR gives approximately 17.36%, while XIRR gives approximately 31.79%. Thatโ€™s largely because XIRR recognises that the entire โ‚น60,000 was not invested for six months. The later SIP instalments had a much shorter investment period.

Therefore, when calculating the investor's actual annualised return, XIRR is potentially more appropriate because it matches each cash flow with the period for which that money was actually invested.

Conclusion

So, now you know what CAGR and XIRR are and which method may potentially be more appropriate for calculating SIP returns. To revise, CAGR is a โ€œpoint-to-pointโ€ return method that measures the annualised growth between a beginning value and an ending value.

In contrast, XIRR calculates annualised returns by considering the amount and exact date of each cash flow. This makes the timing of investments and withdrawals part of the calculation.

Therefore, for SIPs, SWP withdrawals, or any investment involving periodic or irregular cash flows, XIRR may potentially be more appropriate. Thatโ€™s largely because it accounts for when each amount was invested or withdrawn and the length of time for which it remained invested.

CAGR FAQs

1. What is the difference between CAGR and XIRR for SIP returns?

CAGR measures annualised growth between a beginning and ending value. It treats the investment as a single amount held throughout the period. In contrast, XIRR considers the amount and exact date of each cash flow.

Therefore, CAGR is potentially more suited to point-to-point investments, while XIRR is generally more appropriate for SIPs involving multiple instalments.

2. Why is CAGR not ideal for calculating SIP returns?

CAGR does not account for the timing of individual SIP instalments. It effectively treats the total invested amount as though it were invested at the beginning of the period.

Since different instalments remain invested for different durations, this assumption can produce a return percentage that does not accurately represent the investorโ€™s actual annualised return.

3. How does XIRR account for multiple cash flows in a SIP?

XIRR uses both the amount and date of every cash flow. Each SIP instalment is treated as a separate cash โ€œoutflowโ€, while the redemption value is treated as an โ€œinflowโ€.

XIRR then calculates the annualised rate that equates the โ€œpresent valueโ€ of these cash flows by considering their different investment periods.