From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.
  • Home
  • Blog
  • bi
  • How to Calculate Business Growth Rate? Formula & Examples

How to Calculate Business Growth Rate? Formula & Examples

  • Author:
  • Published on:
    April 16, 2024
  • Category:
  • Last updated:
    April 10, 2024
Hoe to calculate business growth rate with examples and formula banner by ajelix

Whether you’re a seasoned entrepreneur or just starting, measuring progress is vital to identify areas of strength, pinpoint opportunities for improvement, and propel your business forward. 🚀

This guide will equip you with the knowledge and tools needed to become a master of business growth measurement. We’ll break down the core formula for calculating growth, explore key metrics that go beyond just revenue, and introduce you to strategies for simplifying the process.

Before you jump in...
Looking to create reporting system fast & painlessly? Check our latest Ajelix BI platform for easy data analytics to help you make data driven decisions.

Give it a go

What is the Business Growth Rate?

The business growth rate is a percentage that reflects how much a specific business metric, like revenue or website traffic, has increased over a set period. It’s a simple calculation that helps you gauge your company’s progress and potential for expansion.

Business Growth Rate Formula

Growth Rate (%) = (Current Value – Past Value) / Past Value x 100%


  • Current Value: The value of your chosen metric (e.g., revenue, website traffic) at present (e.g., this month’s revenue).
  • Past Value: The value of the same metric at a previous time (e.g., last month’s revenue).

What Data Can Be Used for Measuring Business Growth?

While the growth rate formula helps quantify progress, various metrics offer a more well-rounded picture of business growth. To measure business growth define metrics that reflect the business growth.

Here are some key metrics that can measure business growth:

Financial Business Growth Metrics

  • Revenue growth: This is the most popular measure of growth, reflecting the total income generated.
  • Profit: Healthy growth often leads to increasing profits. Monitor net income (revenue minus expenses) to assess profitability alongside revenue growth.

Market Presence and Efficiency

  • Market Share: This reflects the percentage of the total market your business controls. Growth can be measured by an increase in market share.
  • Website Traffic: For online businesses, website traffic growth indicates you’re reaching a wider audience. Track unique visitors and other engagement metrics alongside traffic.

The best approach is to combine these metrics into the operational dashboard to get a holistic view of your business growth. One metric can’t tell you the growth but a set of different metrics can.

How To Calculate Business Growth Rate?

Time needed: 4 minutes

Here’s a step-by-step guide on how to calculate business growth rate:

  1. Define Your Goal and Choose a Metric

    Identify your current business objective. Select a metric that aligns with your goal. Common metrics include revenue, customer acquisition cost (CAC), customer churn rate, market share, and website traffic.

  2. Gather Your Data

    You’ll need the values of your chosen metric for two different periods.
    For the current value: Look at your most recent data (e.g., this month’s sales figures).
    For the past value: Choose an earlier period relevant to your goal. This could be the previous month, quarter, or year, depending on what growth trends you want to analyze.

  3. Apply the Growth Rate Formula

    Growth Rate (%) = (Current Value – Past Value) / Past Value x 100%

  4. Visualize Data

    Use charts, graphs, and dashboards to visualize results and see trends over time.

  5. Interpret Your Results

    The formula will provide you with a percentage that reflects the growth rate.
    A positive number indicates growth (increase in the metric), while a negative number indicates decline.
    The higher the percentage (positive or negative), the larger the change.
    Revenue growth chart example screenshot


Let’s say you want to calculate your quarterly customer acquisition rate growth.

  • In Q1, you acquired 100 new customers. (Current Value)
  • In Q0 (previous quarter), you acquired 80 new customers. (Past Value)
  • Growth Rate = (100 customers – 80 customers) / 80 customers x 100%
  • Growth Rate = 20 customers / 80 customers x 100%
  • Growth Rate = 25%

This indicates a 25% increase in customer acquisition rate from Q0 to Q1.


  • You can adjust the time frame (monthly, quarterly, annually) based on your needs.
  • Growth rate offers a quick view, but monitor it over several periods to identify trends.
  • Use a combination of relevant metrics for a more comprehensive understanding of business growth.

How To Calculate Business Growth Rate in Excel?

Excel provides a user-friendly way to calculate business growth rates. Here’s a breakdown of the steps involved:

1. Prepare your Data

Prepare data table in Excel spreadsheet for business growth

Screenshot from Excel spreadsheet with revenue example data, image by author

The first step is to organize your data in a spreadsheet. The first column typically holds labels for the period (e.g., Month, Quarter, Year). For example, you can see the “Month” heading for the first column and “Revenue” for the second.

Example data with monthly revenue data

2. Enter the Formula

Choose a blank cell where you want the growth rate to be displayed. Simply add another column where you’ll calculate the growth rate. Here’s an example:

We want to find the growth rate for revenue from February to December. In an empty cell C3, enter the formula to calculate the growth rate formula:

= (B3 – B2) / B2 * 100 and you should have a percentage rate.

Business growth rate formula in Excel example screenshot

Screenshot from Excel with growth rate formula example, image by author

3. Apply the Formula to Multiple Periods

If you want to calculate growth rates for several periods, you can copy the formula down the column. Excel will automatically adjust the cell references within the formula as you copy it.

Paste the formula to the cells below from example, screenshot from excel

