Year over year growth in Excel

When you try to calculate the growth of your company, comparing data to the previous month is not always the best idea because the company may have a peak and low demand seasons.

The year over year comparisons helps to analyze the company’s performance and avoid seasonality. For example, many companies have big demand seasons during holidays shopping season.

Instead of comparing the current month to the previous one, it takes the current month and compares it to the same month last year. It’s an easy and efficient way to check whether the company’s performance is improving or worsening.

How to calculate year over year growth in Excel

  1. From the current month, sales subtract the number of sales of the same month from the previous year. If the number is positive that the sales grew.
  2. Divide the difference by the previous year’s total sales.
  3. Convert the value to percentages.

Let’s take a look at the following example.

This is how the chart looks like.

You can copy the following table.

2017 2018 2019
January 3.5 4.2 4.8
February 3.7 4.4 5.5
March 3.6 4.3 5.4
April 3.4 4.1 4.6
May 3.2 3.7 4.1
June 3.1 4 5
July 7.2 8.1 9.8
August 7.9 9.5 11.4
September 6.2 7 8.7
October 6.1 7.8 9.1
November 5.8 7.5 8.8
December 5.1 6.1 7.5

If you want to calculate YOY growth for August 2019, use the following formula.

YOY = ((11.4 – 9.5) / 9.5) * 100

YOY = 20%