# 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.

## 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.

### 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)`

• Press Enter to see the difference in growth.

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

`=(D5-C5)/C5`

• Then, press Enter to get the Growth Rate.

### 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.

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

### 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.

## 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, 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

Advanced Excel Exercises with Solutions PDF