A four-step framework for CFOs to control AI token costs.

Read Now

A step-by-step guide to creating a new business ARR plan

Check if your business is well-positioned to focus on New ARR growth and learn how to build a top-down New Business ARR plan that is aligned with overall business objectives and targets.

In this guide, you'll discover:

  • Analyzing your New ARR growth performance against benchmarks
  • Funnel planning to forecast the pipeline needed
  • Determining the additional headcount needed to achieve your target
  • Overcapacity planning to account for average quota attainment rate
Summarize this guide with AI:

Introduction

The two key components of the Rule of 40 are growth and profitability which greatly impact your revenue and influence your enterprise value and revenue multiples. However growth continues to be weighted higher requiring companies to focus more on their new customer acquisition efforts.

So, how does one build a top-down New ARR plan that will help you achieve your revenue growth targets?

What is the best way of creating models that accurately predict future business performance? In our SaaS Metrics Based Top Down Revenue Modeling guide we illustrated a top-down approach where we defined goals and adjusted business drivers accordingly. We concluded by calculating important downstream operating metrics for our fictitious Acme Inc.

As with most fast-growing SaaS startups, we assumed that meeting the Rule of 40 was critical to Acme Inc’s valuation and revenue goals. Revenue growth is a major part of this puzzle, and your New ARR plan (also called new customer acquisition plan, new logo plan, new business plan, or new bookings plan) is critical to maintaining a steady number.

In this guide, we illustrate how you can build a top-down New ARR plan that will help you achieve your growth goals. We will walk through the various assumptions and steps you need to execute when creating your New ARR plan. As with our previous guide, we will use Acme Inc as an example. Let’s begin with the first step, where we examine two critical financial ratios.

Step 1: Check how aggressively you can pursue New ARR growth

How aggressively should you focus on new customer acquisition?Here are a couple handy ratios that help you answer this question.

LTV to CAC ratio

The customer lifetime value (LTV) to the customer acquisition cost (CAC) indicates how efficiently you’re acquiring customers. Are you spending too much to acquire them or not enough?

We recommend using the following formulas to compute your LTV and CAC:

CAC=Sales & Marketing Expenses Towards New Acquisition EffortsNew Customers Won\mathrm{CAC}= \frac{ \text{Sales \& Marketing Expenses Towards New Acquisition Efforts} }{ \text{New Customers Won} }
LTV=Average Revenue from Newly Acquired Customers×Gross Margin %Revenue Churn %\mathrm{LTV}= \frac{ \text{Average Revenue from Newly Acquired Customers}\times\text{Gross Margin \%} }{ \text{Revenue Churn \%} }

Here’s how you can evaluate your LTV to CAC result:

LTV to CAC ValueHow to Interpret
<3 or a declining trend close to 3 High OpEx. Possible issues around GTM or product offering. Recommend focus on increasing marketing and sales efficiency.
>3 and <5 Ideal. Focus on New ARR planning.
>5 or a rising trend towards 5 Under investment in sales and marketing. Possible opportunity costs being incurred. Recommend focusing on boosting investment in sales and marketing.

CAC Payback Period

The CAC payback period is the second ratio that helps you figure out how aggressively you should focus on New ARR planning. This number indicates the efficiency of your sales and marketing efforts when acquiring a new customer.

It classifies these efforts in terms of the number of months needed to recover your investment.

You can calculate your CAC payback period using the formula below:

