How To Calculate Revenue Growth Rate: Formula & Examples

The revenue growth rate is a performance indicator that shows if your sales efforts are yielding positive results. Tracking it over time is crucial to identify trends, pinpoint periods of acceleration or stagnation, and adjust your strategies accordingly.

This guide provides a clear and concise approach to calculating your revenue growth rate. We’ll delve into the formula, walk you through the process in Excel with helpful screenshots, and offer practical tips for interpreting your results.

Looking to create reporting system fast & painlessly?
Build dashboards and track KPIs in one place with Ajelix BI

Start free

What is the Revenue Growth Rate?

The Revenue Growth Rate is a metric that shows the percentage change in a company’s revenue over a specific period. In simpler terms, it tells you how much faster (or slower) your income is growing compared to a previous period.

Example screenshot with revenue growth chart for years 2022-2023, image by author

This indicator is crucial for businesses to understand the success of the sales performance. Let’s take a look at the formula.

The Revenue Growth Rate Formula

(Current Revenue – Previous Revenue) / Previous Revenue * 100

• Current Revenue: The total income your business generated in the most recent period you’ve chosen (e.g., current month, quarter, or year).
• Previous Revenue: Total income your business generated in the previous period (e.g., month, quarter, or year).
• Division by Previous Revenue: The change in revenue relative to your starting point.
• Multiplication by 100: Converts the result from a decimal to a percentage, making it easier to interpret the growth rate.

Revenue Growth Example

To make things even clearer, imagine a scenario:

• Your company’s revenue for the current quarter is $27,000.
• In the same quarter last year, your revenue was $23,000.

Here’s the solution for this example:

• (Current Revenue – Previous Revenue) / Previous Revenue * 100
• ($27,000 – $23,000) / $23,000 * 100
• $5,000 / $23,000 * 100
• 0.17* 100 = 17.39%

Solution screenshot in Excel with calculation steps, image by author

Your revenue growth rate for this quarter is 33.33%. This indicates a significant increase in sales compared to the same period last year.

In the next section, we’ll walk you through a step-by-step guide with screenshots to put this formula into practice!

How To Calculate Revenue Growth in Excel?

Here’s video on how to calculate revenue growth in Excel:

Calculate Revenue Growth with Ajelix BI

Ajelix BI can be helpful with data visualization tasks and KPI calculations. BI platforms can help with data monitoring and ad hoc report creation as you can perform simple analytics tasks faster. Let’s see how non-technical teams can use Ajelix to calculate metrics and create a more trustworthy reporting process.

1. Prepare your data

First things first: get your data organized! This can be done in an Excel table or a Google Sheets file. We’ll use an example to show how to set up your data to easily track growth over a specific period, comparing the current year to the last.

Screenshot from Excel with tabular data table, picture by author

2. Upload Your Data

Once you have the data you can easily upload it to the Ajelix BI platform. Simply go to dataset upload page click upload data and pick the file.

Screenshot from Ajelix BI with data upload, image by author

3. Create calculation

With your file uploaded, you’re ready to create your report and access the editor. Head to the “Create KPI or metric” tab and click “Add new measure.” This will open a window where you can easily build your formula by selecting the relevant column names.

KPI editor for formula creation in Ajelix BI platform, image by author

4. Create chart

Now you have created a new column with the “Revenue Growth” metric. The next step would be to visualize this column in a pretty chart.

1. Go to “Report Editor”
2. Pick the “Smooth Line Chart” or other element
3. Add the title “Revenue growth 2022-2023” or other title
4. Set number formatting to 0%
5. Pick the category “Month”
6. Add the newly created “Revenue Growth” as a data field

Now you have created a chart that you can share with others and update regularly.

Ajelix BI settings for creating YoY chart, screenshot from author

Ready to give it a go?
Connect your data and create professional reports

Start free
Try free and upgrade whenever

Difference Between Revenue Growth Rate And YOY

The revenue growth rate formula is essentially the same way you calculate the Year-over-Year (YoY) growth rate for revenue. Here’s why:

• YoY (Year-over-Year): This term refers to comparing a specific metric (like website traffic) in the current year to the same metric in the previous year. It’s a common way to analyze performance trends over time.
• Revenue Growth Rate Formula: This formula calculates the percentage change in revenue between two periods.

When you choose the current year and the previous year for your time period in the revenue growth rate formula, it automatically becomes a YoY growth rate calculation. Here’s a table to illustrate the connection:

Both methods use the same core formula, but YoY focuses on a specific comparison window (one year).

Similar Formulas

Revenue growth rate is a core metric, but there are other formulas you can use to analyze a business’s performance alongside it. Here are a few examples:

1. Customer Acquisition Cost (CAC)

This formula helps you understand how much it costs to acquire a new customer.

Formula: CAC = Total Customer Acquisition Expenses / Number of New Customers Acquired in a Period

2. Customer Lifetime Value (CLTV)

This formula estimates the total revenue a customer generates for your business throughout their relationship.

Formula: CLTV = Average Customer Value (ACV) * Average Customer Lifespan

3. Gross Margin

This formula shows the profitability of your products by considering the cost of goods sold.

Formula: Gross Margin = (Revenue – Cost of Goods Sold) / Revenue * 100

4. Net Profit Margin

This formula takes a deeper dive into profitability by factoring in all operating expenses.

Formula: Net Profit Margin = Net Profit / Revenue * 100

5. Month-over-Month (MoM) Growth Rate:

Similar to YoY growth rate, this formula compares revenue between consecutive months.

Formula: MoM Growth Rate = ((Current Month Revenue – Previous Month Revenue) / Previous Month Revenue) * 100

6. Year-to-Date (YTD) Growth Rate:

This formula calculates the total revenue growth from the beginning of the current year to a specific date.

Formula: YTD Growth Rate = ((Current YTD Revenue – Previous YTD Revenue) / Previous YTD Revenue) * 100

Remember, these are just a few examples. The specific formulas you use will depend on your business goals and the data you’re analyzing.

What is a good Revenue Growth Rate?

Keep in mind that there’s no single “good” revenue growth rate that applies universally. It depends on several factors, including:

• Company Stage: Startups can expect much higher growth rates (sometimes exceeding 100%) compared to established businesses (often aiming for 15-25% growth).
• Industry: Different industries have varying growth patterns. Tech startups might target aggressive growth, while mature industries like utilities might see steadier, lower growth.
• Company Goals: Some businesses prioritize rapid expansion, justifying a higher growth rate. Others might focus on profitability or stability, aiming for more moderate growth.

Here’s a general breakdown to give you an idea:

• High Growth (Startups): 100% or more (can be much higher in specific industries)
• Healthy Growth (Established Businesses): 15-25%
• Stable Growth (Mature Industries): Single digits

Remember, these are just ranges. The “good” growth rate for you depends on your specific circumstances. It’s more important to understand trends in your own growth rate and compare them to your industry benchmarks.

Conclusion

Calculating your revenue growth rate is crucial for understanding your business’s financial health and sales performance.

Remember, a strong revenue growth rate is a positive indicator, but it’s not the only measure of success. Consider other factors alongside it, and use industry benchmarks as a reference point.

The good news is that the steps outlined in this blog make calculating and analyzing your revenue growth rate accessible. Start by gathering your revenue data, apply the formula in Excel (or other software), and don’t be afraid to delve deeper into the trends you uncover.

FAQ

• Twitter
• LinkedIn
• Facebook
• Instagram
• YouTube