CAGR Calculator
Compound annual growth rate, the single smoothed rate that takes a starting value to an ending value over time. Enter three numbers, get the rate plus the growth curve.
Your numbers
Smooth curve = applying the CAGR each period. Real growth is rarely this even.
The CAGR formula
CAGR = (Ending value ÷ Beginning value)1 / periods − 1. It answers "if growth had been perfectly steady, what annual rate would take me from start to finish?" That makes it the fairest way to compare growth across different time spans, but because it smooths out the bumps, always pair it with the actual year-by-year numbers when you're judging momentum.
Worked example: $100,000 to $250,000 in 3 years
Revenue that grows from $100,000 to $250,000 over three years compounds at 35.7% a year: (250,000 ÷ 100,000)1/3 − 1 = 2.51/3 − 1.
| Item | Value |
|---|---|
| Beginning value | $100,000 |
| Ending value | $250,000 |
| Number of periods | 3 years |
| Growth multiple (250,000 ÷ 100,000) | 2.50× |
| Total growth | 150.0% |
| Absolute change | $150,000 |
| Average change per period | $50,000 |
| Value after year 1 / year 2 at the CAGR | $135,721 / $184,202 |
| CAGR | 35.7% |
Frequently asked questions
How do you calculate CAGR?
What is the CAGR formula in Excel?
What is the difference between CAGR and average annual growth?
Can I use CAGR for monthly growth?
What does a negative CAGR mean?
Cite this page
Citation
Adlega. "CAGR Calculator: Formula, Example and Excel." Updated October 22, 2026. https://adlega.com/blog/tools/cagr/
Link for your article
<a href="https://adlega.com/blog/tools/cagr/">CAGR Calculator: Formula, Example and Excel</a> (Adlega, updated October 22, 2026)
Plan the whole picture in Adlega
Adlega turns these one-off numbers into a live financial model for your SaaS, projections, scenarios, dashboards.