Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

SaaS Rule of 40: definition, formula & calculation

Running a successful business is tough in any industry, and Software as a Service (SaaS) is no exception. As we become increasingly dependent on technology, demand for these services grows, and so does supply. Competition is fierce, and both customers and investors have access to more information than ever before.

So how can you evaluate how well your SaaS business is doing? Equally important, how are others evaluating the success of your SaaS business? While you can use many financial metrics, the Rule of 40 is a popular SaaS value metric. Initially introduced by venture capitalists, the Rule of 40 considers both growth and profitability, which provides a more balanced view of the company’s performance.

In this guide, you will learn about the rule of 40: what it means and why it matters. You will also learn how to calculate it and how monitoring this metric can help your SaaS business. Finally, you have some examples to see how the Rule of 40 is applied.

What is the Rule of 40?

The Rule of 40 applies to the combined value of the revenue growth rate and the profit margin. It states that the sum of these values should equal at least 40%. This is considered to be the benchmark for sustainable growth, and values below 40% can indicate liquidity issues.

Why does the Rule of 40 matter?

The Rule of 40 promotes a balance between growth and profitability. Applying this principle to your SaaS business will help you with short-term and long-term strategy and planning. Values above 40% are likely to attract potential investors and help ensure sustainable growth for your business.

A strategy focusing exclusively on revenue growth can result in sacrificing profits, while one focusing purely on profitability can result in sacrificing growth. The Rule of 40, however, promotes a balance between the two that favors sustainable growth for your business.

To see how fast a company can grow without new debt or equity, read our guide to the sustainable growth rate.

How to calculate the Rule of 40?

To calculate whether your SaaS business adheres to the Rule of 40, you need to add the revenue growth rate to the profit margin. In other words, you first need to calculate these two metrics.

Growth rate

The Generally Accepted Accounting Principles (GAAP) provide a clear definition of revenue, so calculating your year-over-year revenue growth is a straightforward process. However, if your business is still in the early stages, you may focus more on Annual Recurring Revenue or Monthly Recurring Revenue.

Profit margin

The profit margin, on the other hand, is a slightly different story. It’s a much broader term, and profitability analysis makes use of many different metrics, including gross, net, and operating profit, as well as Earnings Before Interest, Taxes, Depreciation & Amortization (EBITDA). The calculation of these metrics relies on different items on your financial statements, so some of these metrics are more likely than others to yield favorable results for your company.

While there is no single right choice regarding the profit margin, the EBITDA margin is a popular choice due to its comparability across companies. However, as with any kind of financial analysis, it isn’t wise to rely on a single method or metric, as the results can vary significantly. Using different metrics to calculate the profitability margin can also help you identify favorable and unfavorable aspects of your business.

Rule of 40 examples in Google Sheets

For the sake of simplicity, the examples below use year-over-year revenue to express the growth rate and the EBITDA margin to express profitability.

Let’s apply the Rule of 40 to two different companies to see how it works.

Calculate growth rate

First, you need to calculate the revenue growth rate for both companies using the formula for Year-Over-Year (YOY) growth. The formula uses “new” and “old” values for revenue, taken a year apart, to show the annual growth rate.

YOY growth = ((new value – old value) / old value) * 100

For more information and examples of how to use this formula, check out this guide on How to Calculate Year-Over-Year Growth.

1. In Google Sheets, gather the required data for both companies.

SaaS Rule of 40 — Google Sheets table with Company A and Company B revenue for 11/2022 and 11/2021 and an empty YOY Growth Rate (%) column

Rule of 40: Definition, Formula, & Calculation – Gather Revenue Growth Data

2. In the cell where you want the result, type in the equal sign and add the cells as shown below. First, subtract the old revenue value from the new one and divide the result by the old value. Finally, multiply the result by 100.

SaaS Rule of 40 — YOY growth formula =((B3-C3)/C3)*100 typed in cell D3 for Company A

Rule of 40: Definition, Formula, & Calculation – Add YOY Growth Formula

3. You can copy the formula down to Company B by grabbing the fill handle and dragging it to the cell below.

