CAGR vs XIRR: Understanding Which Investment Return Measure to Use

Finance Beyond Numbers – Episode 6

When reviewing an investment, one of the first questions investors usually ask is:

“What return have I actually earned?”

You may have seen two different measures in your mutual fund or investment statement — CAGR and XIRR.

Both are annualised measures of investment return, but they approach the calculation differently.

Understanding the distinction becomes particularly important when you make multiple investments over a period of time.

A Simple Example

Let us consider an investor who makes the following investments:

DateInvestment
1 January 2023₹1,00,000
1 January 2024₹50,000
1 January 2025₹50,000
1 January 2026Current value ₹2,50,000

The total amount invested is ₹2,00,000, while the investment is worth ₹2,50,000 on 1 January 2026.

At first glance, an investor may simply compare the total investment with the current value and conclude that the investment has generated a ₹50,000 gain.

But there is an important issue.

The entire ₹2,00,000 was not invested for three years.

The first ₹1,00,000 was invested in 2023.

The second ₹50,000 was invested one year later.

The final ₹50,000 was invested only in 2025.

Therefore, each amount has been invested for a different length of time.

This is where the difference between CAGR and XIRR becomes important.

What Happens If We Calculate CAGR?

If we treat the entire ₹2,00,000 as though it had been invested for the full three years and calculate the compounded annual growth rate:

CAGR ≈ 7.72%

However, this calculation does not reflect the actual timing of the three investments.

The later investments had less time to grow.

What Does XIRR Do Differently?

XIRR considers the actual amount and the actual date of each cash flow.

In our example, it considers:

  • ₹1,00,000 invested on 1 January 2023
  • ₹50,000 invested on 1 January 2024
  • ₹50,000 invested on 1 January 2025
  • ₹2,50,000 received as the current value on 1 January 2026

The resulting XIRR is approximately 10.26%.

This is why the two figures can be different.

The difference does not mean that one calculation is necessarily wrong.

They are based on different approaches to the timing of the cash flows.

Why Does XIRR Give a Higher Return in This Example?

The important point is that ₹2,00,000 was not working for the investor for the entire three-year period.

A substantial portion of the money was invested later.

For example, the ₹50,000 invested in January 2025 had only about one year to participate in the investment's growth.

XIRR recognises this timing.

Therefore, for investments involving multiple cash flows, XIRR generally provides a more meaningful measure of the investor's annualised return.

CAGR and XIRR — When Should We Look at Each?

A simple way to remember the distinction is:

Single investment with no intermediate cash flows:
CAGR and XIRR will generally be the same.

Multiple investments or withdrawals at different dates:
XIRR is more meaningful because it considers the timing of each cash flow.

This is particularly relevant for SIPs, additional investments, partial withdrawals and other investments where money enters or leaves the investment at different points in time.

Why This Matters to Investors

When reviewing investment performance, it is easy to focus only on the percentage displayed in a statement.

But a return percentage should always be understood in the context of how the investment was made.

Two investors may have the same current value but very different investment histories.

One may have invested a lump sum several years ago.

Another may have invested gradually through SIPs.

Their return calculations therefore need to take their respective cash flows into account.

The objective is not simply to find a higher percentage.

The objective is to understand what the percentage actually represents.

Watch Episode 6

I have explained this concept in a short video as part of the Finance Beyond Numbers series.

🎥 Watch the video on YouTube:

https://youtube.com/shorts/SD9NJNZ5nws

The Key Takeaway

CAGR and XIRR are not competing methods.

They are useful for understanding investment returns under different cash-flow situations.

For a single investment with no intermediate cash flows, CAGR and XIRR will generally be the same.

When there are multiple investments or withdrawals at different dates, XIRR provides a more meaningful annualised return because it takes the timing of the cash flows into account.

Understanding how your investment return is calculated is an important part of making informed financial decisions.

If you found this article useful, please share it with your friends, relatives, colleagues and well-wishers so that more investors can understand their investment returns better.

For more practical financial guidance and financial insights:

KSR Financial Guidance
https://www.ksrfinancialguidance.com

Finance Beyond Numbers
Knowledge that Creates Wealth... Decisions that Create Value.

Comments

Popular posts from this blog