# 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.

Source: https://www.exent.ai/learn/cagr · Reviewed by David, Senior Analyst, Exent · Published Nov 17, 2026 · Updated Nov 17, 2026

## 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 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.

## 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

| Input | Value |
| --- | --- |
| Start (Jul 2016) | $10,000 |
| End (Sep 30, 2026) | $42,626 |
| Years | 10.25 |
| CAGR = (42,626 ÷ 10,000)^(1 ÷ 10.25) − 1 | 15.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](https://www.exent.ai/learn/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

### How do you calculate CAGR in Excel?

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

### Is CAGR the same as average annual return?

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

### What is a good CAGR for stocks?

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.

---

Educational content, not investment advice. Past performance does not guarantee future results.
