CAGR Calculator

Introduction

The Compound Annual Growth Rate (CAGR) is one of the most widely used metrics in finance for measuring the average annual growth rate of an investment over a specified period longer than one year. [sec-cagr] Unlike simple annual returns, which can be distorted by volatility and large single-year swings, CAGR smooths out all fluctuation and provides a single, comparable growth rate that assumes the investment compounds steadily over time.

Investors use CAGR to compare the historical performance of stocks, mutual funds, exchange-traded funds, and business revenue streams on an equal footing. For example, a stock that grew 30% in year one, declined 10% in year two, and grew 15% in year three has a simple average return of 11.7% but a CAGR of only 10.5%, because the decline in year two reduced the base for future compounding. Financial analysts, portfolio managers, and small business owners rely on CAGR to evaluate whether an investment met its target return, to compare funds with different durations, and to project future values based on historical growth rates.

The CAGR metric is especially useful when comparing investments that have existed for different lengths of time, because it annualizes the return and removes the time advantage of longer-held assets. [finra-investment] CAGR also appears frequently in mutual fund fact sheets, ETF prospectuses, and investment performance reports as the standard measure of historical return. Publicly traded companies often report CAGR of revenue, earnings, or customer metrics in their annual reports and investor presentations to highlight sustained growth trends.

Understanding CAGR is essential for anyone making investment decisions, evaluating business opportunities, or analyzing financial statements, as it provides a consistent and comparable view of growth across different time horizons and asset types.

How to Use

Enter the beginning value of your investment, the ending value at the end of the measurement period, and the total number of years the investment was held. The calculator instantly computes three results: the CAGR as a percentage, the total cumulative return as a percentage, and the total dollar growth. All inputs accept positive numeric values. Use the beginning value as the amount you initially invested, the ending value as the current or final account balance, and the number of years as the exact holding period in years (fractional years are supported). The calculator works for any currency since it processes raw numbers without applying exchange rates.

Example 1 — Stock Investment: You purchased $10,000 worth of a diversified stock fund five years ago, and your account statement now shows a balance of $16,105. Enter 10000 as Beginning Value, 16105 as Ending Value, and 5 as Years. The calculator displays a CAGR of approximately 10.0%, meaning your investment grew at an average annual rate of 10% per year. Total growth is $6,105, and total return is 61.05%. If the broader market index returned 9% annually over the same period, your fund outperformed by one percentage point per year.

Example 2 — Business Revenue Growth: A small business generated $500,000 in revenue three years ago and now generates $850,000. Enter 500000, 850000, and 3. The CAGR is approximately 19.3%, which indicates strong year-over-year growth. Total growth is $350,000. This type of CAGR analysis is commonly used in pitch decks and investor presentations to demonstrate a company's growth trajectory.

Example 3 — Mutual Fund with Short Track Record: A newly launched mutual fund grew from $25,000 to $31,200 in just two years. Enter 25000, 31200, and 2. The CAGR of 11.7% annualized looks impressive, but you should weigh this against the short measurement period. A two-year track record carries less statistical significance than a ten-year record because it encompasses fewer market cycles and may reflect favorable entry timing rather than genuine managerial skill. Financial advisors typically recommend evaluating fund performance over at least five years to distinguish skill from luck.

When to use this calculator: Use the CAGR calculator when you need to compare investments with different holding periods, evaluate the annualized return of a single lump-sum investment, or communicate growth performance in a standardized metric. For investments with regular contributions, consider using IRR instead. For simple interest calculations without compounding, use the simple interest or ROI calculators which provide non-annualized metrics better suited for short-term investments.

The Formula

Where FV is the ending value of the investment, PV is the beginning or present value, and n is the number of years in the measurement period. [investopedia-cagr] The formula first computes the ratio of the ending value to the beginning value, then raises that ratio to the inverse power of the number of years, and finally subtracts one to express the result as a growth rate.

For example, an investment that grows from $10,000 to $16,105 over five years produces a ratio of 1.6105. Raising 1.6105 to the power of 0.2 (one fifth) yields approximately 1.10, and subtracting 1 gives 0.10, or a 10% CAGR. Intuitively, CAGR answers the question: at what constant annual growth rate would the beginning value need to compound each year to reach the observed ending value? This makes CAGR a geometric average rather than an arithmetic average, which is why it correctly accounts for the compounding effect over multiple periods.

You can also rearrange the formula to solve for the future value given a known CAGR: FV = PV times (1 plus CAGR) raised to the power of n. This rearrangement is useful for projecting investment growth forward based on an assumed annual return. The total return can be expressed as ending value divided by beginning value minus one, which represents the cumulative percentage change without annualizing.

