on excel, the formula is something like this

=RRI(A7,B2,B7)

where A7 = how many years

B2 = start value

B7 = end value

so for example, lets say i want to calculate the 5 year CAGR rate for aapl. lets say aapl 5 years ago was 50, and the current price is 100.

if you plugged into this formula, it says that AAPL had an annual compounded growth rate of 14.87% each year for 5 years

thanks

eugene

CAGR formula in Excel: https://www.excel-easy.com/examples/cagr.html