CAGR Calculator Compound annual growth rate from start value, end value and years

Enter where a value started, where it ended, and how many years passed. You'll get the smooth annual growth rate that connects the two. Works for investments, revenue, users — anything that grows.

CAGR = (end ÷ start)^(1 ÷ years) − 1

CAGR
smooth annual growth rate
Total growth
Times multiplied

Do this in Excel or Google Sheets

With start value in A1, end value in B1 and years in C1:

ResultFormula
CAGR=(B1/A1)^(1/C1)-1 (format as %)
CAGR (with RATE)=RATE(C1, 0, -A1, B1)
Total growth=(B1-A1)/A1

Growth rates and compounding are core to financial modelling in Excel and Power BI. My courses cover them properly.

Learn Excel & Power BI with my courses →

What CAGR means

The compound annual growth rate is the single, steady yearly rate that would take your start value to your end value over the given period. Real growth is usually bumpy — up one year, down the next — but CAGR smooths it into one figure, which makes different investments or time periods easy to compare. It always assumes the growth compounds, so each year builds on the last.

Frequently asked questions

How is CAGR different from a simple average return?

A simple average just adds the yearly returns and divides. CAGR accounts for compounding, so it reflects the actual end value — which is why it's the fairer measure for multi-year growth.

Can CAGR be negative?

Yes. If the end value is lower than the start value, CAGR is negative, showing an average yearly decline.

What period should I use?

Use the number of years between the start and end values. For part-years you can enter a decimal, such as 2.5.