The Revenue Growth Rate is a popular term for business organizations. It indicates how fast the company is growing. In this tutorial, we will show some techniques to calculate the revenue growth rate in Excel just in a few clicks.
What is Revenue?
Revenue is the amount of income that is earned from a business.
It is calculated as:
It is the total cash flow of a business by a successful operation scheme.
What is the Revenue Growth Rate?
The revenue growth rate is the value of revenue changes over a period.
It is calculated as:
So, it is based on the difference between new revenue and previous revenue. The revenue growth rate is calculated for the same months of different years, month to month, or weekly basis.
How to Calculate Revenue Growth Rate in Excel: 3 Ways
We will show some easy examples to calculate the revenue growth rate in Excel.
1. Calculate Monthly Revenue Growth
In this example, we will calculate the revenue growth from the dataset below.
We have a column named Revenue Growth Rate for calculation.
Step 1:
First, we will calculate the growth of the month of February compared with January.
- Go to cell D6 and put the following formula.
=(C6-C5)/C5
Step 2:
- Now, press Enter.
We get a decimal value. We will convert this to the percentage format.
Step 3:
- Press the right button of the mouse.
- Click on the Format cells from the list.
You can also go to the Format cells option by applying the Keyboard Shortcut CTRL+1.
Step 4:
- Choose Percentage from the Number section.
- Then press OK.
We can decide how many digits will exist after the point.
Now, look at the result.
Step 5:
- Drag the Fill Handle icon then.
Finally, we get the Revenue or sales growth rate for our dataset.
Read More: How to Calculate Monthly Growth Rate in Excel
2. Alternate Way to Calculate Revenue Growth
We will perform the same operation using a different formula in this example. Just divide the new revenue by the previous revenue and subtract 1 from that value.
Step 1:
- Go to cell D6.
- Put the formula below.
=C6/C5-1
Step 2:
- Then press Enter.
- Now, we will convert this decimal value into a percentile.
Step 3:
- Go to Number group from the Home tab.
- Select Percentage from the list.
Look at the dataset now.
Step 4:
- Pull the Fill Handle icon now.
We get the revenue growth percentage by using the formula now.
Related Content: How to Calculate Annual Growth Rate in Excel
3. Calculate Revenue Growth of Months over Years
We will compare the revenue of January, February, and March of the years 2019 and 2020. The following dataset will be used for this.
We add a row for calculation in the dataset.
Step 1:
- Move to cell C9.
- Write the following formula.
=C6/C5-1
Step 2:
- Then, press Enter.
We get the growth rate.
Step 3:
- Pull the Fill Handle icon to the right side.
This is how we can calculate the growth rate of each month from different years.
Related Content: Growth Over Last Year Formula in Excel
Predict the Revenue Growth Depending on the Previous Values
We can predict the revenue of a month from the revenue of the last 12 months.
We will use the GROWTH function for this. This dataset will be used for this prediction.
We will calculate the revenue for January 2022.
Step 1:
- Go to cell D17.
- Write the following formula.
=GROWTH(D5:D16,B5:B16,B17)
Step 2:
- Now, press the Enter button.
So easily we can predict the revenue of a month from the previous values.
Related Content: How to Calculate Dividend Growth Rate in Excel
Things to Remember
- The revenue growth rate must be in percentile form.
- The GROWTH function is used for forecast purposes only.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, we described how to calculate the revenue growth rate in Excel. We also showed how to predict the revenue depending on previous revenue. I hope this will satisfy your needs. If you have any questions, feel free to leave comments in the section below.
Related Articles
- How to Use the Exponential Growth Formula in Excel
- Growth Formula in Excel with Negative Numbers
- How to Calculate Sales Growth over 5 Years in Excel
- How to Calculate Sales Growth Percentage in Excel
- How to Calculate Year over Year Growth with Formula in Excel
<< Go Back to Growth Formula In Excel | Excel Formulas for Finance | Excel for Finance | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
