Growth Rate and CAGR Calculator
Turns a series into period-on-period change, cumulative change and a compound growth rate.
Loading the tool…
How to use this tool
- Paste the series in order, one value per period, oldest first.
- Select Calculate.
- Take the compound rate from the summary — it is the figure that survives being checked.
- Scan the period-on-period column for the one period that is carrying the whole trend.
What growth rate does
Paste the series in order, one value per period, and every period gets its change on the previous value and its change on the first. The compound rate across the whole series is calculated from the two ends, which is what CAGR is — a constant rate that would have produced the same finish from the same start, not an average of the steps along the way.
The simple average of the period changes is shown next to the compound rate, and it is almost always the larger of the two. That gap widens with volatility, which is why a volatile series quoted at its arithmetic mean growth looks better than it was. When the series starts or ends at or below zero no compound rate exists, and the page says so instead of printing a number.