How to Master Cagr Calculator [Step-by-Step Guide]
A cagr calculator computes the Compound Annual Growth Rate of any investment by taking the beginning value, ending value, and time period, then outputting a single annualized return percentage. If you invested $10,000 in the S&P 500 in 2014 and it grew to $32,000 by 2024, the CAGR is 12.3%. That one number tells you more about performance than ten annual return figures ever could.
This tutorial walks through every step of using a CAGR calculator, from the basic formula to advanced applications for stock analysis.
Key Takeaways
- CAGR formula: (Ending Value / Beginning Value)^(1/Years) - 1
- CAGR removes year-to-year volatility and shows true compounded growth
- A 10% CAGR doubles your money in approximately 7.2 years (the Rule of 72)
- Always compare CAGR against inflation (historically ~3%) for real returns
- Use CAGR alongside metrics like P/E and ROIC for complete stock analysis
Step 1: Gather Your Investment Data
Before running any calculation, you need three numbers:
Beginning Value is the starting amount of your investment or the stock price at the start date. Use the adjusted closing price if you are calculating stock returns, as it accounts for dividends and splits.
Ending Value is the current or final value. For a portfolio, this is your total account balance. For a stock, use the most recent adjusted closing price.
Number of Years is the time period measured in years. For partial years, convert to decimals. 3 years and 6 months becomes 3.5.
| Variable | Example A | Example B |
|---|---|---|
| Beginning Value | $10,000 | $25.40 (stock price) |
| Ending Value | $18,500 | $67.80 (stock price) |
| Years | 5 | 8 |
| CAGR | 13.1% | 13.0% |
Step 2: Apply the CAGR Formula
The formula is:
CAGR = (Ending Value / Beginning Value)^(1/n) - 1
Working through Example A:
- Divide ending by beginning: $18,500 / $10,000 = 1.85
- Calculate the exponent: 1/5 = 0.2
- Raise the ratio to the power: 1.85^0.2 = 1.1311
- Subtract 1: 1.1311 - 1 = 0.1311
- Convert to percentage: 13.1%
Your $10,000 investment grew at a compound annual rate of 13.1% over 5 years.
Step 3: Interpret the Results
A raw CAGR number means little without context. Compare it against benchmarks.
The S&P 500 has delivered a 10.0% nominal CAGR over the past 50 years. If your portfolio shows a 7% CAGR, you are underperforming the broad market. If it shows 15%, you are significantly outperforming.
Consider these real-world CAGR benchmarks:
| Investment | 10-Year CAGR | 20-Year CAGR |
|---|---|---|
| S&P 500 | ~12.0% | ~10.0% |
| US Bonds (Aggregate) | ~1.5% | ~3.5% |
| Gold | ~8.0% | ~9.0% |
| US Real Estate (REITs) | ~7.0% | ~8.5% |
| Berkshire Hathaway (BRK.B) | ~13.0% | ~10.5% |
Berkshire's P/E of 9.8 and ROIC of 10.2% reflect Buffett's consistent compounding approach. The CAGR confirms what the fundamentals suggest: steady, above-market growth without extreme risk.
Step 4: Account for Inflation
Nominal CAGR overstates your real purchasing power gain. Subtract the inflation rate to get the real CAGR.
Real CAGR = ((1 + Nominal CAGR) / (1 + Inflation Rate)) - 1
With a 12% nominal CAGR and 3% inflation:
Real CAGR = (1.12 / 1.03) - 1 = 8.74%
That 12% feels great until you realize your actual purchasing power only grew at 8.74%. Still solid, but a meaningful difference over 20 or 30 years of compounding.
Step 5: Compare Stocks Using CAGR
The cagr calculator becomes a stock comparison powerhouse when applied to earnings growth.
Take Apple (AAPL) with a P/E of 28.3 and ROIC of 45.1%. The high ROIC suggests Apple reinvests capital at exceptional rates. Calculate the EPS CAGR over the past 5 years to see if the P/E is justified.
Compare that against JPMorgan (JPM) at a P/E of 11.2 and P/B of 1.8. If JPM's earnings CAGR is 8% and Apple's is 15%, the premium P/E for Apple starts to make mathematical sense.
On ValueMarkers, the VMCI Score quantifies this comparison across five pillars: Value (35%), Quality (30%), Integrity (15%), Growth (12%), and Risk (8%). The Growth component directly reflects the kind of CAGR analysis covered here.
Step 6: Use CAGR for Forward Projections
Once you understand historical CAGR, project it forward with caution.
If Visa (V) has generated a 15% earnings CAGR over the past decade, a reasonable (not guaranteed) forward estimate might be 10-12%, reflecting the law of large numbers.
At a current P/E of 29.5 and ROIC of 32.4%, Visa's valuation already bakes in strong growth expectations. Use the ValueMarkers DCF calculator to see if the current price offers a margin of safety given your CAGR assumptions.
Step 7: Avoid These Common CAGR Mistakes
Mistake 1: Confusing CAGR with average annual return. If a stock returns +50% in year 1 and -30% in year 2, the average annual return is 10%. But the CAGR is only 2.47%. Always use CAGR for compounded investments.
Mistake 2: Comparing CAGRs over different time periods. A 20% CAGR over 3 years is not equivalent to a 20% CAGR over 10 years. Longer periods are harder to sustain and more meaningful.
Mistake 3: Ignoring starting point bias. If you start measuring from a market crash bottom, the CAGR will look inflated. If you start from a peak, it looks deflated. Always note the market context at your starting date.
Mistake 4: Not factoring in dividends. A stock with 5% price CAGR and 3% dividend yield actually returned roughly 8% total CAGR. Coca-Cola (KO) at a 3.0% yield is a classic example where ignoring dividends significantly understates total return.
Further reading: Investopedia · CFA Institute
Why CAGR formula Matters
This section anchors the discussion on CAGR formula. The detailed treatment, formula, and worked examples appear in the body of this article above. The points below summarize the most important takeaways for value investors who want to apply CAGR formula in real portfolio decisions. ValueMarkers exposes the underlying data on every covered ticker via the screener and stock profile pages, so the concepts in this article translate directly into actionable filters.
Key inputs for CAGR formula
See the main discussion of CAGR formula in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using CAGR formula alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.
Sector benchmarks for CAGR formula
See the main discussion of CAGR formula in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using CAGR formula alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.
Related ValueMarkers Resources
- DCF Intrinsic Value — DCF captures how cheaply a stock trades relative to its fundamentals
- Margin of Safety — Margin of Safety expresses how cheaply a stock trades relative to its fundamentals
- Pe Ratio — Glossary entry for Pe Ratio
- Reverse Cagr Calculator — related ValueMarkers analysis
- Compound Annual Dividend Growth Rate Calculator — related ValueMarkers analysis
- Successful Saas Platforms Launched 2023 1 Million Revenue Growth Projections — related ValueMarkers analysis
Frequently Asked Questions
what does cagr stand for
CAGR stands for Compound Annual Growth Rate. It represents the annual rate of return that takes compounding into account, smoothing out the effects of volatility over the measurement period. A $10,000 investment reaching $25,937 in 10 years has a CAGR of exactly 10%.
what is cagr in finance
In finance, CAGR is the standard way to express and compare investment returns on an apples-to-apples basis. It eliminates distortions from uneven year-to-year gains and losses by computing the single constant rate that would produce the same final result. Analysts at firms like Morningstar and Bloomberg report CAGR as a primary performance metric.
what does cagr mean
CAGR means the hypothetical constant rate at which an investment would grow each year to reach its ending value from its starting value. It is a geometric mean, not an arithmetic mean, which is why it accurately reflects compounding. A stock going from $50 to $100 over 5 years has a CAGR of 14.87%, regardless of the actual path taken.
what is cagr growth rate
The CAGR growth rate is the annualized compound rate derived from the formula (EV/BV)^(1/n) - 1. For benchmarking, the S&P 500 has a long-term CAGR growth rate of about 10% nominally (7% real). Individual companies like Microsoft with a 35.2% ROIC tend to deliver above-market CAGR growth rates over sustained periods.
what is a good cagr
A good CAGR depends on the asset class, but for equities, anything consistently above 10% annual is strong since it beats the long-term S&P 500 average. Berkshire Hathaway's roughly 20% CAGR over decades is exceptional and rarely replicated. For conservative investors, a 7-8% real (inflation-adjusted) CAGR from a diversified stock portfolio is a solid target.
how do you calculate cagr in excel
In Excel, use the formula =((B2/B1)^(1/C1))-1, where B2 is the ending value, B1 is the beginning value, and C1 is years. Alternatively, use =RATE(C1,0,-B1,B2) for the same result. Format the cell as a percentage. For date-specific calculations, use =(B2/B1)^(365.25/DAYS(D2,D1))-1, where D1 and D2 are your start and end dates.
Written by Javier Sanz, Founder of ValueMarkers
Last updated April 2026
Take your CAGR analysis to the next level by running discounted cash flow models on any stock. Try the ValueMarkers DCF Calculator to combine growth rate projections with intrinsic value estimates across 73 global exchanges.
Ready to find your next value investment?
ValueMarkers tracks 120+ fundamental indicators across 100,000+ stocks on 73 global exchanges. Run the methodology above in seconds with our stock screener, or see today's top-ranked names on the leaderboard.
Related tools: DCF Calculator · Methodology · Compare ValueMarkers
Disclaimer: This content is for informational and educational purposes only and does not constitute investment advice, a recommendation, or an offer to buy or sell any security. Past performance does not guarantee future results. Consult a licensed financial advisor before making investment decisions.