Compute Compound Annual Growth Rate, or use reverse CAGR to find initial/final value. Perfect for mutual funds, stocks, and long-term planning.
The Compound Annual Growth Rate (CAGR) is the mean annual growth rate of an investment over a specified period longer than one year. It smooths out volatility and gives a single annualized number.
14.3%
annualized rate (CAGR)
Initial Investment
$10,000
Final Value
$19,500
Total Growth
95%
Time Period
5 years
| Year | Value | Growth |
|---|
The Compound Annual Growth Rate (CAGR) is the gold standard for measuring investment performance over time. Whether you're evaluating a mutual fund, a stock portfolio, or a business project, CAGR gives you a smooth, annualized rate that accounts for compounding. In this comprehensive 1700+ word guide, we'll cover everything from the basic formula to advanced topics like reverse CAGR calculator, how to calculate CAGR in Excel, and how to calculate CAGR in mutual funds. You'll also learn to use our interactive tool for both forward and reverse calculations.
Example: $10,000 grows to $19,500 in 5 years → CAGR = (19500/10000)^(1/5)-1 = 14.3%. This means the investment grew at an average annual rate of 14.3% compounded yearly.
A reverse CAGR calculator solves for the missing variable when you know the CAGR, time, and either the initial or final value. The formulas are:
For instance, if you want to know what ₹50,000 today will grow to in 10 years at a 12% CAGR, the final value = 50,000 × (1.12)10 ≈ ₹1,55,292. Conversely, if you need ₹2,00,000 in 7 years at 10% CAGR, you need to invest today = 2,00,000 / (1.10)7 ≈ ₹1,02,632. Our calculator above can be used for reverse CAGR by simply entering the known values and leaving the unknown blank — though for simplicity, we provide direct formulas in this guide.
Excel offers multiple ways to compute CAGR. The most straightforward is the RRI function: =RRI(nper, pv, fv). For our example: =RRI(5, 10000, 19500) returns 0.143 (14.3%). Alternatively, use the power formula: =(19500/10000)^(1/5)-1. Another method is the RATE function: =RATE(5, 0, -10000, 19500) (the negative sign for pv indicates cash outflow). If you have irregular cash flows like SIPs, you'd use XIRR instead. For those searching "how to calculate cagr in excel", these three methods are the most common and accurate.
Pro Tip: When using RATE, set pmt=0 for lump sum. For monthly contributions, use XIRR with dates.
Mutual fund returns are often reported as trailing returns (CAGR) for lump sum investments. For example, a fund's 5-year return of 12% means that if you invested a lump sum 5 years ago, your money grew at 12% CAGR. To calculate it yourself: take the NAV (net asset value) from 5 years ago and today. Use the standard CAGR formula. However, if you're investing via SIP (Systematic Investment Plan), CAGR doesn't apply directly — you need XIRR. Many investors search "how to calculate cagr in mutual fund" and find that for lump sum, it's the same formula. Always compare fund returns with benchmark indices to assess performance.
Example: A mutual fund NAV was ₹100 on Jan 1, 2019, and ₹180 on Jan 1, 2024 (5 years). CAGR = (180/100)^(1/5)-1 = 12.5%. That's the annualized return. For SIP, use XIRR or our dedicated SIP calculator.
A reverse CAGR calculator is invaluable for financial planning. Suppose you need $500,000 in 15 years and expect a 10% CAGR. How much must you invest today? Using the reverse formula: Initial = 500,000 / (1.10)^15 = $119,700. Similarly, if you can invest $50,000 today and want it to become $200,000 in 10 years, what CAGR do you need? That's the standard CAGR: (200,000/50,000)^(1/10)-1 = 14.87%.
Mutual fund houses and research platforms display 1-year, 3-year, 5-year returns as CAGR. This standardization allows investors to compare funds across categories. When you see "how to calculate cagr in mutual fund", remember that it's the same formula but applied to NAVs.
CAGR can be negative if the investment loses value. For instance, $1,000 becomes $800 in 3 years → CAGR = (800/1000)^(1/3)-1 = -7.2%. This is still a valid annualized measure.
Example 1: Stock Portfolio
Initial: $25,000, Final after 7 years: $62,500 → CAGR = (62,500/25,000)^(1/7)-1 = 13.9%.
Example 2: Reverse CAGR for Retirement
Target: $1,000,000 in 20 years, expected CAGR = 8%. Required initial investment = 1,000,000 / (1.08)^20 = $214,548.
Q: What is a reverse CAGR calculator used for?
It helps determine the initial investment needed to reach a future goal given a fixed CAGR, or the future value from a known initial amount and CAGR.
Q: How do I calculate CAGR in Excel for multiple years?
Use the RRI function as shown. For a series of yearly returns, you can also use the GEOMEAN function.
Q: Is CAGR the same as annualized return in mutual funds?
Yes, they are synonymous.
Q: Can I use CAGR for monthly investments?
Not directly. For regular monthly investments (SIP), use XIRR.
Finance ToolBajar’s CAGR calculator and this guide are for educational and planning purposes only. They do not constitute financial advice. Actual investment returns may vary due to market conditions, taxes, fees, and other factors. Past performance does not guarantee future results. Always consult a qualified financial advisor before making investment decisions.