How to Compute Growth Rate: Formula, Excel Examples & SaaS Revenue Metrics

Whether you're a SaaS founder tracking MRR, a finance lead preparing board reports, or a revenue analyst monitoring subscription churn, knowing how to compute growth rate accurately is essential for forecasting revenue, measuring business performance, and making strategic decisions. 

According to McKinsey & Company, companies with strong performance management practices are 4.2 times more likely to outperform peers and achieve an average of 30% higher revenue growth 

Yet growth calculations remain one of the most inconsistently applied metrics across finance and operations teams.

From revenue growth formula calculations and Excel-based analysis to MoM, YoY, and CAGR metrics, selecting the right method directly impacts forecasting accuracy and business planning.

This guide explains how to calculate growth rate correctly using practical formulas, real business examples, and subscription growth scenarios.

What Is Growth Rate?

Growth rate is the percentage increase or decrease of a business metric over a specific period of time. Companies use growth rate calculations to measure revenue, sales, customer acquisition, subscription expansion, and overall business performance.

The growth rate formula calculates how much a value has changed between two points in time, expressed as a percentage. In business, the growth rate equation is commonly used for revenue, customers, transactions, and SaaS metrics like ARR and MRR.

A positive growth rate indicates expansion, while a negative growth rate signals contraction. For example, a 5% month-over-month revenue growth rate may be strong for an enterprise software company but modest for an early-stage startup targeting rapid scale.

Growth rate calculations are essential for:

• Revenue forecasting and budgeting
• Investor and board reporting
• Subscription analytics and churn tracking
• Payment and billing performance analysis

Growth Rate Formula Explained

The standard growth rate formula measures the percentage change between an old value and a new value over a specific period. Businesses use this growth rate equation to track revenue growth, customer growth, subscription expansion, sales performance, and other KPIs.

Growth Rate (%) = ((Current Value − Previous Value) / Previous Value) × 100

The formula calculates how much a metric changed relative to its starting point. This same growth calculation formula works across nearly every business metric and reporting period. This same approach is also used in the annual growth rate formula for long-term business analysis. 

Example Calculation

• Revenue in January: $80,000
• Revenue in February: $94,000

((94,000 − 80,000) / 80,000) × 100 = 17.5%

That means the business achieved a 17.5% month-over-month revenue growth rate.

One of the most common mistakes in growth rate calculations is dividing by the current value instead of the previous value. The denominator must always be the starting value because it defines the true percentage change over time. 

Many finance teams also use a growth percentage calculator or spreadsheet model to automate recurring calculations and improve reporting accuracy. 

How to Calculate Growth Rate Step-by-Step

If you're wondering how to calculate growth rate accurately, the process is straightforward when the inputs and reporting periods are clearly defined. The same approach applies whether you're measuring revenue, customers, subscriptions, or transaction volume.

Step 1: Define the metric

Choose the KPI you want to measure and define the reporting period clearly. For example, revenue growth could refer to gross revenue, net revenue, monthly recurring revenue (MRR), or annual recurring revenue (ARR). Clear definitions are essential when you calculate percentage growth across teams or reporting systems. 

Step 2: Identify start and end values

Pull both values from the same reporting source to avoid inconsistencies. Using data from different platforms such as a CRM, payment gateway, or billing system often creates reporting discrepancies that distort growth calculations. Businesses pulling subscription data from Stripe, CRM systems, and accounting tools frequently see inconsistent reporting unless the data is reconciled properly. 

Step 3: Apply the growth rate formula

Use the standard growth calculation formula:

Growth Rate (%) = ((End Value − Start Value) / Start Value) × 100 

This formula helps calculate percentage growth for nearly any business metric over a defined time period.

Step 4: Interpret the results in context

A growth rate only becomes meaningful when compared against historical performance, industry benchmarks, or internal targets. For example, a 10% quarterly growth rate may be exceptional in one industry and below expectations in another. 

Step 5: Validate the data source

Growth calculations are only as reliable as the underlying data. If your analytics platform, payment processor, and billing system are not reconciled properly, reporting inconsistencies can lead to inaccurate forecasts and business decisions. Many finance teams use a business growth rate calculator or BI dashboard to validate growth reporting automatically and reduce manual errors. 

