CAGR and XIRR are both used to understand investment returns, but they are designed for different situations.
If you invest ₹1 lakh once and check its value several years later, CAGR can show the annualised compounded growth rate.
But what if you invest ₹5,000 every month through an SIP? Every instalment is invested on a different date and remains invested for a different period. In such a case, XIRR is generally the more appropriate return calculation because it accounts for individual cash flows and their dates.
Understanding this difference can help you interpret your mutual fund returns correctly.
What Is CAGR?
CAGR stands for Compound Annual Growth Rate.
It represents the constant annualised compounded rate at which an investment would have grown from its beginning value to its ending value over a specified period.
The basic formula is:
CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ Number of Years) − 1
For example, suppose ₹1 lakh grows to ₹1.5 lakh in five years.
The CAGR is approximately 8.45% per year.
This does not mean the investment actually delivered exactly 8.45% in each individual year. CAGR smooths the entire period into one annualised compounded growth rate.
For a detailed explanation, see our earlier guide: “What Is CAGR? Meaning, Formula and Examples Explained Simply.”
What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
XIRR calculates an annualised return when an investment involves cash flows occurring on different dates.
It takes into account:
Amount of each investment
Date of each investment
Withdrawals, if included
Final investment value
Timing of every cash flow
Microsoft’s official XIRR documentation defines XIRR as the internal rate of return for a schedule of cash flows that is not necessarily periodic. Its calculation uses the dates associated with individual cash flows.
This makes XIRR useful for SIPs and other investment situations involving multiple transactions.
CAGR vs XIRR: Key Differences
| Basis | CAGR | XIRR |
|---|---|---|
| Full Form | Compound Annual Growth Rate | Extended Internal Rate of Return |
| Best suited for | Single investment with beginning and ending values | Multiple cash flows occurring on different dates |
| Cash flows | Typically one initial investment and one final value | Multiple investments and/or withdrawals |
| Exact dates | Not required beyond the overall period | Individual transaction dates are considered |
| Common example | Lump-sum investment | SIP or irregular investments |
| Result | Annualised compounded growth rate | Annualised internal rate of return |
| Calculation | Relatively simple formula | Usually calculated using software/spreadsheet |
The important point is that the two metrics solve different problems.
How CAGR Works With a Lump-Sum Investment
Suppose you invest:
₹1,00,000
After five years, your investment becomes:
₹1,50,000
The CAGR formula is:
CAGR = (₹1,50,000 ÷ ₹1,00,000)^(1/5) − 1
The result is approximately:
8.45% per year
CAGR therefore answers:
“At what constant compounded annual rate would ₹1 lakh need to grow to become ₹1.5 lakh in five years?”
It does not show the actual return earned in each individual year.
How XIRR Works With SIPs and Multiple Transactions
An SIP works differently from a lump-sum investment.
SEBI’s financial education material describes an SIP as a way of investing a fixed amount in a mutual fund scheme at regular intervals, such as weekly, monthly or quarterly.
AMFI similarly describes an SIP as a method through which a fixed amount can be invested periodically in a mutual fund instead of making a single lump-sum investment.
Suppose you invest:
₹5,000 in January
₹5,000 in February
₹5,000 in March
and continue investing every month
The January instalment remains invested longer than the December instalment.
Simply adding all your SIP contributions and applying CAGR to that total would ignore these different investment dates.
XIRR addresses this by assigning each cash flow its actual date.
CAGR vs XIRR Example Using ₹1 Lakh Lump Sum vs Monthly SIP
Consider two different situations.
Investor A: Lump-Sum Investment
Investor A invests:
₹1,00,000 on January 1
Assume the investment becomes:
₹1,20,000 after two years
There is one initial investment and one final value.
CAGR can therefore be calculated directly from the beginning value, ending value and investment period.
CAGR:
(₹1,20,000 ÷ ₹1,00,000)^(1/2) − 1
This is approximately:
9.54% per year
Investor B: Monthly SIP
Investor B does not invest ₹1 lakh on a single date.
Instead, the investor makes multiple investments over time—for example:
January: ₹5,000
February: ₹5,000
March: ₹5,000
April: ₹5,000
and so on
Each investment has a different investment date.
If we simply combine all those instalments and treat them as though the entire amount had been invested on the first day, the calculation would not reflect the actual timing of the cash flows.
XIRR instead considers each investment date separately.
Important: An exact XIRR cannot be calculated from the SIP amount alone. We also need the exact transaction dates and the final value/withdrawal cash flow. Therefore, no assumed XIRR figure is being assigned to this example.
When Should You Use CAGR?
CAGR is useful when you have a straightforward beginning-to-ending investment scenario.
For example:
One lump-sum investment → investment remains invested → final value
CAGR can be useful for:
Understanding long-term growth of a lump-sum investment
Expressing multi-year growth as an annualised compounded rate
Comparing historical growth over identical periods, where the underlying comparison is appropriate
However, CAGR does not show the volatility experienced between the beginning and ending dates.
When Should You Use XIRR?
XIRR is generally appropriate when money moves into or out of an investment on multiple dates.
Examples include:
SIPs
You invest periodically rather than on one date.
Irregular Investments
You invest different amounts at different times.
Additional Investments
You make a lump-sum investment and later add more money.
Withdrawals
You withdraw part of your investment before the final valuation date.
Because XIRR considers individual transaction dates, it can account for these cash-flow patterns.
Can CAGR and XIRR Give Different Results?
Yes.
They can give different results because they handle cash flows differently.
CAGR works from a beginning value, an ending value and an overall time period.
XIRR works with multiple cash-flow amounts and their actual dates.
If there is only one initial cash outflow and one final cash inflow, the annualised results from the underlying calculations can align when the periods are treated consistently.
Once multiple investments or withdrawals occur on different dates, XIRR incorporates information that a simple CAGR calculation does not.
Which Metric Should Mutual Fund Investors Look At?
It depends on how the investment was made.
For a Lump-Sum Investment
If there is one investment at the beginning and a value at the end, CAGR can provide a straightforward measure of annualised compounded growth.
For SIP Investments
For an investor’s personal SIP return, XIRR is more appropriate because SIP contributions occur on multiple dates.
But return is only one part of evaluating a mutual fund.
SEBI advises investors to consider factors such as:
Investment objective
Risk appetite
Investment horizon
Costs
Diversification
Past performance in proper context
SEBI also specifically notes that past performance can provide information but does not guarantee future returns.
Mutual funds themselves carry investment risks, and SEBI advises investors to compare risks and expected returns while making investment decisions.
Common Mistakes When Comparing Investment Returns
Using CAGR for an SIP as if All Money Was Invested on Day One
This ignores the fact that individual SIP instalments were invested on different dates.
Assuming CAGR Was Actually Earned Every Year
CAGR is a smoothed annualised rate.
Actual yearly returns may have been higher, lower or negative.
Treating XIRR as a Guaranteed Future Return
XIRR calculated from past transactions represents historical performance.
It does not predict future returns.
SEBI’s SIP calculator explicitly states that its calculations are illustrative, that stock-market returns are not fixed and that the rate of return cannot be predicted.
Comparing Different Time Periods
A return measured over one year should not be casually compared with another investment measured over five or ten years.
Ignoring Risk
A higher historical CAGR or XIRR does not automatically mean an investment is better.
SEBI advises investors to assess their risk appetite and notes that investments offering higher potential returns often come with higher risk.
Comparing Different Fund Categories Only on Returns
Equity, debt and hybrid mutual funds can have different objectives and risk profiles.
Return should therefore be evaluated along with the scheme’s objective and risk.
FAQs
What is the main difference between CAGR and XIRR?
CAGR measures annualised compounded growth between a beginning and ending value. XIRR calculates an annualised return while considering multiple cash flows and their individual dates.
Is CAGR suitable for SIPs?
A simple CAGR calculation is not suitable for measuring an investor’s overall SIP return when there are multiple instalments on different dates. XIRR can account for those individual cash flows and dates.
Is XIRR only for SIPs?
No.
XIRR can be used whenever there are multiple or irregular cash flows on different dates, including additional investments and withdrawals.
Which is better: CAGR or XIRR?
Neither is universally better.
The appropriate metric depends on the cash-flow pattern. CAGR is suited to a simple beginning-and-ending investment calculation, while XIRR is designed for multiple dated cash flows.
Can CAGR and XIRR be negative?
Yes.
Depending on the beginning value, ending value and cash flows, the calculated annualised return can be negative.
Does a 12% CAGR mean the investment earned 12% every year?
No.
CAGR represents a constant annualised compounded rate connecting the beginning and ending values. Actual year-to-year returns may have varied substantially.
Does a 12% XIRR mean I will earn 12% next year?
No.
A historical XIRR does not guarantee future returns. Market-linked investment returns are not fixed or predictable.
Why are dates important in XIRR?
Because money invested earlier remains invested for a different period than money invested later.
Microsoft’s XIRR calculation therefore uses a schedule of cash flows together with their corresponding dates.
How can XIRR be calculated in Excel?
Microsoft Excel provides the function:
=XIRR(values, dates, [guess])
Microsoft states that the values must include at least one positive and one negative cash flow, with corresponding dates supplied to the function.
Conclusion
CAGR and XIRR both help investors understand returns, but they should not be used interchangeably without considering the investment’s cash-flow pattern.
For a straightforward lump-sum investment with one beginning value and one ending value, CAGR provides a useful annualised compounded growth rate.
For an SIP or an investment involving multiple contributions and withdrawals on different dates, XIRR is more appropriate because it accounts for the amount and timing of each cash flow.
For mutual fund investors, however, neither CAGR nor XIRR should be viewed in isolation. Historical return is only one part of investment evaluation. Risk, investment horizon, scheme objective, costs and suitability also matter.
Most importantly, CAGR and XIRR describe calculated investment performance; neither guarantees what an investment will earn in the future.