SaaS Rule of 40 — YOY Growth Rate (%) formula filled down, showing 22.22 for Company A and 20.00 for Company B

Rule of 40: Definition, Formula, & Calculation – Drag Formula Down

4. That’s it. You have the growth rates for both companies.

SaaS Rule of 40 — revenue growth rate table with YOY growth of 22.22 for Company A and 20.00 for Company B

Rule of 40: Definition, Formula, & Calculation – Revenue Growth Rate

Calculate EBITDA margin

Now that you have the growth rates, you need to calculate the EBITDA margins by dividing the value of EBITDA by the value of revenue.

EBITDA margin = EBITDA / revenue

To learn more about EBITDA and related metrics, take a look at this post on How to Calculate EBITDA.

1. In Google Sheets, gather the required data for both companies.

SaaS Rule of 40 — Calculate EBITDA Margin table with EBITDA and revenue for Company A and Company B and an empty EBITDA Margin column

Rule of 40: Definition, Formula, & Calculation – Gather EBITDA Margin Data

2. Type the equal sign to add the formula in the cell where you want the results. Select the cell with the value of EBITDA and divide by the cell containing the value for revenue.

SaaS Rule of 40 — EBITDA margin formula =B8/C8 typed in cell D8 for Company A

Rule of 40: Definition, Formula, & Calculation – Add EBITDA Margin Formula

3. You can copy the formula down to Company B by grabbing the fill handle and dragging it to the cell below.

SaaS Rule of 40 — EBITDA Margin formula filled down, showing 31.82% for Company A and 33.33% for Company B

Rule of 40: Definition, Formula, & Calculation – Drag Formula Down

4. That’s it. You have the profit margin for both companies.

SaaS Rule of 40 — EBITDA margins of 31.82% and 33.33% below the YOY revenue growth rate table

Rule of 40: Definition, Formula, & Calculation – EBITDA Margins

Add growth & profit

To calculate the Rule of 40 value, simply add the growth rate and profit margin for each company.

1. Type in the equal sign and add the growth rate and EBITDA margin values for Company A.

Rule of 40 formula — Calculate Rule of 40 section with =D3+D8 typed in cell B12 for Company A

Rule of 40: Definition, Formula, & Calculation – Add Rule of 40 Formula

2. Grab the fill handle and drag it down to copy the formula for Company B.

Rule of 40 formula — formula filled down, showing 54.04% for Company A and 53.33% for Company B

Rule of 40: Definition, Formula, & Calculation – Drag Rule of 40 Formula Down

3. As you can see, both companies have values above 40%, despite the differences in terms of the absolute values for revenue.

Rule of 40 calculation — Company A at 54.04% and Company B at 53.33%, each marked above 40%

Rule of 40: Definition, Formula, & Calculation – Rule of 40 Values

Conclusion

As you have seen, the Rule of 40 is a useful SaaS value metric and promotes balanced and sustainable growth. Its popularity among investors means it’s a good idea for you to keep this metric in mind, as they certainly will. However, just like any company valuation method, you shouldn’t rely exclusively on it. In fact, different metrics can be used within the Rule of 40 calculations.

You now know what the Rule of 40 is and why it has become one of the most popular SaaS value metrics, particularly among long-term investors. You also know the formula used to obtain this value and how to use Google Sheets to calculate it.

To learn more about the different formulas used in this post, as well as other company valuation methods, check out the ones below.

To compare growth over several years instead of one, see how to calculate CAGR in Google Sheets. And if you plan ahead, our revenue forecasting guide covers the main models. When these numbers come from several spreadsheets, Sheetgo’s AI finance virtual employee can collect the figures and keep your Rule of 40 calculation up to date.

● Available 24/7

Put Owen on your finance ops

Sheetgo's finance virtual employee keeps your numbers current and your reporting on time. Your data stays in Google Sheets; you work with Owen in Slack, Teams, or Google Chat.

You may also like…

simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...
finance

How to use Google Sheets for currency conversion

Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to learn how to use Google...
finance processes and templates

8 steps to prepare a bank reconciliation statement

Bank reconciliation is a crucial financial process for businesses to ensure that records match bank statements. In this post, we'll...