archive

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

Comments are closed.