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.

Key Takeaways
  • 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.

CAGR Formula
CAGR = (FV / PV)1/n - 1

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?

Step 1: Identify your values
FV = $25,000 (ending balance)
PV = $10,000 (starting balance)
n = 10 years (investment period)
Step 2: Calculate the growth multiple
FV / PV = $25,000 / $10,000 = 2.5
(Your money multiplied 2.5 times)
Step 3: Take the nth root (raise to 1/n)
2.51/10 = 2.50.1 = 1.09596
(This extracts the per-year growth factor)
Step 4: Subtract 1 to get the rate
1.09596 - 1 = 0.09596 = 9.60%
(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 ValueEnding ValueYearsGrowth MultipleCAGR
$5,000$10,00072.00x10.41%
$10,000$15,00051.50x8.45%
$25,000$100,000154.00x9.68%
$50,000$200,000204.00x7.18%
$100,000$1,000,0003010.00x8.01%
$10,000$7,50050.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

MetricBest ForHandles Multiple Cash Flows?Time-Normalized?Complexity
CAGRLump-sum investments, benchmarkingNoYes (annual)Simple
IRRPortfolios with contributions/withdrawalsYesYes (annual)Moderate
TWRFund manager performanceNeutralizes themYes (any period)Complex
ROITotal return without time contextNoNoSimple
Average ReturnUnderstanding typical yearNoNo (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 ClassNominal CAGRReal CAGR (Inflation-Adjusted)Volatility (Std Dev)Worst 10-Year CAGR
U.S. Large Cap Stocks10.2%7.0%18.5%-1.4% (2000-2009)
U.S. Small Cap Stocks11.8%8.6%28.5%-5.7% (1929-1938)
International Stocks7.5%4.5%22.0%-4.2% (2000-2009)
Long-Term Govt Bonds5.5%2.5%9.5%-2.0% (1950-1959)
Corporate Bonds5.9%2.9%8.5%1.5% (1969-1978)
Gold5.8%2.8%19.5%-6.5% (1988-1997)
Cash/T-Bills3.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:

Why Average Return Is Misleading
Year 1: $10,000 x 1.50 = $15,000 (+50%)
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

MetricAverage ReturnCAGR
DefinitionArithmetic mean of annual returnsGeometric mean (compounded) return
Accounts for compoundingNoYes
Reflects actual growthNot alwaysAlways
Affected by volatilityNoYes (always lower with volatility)
Better for projectionsNoYes
RelationshipAlways >= CAGRAlways <= Average
Used in marketingOften (looks better)Less often (more accurate)

Real-World Impact of Volatility Drag

ScenarioYear 1Year 2Year 3Average ReturnActual CAGRGap
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

SituationUse CAGRUse IRR InsteadConsider Also
Single lump-sum investmentYesNot neededSharpe ratio for risk
Regular 401(k) contributionsLimited useYesDollar-cost averaging effect
Comparing two fundsYesNot neededExpense ratios, volatility
Real estate with rental incomeLimited useYesCap rate, cash-on-cash
Evaluating fund manager skillPartialNoTime-weighted return
Planning retirement needsYes (for projections)For existing portfolioSequence 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

InvestmentPeriodCAGR (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 Bonds1928-2024~5.0%~1.9%
Gold1971-2024~7.8%~4.0%
US Housing (Nominal)1991-2024~4.3%~1.7%
Savings Account (Average)2000-2024~1.5%~-1.0%
Bitcoin2013-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:

CAGRAfter 5 YearsAfter 10 YearsAfter 20 YearsAfter 30 YearsYears to Double
3%$11,593$13,439$18,061$24,27323.4
5%$12,763$16,289$26,533$43,21914.2
7%$14,026$19,672$38,697$76,12310.2
8%$14,693$21,589$46,610$100,6279.0
10%$16,105$25,937$67,275$174,4947.3
12%$17,623$31,058$96,463$299,5996.1
15%$20,114$40,456$163,665$662,1185.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:

MethodFormulaExample ($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?

Solve for Present Value (PV)
PV = FV / (1 + CAGR)n

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?

Solve for Time (n)
n = ln(FV/PV) / ln(1 + CAGR)

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?

Solve for Required CAGR
CAGR = (FV/PV)1/n - 1

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

๐Ÿ“Š
Revenue CAGR

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.

๐Ÿ‘ฅ
User Growth CAGR

Tech companies measure user base growth using CAGR. Growing from 100K to 5M users in 4 years represents a 168% CAGR.

๐Ÿญ
Market Size CAGR

Industry analysts project market growth using CAGR forecasts. A market growing at 12% CAGR will roughly double in size every 6 years.

๐Ÿ’ฐ
Earnings Per Share CAGR

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/MarketProjected CAGRGrowth Description
AI/Machine Learning35-40%Explosive growth
Electric Vehicles20-25%Very high growth
Cloud Computing15-18%High growth
E-commerce10-14%Strong growth
Healthcare7-9%Moderate growth
Consumer Staples3-5%Steady growth
Traditional Retail1-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:

Rule of 72
Years to Double โ‰ˆ 72 / CAGR
CAGRRule of 72 EstimateExact Doubling TimeAccuracy
4%18.0 years17.67 years98.2%
6%12.0 years11.90 years99.2%
8%9.0 years9.01 years99.9%
10%7.2 years7.27 years99.0%
12%6.0 years6.12 years98.0%
15%4.8 years4.96 years96.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 ClassTypical CAGR RangeRisk LevelBest For
High-Yield Savings1-5%Very LowEmergency fund, short-term savings
Government Bonds2-5%LowCapital preservation, income
Corporate Bonds4-7%Low-MediumIncome, moderate growth
Balanced Fund (60/40)6-8%MediumRetirement savings
Large-Cap Stocks (S&P 500)8-11%Medium-HighLong-term growth
Small-Cap Stocks9-13%HighAggressive growth
Emerging Markets7-14%Very HighDiversification, growth
Real Estate (REITs)8-12%Medium-HighIncome + growth

These ranges represent long-term historical averages. Actual returns in any given period can vary significantly from these ranges.

Common CAGR Calculation Mistakes

1
Confusing CAGR with Average Return

The arithmetic average of yearly returns is always higher than CAGR when there's any volatility. Use CAGR for projections and actual growth measurement.

2
Ignoring Inflation

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.

3
Cherry-Picking Time Periods

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.

4
Ignoring Fees and Taxes

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 AmountMonthly AdditionCAGRAfter 10 YearsAfter 20 YearsAfter 30 Years
$10,000$5007%$106,348$280,906$620,853
$10,000$5008%$113,295$316,204$740,840
$10,000$50010%$128,565$397,810$1,050,636
$25,000$1,0007%$223,889$573,018$1,248,826
$25,000$1,0008%$237,773$643,380$1,488,458
$25,000$1,00010%$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 Class10-Year CAGR20-Year CAGR30-Year CAGRTypical Range
U.S. Large Cap Stocks (S&P 500)12.0%10.1%10.4%8-12%
U.S. Small Cap Stocks8.5%9.2%10.8%8-13%
International Developed Stocks5.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%
Gold8.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.

Calculate Your CAGR โ†’

Related Guides