What is CAGR, the compound annual growth rate?

CAGR, the compound annual growth rate, is the single yearly rate that would turn a starting value into an ending value over a set number of years. It smooths out the ups and downs, so it describes the pace of growth but not the path.

By Sonic Wallet Editorial Team· Updated · 6 min read

Key takeaways

  • CAGR, the compound annual growth rate, is the one constant yearly rate that would grow a starting value into an ending value over a given period if gains compounded evenly. It equals the ending value divided by the starting value, raised to the power of 1 divided by the number of years, minus 1. It summarizes the pace of growth, not any single year.
  • On price alone, the S&P 500 rose from 2,126.15 on October 31, 2016 to 7,743.98 on October 28, 2026, a 264.2% gain that works out to a CAGR of 13.8% a year.
  • Averages overstate growth when returns swing: the S&P 500 fell 19.44% in 2022 and gained 24.23% in 2023, an average of 2.39% a year, yet it ended 2023 at 4,769.83, barely above its 4,766.18 close of 2021, a CAGR of 0.04%.
  • The 'average annual total return' in a US fund prospectus is a compound rate: SEC Form N-1A has funds solve P(1 + T)^n = ERV for a hypothetical $1,000 payment with every distribution reinvested.
  • CAGR ignores the path and any cash added or withdrawn. The S&P 500's 13.8% decade included a 33.9% fall between February 19 and March 23, 2020, and the rate says nothing about an account that received deposits.

CAGR, short for compound annual growth rate, is the single yearly rate that would carry a starting value to an ending value over a given number of years if growth compounded at exactly that rate every year. It is a summary, not a record: an investment with a 10% CAGR may never have returned 10% in any one year. Analysts use it to put growth over spans of different lengths on the same footing, whether the series is a stock index, a company's sales or the price level. The stocks hub covers the investments it is most often quoted for.

How do you calculate CAGR?

Divide the ending value by the starting value, raise the result to the power of one over the number of years, then subtract 1.

CAGR = (ending value ÷ starting value) ^ (1 ÷ years) − 1

The number of years does not have to be whole: for a period counted in days, divide the days by 365.25. Run the formula backward and it gives the ending value, starting value × (1 + CAGR) ^ years, which is the compounding arithmetic set out in how compound interest works. FINRA's investor page on evaluating performance gives the same calculation under the name annualized return, (1 + return) ^ (1 ÷ years) − 1, where return is the cumulative gain written as a decimal. In a spreadsheet, type =(end/start)^(1/years)-1, or use Excel's RRI function, RRI(nper, pv, fv), which Microsoft describes as the equivalent interest rate for the growth of an investment.

Two conditions limit the formula. The starting value must be above zero, so CAGR cannot describe a company moving from a loss to a profit. And it reads only the two end points, so nothing that happened in between enters the result.

What was the S&P 500's CAGR over the last 10 years?

On price alone, the S&P 500 compounded at about 13.8% a year from October 31, 2016 to October 28, 2026, the decade of daily data FRED publishes.

Worked example: The S&P 500 from October 2016 to October 2026

  • Starting level, October 31, 2016: 2,126.15
  • Ending level, October 28, 2026: 7,743.98
  • Growth multiple: 7,743.98 ÷ 2,126.15 = 3.642, a cumulative gain of 264.2%
  • Length: 3,649 days ÷ 365.25 = 9.99 years
  • CAGR: 3.642 ^ (1 ÷ 9.99) − 1 = 13.8% a year
  • In dollars: $10,000 at the start became $36,423 at the end, before dividends

These levels come from the S&P 500 series that S&P Dow Jones Indices supplies to the St. Louis Fed's FRED database, which is a price index and leaves dividends out. A fund that reinvested its dividends compounded faster, and that gap is what total return measures. The same series feeds our bitcoin vs S&P 500 study, which reports 3-year and 5-year rates to the same end date of 23.4% and 11.0% a year: one index and one end date give three quite different CAGRs, depending only on where the window starts. What is the S&P 500 covers what the index holds.

Why is CAGR lower than the average annual return?

A loss shrinks the base that the next gain works on, so the simple average of yearly returns runs ahead of the rate at which money actually compounded.

Worked example: Two volatile years: the S&P 500 in 2022 and 2023

YearLevel at startLevel at endPrice return
20224,766.183,839.50−19.44%
20233,839.504,769.83+24.23%
  • Average of the two returns: (−19.44% + 24.23%) ÷ 2 = 2.39% a year
  • Two-year multiple: 4,769.83 ÷ 4,766.18 = 1.00077
  • CAGR: 1.00077 ^ (1 ÷ 2) − 1 = 0.04% a year
  • $10,000 at the end of 2021 fell to $8,056 by the end of 2022, then climbed back to $10,008

The average says the index earned 2.39% a year; the money says it went almost nowhere. The gap widens with the size of the swings. Using the rounded calendar-year figures in the same study, bitcoin lost 64.2% in 2022 and gained 155.7% in 2023, an average of +45.8% a year, yet $10,000 would have dropped to $3,580 and recovered only to about $9,154, a CAGR of roughly −4.3%. Calmer stretches show a smaller gap: the S&P 500's nine calendar-year returns from 2017 through 2025 average 14.41%, while its CAGR over those years, from 2,238.83 to 6,845.50, is 13.22%.

A rule of thumb connects the two: CAGR ≈ average return − variance ÷ 2, where variance is the square of the standard deviation of the yearly returns. From 2017 to 2025 that standard deviation was 15.44 points, so the drag is about 0.1544 × 0.1544 ÷ 2 = 1.19 points, and 14.41 − 1.19 = 13.22. The shortcut fails for swings as large as bitcoin's, where only the full formula works.

Where do you see CAGR?

