CAGR Calculator: Calculate Compound Annual Growth Rate
Use this compound annual growth rate calculator to determine the constant annualized return of an investment, business revenue, or asset value over any multi-year period. Enter your starting balance, ending balance, and the time horizon in years to calculate your CAGR, absolute gain, and growth multiple instantly.
⚡ CAGR Calculator at a Glance
CAGR (Compound Annual Growth Rate) is the constant annual growth rate that would take an initial value to a final value over a specified period, assuming annual compounding. It provides a level baseline for comparing the growth of mutual funds, stocks, real estate, or corporate revenues across different time horizons.
For example, if ₹1,00,000 grows to ₹2,00,000 over 5 years, the CAGR is approximately 14.87% per year.
Keep in mind that this does not mean the investment earned exactly 14.87% every year. Markets fluctuate, so individual calendar years may have produced gains of 25%, losses of 10%, or flat returns. CAGR is a smoothed annualized measure based strictly on your starting value, ending value, and total holding period.
- 1. What Is CAGR?
- 2. How Does a CAGR Calculator Work?
- 3. CAGR Formula
- 4. How to Calculate CAGR Step by Step
- 5. CAGR Calculation Example
- 6. What Does a CAGR Percentage Mean?
- 7. CAGR vs Absolute Return
- 8. CAGR vs XIRR: Which Should You Use?
- 9. CAGR vs Average Annual Return
- 10. CAGR for Mutual Funds
- 11. CAGR for Stocks
- 12. CAGR for Business Revenue and Profit
- 13. CAGR and Inflation (Nominal vs Real)
- 14. How to Use CAGR to Estimate Future Value
- 15. Where CAGR Is Used
- 16. Limitations of CAGR
- 17. Common CAGR Calculation Mistakes
- 18. How to Calculate CAGR in Excel
- 19. Frequently Asked Questions
- 20. Final Takeaway
1. What Is CAGR?
CAGR stands for Compound Annual Growth Rate. It measures the steady yearly rate at which an investment, business metric, or asset balance grows from an initial starting point to an ending balance over multiple years.
In everyday finance, market investments rarely advance in a straight line. Stocks rise and drop, mutual funds react to economic conditions, and property values shift across market cycles. If you only look at your total percentage gain, comparing an asset held for three years against one held for seven years becomes confusing.
CAGR solves this problem through annualization. It translates uneven historical gains into a single uniform percentage rate. Instead of describing actual annual returns, CAGR represents the constant annualized growth rate implied by the beginning value, ending value, and time period.
2. How Does a CAGR Calculator Work?
A CAGR calculator takes three specific data points to find your annualized growth:
Starting Value (Initial Investment)
This is the total capital initially committed or the baseline price at the start of your measurement window. It represents your opening balance.
Ending Value (Final Balance)
This is the total value of the asset at the end of the specified time frame, after all gains or losses have taken place.
Investment Period (Holding Duration in Years)
This is the total elapsed time between your starting date and ending date, measured in years (including fractional years such as 3.5 years).
The calculator combines these three inputs using compound interest geometry. It calculates the exact geometric rate connecting your starting balance to your ending balance across that duration.
3. CAGR Formula
The mathematics behind CAGR uses the standard compound growth relationship:
To express this result as a percentage, multiply by 100:
CAGR Formula Explained
The formula first divides the ending balance by the starting balance. This gives the total growth multiple over the whole holding period. Next, it raises that multiple to the power of 1 / n. This calculation extracts the geometric mean for a single year. Finally, subtracting 1 isolates the pure annual growth percentage.
What Each Variable Means
- Ending Value (Final Balance): The closing valuation of your portfolio, stock, or business balance.
- Beginning Value (Initial Investment): The starting cost basis or capital initially allocated.
- n: The total duration in years between the two valuations.
4. How to Calculate CAGR Step by Step
Here is a practical calculation walking through each step of the formula:
Worked Example Parameters
Initial Investment: ₹1,00,000
Final Portfolio Value: ₹2,00,000
Holding Duration: 5 Years
-
Step 1: Divide final value by initial value.
₹2,00,000 / ₹1,00,000 =2.0(The investment doubled). -
Step 2: Raise the ratio to the power of 1 divided by the years (1 / 5 = 0.20).
(2.0)0.20 ≈1.148698 -
Step 3: Subtract 1 from the result.
1.148698 - 1 =0.148698 -
Step 4: Convert the decimal into a percentage.
0.148698 × 100 = 14.87%
The resulting 14.87% figure is a smoothed annual growth rate. It does not mean the investment increased by exactly 14.87% in each individual year. Instead, earning a steady 14.87% every year would produce the exact same ₹2,00,000 outcome over five years.
5. CAGR Calculation Example
To visualize how compounding operates behind a 14.87% CAGR, review this year-by-year illustrative trajectory for an initial ₹1,00,000 investment:
| Timeline | Opening Capital | Implied Growth Rate | Yearly Compounded Gain | Closing Balance |
|---|---|---|---|---|
| Start | — | — | — | ₹1,00,000 |
| Year 1 | ₹1,00,000 | 14.87% | +₹14,870 | ₹1,14,870 |
| Year 2 | ₹1,14,870 | 14.87% | +₹17,081 | ₹1,31,951 |
| Year 3 | ₹1,31,951 | 14.87% | +₹19,621 | ₹1,51,572 |
| Year 4 | ₹1,51,572 | 14.87% | +₹22,539 | ₹1,74,111 |
| Year 5 | ₹1,74,111 | 14.87% | +₹25,889 | ₹2,00,000 |
Illustrative constant-growth path implied by the CAGR. It is not necessarily the investment's actual year-by-year performance.
6. What Does a CAGR Percentage Mean?
Evaluating a CAGR figure requires understanding the mathematical pace of wealth accumulation:
- 10% CAGR: At a 10% annualized pace, your invested capital doubles in approximately 7.2 years according to the Rule of 72 (72 / 10 = 7.2). Over 20 years, an initial ₹1,00,000 grows to roughly ₹6,72,750.
- 15% CAGR: At a 15% annualized pace, your capital doubles in about 4.8 years. Over a 10-year span, your money grows more than fourfold (₹1,00,000 becomes roughly ₹4,04,555).
- 20% CAGR: At a 20% annualized pace, your capital doubles in 3.6 years. Sustaining a 20% CAGR over a decade expands an initial ₹1,00,000 into roughly ₹6,19,173.
- Negative CAGR: If you invest ₹1,00,000 and the balance drops to ₹70,000 over 3 years, your CAGR is -11.21%. A negative CAGR highlights the annual compounding rate of capital loss.
Whether a specific CAGR is attractive depends on the asset class, holding period, benchmark performance, inflation, taxes, fees, and level of risk. Comparing a 12% equity CAGR against a 7% fixed deposit return without accounting for stock market drawdowns ignores the fundamental relationship between risk and reward.
7. CAGR vs Absolute Return
Investors frequently confuse absolute return with CAGR. While both describe gains, they answer different financial questions.
| Metric | CAGR | Absolute Return |
|---|---|---|
| What It Measures | Annualized compounded growth rate | Total cumulative percentage change |
| Considers Time? | Yes (Duration in years is central) | No (Time passed is ignored) |
| Accounts for Compounding? | Yes | No |
| Best Used For | Multi-year point-to-point comparisons (> 1 year) | Short-term holdings (< 1 year) or total gain overview |
| Doubling Money Example | 14.87% per year over 5 years | 100% total gain regardless of years |
Consider an investment that grows from ₹1,00,000 to ₹2,00,000:
- The absolute return is always 100%:
[(2,00,000 - 1,00,000) / 1,00,000] × 100. - If that doubling occurs over 3 years, the CAGR is 25.99%.
- If that doubling takes 5 years, the CAGR is 14.87%.
- If that doubling takes 10 years, the CAGR is 7.18%.
Both the 100% absolute return and the 14.87% CAGR are mathematically accurate. Absolute return tells you total growth, while CAGR tells you annual speed. To calculate pure percentage changes without compounding, use our Percentage Calculator.
8. CAGR vs XIRR: Which Should You Use?
One of the most frequent dilemmas for mutual fund and equity investors is choosing between CAGR and XIRR.
| Investment Scenario | Recommended Calculation Method | Reason |
|---|---|---|
| One lumpsum deposit → One final balance | CAGR | Single start and end point; no intermediate transactions. |
| Monthly Systematic Investment Plan (SIP) | XIRR | Each installment is invested for a different length of time. |
| Multiple staggered deposits | XIRR | Cash enters the portfolio on multiple calendar dates. |
| Occasional withdrawals or dividend payouts | XIRR | Accounts for cash leaving the account during the journey. |
| Total percentage gain overview | Absolute Return | Provides total gain without annualizing by duration. |
When to Use CAGR
Use CAGR when evaluating a single lump-sum investment held untouched between two dates. For instance, if you purchase shares worth ₹50,000 on June 1, 2020, and sell them on June 1, 2025, for ₹95,000 without adding or withdrawing cash, CAGR provides the exact annualized metric.
When to Use XIRR
Use XIRR (Extended Internal Rate of Return) when cash flows happen on multiple dates. If you invest ₹10,000 every month in a mutual fund, each installment has a different holding period. Your first monthly installment compounds for 60 months, but your final installment compounds for only 1 month.
CAGR vs XIRR Example
Because basic CAGR formula only accepts one starting value and one ending value, it cannot account for multiple deposit dates. Applying CAGR to the sum of your SIP installments yields an inaccurate, distorted figure. For systematic investing, explore our guide on SIP vs Lumpsum Investing.
9. CAGR vs Average Annual Return
Many investors mistakenly calculate average return by adding individual yearly returns and dividing by the number of years. This arithmetic average overlooks the mathematics of compounding and creates misleading expectations.
The Volatility Drag Example
Suppose you invest ₹100 in a stock fund for two years:
- Year 1: The fund surges by +50%. Your balance reaches ₹150.
- Year 2: The fund drops by -50%. A 50% loss on ₹150 reduces your balance to ₹75.
Arithmetic Average: (+50% - 50%) / 2 = 0.0% per year.
Actual Reality: You started with ₹100 and ended with ₹75, suffering a -25% total loss.
True CAGR: (75 / 100)(1/2) - 1 = -13.40% per year.
The arithmetic average suggests you broke even at 0%, but your actual wealth contracted at an annualized rate of -13.40%. This gap demonstrates why compounding matters and why CAGR is essential for assessing volatile assets.
10. CAGR for Mutual Funds
Mutual fund fact sheets routinely display 1-year, 3-year, 5-year, and since-inception CAGR figures.
Fund houses calculate these numbers by comparing point-to-point Net Asset Value (NAV). In growth-option mutual funds, all dividends and interest are retained within the scheme, so the NAV reflects true compound capital growth.
Keep in mind that published fund CAGR represents the performance of an initial lump-sum investment held across the entire period. If you entered or exited at intermediate dates or invested via systematic plans, your personal return will differ from the scheme's published CAGR.
11. CAGR for Stocks
CAGR can measure the long-term price appreciation of individual equities. Suppose you purchased shares of an enterprise for ₹2,00,000, and five years later the position is valued at ₹3,50,000:
A simple price-based CAGR does not automatically capture dividends, brokerage commissions, or capital gains taxes unless those cash flows are included in the valuations. For dividend-paying equities, evaluating Total Shareholder Return (TSR) provides a more complete assessment than share price CAGR alone.
12. CAGR for Business Revenue and Profit
CAGR is widely used beyond personal investing. Corporate leaders, equity analysts, and founders apply CAGR to measure business growth trends over multi-year windows:
- Annual Revenue Growth: If a company expands top-line revenue from ₹10 crore to ₹20 crore over five years, its revenue CAGR is 14.87%.
- Operating Profit Expansion: Tracking EBITDA or net profit CAGR demonstrates whether a business scales earnings faster than expenses.
- Customer & Subscriber Acquisition: Subscription platforms track active customer CAGR to evaluate organic expansion.
- Industry & Market Sizing: Market research firms report sector forecasts in CAGR to summarize expected annual industry expansion.
13. CAGR and Inflation: What Is Real Growth?
When evaluating investment performance over long horizons, nominal growth can create an illusion of wealth. Inflation steadily chips away at the purchasing power of your money.
Nominal CAGR
Nominal CAGR is the raw percentage return calculated directly from your opening and closing balances, before any adjustment for inflation.
Real CAGR
Real CAGR measures your growth in actual purchasing power. Rather than subtracting inflation, financial economists use the Fisher equation to calculate exact real returns:
For instance, if your portfolio delivers a 12% nominal CAGR while inflation averages 6% over the same decade:
Your actual purchasing power grew at 5.66% per year, not 12%. To see how inflation alters future purchasing power, use our dedicated Inflation Calculator Guide.
14. How to Use CAGR to Estimate Future Value
You can invert the CAGR formula to project how much a current portfolio could become if an assumed annual rate continues:
Suppose you hold ₹1,00,000 today and assume an illustrative 10% annual growth rate over 10 years:
This projection is a mathematical estimate assuming constant compounding. It does not constitute a guarantee of future performance. For compound growth schedules with periodic additions, explore our Compound Interest Calculator and Investment Calculator.
15. Where CAGR Is Used
CAGR serves as a practical financial ruler across multiple industries:
- Mutual Fund & ETF Comparison: Comparing 3-year, 5-year, and 10-year fund categories.
- Stock Portfolio Review: Assessing point-to-point share price performance.
- Real Estate Appraisal: Calculating annualized property value appreciation between purchase and sale.
- Retirement Planning: Projecting long-term corpus growth needed to fund living expenses using our Retirement Corpus Calculator.
- Corporate Finance: Benchmarking revenue, profit margins, and operating cash flow growth against competitors.
- Macroeconomic Data: Measuring GDP, energy consumption, and trade volume growth over decades.
16. Limitations of CAGR
While CAGR is a widely used benchmark, relying on it blindly can lead to poor financial decisions. Keep these limitations in mind:
- CAGR Hides Volatility: Two mutual funds can share an identical 12% 5-year CAGR. Fund A might gain a steady 12% each year, while Fund B drops 30% in year two before recovering. CAGR reveals nothing about drawdown risk or emotional stress along the journey.
- CAGR Ignores Intermediate Cash Flows: CAGR cannot process periodic monthly additions or partial withdrawals. For irregular flows, XIRR is the required metric.
- CAGR Does Not Measure Risk: A high-risk speculative portfolio and a diversified balanced fund may deliver similar 3-year CAGRs, but the speculative fund carries far greater downside danger.
- Taxes and Transaction Fees Are Excluded: Unless balances reflect net-of-tax proceeds, raw CAGR overstates what you keep in your bank account.
- CAGR Is Backward-Looking: Historical CAGR reflects past performance and provides no guarantee of future returns.
- CAGR Does Not Reflect Liquidity: An illiquid private asset and a publicly traded ETF may both report a 10% CAGR, but the ETF can be sold instantly while the private asset may take months to exit.
17. Common CAGR Calculation Mistakes
Avoid these seven frequent calculation errors:
- Dividing Total Return by Years: If an investment grows 100% in 5 years, dividing 100 by 5 yields 20%. That simple average ignores compounding; the true CAGR is 14.87%.
- Using CAGR for SIP Investments: Applying CAGR to systematic recurring deposits produces a distorted number because cash entered on different dates.
- Miscounting the Holding Period: Calculating years using rounded calendar estimates rather than exact days reduces precision.
- Expecting Steady Annual Growth: Treating CAGR as a guaranteed annual return sets unrealistic expectations for market investments.
- Projecting Past CAGR Indefinitely: Assuming a fund's previous 5-year CAGR of 18% will continue for the next 20 years leads to severe retirement planning shortfalls.
- Comparing Assets Without Considering Fees & Risk: Comparing gross fund returns without subtracting expense ratios or risk levels yields flawed comparisons.
- Confusing Absolute Return with CAGR: Quoting a 150% return without stating the holding period obscures the investment's actual annual performance.
18. How to Calculate CAGR in Excel
You can calculate compound annual growth rate in Microsoft Excel or Google Sheets using standard spreadsheet math:
For example, if your starting value of ₹1,00,000 sits in cell B2, your ending value of ₹2,00,000 sits in cell C2, and your holding duration of 5 years sits in cell D2, enter:
Format the result cell as a Percentage with two decimal places to display 14.87%.
Alternatively, Excel offers the built-in RRI function, which calculates the equivalent compound rate:
19. Frequently Asked Questions
CAGR stands for Compound Annual Growth Rate. It represents the constant annual growth rate required for an initial balance to reach an ending balance over a specified number of years, assuming compounding.
CAGR is a smoothed annual growth number. Instead of looking at uneven ups and downs every single year, CAGR tells you the single steady yearly percentage that connects your starting money to your ending money.
CAGR is calculated by dividing your ending value by your starting value, raising that ratio to the power of 1 divided by the number of years, subtracting 1, and multiplying by 100 to get a percentage.
The formula is CAGR = (Ending Value / Beginning Value)^(1 / n) - 1, where n is the number of years between the two balances.
Absolute return measures total percentage growth regardless of how much time passed. CAGR measures the annualized compound growth per year. Doubling your money is a 100% absolute return, but over 5 years that equals a 14.87% CAGR, whereas over 10 years it equals a 7.18% CAGR.
No. Annual return measures actual performance in one specific calendar year, which can be positive or negative. CAGR is a smoothed multi-year average rate that connects the start and end values.
Yes. If your ending balance is lower than your initial balance, the CAGR is negative, showing the annualized rate of capital decline over that period.
No. CAGR is designed for a single lump-sum starting amount and a single ending value. For monthly SIPs or irregular deposits on multiple dates, XIRR (Extended Internal Rate of Return) should be used instead.
CAGR evaluates a single point-to-point investment period. XIRR evaluates multiple cash flows occurring on different calendar dates, calculating the annualized internal rate of return across all contributions and withdrawals.
Standard CAGR calculates nominal growth before inflation. To find your real purchasing power growth, adjust your nominal CAGR by the inflation rate using the Fisher relationship: Real Return = [(1 + Nominal CAGR) / (1 + Inflation Rate)] - 1.
In Excel, enter =(Ending_Cell / Starting_Cell)^(1 / Years_Cell) - 1, and format the cell as a percentage. You can also use the built-in RRI formula: =RRI(Years, Starting_Value, Ending_Value).
Not necessarily. A higher CAGR often involves higher price volatility, deeper drawdowns, or illiquidity. Sound evaluation compares CAGR against relevant benchmarks, inflation rates, fees, taxes, and downside risks.
20. Final Takeaway
CAGR Calculator: Key Takeaway
CAGR converts a start-to-end change into a single annualized growth rate. It is useful for comparing multi-year point-to-point growth, but it does not show the actual year-by-year path and is not designed for investments with multiple cash flows. For SIPs and irregular contributions or withdrawals, use XIRR instead.
- Securities and Exchange Board of India (SEBI): Mutual fund performance reporting guidelines and standardized CAGR computation norms. sebi.gov.in
- U.S. Securities and Exchange Commission (SEC): Investor education bulletin on compound interest, geometric means, and portfolio evaluation. sec.gov
- CFA Institute: Quantitative Methods curriculum — Time value of money, geometric mean return vs arithmetic mean return. cfainstitute.org
- Reserve Bank of India (RBI): Financial education resources on compound interest and annualized inflation benchmarks. rbi.org.in
- Investopedia Financial Analysis Standards: Compound Annual Growth Rate (CAGR) definitions, formulas, and limitations. investopedia.com