Excel: Constant Annual Growth Rate (CAGR)
Friday, February 25th, 2011In 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
Nice application showing in treemap form the expenditures of the german government.