Growth Over Last Year Formula in Excel (A Step-by-Step Analysis)

Get FREE Advanced Excel Exercises with Solutions!

Year-over-year growth analysis can offer a comprehensive portrayal of a company’s financial development. To compare the growth of a company over the last year, we have to apply a formula. In this tutorial, we will show you how to use the growth over last year formula in Excel.


Introduction to Year-Over-Year Growth

Year-over-Year (YoY) Growth compares the change in an annualized statistic over two similar periods, often the current and preceding years as of the fiscal year’s close date. This study is commonly used to compare the pace of revenue increase over the last year. Businesses can also use the YOY growth formula, which displays commercial success as a percentage over the last year.


Growth Over Last Year’s Formula

The growth rate is calculated by first determining the ratio of the Current Value to the Prior Value. The growth rate is then calculated by subtracting 1 from the result.

Sample Data


Growth Over Last Year Formula in Excel: with Easy Steps

We’ll use four stages to determine growth over the last year in the following sections. To complete the task, a sample data set is supplied. We gathered the sales value for the previous two years, 2021 and 2022, in our data collection.

Sample Data

Step 1: Calculate the Difference in Growth Over Last Year

  • Firstly, to calculate the difference in growth, we need to subtract the Prior Value from the Current Value with the following formula.
=(D5-C5)

Steps to Use Growth Over Last Year Formula in Excel

  • Press Enter to see the difference in growth.

Steps to Use Growth Over Last Year Formula in Excel


Step 2: Apply Formula to Find Growth Rate Over Last Year

=(D5-C5)/C5

Steps to Use Growth Over Last Year Formula in Excel

  • Then, press Enter to get the Growth Rate.

Steps to Use Growth Over Last Year Formula in Excel

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


Step 3: Find the Percentage in Growth Over Last Year

  • To find the percentage of the Growth Rate, click on the Percentage (%) from the Number tab.

Steps to Use Growth Over Last Year Formula in Excel

  • Finally, you will obtain the value of the Growth Rate in Percentage.

Steps to Use Growth Over Last Year Formula in Excel

Read More: How to Calculate Growth Percentage with Formula in Excel


Step 4: Copy the Formula to the Required Cells

  • To apply the same formula to fill the column, use the AutoFill tool to auto-fill the cells.

Sample Data

Sample Data


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

To conclude, I hope this article has given you some useful information about how to use formulas to calculate the growth over the last year in Excel. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

If you have any questions – Feel free to ask us. Also, feel free to leave comments in the section below.


Related Articles


<< Go Back to Growth Formula In Excel | Excel Formulas for Finance | Excel for Finance | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bhubon Costa
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo