How to Calculate Sales Growth over 5 Years in Excel (3 Ideal Examples)

Get FREE Advanced Excel Exercises with Solutions!

Business sectors preserve their necessary information in Excel. They have to perform various operations according to their requirements. The sales sector stores the Sales records of different products over the years in the Excel worksheet. Excel makes it easy to track records of large amounts of data. Users can easily understand and analyze the data. Apart from keeping the Sales records, it’s also equally important to assess the Sales Growth. You can determine the growth annually or over a couple of years. In this article, we’ll give you suitable examples to Calculate Sales Growth over 5 Years in Excel.


How to Calculate Sales Growth over 5 Years in Excel: 3 Ideal Examples

This article will demonstrate the Sales Growth over 5 Years. Here we’ll assume the Net Sales amount is greater for the later years than the previous ones. Thus, we’ll calculate the growth. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset displays the Net Sales of a product for the period of 5 Years (2017-2021) of a company. Sales amount in 2017 is the lowest, whereas, the amount in 2021 is the highest. Now, you’ll see 3 different examples to compute Sales Growth over 5 Years in Excel.


1. Calculate Sales Growth over 5 Years in Excel with Simple Formula

We can create many different formulas in Excel as per our requirements using different cells and built-in functions. To get the Sales Growth over 5 years, you need to deduct the year 2015 Sales amount from the year 2021 Sales amount. But, from this value, one can’t tell whether the growth is satisfactory or not. So, we need the growth rate. That’s why the subtracted result needs to be divided by the 2021 sales amount. Using this fact, we’ll generate a simple formula for calculating Sales Growth. Therefore, follow the steps below to carry out the operation.

STEPS:

  • First, select cell C11.
  • Then, type the formula:
=(C9-C5)
  • After that, press Enter to return the value.
  • Thus, you’ll get the growth amount.

Calculate Sales Growth over 5 Years in Excel with Simple Formula

  • Now, click cell C12.
  • Next, choose the Percentage number format from the Number section of the Home tab.

Calculate Sales Growth over 5 Years in Excel with Simple Formula

  • Again, select cell C12.
  • Afterward, insert the below formula:
=C11/C5
  • Subsequently, return the result by pressing Enter.
  • At last, the growth rate over 5 years will appear in cell C12.

Calculate Sales Growth over 5 Years in Excel with Simple Formula

Read More: How to Calculate Sales Growth Percentage in Excel


2. Create Excel Formula to Get Compound Growth Rate of Sales over 5 Years

Suppose, we want to get the Compound Growth Rate. Most investment sectors prefer the compound growth rate over the average growth rate. Because the average growth rate doesn’t take account of the compounding. Therefore, it overestimates the growth sometimes. Hence, it can cause an error in the return values. On the other hand, the compound growth rate is more accurate. So, learn the following steps to perform the task.

STEPS:

  • Firstly, choose cell C11 to input a formula.
  • Next, type the formula:
=((C9/C5)^(1/4))-100%
  • Consequently, press Enter to get the value.
  • As a result, it’ll return the compound growth rate.

Read More: How to Calculate Sales Growth over 3 Years in Excel


3. Compute Compound Annual Growth Rate Using Excel XIRR Function

We know that Excel provides numerous functions to perform a multitude of tasks. Such a kind is the XIRR function. This function generates the internal rate of return for the cash flows in a period. We can apply this function to calculate the Compound Annual Sales Growth Rate over 5 Years. Hence, follow the process to carry out the operation.

STEPS:

  • First of all, you have to place the year 2015 (Start Value) sales and year 2021 (End value) sales in the new cells as it’s shown in the following picture.
  • See the below image for a better understanding.

Compute Compound Annual Growth Rate Using Excel XIRR Function

  • However, don’t forget to insert a Minus sign before the Start value (2017 Sales) for the formula to function without errors.

Compute Compound Annual Growth Rate Using Excel XIRR Function

  • Then, select cell C11 and type the formula:
=XIRR(E6:F6,E5:F5)
  • After that, press Enter. It’ll return the output of the equation.

Compute Compound Annual Growth Rate Using Excel XIRR Function

  • Now, choose the % (Percentage) number format for the output value in cell C11.
  • Thus, you’ll get the compound annual sales growth rate.

Read More: How to Calculate Monthly Growth Rate in Excel


Download Practice Workbook

Download the following workbook to practice by yourself.


Conclusion

Henceforth, you will be able to Calculate Sales Growth over 5 Years in Excel following the above-described examples. Keep using them and let us know if you have more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo