Excel: Constant Annual Growth Rate (CAGR)
In order to calculate the (average) annual growth rate over multiple year, use this formula:
CAGR: =((End Value/Start Value)^(1/(Periods - 1)) - 1
In order to calculate the (average) annual growth rate over multiple year, use this formula:
CAGR: =((End Value/Start Value)^(1/(Periods - 1)) - 1