Compound Annual Growth Rates (CAGR) in Excel
CAGR (compound annual growth rate) is a common requirement in spreadsheets. What we are generally asking is what is the average growth in an amount over a number of years, taking compounding into account.
There is unfortunately no CAGR formula in Excel currently but there are a few ways of achieving it with other functions.
To see the full course contents click here.