# 2 Ways to Calculate Revenue Growth Rate in Excel

The revenue keeps changing in the fast-growing business world. So many of you have to regularly calculate the revenue growth rate. But the good news is that you can calculate the revenue growth rate using Microsoft Excel. This article will teach you 2 easy methods to calculate the revenue growth rate in Excel.

## Revenue & Revenue Growth Rate

### 1. Revenue

In the easiest language, revenue is the total income of a company in a given period of time. The income can come from either selling goods or selling services.

There are two formulas to calculate the revenue:

### 2. Revenue Growth Rate

The revenue growth rate is the change in revenue value over a given period of time.

The formula to calculate the revenue growth rate:

The revenue growth rate can be calculated weekly, month to month, and year to year.

## Introduction to the Dataset

The dataset I am going to use for this article has 3 columns: **Month** **(column A)**, **Revenue(USD)** **(column B)**, and** Revenue Growth Rate (column C)**. I am going to show the monthly change in revenue in this article. But you can also apply this method to calculate the weekly change or yearly change.

## Quickest Way to Calculate Revenue Growth Rate in Excel

I think the following formula will be the easiest one to remember for anyone.

**Usage Guide**

**Step_1: **Insert a new column for the revenue growth rate results.

I have used **column C **and named it**: Revenue Growth Rate**.

**Step_2: **Select cell **C3**.

**Step_3: **Write the following formula in cell **C3**:

**=B3/B2-1**

** **

**Formula Explanation**

**B2**is the**Starting Value**.**B3**is the**Ending Value**.- I applied the formula in cell
**C3**because**B2**is the first**Starting Value**and**B3**is the first**Ending Value**. Before**B2**, there is no beginning value. So you can’t show any change of values in cell**C2**.

**Step_4: **Now press **ENTER**.

The result will come along in decimal form.

**Decimal to Percentage**

**Step_5: **Select cell **C3**.

**Step_6: **Select the **Home **tab.

**Step_7:** Click on the **‘%’ **icon from the **Number **group.** **

** **

**Step_8: **Double-click on the **Fill Handle** to fill down the formula from cell **C3 **to **C13**.

**Final Result >**

Here is the outcome. Take a look.

** **

### Alternative Way: Use the Basic Formula to Calculate the Revenue Growth Rate in Excel

The basic formula for revenue growth rate is finding the difference between the initial and final value; then dividing the value by the initial value. I am going to use this formula and add the percentages with the result in the next steps.

**Usage Guide**

**Step_1: **Create a new column for the results (**column C**).

**Step_2: **Select cell **C3**.

**Step_3: **Write the following formula in cell **C3**:

**=(B3-B2)/B2**

**Formula Explanation**

**B3**is the final revenue.**B2**is the starting revenue.

**Step_4: **Hit **ENTER**.

The result is in decimal form, **0.192307692**. You can keep the result in this form. But usually, the rates are expressed in percentages.

**Decimal to Percentage**

**Step_5: **Give a single click on cell **C3**.

**Step_6: **Click on the **Home **tab.

**Step_7: **From the **Number** group, click on the **‘%’ icon**. ** **

You will find the result has been converted into a percentage.

**Step_8: **Double-click on the **Fill Handle** to fill down the formula.

**Final Result >**

## Conclusion

I have tried to cover everything about the revenue growth rate in this article. I hope you will find this article helpful. Please let us know if you have any questions regarding this blog in the comment section.

**Related Articles**

**How to Calculate Annual Growth Rate in Excel (5 Different Cases)****Calculate Dividend Growth Rate in Excel [2+ Formulas]****2 Ways to Calculate Bacterial Growth Rate in Excel****3 Ways to Forecast Growth Rate in Excel****3 Scenarios of Exponential Growth Formula in Excel****2+ Ways to Calculate Monthly Growth Rate in Excel**