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.

**Table of Contents**hide

## 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 **Sale****s **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.

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

- After that, simply press
**Enter**on your**keyboard**, and you will get**0.****30**as the return of the formula.

**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**

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

**Related Content: How to Calculate Growth Percentage Formula in Excel**

**Similar Readings**

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Apply Percentage Formula in Excel for Marksheet (7 Applications)****Calculate Bacterial Growth Rate in Excel (2 Easy Ways)****How to Calculate Percentage in Excel Based on Cell Color (4 Methods)****Calculate Percentage Increase from Zero in Excel (4 Methods)**

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

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

- 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%.**

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