CAC Payback Period=Previous Quarter′s CACNew MRR in Current Quarter×Gross Margin %\mathrm{CAC\ Payback\ Period}= \frac{ \mathrm{Previous\ Quarter's\ CAC} }{ \mathrm{New\ MRR\ in\ Current\ Quarter}\times\mathrm{Gross\ Margin\ \%} }

The lower your CAC payback period, the more efficient your spending is. If the payback period is too long, you need to address what’s behind that issue before you embark on new ARR planning.

Fast-growing businesses with a shorter sales cycle should aim for a CAC payback period of five months to a year. Businesses with longer sales cycles, such as large enterprises, will experience longer payback periods.If these two ratios look good, it’s time to start building your New Business ARR plan.

Step 2: Perform Funnel Calculations

Building your New Business ARR plan is a two-part process. These parts are:

  1. Funnel calculations to forecast the pipeline needed
  2. Capacity matching to determine the additional capacity (personnel) required to achieve your target.

Before diving into funnel calculations, let’s set the stage with some assumptions and sample metrics. For continuity and simplicity, we will continue with the example shared in the SaaS metrics based planning guide. Here’s a summary:

Acme is a fast-growth SaaS company with an annualized run rate (ARR) of $30 million, operating in US and EU markets and catering to two market segments.

Targets set by the board are as follows:

  • Growth rate: 100%
  • GRR: 80%
  • NRR: 130%
  • Gross margin: 80%
  • Rule of 40

From the above numbers, we calculated a New Business ARR target and other associated metrics as listed below.

Summary of metrics computed thus far
Metric NameValue
Target ARR$60 million
Monthly churn rate % (upper limit)1.84%
Churn ARR (upper limit)$6 million
Expansion ARR$15 million
New ARR$21 million
COGS$12 million
EBITDA margin %-60%
EBITDA-$36 million
Operating expenses$84 million

With these numbers in place, let’s get started with our funnel calculations. Start simple and include only high-impact assumptions in your funnel calculations. These are:

Volume metrics: Average deal size and number of leads.

Efficiency metrics: Conversion rates across stages from lead to closed-won.

Keeping the funnel model to a few high-impact efficiency and volume assumptions makes the pipeline needed for a $21M new ARR target easier to build and defend.

Let’s walk through these calculations using Acme as an example. First, let’s assume Acme’s funnel consists of the stages illustrated in the image below.

Working backward through these stages from closed-won deals tells you how many SQLs, MQLs and leads you must generate to hit the new ARR target.

Your assumptions are critical when building a model. The base rates (baseline values) you assume have an outsized impact on the model’s results. Here’s a handy guide to estimating base rates that minimize biases and increase model accuracy.

Next, we assume the following base rates for Acme based on historical data to avoid biases:

Metric NameValue
Average deal size$20,000
Lead to MQL conversion rate %25%
MQL to SQL conversion rate %40%
SQL to Closed-Won conversion rate25%
Enter values by market segment only if those metrics vary significantly across the segments. If the variation is minimal, keep it simple by taking the weighted average.

Next, we determine the volumes we need at every funnel stage to achieve our New ARR target of $21 million annually. We can work backwards from the deepest portion of the funnel, the number of Closed-Won deals.

The number of new Closed-Won deals required to achieve the New ARR target is:

# of New Closed-Won Deals=New ARR TargetAverage Deal Size=21,00020,000=1,050 Closed-Won deals per fiscal year.\#\text{ of New Closed-Won Deals} = \frac{\text{New ARR Target}}{\text{Average Deal Size}} = \frac{21{,}000}{20{,}000} = 1{,}050\ \text{Closed-Won deals per fiscal year.}

The number of monthly SQLs needed is:

# of SQLs=# of New Closed-Won DealsSQL to Closed-Won Conversion Rate=1,0500.25=4,200 SQLs per Fiscal Year=350 SQLs per Month\#\text{ of SQLs} = \frac{ \#\text{ of New Closed-Won Deals} }{ \text{SQL to Closed-Won Conversion Rate} } = \frac{1{,}050}{0.25} = 4{,}200\ \text{SQLs per Fiscal Year} = 350\ \text{SQLs per Month}

Similarly, the MQL and Lead numbers are:

# of MQLs=# of SQLsMQL to SQL conversion rate %\#\text{ of MQLs} = \frac{ \#\text{ of SQLs} }{ \text{MQL to SQL conversion rate \%} }
# of Leads=# of MQLsLeads to MQL conversion rate %\#\text{ of Leads} = \frac{ \#\text{ of MQLs} }{ \text{Leads to MQL conversion rate \%} }

This works out to 10,500 MQLs and 42,000 leads per fiscal year, or 875 MQLs and 3,500 leads each month.

Summary of pipeline volume metrics
Metric NameAnnual targetMonthly target
Closed-Won deals1,050~88
SQLs4,200350
MQLs10,500875
Leads42,0003,500
For simplicity, we have assumed that the deal size and conversion rates remain the same across geographies and market segments. You can incorporate variations into your top-down plan as Deal sizeUS, Deal sizeEU, MQL to SQL rate %US, MQL to SQL rate %EU, and so on.

Now that you know the lead volumes you need to generate, it’s time to create a capacity plan that will get you there.

Step 3: Calculate and plan capacity

Capacity planning depends on three groups of inputs, and velocity and ramp-up times in particular determine how early you must start hiring to fill the pipeline in time.

The first step in creating a capacity plan is figuring out your funnel velocity metrics. These refer to the time it takes to move a prospect from one stage to another. For example, how long does it take you to turn a lead into an MQL or an MQL into an SQL?

We’ve listed the funnel velocity metrics for Acme Inc below.

Assumptions for funnel-related velocity metrics
Metric NameValueDescription
SQL to Closed-Won time3 months Average time taken to move a prospect from SQL stage to Closed-Won stage
MQL to SQL time2 months Average time taken to move a prospect from MQL stage to SQL stage
Lead to MQL time1 month Average time taken to move a prospect from Lead stage to MQL stage

Acme: A B2B SaaS Company

Acme caters to the mid-market and enterprise segment. They have a 6-month sales cycle. They do fixed 12-month plans.

With a six-month sales cycle, pipeline for the first half of next year has to be built in the last six months of this one, so the plan must be locked well before the fiscal year starts.
We haven’t factored seasonality into our plan to maintain brevity.
Assumption for workforce-related volume metrics
MetricValueDescription
Recruitment rate
(or hiring capacity)
5 reps
per month
The average speed at which open rep positions are closed
Assumption for workforce-related velocity metrics
MetricValueDescription
BDR 100% ramp-up time2 months The average time it takes a BDR or AE to complete training and reach full productivity (i.e. hit 100% of their quota). We've assumed the ramp-up schedule goes straight from 0% to 100% after 2 months for simplicity.
AE 100% ramp-up time2 months
Assumption for workforce-related efficiency metrics
MetricValueDescription
Sales Development Rep (SDR) capacity20 SQLs per month The maximum quota (in terms of accounts) that a BDR or AE can deliver in a given period
Account Executive (AE) capacity5 Closed-Wons per month
Annual attrition rate20% The percentage of salespeople leaving Acme annually

The funnel velocity time dictates how soon Acme must fill its pipeline. In this case, the company must achieve their pipeline volume target within six months. If Acme’s funnel velocity was nine months, the company must fill its pipeline within three months to achieve its target by the end of the fiscal year.

Additionally, you must also account for employee ramp-up times and create a hiring plan accordingly. In Acme’s case, a ramp up time of two months means the company must execute its hiring plans at least two months before the plan is locked in. Given the need to lock in the plan six months before the start of the fiscal year, Acme must begin executing its hiring plan eight months before to ensure it meets its growth targets.

MetricMonthly target
Closed-Won deals175
SQLs700
MQLs1,750
Leads7,000

Next, let’s assume that Acme currently has:

10 SDRs - Delivering 20 SQLs each every month per previous assumptions

10 AEs - Delivering 5 Closed-Wons each every month per previous assumptions

Acme is currently achieving 50 Closed-Wons every month (10 AEs * 5 Closed-Wons per AE per month,) but needs to hit 175 per the table above. Thus, the number of AEs Acme must hire is:

# of AEs to hire=Gap to targetNumber of Closed-Wons per AE=1255=25\#\text{ of AEs to hire} = \frac{ \text{Gap to target} }{ \text{Number of Closed-Wons per AE} } = \frac{125}{5} = 25
Gap to Target=Target−Current Output=175−50=125\text{Gap to Target}=\text{Target}-\text{Current Output}=175-50=125

Similarly, the number of SDRs Acme must hire is 25. Note that the SDR to AE ratio being 1-to-1 is coincidental. This is due to the assumptions we have made in our model.

Next, we must account for attrition. We’ve assumed an annual rate of 20% previously, giving us the number of AEs and SDRs to be hired as 27 each.

Acme must hire these reps at least two months before the planning period begins, given our assumption that ramp-up time lasts for two months.

Step 4: Build a safety factor into capacity plans

Not everyone you hire will successfully hit their quota. You can use a damping factor to act as a buffer. This is commonly called the quota attainment rate %. Here is our quota attainment assumption for Acme Inc.

MetricValueDescription
Quota attainment rate80% The average achievement of a team's total sales as a percentage of their quota for a given period

An attainment rate of 80% implies that four out of five new hires will meet their quotas. You must compensate for this potential shortfall by hiring additional resources.

Thus, instead of hiring 27 AEs and 27 SDRs, Acme must hire 34 AEs and 34 BDRs (27 ÷ 80%).

Given the large team size, Acme must also fill management positions (VP or Director). Assuming a 1-to-7 ratio of executives to team members, Acme must hire an additional 10 managers across its SDR and AE teams.

You will experience fluctuations in the sales cycle due to seasonality. However, since we’ve spread pipeline targets evenly, you will achieve your desired targets.

Chart your path to New ARR

The methods described thus far will help you chart a course towards your New ARR. Best of all, you can extend capacity planning calculations to other teams such as marketing, onboarding, customer success, and support to achieve optimal resource allocations.

Make sure you verify whether your business can afford to focus on New ARR before diving into resource planning. If your business is in the right position, begin by examining funnel velocity and determine your resource needs from there. Build a safety factor into capacity planning as we’ve described, and you’ll have a timeline and resource plan to help you hit your revenue growth targets.

Curious about how you can optimally deploy the methods shared here? Reach us at learn@drivetrain.ai or schedule a free demo.

Share guide

About the author

Kirk Kappelhoff

Kirk Kappelhoff

Senior Director, Strategic Finance

Kirk Kappelhoff is a financial modeling expert with a BBA in Finance & Accounting and nearly a decade of experience at Deloitte, EY, and KPMG, where he built models for pre-IPO companies, M&A transactions, and strategic planning initiatives. At KPMG, he led the Business Modeling Services team, specializing in equity stories and financial forecasts that help high-growth companies communicate their value to investors. At Drivetrain, Kirk writes about strategic planning, granular reporting, and modern FP&A best practices for rapidly scaling finance teams.

Become the strategic partner your business needs

Fewer spreadsheets, faster planning, better decisions.

Book a Demo