Screenshot from Excel on how to copy formula down, image by author

4. Format the Results as Percentages

Select the cells containing the growth rate calculations. Go to the “Number” format section in the Excel ribbon. Choose the percentage format with the desired number of decimal places.

Format cells as percentage example screenshot from excel

Screenshot from Excel with percentage settings, image by author

Similar Formulas To Business Growth Rate

While the core growth rate formula (Current Value – Past Value) / Past Value x 100% is versatile, there are other formulas you might encounter depending on the specific growth aspect you’re analyzing. Here are a few examples:

1. Compound Annual Growth Rate

This formula is used to calculate the average annual growth rate of an investment over a period exceeding one year. It considers the impact of compounding interest, where earnings from previous periods are reinvested and also generate returns.


CAGR = (End Value)^(1/Number of Years) – 1 x 100%


  • End Value: The value at the end of the period you’re analyzing.
  • Number of Years: The total number of years in the period.


Imagine your company’s revenue grew from $1 million in year 1 to $1.5 million in year 5.

CAGR = ($1.5 million)^(1/5) – 1 x 100%

CAGR ≈ 14.87%

This indicates an average annual growth rate of around 14.87% over the five-year period.

2. Customer Lifetime Value (CLV) Growth Rate

This formula helps assess how effectively you’re increasing the value each customer brings to your business over time.


CLV Growth Rate = ((Current CLV – Past CLV) / Past CLV) x 100%


  • Current CLV: The average revenue a customer generates over their relationship with your business at the present time.
  • Past CLV: The average revenue a customer generated at an earlier point.

3. Market Share Growth Rate:

This formula measures the growth in the percentage of the total market your business controls.


Market Share Growth Rate = ((Current Market Share – Past Market Share) / Past Market Share) x 100%


  • Current Market Share: The percentage of the total market your business controls at the present time.
  • Past Market Share: The percentage of the market your business controlled at an earlier point.

How Can Ajelix BI help with Business growth calculations?

Calculating business growth is essential but manually crunching numbers and wrestling with spreadsheets can be time-consuming and error-prone. Ajelix BI can help streamline growth calculations and empower you to focus on strategic insights.

Ad hoc financial analysis report example from ajelix bi portal

Financial dashboard example from Ajelix BI platform, image by author

Ajelix BI goes beyond basic data visualization. Its user-friendly platform boasts an easy-to-use KPI editor, allowing you to define and track key performance indicators (KPIs) central to your growth objectives. This eliminates the need for complex formulas and streamlines the process of monitoring progress.

With AI functionality businesses can create dashboards tailored to various business goals, getting started is quick and effortless.

Generate Your Business Data Dashboard With One Click on Ajelix BI Platform - AI Dashboard Generator

But Ajelix BI doesn’t lock you into its ecosystem. It seamlessly integrates with your existing workflow, connecting effortlessly to your familiar tools like Excel and Google Sheets. This means you can leverage your existing data sources and continue working in your preferred environment, while Ajelix BI brings its analytical muscle to the table.

By automating calculations, providing pre-built dashboards, and offering smooth integration with your favorite tools, Ajelix BI lets you spend less time wrestling with data and more time strategizing for growth.

Ready to give it a go?
Test Ajelix BI on freemium plan and only upgrade if our platform can solve your reporting issues.

Give it a go


Calculating business growth doesn’t have to be a daunting task. By understanding the core formula and the various metrics that paint a holistic picture, you’re equipped to assess your company’s progress.

Stop spending time wrestling with spreadsheets and focus on what truly matters: strategizing for long-term success. Take control of your growth journey with Ajelix BI today.


What is the core formula for calculating business growth rate?

The core formula for calculating business growth rate is (Current Value – Past Value) / Past Value x 100%. Here, “Current Value” refers to the value of your chosen metric (e.g., revenue) at present, and “Past Value” is the same metric’s value at an earlier point.

What is the easiest way to measure business growth?

The easiest way to measure business growth is by calculating the growth rate of a key metric relevant to your goals. This involves the formula: (Current Value – Past Value) / Past Value x 100

From data to report in one minute or less with Ajelix BI

Ad hoc financial analysis report example from ajelix bi portal

Similar posts

generative AI for data analytics banner blog article by ajelix

Generative AI For Data Analytics: What You’re Missing Out

April 18, 2024
Organizations across all industries are turning to data analytics to inform strategic decisions, optimize processes, and gain a competitive edge. But what happens when the data itself becomes a hurdle? Limited datasets, time-consuming manual tasks, and hidden patterns within complex data can all act as bottlenecks, hindering the full potential of data analytics. 📉 Gartner […]
How to calculate average revenue per user formula & meaning example banner

Calculate Average Revenue Per User: ARPU Formula & Meaning

April 11, 2024
The metrics are king, there’s no doubt about it. They tell the story of your company’s health, customer base, and overall success. But with so many acronyms flying around, it’s easy to get lost in the alphabet soup. 🥣 Today, we’re diving into ARPU formula, a metric crucial for understanding the value of your customers. […]
How to calculate revenue growth in Excel with examples and formulas banner by ajelix

How To Calculate Revenue Growth Rate: Formula & Examples

April 9, 2024
Revenue growth rate is a performance indicator, that helps understand 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 […]