Example: Subscription growth rate calculation

• Active subscriptions in Q1: 1,200
• Active subscriptions in Q2: 1,440

((1,440 − 1,200) / 1,200) × 100 = 20% 

In this example, the subscription business achieved a 20% quarterly growth rate.

To calculate percentage growth across multiple years or long-term business periods, CAGR is usually a more accurate metric.

Revenue Growth Formula for Businesses

The revenue growth formula measures how much a company’s revenue increased or decreased over a specific period. It is one of the most important company growth metrics used in SaaS, subscription finance, and financial forecasting because it directly reflects business momentum and operational performance. 

Revenue Growth Rate (%) = ((Revenue This Period − Revenue Last Period) / Revenue Last Period) × 100 

While the formula itself is simple, revenue analysis becomes more complex for businesses managing recurring billing, refunds, pricing tiers, and multiple revenue streams.

For product and transaction-based businesses, revenue usually refers to net revenue after refunds, discounts, and returns. In SaaS and subscription companies, revenue growth is commonly segmented into:

• New MRR: revenue from new customers
• Expansion MRR : upgrades, cross-sells, and seat additions
• Churned MRR : revenue lost from cancellations or downgrades
• Net New MRR : the combined impact of growth and churn

Analyzing only blended revenue growth can hide operational issues. For example, a company reporting 15% revenue growth with high churn is in a very different position from a business achieving the same growth with strong customer retention. For many mid-stage SaaS businesses, sustainable annual revenue growth typically ranges between 20% and 40%, depending on retention and expansion efficiency.

The sales growth rate formula is especially useful for e-commerce, retail, and transaction-driven businesses where subscription-based metrics are less relevant.

Sales Growth Rate (%) = ((Current Period Sales − Prior Period Sales) / Prior Period Sales) × 100
Both the revenue growth formula and sales growth rate formula are widely used in investor reporting, board presentations, budgeting, and annual business planning.

Month Over Month Growth Formula

Month-over-month (MoM) growth measures the percentage change in a metric from one month to the next. The month over month growth formula is widely used by SaaS, subscription, e-commerce, and transaction-driven businesses because it helps identify short-term performance trends and monthly revenue momentum quickly. 

