Calculate Annual Growth Rate

Annual Growth Rate in Excel

Calculating the annual growth rate is very easy in Excel. To calculate the annual growth rate, use the following formula.

=(Current year-Previous year)/Previous year

Using the following data set below as an example,

Annual growth rate

You can use the fill handle to pull down the formula to calculate the annual growth rate over multiple years as shown below.

Make sure you use the Percentage

Annual growth rate

Was this article helpful?

Related Articles

Leave a Reply