Last Updated: February 2026 โข 25 min read
Compound Annual Growth Rate (CAGR): Complete Guide
The Compound Annual Growth Rate (CAGR) is the smoothed annual rate of return that an investment would need to grow from its beginning value to its ending value over a specific time period. Unlike simple average returns, CAGR accounts for compounding and gives you a single, clean number to evaluate investment performance. Whether you are analyzing stock market returns, business revenue growth, or portfolio performance, CAGR provides the most accurate picture of true annualized growth.
- CAGR measures the smoothed annual growth rate of an investment over time
- Formula: CAGR = (Ending Value / Beginning Value)1/n - 1
- S&P 500 CAGR: Approximately 10.2% annually from 1957-2024 (before inflation)
- CAGR vs. average return: CAGR is always lower because it accounts for compounding and volatility
- Key limitation: CAGR ignores volatility and interim cash flows
- Use our CAGR calculator to calculate growth rates instantly
What Is CAGR and How Does It Differ from Average Return?
CAGR stands for Compound Annual Growth Rate. It is the industry-standard metric used in SEC filings, FINRA investor resources, and investment prospectuses worldwide. CAGR represents the rate at which an investment would have grown if it had grown at a steady, constant rate every year. In reality, investments fluctuate wildly, sometimes gaining 25% one year and losing 15% the next. CAGR smooths out this volatility to give you a single annual growth rate that precisely captures your actual wealth accumulation.
The critical distinction between CAGR and simple average return lies in how they handle the mathematics of compounding. Average return is an arithmetic mean: add up all the yearly returns and divide by the number of years. CAGR is a geometric mean: it calculates the single constant rate that would produce the same ending value through compound growth. This distinction has profound practical implications for investors.
Consider a practical example: an investment gains 50% in year one and loses 33% in year two. The arithmetic average return is (50% - 33%) / 2 = 8.5%. But what actually happened? Starting with $10,000, after year one you have $15,000. After year two (losing 33%), you have $10,050. Your actual CAGR over two years is a mere 0.25%, not 8.5%. This gap between average return and CAGR is called "volatility drag" or "variance drain," and it explains why volatile investments often disappoint investors who focus on average returns rather than compound growth.
According to Investopedia, CAGR is particularly valuable because it allows fair comparisons between investments with different time horizons and volatility profiles. A real estate investment with 6% CAGR over 15 years can be meaningfully compared against a tech stock with 12% CAGR over 5 years, something impossible with simple percentage returns.
Why CAGR Matters for Your Financial Decisions
- Comparing investments: CAGR lets you compare returns from stock investments and other assets with different time horizons and volatility patterns on an apples-to-apples basis
- Setting expectations: Historical CAGR helps you set realistic expectations for future returns. See our compound interest guide for a broader overview
- Business growth: Companies use CAGR to measure revenue growth, customer growth, and market expansion
- Financial planning: Retirement calculators like our 401(k) calculator and financial models use CAGR to project future values
- Performance benchmarking: Fund managers and analysts report CAGR to benchmark against indices and competitors
The CAGR Formula Explained Step by Step
Understanding the CAGR formula is essential for any serious investor. The formula derives from the fundamental compound interest formula, solved algebraically for the growth rate. While it may look intimidating at first glance, each component has a clear meaning, and mastering it will transform how you analyze investments.
Where:
- FV = Final value (ending balance) - what your investment is worth at the end
- PV = Present value (beginning balance) - what you started with
- n = Number of years - the time period of your investment
- 1/n = The inverse of years, which creates the "nth root" mathematically
Let us break down the mathematical logic. When you divide FV by PV, you get the total growth multiple (how many times your money multiplied). Raising this to the power of 1/n extracts the annual component of that growth. Subtracting 1 converts from a growth factor to a rate. For example, a growth factor of 1.08 means 8% growth.
Step-by-Step Calculation Example
You invested $10,000 in 2015 and it's worth $25,000 in 2025 (10 years later). What's the CAGR?
PV = $10,000 (starting balance)
n = 10 years (investment period)
(Your money multiplied 2.5 times)
(This extracts the per-year growth factor)
(Convert growth factor to percentage rate)
The CAGR is 9.60%. This means your investment grew at an equivalent constant rate of 9.60% per year over the 10-year period. If you had invested $10,000 at exactly 9.60% compounded annually for 10 years, you would end with exactly $25,000.
Quick Reference: CAGR Calculation Examples
| Starting Value | Ending Value | Years | Growth Multiple | CAGR |
|---|---|---|---|---|
| $5,000 | $10,000 | 7 | 2.00x | 10.41% |
| $10,000 | $15,000 | 5 | 1.50x | 8.45% |
| $25,000 | $100,000 | 15 | 4.00x | 9.68% |
| $50,000 | $200,000 | 20 | 4.00x | 7.18% |
| $100,000 | $1,000,000 | 30 | 10.00x | 8.01% |
| $10,000 | $7,500 | 5 | 0.75x | -5.59% |
Notice that the same growth multiple (4.00x) produces different CAGRs depending on the time frame: 9.68% over 15 years versus 7.18% over 20 years. Time is the critical denominator in compound growth.
When to Use CAGR vs. Other Metrics
CAGR is powerful, but it is not the right tool for every situation. Understanding when to use CAGR versus alternative metrics like IRR (Internal Rate of Return), TWR (Time-Weighted Return), or simple ROI will make you a more sophisticated analyst. The SEC provides guidance on interpreting different return metrics.
Use CAGR When:
- Analyzing lump-sum investments: You invested a single amount and want to know the annualized return
- Comparing assets with different holding periods: A 3-year and 10-year investment can be compared fairly
- Evaluating business growth: Revenue, users, or market size over time
- Setting long-term expectations: What growth rate should you assume for retirement planning?
- Benchmarking against indices: How did your portfolio CAGR compare to the S&P 500 CAGR?
Use IRR (Internal Rate of Return) When:
- Multiple cash flows exist: Regular investments, dividends reinvested, or partial withdrawals
- Evaluating a 401(k) or IRA: Where you contribute periodically
- Analyzing real estate: With rental income and ongoing expenses
- Project finance: Where timing of cash flows matters significantly
CAGR vs. Other Metrics Comparison
| Metric | Best For | Handles Multiple Cash Flows? | Time-Normalized? | Complexity |
|---|---|---|---|---|
| CAGR | Lump-sum investments, benchmarking | No | Yes (annual) | Simple |
| IRR | Portfolios with contributions/withdrawals | Yes | Yes (annual) | Moderate |
| TWR | Fund manager performance | Neutralizes them | Yes (any period) | Complex |
| ROI | Total return without time context | No | No | Simple |
| Average Return | Understanding typical year | No | No (misleading) | Simple |
For most individual investors analyzing their investment compound interest over time, CAGR provides the clearest picture of wealth accumulation from a starting point to an ending point.
CAGR for Different Investment Types
Different asset classes exhibit dramatically different CAGR profiles over time. Understanding these typical ranges helps you set appropriate expectations and recognize when a claimed return seems too good to be true. Data from the Federal Reserve and academic research consistently show these long-term patterns.
Stocks and Equity Investments
Equity investments have historically delivered the highest long-term CAGR among mainstream asset classes, compensating investors for higher volatility and risk. The S&P 500, representing large U.S. companies, has delivered approximately 10% nominal CAGR since 1957 (about 7% after inflation). However, this average masks enormous variation: the decade from 2000-2009 (the "lost decade") produced essentially 0% CAGR for U.S. large caps, while 2010-2019 delivered over 13% CAGR.
Small-cap stocks have historically produced slightly higher CAGR (around 11-12%) with substantially higher volatility. International developed market stocks typically lag U.S. stocks with 6-8% CAGR, while emerging markets offer higher potential (8-12% CAGR) with much greater risk. Use our stock investment calculator to model different scenarios.
Bonds and Fixed Income
Bond CAGR typically ranges from 3-6% for investment-grade securities. U.S. Treasury bonds have averaged about 5% nominal CAGR since 1928, though the 40-year bull market in bonds (1981-2021) produced higher returns that are unlikely to repeat from current yield levels. High-yield ("junk") bonds offer higher CAGR potential (6-8%) with credit risk approaching equity-like volatility.
Real Estate
Direct real estate investment (your home or rental property) has historically delivered 3-4% CAGR for property appreciation alone. Including rental income, total returns approach 7-10% CAGR, though with significant illiquidity and transaction costs. REITs (Real Estate Investment Trusts) have delivered 9-11% CAGR historically, combining income and appreciation in a liquid, tradable form.
Historical CAGR by Asset Class (1926-2024)
| Asset Class | Nominal CAGR | Real CAGR (Inflation-Adjusted) | Volatility (Std Dev) | Worst 10-Year CAGR |
|---|---|---|---|---|
| U.S. Large Cap Stocks | 10.2% | 7.0% | 18.5% | -1.4% (2000-2009) |
| U.S. Small Cap Stocks | 11.8% | 8.6% | 28.5% | -5.7% (1929-1938) |
| International Stocks | 7.5% | 4.5% | 22.0% | -4.2% (2000-2009) |
| Long-Term Govt Bonds | 5.5% | 2.5% | 9.5% | -2.0% (1950-1959) |
| Corporate Bonds | 5.9% | 2.9% | 8.5% | 1.5% (1969-1978) |
| Gold | 5.8% | 2.8% | 19.5% | -6.5% (1988-1997) |
| Cash/T-Bills | 3.3% | 0.3% | 3.0% | 0.5% (multiple) |
| Inflation (CPI) | 3.0% | -- | 4.0% | -- |
Note the "Worst 10-Year CAGR" column: even asset classes with strong long-term records can produce negative or near-zero returns for extended periods. This underscores the importance of diversification and appropriate time horizons for different goals.
CAGR vs. Average Annual Return
Many people confuse CAGR with average annual return. They are fundamentally different, and the distinction matters critically for investment planning and realistic expectations.
The Volatility Drag Problem
Consider an investment that goes up 50% in Year 1 and down 50% in Year 2:
Year 2: $15,000 x 0.50 = $7,500 (-50%)
Average return: (50% + (-50%)) / 2 = 0%
Actual result: Lost $2,500 (โ25%)
CAGR: ($7,500/$10,000)1/2 - 1 = โ13.40%
The average return says 0%, but you actually lost money. CAGR correctly shows the -13.40% annual rate that reflects reality. This difference between average return and actual compounded return is called volatility drag or variance drain.
CAGR vs. Average Return: Side-by-Side Comparison
| Metric | Average Return | CAGR |
|---|---|---|
| Definition | Arithmetic mean of annual returns | Geometric mean (compounded) return |
| Accounts for compounding | No | Yes |
| Reflects actual growth | Not always | Always |
| Affected by volatility | No | Yes (always lower with volatility) |
| Better for projections | No | Yes |
| Relationship | Always >= CAGR | Always <= Average |
| Used in marketing | Often (looks better) | Less often (more accurate) |
Real-World Impact of Volatility Drag
| Scenario | Year 1 | Year 2 | Year 3 | Average Return | Actual CAGR | Gap |
|---|---|---|---|---|---|---|
| Low volatility | +8% | +10% | +9% | 9.00% | 8.99% | 0.01% |
| Medium volatility | +20% | -5% | +15% | 10.00% | 9.24% | 0.76% |
| High volatility | +40% | -20% | +25% | 15.00% | 12.16% | 2.84% |
| Extreme volatility | +60% | -40% | +50% | 23.33% | 11.87% | 11.46% |
As volatility increases, the gap between average return and CAGR widens dramatically. An investment with 23.33% average annual return actually delivered only 11.87% CAGR due to extreme volatility. This is why professional investors focus on risk-adjusted returns rather than raw averages.
Limitations of CAGR Every Investor Should Know
While CAGR is an excellent metric for evaluating investment performance, it has important limitations that can mislead investors who rely on it exclusively. The FINRA investor education resources emphasize understanding these limitations for making informed decisions.
1. CAGR Ignores Volatility and Risk
Two investments can have identical CAGRs but radically different risk profiles. Investment A might steadily grow 8% every single year with minimal fluctuation. Investment B might swing wildly from -30% to +50% in different years but end up at the same point. CAGR treats them as identical performers, but Investment A provided a much smoother ride and lower risk of catastrophic loss if you needed to withdraw at an inopportune time. For risk-adjusted comparisons, metrics like the Sharpe ratio or Sortino ratio supplement CAGR analysis.
2. CAGR Is Highly Sensitive to Start and End Points
Because CAGR only considers two data points (beginning and ending values), it can be manipulated or accidentally distorted by unusual start/end timing. The S&P 500 CAGR from March 2009 (the Great Recession bottom) to January 2022 (pre-correction peak) was approximately 16%. Measured from January 2000 (dot-com peak) to March 2009 (recession bottom), it was approximately -6%. Neither figure represents the "true" long-term expected return. Always consider whether your measurement period begins or ends at an extreme point.
3. CAGR Cannot Handle Interim Cash Flows
If you made additional investments or withdrawals during the holding period, standard CAGR does not account for these. Consider: you invest $10,000, it grows to $12,000, you add another $10,000, and the combined $22,000 grows to $30,000. What is your CAGR? The formula does not work cleanly because money entered at different times. For portfolios with ongoing contributions (like 401(k) accounts), Internal Rate of Return (IRR) or money-weighted return is the appropriate metric.
4. Past CAGR Does Not Predict Future Returns
Perhaps the most dangerous misuse of CAGR is assuming historical rates will continue. A stock with 25% CAGR over the past 5 years might be significantly overvalued and return -5% over the next 5 years. CAGR is strictly backward-looking and should never be the sole basis for investment decisions. The SEC requires mutual funds to include "past performance is no guarantee of future results" disclaimers for this reason.
5. CAGR Assumes Reinvestment of All Returns
CAGR calculations implicitly assume that all dividends, interest, and other distributions are reinvested at the same rate of return. In practice, dividends might be spent or reinvested at different rates. For income-focused investors who spend their dividends, the "price return" CAGR (excluding dividends) may be more relevant than "total return" CAGR.
When to Use CAGR vs. Alternatives
| Situation | Use CAGR | Use IRR Instead | Consider Also |
|---|---|---|---|
| Single lump-sum investment | Yes | Not needed | Sharpe ratio for risk |
| Regular 401(k) contributions | Limited use | Yes | Dollar-cost averaging effect |
| Comparing two funds | Yes | Not needed | Expense ratios, volatility |
| Real estate with rental income | Limited use | Yes | Cap rate, cash-on-cash |
| Evaluating fund manager skill | Partial | No | Time-weighted return |
| Planning retirement needs | Yes (for projections) | For existing portfolio | Sequence of returns risk |
Real-World CAGR Examples
Here are CAGR values for common investments and scenarios to help you understand what different growth rates look like in practice. Historical S&P 500 CAGR data is available through FRED, and investment research firms like S&P Global publish benchmark CAGR figures.
Historical Investment CAGRs
| Investment | Period | CAGR (Nominal) | CAGR (Real, After Inflation) |
|---|---|---|---|
| S&P 500 (Total Return) | 1957-2024 | ~10.2% | ~7.0% |
| S&P 500 (Price Only) | 1957-2024 | ~7.7% | ~4.5% |
| 10-Year Treasury Bonds | 1928-2024 | ~5.0% | ~1.9% |
| Gold | 1971-2024 | ~7.8% | ~4.0% |
| US Housing (Nominal) | 1991-2024 | ~4.3% | ~1.7% |
| Savings Account (Average) | 2000-2024 | ~1.5% | ~-1.0% |
| Bitcoin | 2013-2024 | ~75% | ~72% |
| US Inflation (CPI) | 1926-2024 | ~3.0% | -- |
Growth Examples: What CAGR Means for Your Money
Starting with $10,000, here's what different CAGR rates produce over time:
| CAGR | After 5 Years | After 10 Years | After 20 Years | After 30 Years | Years to Double |
|---|---|---|---|---|---|
| 3% | $11,593 | $13,439 | $18,061 | $24,273 | 23.4 |
| 5% | $12,763 | $16,289 | $26,533 | $43,219 | 14.2 |
| 7% | $14,026 | $19,672 | $38,697 | $76,123 | 10.2 |
| 8% | $14,693 | $21,589 | $46,610 | $100,627 | 9.0 |
| 10% | $16,105 | $25,937 | $67,275 | $174,494 | 7.3 |
| 12% | $17,623 | $31,058 | $96,463 | $299,599 | 6.1 |
| 15% | $20,114 | $40,456 | $163,665 | $662,118 | 5.0 |
At a 10% CAGR (close to the S&P 500 historical average), $10,000 grows to $174,494 over 30 years. The difference between 7% and 10% CAGR over 30 years is the difference between $76,123 and $174,494, more than double. This illustrates why even small improvements in CAGR (through lower fees, better asset allocation, or long-term investing discipline) matter enormously over time.
How to Calculate CAGR in Excel & Google Sheets
There are several ways to calculate CAGR in spreadsheet applications:
| Method | Formula | Example ($10K to $25K, 10 years) |
|---|---|---|
| Direct Formula | =(FV/PV)^(1/n)-1 | =(25000/10000)^(1/10)-1 |
| RATE Function | =RATE(n,0,-PV,FV) | =RATE(10,0,-10000,25000) |
| POWER Function | =POWER(FV/PV,1/n)-1 | =POWER(25000/10000,1/10)-1 |
| With Dates | =(FV/PV)^(365/days)-1 | =(25000/10000)^(365/3650)-1 |
| RRI Function (Excel 2013+) | =RRI(n,PV,FV) | =RRI(10,10000,25000) |
All methods return the same result: 9.60%. The RATE function is the most versatile as it can also handle periodic payments (for investments with regular contributions). For more formula techniques, see our compound interest formula guide.
Using CAGR to Reverse-Engineer Investment Goals
CAGR is useful not just for analyzing past performance but for planning future investments. You can rearrange the compound interest formula to solve for any variable. For practical examples of investment compound interest and long-term investing, see our dedicated guides.
How Much Do I Need to Start With?
Goal: $1,000,000 in 25 years at 8% CAGR
PV = $1,000,000 / (1.08)25
PV = $1,000,000 / 6.8485
PV = $146,018
You'd need to invest approximately $146,018 today at an 8% CAGR to reach $1 million in 25 years (without additional contributions).
How Long Will It Take?
Question: How long to grow $50,000 to $200,000 at 7% CAGR?
n = ln(200000/50000) / ln(1.07)
n = ln(4) / ln(1.07)
n = 1.3863 / 0.06766
n = 20.49 years
What CAGR Do I Need?
Question: What CAGR turns $30,000 into $250,000 in 15 years?
CAGR = (250000/30000)1/15 - 1
CAGR = 8.33330.0667 - 1
CAGR = 1.1516 - 1 = 15.16%
A 15.16% CAGR would be required, which is very aggressive and unlikely to be sustained over 15 years. This kind of analysis helps set realistic expectations.
CAGR for Business Growth
CAGR is not just for investments. Businesses use it extensively to measure and communicate growth:
Common Business CAGR Applications
Companies report revenue CAGR to show consistent growth over time. A startup growing from $1M to $10M revenue in 5 years has a 58.5% revenue CAGR.
Tech companies measure user base growth using CAGR. Growing from 100K to 5M users in 4 years represents a 168% CAGR.
Industry analysts project market growth using CAGR forecasts. A market growing at 12% CAGR will roughly double in size every 6 years.
Investors evaluate a company's earnings growth CAGR to assess whether the stock is growing its profitability at an acceptable rate.
Industry Growth Rate Examples
| Industry/Market | Projected CAGR | Growth Description |
|---|---|---|
| AI/Machine Learning | 35-40% | Explosive growth |
| Electric Vehicles | 20-25% | Very high growth |
| Cloud Computing | 15-18% | High growth |
| E-commerce | 10-14% | Strong growth |
| Healthcare | 7-9% | Moderate growth |
| Consumer Staples | 3-5% | Steady growth |
| Traditional Retail | 1-3% | Low growth |
CAGR and the Rule of 72
The Rule of 72 is a quick shortcut that works hand-in-hand with CAGR. To estimate how long it takes for an investment to double at a given CAGR:
| CAGR | Rule of 72 Estimate | Exact Doubling Time | Accuracy |
|---|---|---|---|
| 4% | 18.0 years | 17.67 years | 98.2% |
| 6% | 12.0 years | 11.90 years | 99.2% |
| 8% | 9.0 years | 9.01 years | 99.9% |
| 10% | 7.2 years | 7.27 years | 99.0% |
| 12% | 6.0 years | 6.12 years | 98.0% |
| 15% | 4.8 years | 4.96 years | 96.8% |
The Rule of 72 is most accurate for rates between 6% and 10%, where it is essentially exact. For rates outside this range, it becomes a useful approximation.
CAGR for Different Asset Classes
Understanding typical CAGRs for different asset classes helps you build realistic financial plans:
| Asset Class | Typical CAGR Range | Risk Level | Best For |
|---|---|---|---|
| High-Yield Savings | 1-5% | Very Low | Emergency fund, short-term savings |
| Government Bonds | 2-5% | Low | Capital preservation, income |
| Corporate Bonds | 4-7% | Low-Medium | Income, moderate growth |
| Balanced Fund (60/40) | 6-8% | Medium | Retirement savings |
| Large-Cap Stocks (S&P 500) | 8-11% | Medium-High | Long-term growth |
| Small-Cap Stocks | 9-13% | High | Aggressive growth |
| Emerging Markets | 7-14% | Very High | Diversification, growth |
| Real Estate (REITs) | 8-12% | Medium-High | Income + growth |
These ranges represent long-term historical averages. Actual returns in any given period can vary significantly from these ranges.
Common CAGR Calculation Mistakes
The arithmetic average of yearly returns is always higher than CAGR when there's any volatility. Use CAGR for projections and actual growth measurement.
A 10% nominal CAGR with 3% inflation gives only ~7% real purchasing power growth. Always consider whether you're using nominal or real (inflation-adjusted) CAGR.
Measuring from a low point to a high point (or vice versa) distorts CAGR. Use long time periods (10+ years) and be aware of where you start and end.
Published CAGRs rarely include the impact of management fees, transaction costs, or taxes. A fund with 10% CAGR and 1% annual fees effectively delivers 9% CAGR to you.
CAGR with Regular Contributions (Modified CAGR)
Standard CAGR only works for a single lump-sum investment. If you make regular contributions, you need a modified approach. Here's how $500 monthly contributions change the picture:
| Starting Amount | Monthly Addition | CAGR | After 10 Years | After 20 Years | After 30 Years |
|---|---|---|---|---|---|
| $10,000 | $500 | 7% | $106,348 | $280,906 | $620,853 |
| $10,000 | $500 | 8% | $113,295 | $316,204 | $740,840 |
| $10,000 | $500 | 10% | $128,565 | $397,810 | $1,050,636 |
| $25,000 | $1,000 | 7% | $223,889 | $573,018 | $1,248,826 |
| $25,000 | $1,000 | 8% | $237,773 | $643,380 | $1,488,458 |
| $25,000 | $1,000 | 10% | $268,359 | $806,478 | $2,107,999 |
With $10,000 starting and $500/month at a 10% CAGR, you'd exceed $1 million in 30 years. The combination of starting capital, consistent contributions, and compound growth creates powerful long-term results.
CAGR Across Different Asset Classes
Understanding typical CAGR ranges for different asset classes helps you set realistic expectations and evaluate investment performance. Below are historical CAGR figures for major asset classes over various periods:
| Asset Class | 10-Year CAGR | 20-Year CAGR | 30-Year CAGR | Typical Range |
|---|---|---|---|---|
| U.S. Large Cap Stocks (S&P 500) | 12.0% | 10.1% | 10.4% | 8-12% |
| U.S. Small Cap Stocks | 8.5% | 9.2% | 10.8% | 8-13% |
| International Developed Stocks | 5.8% | 6.4% | 6.2% | 4-8% |
| U.S. Bonds (Aggregate) | 1.5% | 3.2% | 4.8% | 3-6% |
| Real Estate (REITs) | 7.5% | 8.8% | 9.6% | 7-11% |
| Gold | 8.2% | 9.5% | 5.8% | 3-10% |
Note that past performance does not guarantee future results. These figures vary significantly depending on the exact start and end dates chosen. The key insight is that equities have historically delivered the highest CAGR over long periods, but with substantially more volatility than bonds or cash equivalents. A diversified portfolio blending several asset classes typically delivers a CAGR somewhere between the highest and lowest individual asset returns, with reduced volatility.
Frequently Asked Questions
A "good" CAGR depends on the asset class and risk level. For the stock market, 8-10% CAGR over long periods is considered strong (the S&P 500 has averaged about 10% historically). For bonds, 4-6% is solid. For a diversified portfolio, 7-9% is typically good. Any CAGR that exceeds inflation (historically about 3%) means your purchasing power is growing. According to Investopedia, beating the relevant benchmark index CAGR is the true measure of investment success.
ROI (Return on Investment) measures the total percentage gain or loss, regardless of time. CAGR normalizes that return to an annual rate. For example, an investment that grows 100% over 10 years has an ROI of 100% but a CAGR of 7.18%. CAGR is better for comparing investments held for different time periods, while ROI shows the absolute return.
Yes. CAGR is negative when the ending value is less than the beginning value, meaning the investment lost money over the period. For example, if $10,000 became $7,000 over 5 years, the CAGR would be (7000/10000)^(1/5) - 1 = -6.87%. A negative CAGR indicates the investment declined at an equivalent rate of 6.87% per year.
They're closely related but not identical. A compound interest rate is the stated rate applied to a financial product (like a savings account at 5% compounded monthly). CAGR is the effective annual growth rate calculated backward from actual results. If you invested at a fixed 5% compound interest rate for 10 years, your CAGR would be 5%. But for volatile investments like stocks, the CAGR is calculated from actual beginning and ending values. Learn more in our compound interest formula guide.
This is due to a mathematical property: the geometric mean (CAGR) is always less than or equal to the arithmetic mean (average return) when there's any variation in returns. The more volatile the returns, the larger the gap. This is called "volatility drag" - volatility itself reduces compounded returns even if the average return stays the same.
The simplest way is: =(EndValue/StartValue)^(1/Years)-1. For example, =(25000/10000)^(1/10)-1 returns 9.60%. Alternatively, you can use the RATE function: =RATE(10,0,-10000,25000), which also returns 9.60%. Excel 2013 and later also includes the RRI function: =RRI(10,10000,25000). All methods work in both Excel and Google Sheets.
The S&P 500 total return (with dividends reinvested) has delivered approximately 10.2% nominal CAGR since its inception in 1957 through 2024. After adjusting for inflation, the real CAGR is approximately 7%. However, CAGR varies dramatically by period: 2010-2019 delivered over 13% CAGR, while 2000-2009 produced essentially 0% CAGR. Data is available from FRED (Federal Reserve Economic Data).
Inflation reduces your real (purchasing power) returns. To calculate real CAGR: Real CAGR โ Nominal CAGR - Inflation Rate. More precisely: Real CAGR = ((1 + Nominal CAGR) / (1 + Inflation)) - 1. For example, a 10% nominal CAGR with 3% inflation gives approximately 6.8% real CAGR. Always consider whether published returns are nominal or inflation-adjusted when making comparisons.
Standard CAGR is not ideal for accounts with regular contributions because it only considers starting and ending values, not the timing of deposits. For 401(k) accounts, Internal Rate of Return (IRR) or money-weighted return is more appropriate. However, you can use CAGR assumptions (like 7-10% expected market CAGR) to project future values using our 401(k) calculator, which accounts for regular contributions.
CAGR measures the annualized return between two points (start and end) with no intermediate cash flows. IRR (Internal Rate of Return) calculates the annualized return while accounting for multiple cash flows at different times (deposits, withdrawals, dividends). Use CAGR for simple lump-sum analysis; use IRR for portfolios with ongoing activity. For most investment accounts with regular contributions, IRR provides a more accurate picture of your actual performance.