You meet it in fund prospectuses and fact sheets, in company presentations, in economic statistics and in any multi-year return quoted per year.

  • Fund documents. SEC Form N-1A tells a mutual fund to report its average annual total return for 1, 5 and 10 years by solving P(1 + T)^n = ERV, where P is a hypothetical $1,000 payment, T the return, n the number of years and ERV the ending redeemable value. The instructions deduct the maximum sales load, reinvest every distribution and state the result to the nearest hundredth of a percent. Despite the word "average", T is a compound rate: a CAGR of total return after fund costs. Index funds explained shows where those tables appear.
  • Company reports. Investor presentations often quote revenue or earnings per share growth as a five- or ten-year CAGR. Check the base year, because a weak starting point inflates the rate.
  • Economic data. The Bureau of Labor Statistics CPI-U index rose from 241.428 in September 2016 to 336.940 in September 2026, 39.6% in all, which is 3.39% a year compounded.
  • Savings rates. An APY is the one-year compound growth of a deposit, so it plays the same role for a bank account; APY vs APR explains the conversion.
  • Calculators and shortcuts. The compound interest calculator runs the formula forward from a rate you choose, and the rule of 72 turns a CAGR into a doubling time: 72 ÷ 13.8 ≈ 5.2 years.

How does CAGR compare with other return measures?

CAGR is a compound, time-weighted rate for one lump sum; cumulative return, the average annual return and the money-weighted return each answer a different question.

MeasureHow it is calculatedS&P 500, end of 2021 to end of 2023Question it answers
Cumulative returnEnding value ÷ starting value − 1+0.08%How much did the value change in total?
Average annual returnSum of yearly returns ÷ number of years+2.39%What did a typical single year look like?
CAGR(Ending ÷ starting) ^ (1 ÷ years) − 1+0.04%At what steady rate did it compound?
Money-weighted return (IRR)The rate at which all deposits, withdrawals and the final balance net to zeroDepends on your cash flowsWhat did your own account earn?

The last row matters to anyone who adds money over time. In a 2023 rule filing, FINRA described the average annual total returns that mutual funds advertise as time-weighted returns, which ignore the size and timing of cash flows, while an internal rate of return measures how a specific portfolio performed. Two people in the same fund over the same decade see the same CAGR, but the one who put most of the money in just before a fall earns less. That is why regular investing is judged with money-weighted figures, as in lump sum vs dollar-cost averaging and the DCA calculator.

What are the limits of CAGR?

CAGR hides the ride, depends on the dates chosen, and leaves out cash flows, the dividends missing from price data and inflation unless you add them back.

  • It hides volatility. The S&P 500's 13.8% decade included a fall from 3,386.15 on February 19, 2020 to 2,237.40 on March 23, 2020, a drawdown of 33.9%. A smooth rate says nothing about whether an investor could have sat through that.
  • It depends on the end points. Starting a window at a market low or at a company's weakest year raises the result, and starting at a peak lowers it. Compare CAGRs only over identical dates.
  • It ignores deposits and withdrawals. Dividing a balance that includes new savings by the opening balance overstates growth; a money-weighted return handles the cash flows.
  • Price-only data understate it. Index levels exclude dividends while fund figures include them after costs, so check which one you are reading before comparing.
  • It is nominal unless adjusted. Prices rose 3.39% a year over the decade to September 2026, so a 13.8% nominal CAGR was roughly 10.1% after inflation (1.138 ÷ 1.0339 − 1), with the caveat that the two windows end a month apart. Real returns and inflation walks through the adjustment.
  • Short periods annualize badly. A 5% gain in one quarter compounds to 21.6% a year on paper, which assumes the same pace for three more quarters.
  • It looks backward. A past CAGR describes history only, and past performance does not predict future results.

Frequently asked questions

Is CAGR the same as annualized return?+

For one sum invested at the start and left alone, yes. FINRA's investor guide writes annualized return as (1 + return) raised to the power of 1 ÷ years, minus 1, which is the CAGR formula. The two part ways once deposits or withdrawals happen.

Can CAGR be negative?+

Yes, whenever the ending value is below the starting value. A share bought for $50 that is worth $40 five years later has a CAGR of (40 ÷ 50) raised to the power of 1 ÷ 5, minus 1, or about −4.4% a year.

How do you calculate CAGR in Excel?+

Type =(end/start)^(1/years)-1, or use the RRI function, =RRI(years, start, end), which Microsoft describes as the equivalent interest rate for the growth of an investment. =RRI(10, 2126.15, 7743.98) returns about 13.8%.

What was the CAGR of US inflation over the past 10 years?+

The CPI-U index rose from 241.428 in September 2016 to 336.940 in September 2026, according to the Bureau of Labor Statistics. That is a 39.6% increase in all, or 3.39% a year compounded.

How long does money take to double at a given CAGR?+

Divide 72 by the CAGR in percent for a quick estimate, or divide the natural log of 2 by the natural log of 1 plus the rate for the exact answer. At 13.8% a year the shortcut gives 5.2 years and the exact figure is 5.4.

Sources

  1. Evaluating Performance, FINRA
  2. Form N-1A, Item 26: Calculation of Performance Data, US Securities and Exchange Commission
  3. S&P 500 (SP500), daily close, Federal Reserve Bank of St. Louis (FRED), data from S&P Dow Jones Indices
  4. CPI for All Urban Consumers (CPI-U), all items, not seasonally adjusted (CUUR0000SA0), US Bureau of Labor Statistics
  5. Notice of Filing of a Proposed Rule Change to Amend FINRA Rule 2210 (SR-FINRA-2023-016), November 17, 2023, FINRA (Federal Register notice)
  6. RRI function, Microsoft Support

Related guides