TABLE OF CONTENT
blog-card-logo Discover your MoneySign®

Identify the personality traits and behavioural patterns that shape your financial choices.

Understanding CAGR and XIRR: Which One Should You Use to Calculate Investment Returns?

By
Chetan Wagh
author-image
Chetan Wagh Assistant Manager

Chetan has been working in fintech in various capacities and writing about personal finance for nearly four years. He enjoys sharing and simplifying financial concepts for readers.

linkedin-icon
17 March 2025 2 min read
Understanding CAGR and XIRR: Which One Should You Use to Calculate Investment Returns?

The objective of any investment is to generate returns, and while calculating the returns, investors come across terms like compounded annual growth rate (CAGR) and extended internal rate of return (XIRR).

Both of these are used to gauge the effectiveness of the investments. Although some investors confuse these metrics and use them interchangeably, they are different. We will try to understand both these metrics and highlight the differences between them

What is CAGR?

As the name suggests, compounded annual growth rate or CAGR calculates the average annual return of any investment, assuming returns are compounded every year. This is ideal for calculating the return when an investment is made once.

Is CAGR the same as Absolute Returns?

CAGR is different from absolute returns. The absolute return shows the total return from the day the investment was made till the date when you are calculating it. CAGR, on the other hand, shows average annualised returns. 

The formula for CAGR is

CAGR = (Ending Value/Beginning Value)^ (1 / Number of Years) – 1

Example: 

If you invest ₹1,00,000 in a mutual fund. After five years, the investment grows to ₹1,50,000. What is the annualized return (CAGR)?

(Ending Value/Beginning Value)^ (1 / Number of Years) – 1

CAGR = (150000/100000) ^ (1/5) – 1

CAGR = 8.45% per annum

What is XIRR?

Just like CAGR, XIRR is also used for measuring returns, but XIRR helps us to calculate returns on investments made at different intervals like SIP.

Although there is no algebraic formula for XIRR, it can be calculated using the XIRR function in Excel or Google Sheets, where the formula is

XIRR = (value, dates, guess)

Example:

If you invest ₹5000 each month in a mutual fund for 6 months. Your portfolio value is ₹32,000. What is the XIRR?

Here is the calculation for XIRR using excel

Date Amount
01-01-2024 -5000
02-01-2024 -5000
03-01-2024 -5000
04-01-2024 -5000
05-01-2024 -5000
06-01-2024 -5000
07-01-2024 32000

24.63%

Difference between XIRR and CAGR 

CAGR XIRR
Meaning Helps in calculating point-to-point return by considering initial investment and final value Helps in tracking returns on investment made at frequent intervals
Suitable for Best suited for lump-sum investments Best suited for investments with multiple inflows like SIP
Timing Assumes single investment at the beginning Considers exact timing of the investments
Investment type Lumpsums or any other one-time investment SIPs and other regular investments

When to Use CAGR and XIRR?

Use CAGR for:

  • A one-time investment.
  • Calculating the average annual growth rate.  
  • Comparing returns of various investments. 

Use XIRR for:

  • Help us to measure the average annual growth of investments that are done multiple times in the same product, like SIP or additional lump-sum investments.
  • Measuring the exact returns on investment

Parting Thoughts

Both CAGR and XIRR are crucial metrics for measuring the returns of your investments, but they serve different purposes. CAGR is ideal for single, point-to-point investments, while XIRR is best for multiple investments.

Please note,

The views in the article /blog are personal and that of the author. The idea is to create awareness and not intended to provide any product recommendations.

blog-card-logo

Discover your MoneySign®

Identify the personality traits and behavioural patterns that shape your financial choices.

WhatsAppXLinkedIn
Chat with us