Reference Table

The table below shows how different growth trajectories translate into CAGR for a $10,000 investment over various time periods. Notice how the CAGR decreases as the same final value is spread over more years.

Longer periods with the same ending multiple produce lower CAGRs because the growth is spread over more years. A 100% total return over 5 years produces a 14.9% CAGR, while the same return over 10 years yields only a 7.2% CAGR. This inverse relationship between time and annualized return is crucial when evaluating long-term investments. The table also illustrates that a $10,000 investment growing to $30,000 over ten years represents a CAGR of 11.6%, which is roughly in line with long-term equity market averages. When evaluating any investment, compare its CAGR against the appropriate benchmark for the same period to determine whether the investment added alpha or simply tracked the market. A CAGR that significantly exceeds the benchmark over multiple years may indicate superior management or a sustainable competitive advantage, while a shortfall could signal underperformance or excessive fees.

Practical Tips

Use CAGR to compare investments of different durations on an even footing. A fund that returned 50% over three years (14.5% CAGR) outperformed one that returned 80% over five years (12.5% CAGR) on an annualized basis, even though the second fund had a higher total return. [finra-investment] Be aware that CAGR does not reflect risk or volatility: two investments with the same CAGR could have very different year-to-year fluctuations. Always evaluate CAGR alongside other metrics like standard deviation, Sharpe ratio, and maximum drawdown.

For short-term periods under one year, CAGR can be misleading because it annualizes partial-year returns. Consider using simple cumulative return for periods shorter than 12 months. When evaluating mutual funds, always use NAV-to-NAV returns with dividends reinvested to get an accurate CAGR. [sec-mutual-fund] For business metrics, use consistent fiscal year boundaries to avoid partial-year distortions. Compare CAGR against an appropriate benchmark index to determine whether the investment added value relative to a passive strategy. For portfolio analysis, consider the weighted average CAGR of all holdings to assess overall portfolio performance.

Limitations

CAGR assumes steady compounding and does not account for contributions or withdrawals during the period. If you added money to an investment over time, the CAGR calculation will not reflect your actual dollar-weighted return. CAGR also ignores taxes, fees, and inflation, which can significantly reduce real purchasing power.

For dividend-paying stocks, CAGR of share price alone does not capture total shareholder return. Use total return figures that include reinvested dividends for a complete picture. Past CAGR does not guarantee future performance. [sec-cagr] For investments with high volatility, the CAGR will always be lower than the arithmetic average return, and the difference between the two is a rough measure of volatility drag.

Finally, CAGR applied to very short periods (under one year) should be interpreted with caution, as annualizing partial-year returns assumes the same growth rate will persist for the remainder of the year. When using CAGR for business planning, remember that revenue growth rates often decline as companies mature, so historical CAGR may overstate future potential for established businesses. [bogle-common-sense]

Frequently Asked Questions

❓ What is a good CAGR?

✅ A good CAGR depends on the asset class and market conditions. Historically, the S&P 500 has delivered an average CAGR of approximately 10% before inflation over the long term. Bonds typically yield 3-5%, while small-cap stocks or emerging market investments may show higher CAGRs with greater volatility.

❓ How is CAGR different from average return?

✅ Average return simply divides total return by the number of years, which ignores compounding. CAGR accounts for compounding and is always lower than or equal to the simple average return when returns vary year to year. For example, an investment returning +40% then -20% has a 10% average return but a CAGR of 5.8%.

❓ Can CAGR be negative?

✅ Yes. If an investment loses value over the measurement period, the CAGR will be negative. A negative CAGR indicates the investment declined on an annualized basis, which is common during bear markets or for poorly performing assets.

❓ What is the difference between CAGR and IRR?

✅ CAGR assumes a single initial investment with no intermediate cash flows. IRR (Internal Rate of Return) handles investments with multiple cash flows over time, such as regular contributions or withdrawals. For a simple buy-and-hold investment with no additions, CAGR and IRR will match.

❓ How do I calculate CAGR in Excel?

✅ Use the RRI function: =RRI(n, PV, FV) where n is the number of periods, PV is the present value, and FV is the future value. Alternatively, use =(FV/PV)^(1/n)-1 directly.

❓ Does CAGR include dividends?

✅ Only if you include reinvested dividends in the ending value. To account for dividends, use the total return ending value that assumes dividends were reinvested in additional shares.

❓ Why use CAGR instead of simple growth?

✅ CAGR normalizes returns across different time periods, letting you compare a 3-year investment with a 10-year investment on equal footing. Simple growth percentages are not comparable across different time horizons.