What is CAGR in Mutual Fund? CAGR Formula, CAGR vs XIRR
When investors check mutual fund performance, the first number they usually look at is returns. But raw returns can be misleading. A fund showing 120% growth over ten years sounds impressive, yet it doesn’t tell you how consistently your money grew every year. This is where CAGR in mutual funds becomes important.
CAGR, or Compounded Annual Growth Rate, simplifies long-term returns into a single annual percentage. It answers one practical question every Indian investor asks: “At what yearly rate did my investment actually grow?”
In this detailed guide, we will explain what is CAGR in mutual funds, how to calculate CAGR, the CAGR vs XIRR, and the CAGR formula in Excel, using realistic Indian examples. By the end, you will clearly know when CAGR is useful — and when it is not.
What Is CAGR in Mutual Fund?
CAGR (Compounded Annual Growth Rate) is the mean annual gain realized by an investment within a given timeframe and when reinvestments of the gains are done every year.
Simply put: CAGR will smooth out returns and transform total growth into annual growth rate.
CAGR has become a popular measurement of:
- Long term lump sum investments.
- Equity, hybrid and debt fund performance.
- Growth in historic funds within 3, 5 or 10 years.
Mutual fund platforms under the instructions of Securities and Exchange Board of India (SEBI) tend to show a CAGR so that the comparison of the schemes is made even.
Why Is the CAGR Important for Indian Investors?
Indian investors invest for long-term goals such as:
- Retirement
- Child education
- Wealth creation
- Financial independence
CAGR helps because it:
- Removes short-term volatility noise
- Allows comparison between different funds
- Shows compounding impact clearly
For example, comparing:
- Fixed Deposits
- Mutual Funds
- Equity indices like NIFTY 50
becomes much easier when returns are annualised using CAGR.
How CAGR Works?
CAGR assumes:
- Your investment grows at a constant rate every year
- All gains are reinvested
- There are no intermediate cash flows
Though markets do not increase in linear curves, CAGR provides a clean, similar figure.
How to Calculate CAGR?
The CAGR formula is:
CAGR=(Ending ValueBeginning Value)1n−1\text{CAGR} = \left(\frac{\text{Ending Value}}{\text{Beginning Value}}\right)^{\frac{1}{n}} – 1CAGR=(Beginning ValueEnding Value)n1−1
Where:
- Beginning Value = Initial investment
- Ending Value = Final investment value
- n = Number of years
CAGR Calculation Example (Indian Mutual Fund)
Let’s say:
- You invested ₹1,00,000 in an equity mutual fund
- Investment value after 5 years = ₹2,01,000
CAGR=(2.01)1/5−1\text{CAGR} = (2.01)^{1/5} – 1CAGR=(2.01)1/5−1 CAGR≈15%\text{CAGR} ≈ 15\%CAGR≈15%
This means your money grew at 15% per year, compounded annually.
CAGR Formula in Excel (Very Important)
Many Indian investors calculate returns using Excel. Here’s how:
Basic Excel Formula = (Ending Value / Beginning Value)^(1/Years) – 1
Example in Excel
Cell | Value |
A1 | 100000 |
A2 | 201000 |
A3 | 5 |
Formula: =(A2/A1)^(1/A3)-1
Format the cell as percentage to get CAGR.
CAGR in Mutual Fund vs Absolute Return
Parameter | CAGR | Absolute Return |
Time Factor | Included | Ignored |
Comparison | Easy | Misleading |
Long-Term Analysis | Best | Weak |
SIP Suitability | No | No |
Always prefer CAGR for long-term performance evaluation.
CAGR vs XIRR (Very Important for India)
One of the most common doubts Indian investors have is CAGR vs XIRR.
Feature | CAGR | XIRR |
Investment Type | Lump sum | SIP / irregular |
Cash Flows | Single | Multiple |
Accuracy for SIP | Poor | Excellent |
Complexity | Simple | Moderate |
Why is the CAGR Not Suitable for SIPs?
In SIPs:
- Money is invested monthly
- Each instalment has a different investment period
CAGR assumes one-time investment, which makes it inaccurate for SIPs. For SIPs, always use XIRR.
Platforms regulated by Association of Mutual Funds in India (AMFI) recommend XIRR for SIP performance.
When Should You Use CAGR?
Use CAGR when:
- You invested a lump sum
- Investment period is clearly defined
- No additional investments or withdrawals were made
- Comparing mutual fund schemes
Examples:
- ELSS funds
- Index funds
- Long-term equity funds
When You Should NOT Use CAGR?
Avoid CAGR when:
- You invested via SIP
- There are multiple cash flows
- You withdrew partial amounts
- Evaluating short-term performance
In such cases, XIRR gives a more realistic picture.
Real-World Indian Mutual Fund Example
Suppose:
- Lumpsum investment in 2018: ₹5,00,000
- Value in 2024: ₹10,50,000
- Duration: 6 years
CAGR calculation shows:
- CAGR = 13.2%
This makes comparison easy with:
- Bank FDs (6-7%)
- Government bonds
- Index returns
Limitations of CAGR
CAGR looks perfect on paper, but it has limitations:
- Assumes smooth growth (markets are volatile)
- Ignores interim ups and downs
- Does not show risk or volatility
- Can hide poor yearly performance
Hence, CAGR should be used along with:
- Rolling returns
- Standard deviation
- Sharpe ratio
CAGR and Compounding: The Real Power
Even a small difference in CAGR creates massive wealth over time.
Example:
- ₹1,00,000 at 10% for 20 years → ₹6.7 lakh
- ₹1,00,000 at 14% for 20 years → ₹13.7 lakh
This is why long-term equity mutual funds remain popular among Indian investors.
Common Mistakes Investors Make with CAGR
- Using CAGR for SIP returns
- Comparing CAGR of different time periods
- Ignoring expense ratio impact
- Assuming CAGR guarantees future returns
Remember: CAGR is historical, not predictive.
Conclusion
One of the most misrepresented yet most effective metrics in mutual fund investment is CAGR. It offers a clean and standardised measure of long term performance of lump sum investments to Indian investors. CAGR can be used to compare mutual funds, benchmark returns and to discover the true effect of compounding when it is applied correctly.
CAGR however should never be applied without looking. It fails to reflect volatility, timing of cash flow or actual investor behaviour of SIPs. It is because it is important to know CAGR vs XIRR before making investment decisions.
At Trendy Traders Academy we do not think that investors need to pursue returns only, but they need to know more about the mathematics of returns. Learning how to use CAGR is an initial move towards becoming a participant in the market as a disciplined and informed being.
FAQ'S
What is CAGR in mutual funds?
CAGR This is the annual growth rate (assuming compounding) of a mutual fund investment.
Is CAGR applicable for SIP?
No, SIP investments cannot be done using CAGR. XIRR should be used instead.
Which is better, CAGR or XIRR?
CAGR is more suitable in lump sum investments whereas XIRR is more suitable in SIPs and multiple cash flow.
What is the CAGR formula in Excel?
The Excel formula is: =(Ending Value / Beginning Value)^(1/Years) − 1.
How to calculate CAGR?
CAGR is calculated using the formula: (Ending Value / Beginning Value)^(1/Years) − 1.
