GlossaryGlossary

What Is CAGR? Definition, Formula and Example

CAGR is the steady yearly rate that turns a starting value into an ending value. Here is the formula, a real S&P 500 example, and why it beats a simple average.

Published Updated 2 min readHow we research

Key takeaways

  • CAGR (compound annual growth rate) is the constant yearly return that would turn a starting value into an ending value: (end ÷ start)^(1 ÷ years) − 1.
  • In Exent’s backtest, $10,000 in the S&P 500 (SPY) from Jul 2016 grew to $42,626 by Sep 2026, a CAGR of 15.2%.
  • CAGR is lower than the simple average of yearly returns whenever returns bounce around. For SPY in 2017–2025 the average was 16.2% but the CAGR was 15.0%.
  • CAGR hides the path: two investments with the same CAGR can have very different drawdowns.

What is your own portfolio exposed to? Check it with Exent →

What is CAGR?

CAGR is the single yearly growth rate that, compounded every year, connects where an investment started and where it ended. It smooths a bumpy path into one number, which makes investments held for different lengths of time comparable.

See how this applies to your own holdings with an Exent portfolio check.

What is the CAGR formula?

CAGR = (ending value ÷ starting value)^(1 ÷ number of years) − 1. Use total return values, with dividends reinvested, or the result understates income‑paying assets. Years can be fractional: 123 months is 10.25 years.

Example: CAGR of the S&P 500

InputValue
Start (Jul 2016)$10,000
End (Sep 30, 2026)$42,626
Years10.25
CAGR = (42,626 ÷ 10,000)^(1 ÷ 10.25) − 115.2%

Source: Exent’s backtest of SPY, month‑end total returns (past results). Illustrative contrast: +50% one year and −50% the next averages 0%, but $100 becomes $75, a CAGR of about −13.4%. That gap is volatility drag.

Why does it matter for a self‑directed investor?

CAGR is the honest way to state what your money actually compounded at. It is the right number to compare against a benchmark over the same dates, and it is the basis for judging a good annual return.

Common mistakes

  • Averaging yearly returns. The arithmetic average overstates what you earned.
  • Ignoring deposits and withdrawals. CAGR on an account balance mixes your contributions with returns; use a time‑weighted return instead. See how to calculate portfolio return.
  • Cherry‑picking dates. Starting at a market low flatters CAGR; starting at a peak punishes it.

Frequently asked questions

Use =(End/Start)^(1/Years)-1, or =RRI(Years, Start, End), which returns the same compound annual rate.

No. The average adds yearly returns and divides; CAGR compounds them. With volatile returns, CAGR is always the lower of the two.

It depends on the period. In a backtest, the S&P 500 compounded at 15.2% a year from mid-2016 to Sep 2026, which is high by long-run standards.

See what your portfolio is really made of.

Upload a screenshot of your holdings and get concentration, overlap, crash exposure and a risk-matched benchmark in about a minute.

Check my portfolioLimited offer$1.95 for unlimited checks· unlimited checks

Educational content, not investment advice. Examples are illustrative; past performance does not guarantee future results.

DISCLAIMER: Exent AI is an informational research platform and does not provide investment advice, financial advice, or act as an investment adviser, broker-dealer, or fiduciary. All content, analytics, and model outputs are provided for educational and informational purposes only and should not be relied upon as a recommendation to buy, sell, or hold any financial instrument. Investing involves risk, including the possible loss of principal. Exent AI does not execute trades, hold customer funds, or provide brokerage services. Past performance and hypothetical results are not indicative of future results. Third-party data and AI-generated outputs may be incomplete or inaccurate.