MoM Growth Rate (%) = ((This Month's Value − Last Month's Value) / Last Month's Value) × 100 

Because MoM analysis is highly sensitive, it can highlight momentum early — but it can also exaggerate seasonal spikes or temporary promotional gains. This is why businesses often pair MoM reporting with rolling 3-month or 6-month trend analysis. 

Common MoM growth use cases

• Monitoring MRR growth during product launches
• Tracking transaction volume after payment system changes
• Identifying early subscription churn trends
• Measuring short-term sales or customer acquisition performance

For recurring revenue businesses, tracking MoM performance on net revenue, after refunds, failed payments, and disputes, provides a more reliable indicator of recurring revenue movement than gross transaction volume alone.

Month over month growth formula in excel

If January revenue is in cell B2 and February revenue is in cell B3, use: 

Excel formula:

=(B3-B2)/B2

This is one of the most common methods used to calculate growth rate in Excel for SaaS and finance reporting.

When formatted as a percentage, the formula returns a 15% month-over-month increase.

Many finance and operations teams also use a MoM growth calculator or spreadsheet templates to automate recurring growth analysis across revenue, subscriptions, and transaction data. 

Year Over Year Growth Formula

Year-over-year (YoY) growth measures the percentage change in a business metric compared to the same period in the previous year. The year over year growth formula is commonly used as part of annual growth rate formula analysis for budgeting, investor reporting, and board-level performance reviews because it removes short-term seasonal fluctuations. 

YoY Growth Rate (%) = ((This Year's Value − Last Year's Value) / Last Year's Value) × 100 

Unlike month-over-month analysis, YoY growth compares equivalent periods, making it more stable and reliable for long-term trend evaluation. For example, comparing December sales to November sales may produce misleading conclusions due to seasonal buying behavior, while comparing December this year to December last year provides a clearer picture of actual business growth. 

Example: YoY ARR Growth

• ARR in FY2023: $2.4M
• ARR in FY2024: $3.1M

((3,100,000 − 2,400,000) / 2,400,000) × 100 = 29.2% 

In this example, the business achieved a 29.2% year-over-year ARR growth rate.

MoM vs YoY growth

For larger businesses, YoY analysis is one of the most reliable ways to measure business growth over time because it provides a clearer view of sustainable revenue performance.

YoY growth is also one of the most widely used company growth metrics for competitive benchmarking. If similar SaaS companies are growing at 35% YoY while your business is growing at 18%, the gap may indicate differences in pricing strategy, customer retention, acquisition efficiency, or product-market fit. 

A SaaS company growing 30% YoY with strong retention typically has a healthier revenue profile than a business growing 50% with high churn.

Which growth metric should you use?

CAGR Formula Explained

The CAGR formula (Compound Annual Growth Rate) measures the average annual growth rate of a metric over multiple years while accounting for compounding. Unlike standard period-over-period calculations, CAGR shows the consistent annual rate at which a business, investment, or revenue stream would have grown from its starting value to its ending value. 

CAGR = ((End Value / Start Value) ^ (1 / n)) − 1

(where n = number of years/intervals)

Because it smooths out short-term volatility, the CAGR formula is widely used in investor reporting, startup forecasting, SaaS valuation, financial modeling, and long-term revenue analysis.

CAGR formula example

• Revenue in Year 1: $500,000
• Revenue in Year 5: $1,350,000

((1,350,000 / 500,000) ^ (1 / 4)) − 1 = 28.2% 

In this example, the business achieved a compound annual growth rate of 28.2% per year.

One important detail: the exponent uses the number of intervals, not the number of data points. Five years of data equals four growth intervals.

When to use CAGR vs Standard growth rate

How to use CAGR as a growth calculator

Many businesses use a CAGR calculator to quickly estimate long-term growth trends across revenue, investments, customer acquisition, and subscription performance. An online CAGR calculator can simplify multi-year forecasting, but finance teams often embed CAGR formulas directly into Excel models and BI dashboards for deeper financial analysis and automated reporting.

Investors frequently rely on CAGR to compare startup growth trajectories, evaluate SaaS business performance, and benchmark multi-year returns across companies or portfolios.

Understanding the CAGR formula directly is more valuable than relying only on online calculators because it allows finance and operations teams to apply the calculation inside forecasting tools, investor reporting workflows, and operational dashboards.

How to Calculate Growth Rate in Excel

Excel remains one of the most widely used tools for growth rate calculations across finance, SaaS operations, revenue analytics, and investor reporting. Whether you're tracking revenue growth, subscription expansion, or sales performance, understanding how to calculate growth rate in Excel makes reporting faster, more consistent, and easier to scale. 

Basic growth rate formula in excel

Assume:

• Cell B2 = Previous period value
• Cell B3 = Current period value

Use this formula in C3:

=(B3-B2)/B2

Format the result as a percentage to calculate growth rate in Excel correctly.

Result:  ((97,040 − 83,200) / 83,200) × 100 = 16.6%

The formula returns a 16.6% growth rate.

Year over year growth formula in excel

If Column A contains dates and Column B contains monthly revenue values:

=(B14-B2)/B2

In this example, B14 represents the same month in the following year, making it a standard year over year growth formula in Excel.

CAGR formula in excel

To calculate CAGR in Excel:

= (B_end / B_start) ^ (1 / years) - 1 

You can also use Excel’s built-in RRI function:

= RRI(number_of_periods, start_value, end_value) 

Common growth rate excel functions

Common excel mistakes to avoid

• Hard-coding values instead of referencing cells
• Forgetting absolute references ($) in formulas
• Formatting outputs incorrectly before percentage conversion
• Comparing mismatched reporting periods

For teams managing multiple revenue streams, subscriptions, or regional reporting segments, structured Excel tables and named ranges are far more maintainable than disconnected formula cells. Many teams combine Excel templates with a business growth rate calculator or growth percentage calculator to automate reporting and reduce manual errors.

For recurring SaaS reporting, finance teams often connect Excel models to payment and subscription systems through BI tools or automated exports to improve reporting consistency and forecasting accuracy.

Important Company Growth Metrics

Understanding company growth metrics is essential when learning how to measure business growth accurately. While knowing how to compute growth rate is important, the real value comes from tracking the metrics that reflect long-term business health, revenue quality, and operational efficiency.

MRR / ARR (monthly and annual recurring revenue)

MRR and ARR are foundational company growth metrics for SaaS and subscription businesses.

• Track MRR growth monthly for short-term revenue momentum
• Track ARR growth quarterly or annually for long-term scaling analysis
• Useful for forecasting recurring revenue performance

Net Revenue Retention (NRR)

NRR measures how much revenue existing customers retain after churn, downgrades, and expansion revenue are factored in.

• NRR above 100% indicates expansion revenue is outpacing losses
• Strong NRR is often a key SaaS investor benchmark
• Helps evaluate customer retention quality and upsell efficiency

Customer Acquisition Rate

This metric tracks how many new customers are added during a specific period.

To measure business growth effectively, customer acquisition should always be analyzed alongside churn rate and retention trends. A SaaS company with rising customer acquisition but declining ARPU may be scaling inefficiently despite strong signup growth.

Churn Rate

Churn directly impacts sustainable growth.

Churn Rate (%) = (Customers Lost During Period / Customers at Start of Period) × 100 

A company showing 10% monthly growth with 8% monthly churn may appear healthy on the surface while actually struggling to retain revenue efficiently.

Average Revenue Per User (ARPU)

ARPU measures how much revenue each customer generates on average.

In many cases, rising ARPU with stable customer growth is healthier than aggressive acquisition paired with declining revenue quality.

Transaction Volume Growth

For payment-driven and transaction-heavy businesses, transaction volume growth helps identify:

• Pricing efficiency
• Discount dependency
• Failed payment trends
• Operational scaling patterns independent of revenue growth

Knowing how to measure business growth means evaluating these company growth metrics together rather than in isolation. Metrics like MRR growth, NRR, churn, ARPU, and customer acquisition collectively provide a clearer picture of sustainable business performance.

Common Mistakes When Calculating Growth Rates

Even businesses with sophisticated reporting systems can produce misleading growth metrics when definitions, time periods, or data sources are inconsistent. Understanding why growth calculations become inaccurate is essential for reliable forecasting, investor reporting, and operational decision-making. 

1. Comparing incompatible periods

Comparing a 31-day month with a 28-day month can distort performance trends. When possible, normalize comparisons using business days or year-over-year analysis. 

2. Using gross instead of net revenue

Gross transaction volume includes refunds, disputes, and failed payment recoveries, while net revenue reflects the revenue a business actually retains. Growth calculations based only on gross figures can significantly overstate performance. 

3. Ignoring negative base effects

If the previous period was unusually weak due to outages, migrations, seasonality, or operational disruptions, the resulting growth rate may appear artificially high. Always annotate anomalies when presenting performance trends. 

4. Mixing calculation methodologies across reports

If finance teams, payment systems, and BI dashboards calculate growth differently, leadership may see conflicting numbers across reports. Inconsistent use of the growth calculation formula across departments often creates reporting mismatches and unreliable forecasts. Standardized calculation methods are critical for reporting consistency. 

5. Confusing activity metrics with revenue metrics

Higher transaction counts do not always translate into higher revenue. Similarly, increased signups do not necessarily improve MRR or profitability. Define the business metric clearly before applying a growth rate formula. 

6. Treating CAGR as a real growth trajectory

CAGR smooths volatility into a single annualized growth figure. A business with unstable year-to-year performance may still show a strong CAGR, which can hide operational inconsistency. Whenever relevant, present CAGR alongside actual yearly growth trends. 

How Transact Bridge Helps Businesses Track Revenue Growth

Calculating growth rate is only as reliable as the underlying revenue data. Most businesses struggle with fragmented reporting across billing systems, payment gateways, subscription platforms, and accounting tools.

Transact Bridge helps SaaS and subscription businesses automate revenue reconciliation and centralize growth reporting.

With Transact Bridge, teams can:

• Track MRR, ARR, churn, NRR, and revenue growth
• Monitor MoM and YoY performance trends
• Detect failed payments and recover lost revenue
• Reduce spreadsheet-based reporting errors

With reconciled reporting and automated subscription analytics, finance teams can forecast revenue faster and make more confident business decisions.

Final Takeaway

Understanding how to compute growth rate is essential for tracking business performance, forecasting revenue, and evaluating long-term growth trends.

Whether using a monthly growth formula, YoY analysis, or CAGR modeling, selecting the right metric is critical for accurate forecasting and decision-making.

Quick Growth Rate Formula Table

Accurate growth reporting depends not only on formulas, but also on reliable, reconciled revenue data across subscriptions, billing systems, and payment platforms.

Frequently Asked Questions

What is the formula for growth rate?

The standard growth rate formula is:

Growth Rate (%) = ((Current Value − Previous Value) / Previous Value) × 100

This growth rate equation applies to any business metric- revenue, customers, subscriptions, or sales. Businesses use this growth calculation formula to track performance across any reporting period.

How do you calculate percentage growth?

To calculate percentage growth, subtract the previous value from the current value, divide by the previous value, and multiply by 100. This is the same approach used in the revenue growth formula, the sales growth rate formula, and the annual growth rate formula; the method is identical across all three; only the metric changes.

How to compute growth rate accurately?

Knowing how to compute growth rate accurately requires three things: a clearly defined metric, values pulled from the same data source, and the correct denominator; always the starting value, never the ending one. Teams that reconcile billing, payment, and CRM data before applying the formula produce significantly more reliable growth reporting.

What is CAGR and when should I use it?

CAGR (Compound Annual Growth Rate) measures average annual growth over multiple years while accounting for compounding:

CAGR = ((End Value / Start Value) ^ (1 / n)) − 1

Use the CAGR formula for multi-year performance reporting and investor communications. A CAGR calculator is useful for quick estimates, but embedding the formula directly into Excel models gives finance teams more control for forecasting and scenario analysis.

What is the difference between MoM and YoY growth?

The month over month growth formula measures percentage change between consecutive months; best for short-term operational tracking. The year over year growth formula compares the same period across two years, removing seasonal distortion and making it the standard for board reporting and investor updates. Both use the same base formula; the difference is the time window applied.

How do you calculate growth rate in Excel?

The basic formula to calculate growth rate in Excel is:

= (Current Value − Previous Value) / Previous Value

Format as a percentage. For multi-year CAGR:

= (End Value / Start Value) ^ (1 / years) − 1

Or use Excel's built-in = RRI(number_of_periods, start_value, end_value). Many teams pair Excel templates with a business growth rate calculator or growth percentage calculator to automate recurring reporting.

What is a good revenue growth rate for SaaS businesses?

For mid-stage SaaS, sustainable annual revenue growth typically ranges between 20% and 40% when supported by strong retention. Applying the revenue growth formula to net revenue, not gross transaction volume, gives a more accurate benchmark. The sales growth rate formula serves the same purpose for e-commerce and transaction-driven businesses.

How do companies measure business growth?

Knowing how to measure business growth means tracking company growth metrics together rather than in isolation. The most important are MRR, ARR, Net Revenue Retention (NRR), Churn Rate, Customer Acquisition Rate, and ARPU. A business applying the annual growth rate formula to revenue alone, without NRR or churn context, can miss serious retention problems masked by acquisition growth.

What is the annual growth rate formula?

The annual growth rate formula measures year-over-year performance using full-year figures:

Annual Growth Rate (%) = ((Current Year Value − Previous Year Value) / Previous Year Value) × 100

It is the standard metric for investor reporting, board presentations, and annual business planning.

Why are growth rate calculations inconsistent across reports?

The most common cause is using different data sources across teams. When a payment gateway, CRM, and billing platform each calculate growth differently, leadership sees conflicting numbers. Standardising on the same growth rate equation, aligning reporting periods, and reconciling revenue data across platforms eliminates most discrepancies- which is precisely the problem Transact Bridge is built to solve.