How to Calculate Monthly Growth Rate in Excel (2 Methods)

We calculate the monthly growth rate to figure out how much our assets and investments are worth. Microsoft Excel makes this task easier. From our dataset, in this article, we’ll learn two quick and suitable ways to calculate the monthly growth rate in Excel with appropriate illustrations. Here’s an overview of the dataset for today’s task.

calculate monthly growth rate in excel


Download Practice Workbook

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


Introduction to the Monthly Growth Rate

Undoubtedly, calculating the month-over-month growth rate is an easy task. Subtract the first month from the second month, then divide by the previous month’s total to get Month-over-Month growth. You’ll get a percentage when you multiply the result by 100. Your Month-over-Month growth rate is expressed as a percentage. The Monthly Growth Rate(MGR) formula is,

MGR = ((Y -X)/ Y)*100%

Where,

X = First Month’s Total

Y = Second Month’s Total

By applying the above formula, we also can calculate the week-over-week growth rate or year-over-year growth rate.


2 Suitable Ways to Calculate Monthly Growth Rate in Excel

1. Use the Linear Formula to Calculate Monthly Growth Rate in Excel

Let’s say, we have a dataset that contains information about Sales in several months. We can calculate the month-over-month growth rate by applying the Linear formula in Excel. From our dataset, we’ll calculate the linear monthly growth rate.  Let’s follow the instructions below to learn!

Step 1:

  • First, select cell D6 to calculate the monthly growth rate.

Use the Linear Formula to Calculate Monthly Growth Rate in Excel

  • Hence, write down the below formula in the Formula Bar. The formula is,
=(C6-C5)/C6
  • Where C6 is the total sale in February and C5 is the total sale in January.

Use the Linear Formula to Calculate Monthly Growth Rate in Excel

  • After that, simply press Enter on your keyboard, and you will get 0.30 as the return of the formula.

Use the Linear Formula to Calculate Monthly Growth Rate in Excel

Step 2:

  • Further, place your cursor on the bottom-right on cell D6, and an autoFill sign will appear in front of you.

  • After that, drag the autoFill sign downward, and you will get your desired output that has been given in the below screenshot.

Step 3:

  • Now, look at our dataset, you will see that the formula returns fraction value. We will convert these fraction values into a percentage. To do that, from Home tab, go to,

Home → Number → Percentage

Use the Linear Formula to Calculate Monthly Growth Rate in Excel

  • Finally, after completing the above process, you will get the monthly growth rate.

Step 4:

  • Here’s the graphical representation of our monthly growth rate.

Use the Linear Formula to Calculate Monthly Growth Rate in Excel

Related Content: How to Calculate Growth Percentage Formula in Excel


Similar Readings:


2. Apply the Compound Interest Rate Formula to Calculate Monthly Growth Rate in Excel

In this method, we will calculate compounded monthly growth rate. The formula of the  Compounded Monthly Growth Rate(CMGR) is,

CMGR =( Last Month/ First month)^(1/ Month Difference) - 1

Let’s follow the steps below to calculate compounded monthly growth rate.

Step 1:

  • First of all, select cell D5 to calculate compounded monthly growth rate.

Apply the Compound Interest Rate Formula to Calculate Monthly Growth Rate in Excel

  • After that, write down the below formula in the Formula Bar. The formula is,
=((C16/C5)^(1/(12-1)))-1
  • Where C16 is the total sale in December and C5 is the total sale in January.

Apply the Compound Interest Rate Formula to Calculate Monthly Growth Rate in Excel

  • Hence, press Enter on your keyboard, and you will get 060648419 as the return of the formula.

Step 2:

  • Further, look at our dataset, you will see that the formula returns fraction value. We will convert these fraction values into a percentage. To do that, from your Home tab, go to,

Home → Number → Percentage

  • Finally, you will be able to calculate compounded monthly growth rate. The compounded monthly growth rate is 6.06%.

Apply the Compound Interest Rate Formula to Calculate Monthly Growth Rate in Excel

Related Content: Percentage Formula in Excel (6 Examples)


Things to Remember

👉 The formula returns you a fraction value, then converts it into a percentage for calculating the monthly growth rate.


Conclusion

I hope all of the suitable methods mentioned above to calculate the monthly growth rate will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo