Free tool

Turn the number into a plan you can staff.

The GTM Capacity Modeler works backward from a new ARR target to the headcount, pipeline, and prospecting activity it takes to hit it. Every assumption is yours to change, and the math is shown.

Assumptions

Build your operating case.

The inputs below are example values, not benchmarks for your business. Replace them with your own history. Your assumptions stay in your browser.

reps · hiresSee results

Get the Excel model.

Tell us where to send it. The file downloads as soon as you submit. Your model inputs are never sent.

How the math works

Top-down for revenue, bottom-up for activity. Where they disagree, the model says which one binds.

The funnel, in order

  1. Wins = new ARR target / average contract value.
  2. Opportunities = wins / win rate. Opportunities to create = opportunities minus the pipeline you already hold / contract value.
  3. Meetings held = opportunities to create / meeting-to-opportunity rate. Meetings booked = held / show rate.
  4. Prospecting activities = meetings booked / blended meetings per activity. For each channel, meetings per activity = connect (or reply) rate x meeting rate, weighted by the channel mix.
  5. Pipeline = target / win rate. Pipeline needed on day one = pipeline x (sales cycle / 12), assuming wins close evenly through the year.

The team, in order

  1. Ramped reps required = target / (quota x expected attainment).
  2. Planned team = ramped reps x (1 + buffer). Net adds = planned team minus current reps.
  3. Backfills = planned team x annual attrition. Gross hires = net adds + backfills.
  4. Year-one capacity = current reps x productivity + net adds x productivity x ramp factor, with every new hire starting on day one. Ramp factor = 1 - ramp months / 24 for ramps up to 12 months (linear ramp). Attrition is not deducted.
  5. Activity capacity = work days x hours x selling-time share / weighted minutes per activity. Accounts per rep = the lower of your ceiling and capacity / monthly activities each account needs.
  6. Activity need per rep = the larger of two figures: the funnel need (activities to book the meetings, / 12 / planned team) and the cadence need (named accounts / planned team x contacts x touches per month). Contacts and touches move the second one.

What the model does not do

  • It does not phase by season. Monthly and quarterly tabs divide the year evenly.
  • It assumes quota-carrying reps do the prospecting. If SDRs or automation carry part of it, read the activity check as total outbound capacity.
  • It treats every new hire as starting on day one. Later starts cut year-one capacity further.
  • Pipeline to create includes a seed for next year: next year's target times your sales cycle over 12, divided by win rate. It assumes next year's wins close evenly.
  • Pipeline in hand is weighted by three stages, using the share of each stage you expect to win inside the plan year. The model does not age individual deals, and the three shares are your estimates, not benchmarks.
  • It does not model territory quality, deal size by segment, or expansion revenue.

Use it well

  • Replace the example conversion rates with your last four quarters. The model is only as good as those rates.
  • Run it twice: once with your current rates, once with the rates you are planning on. The gap is the plan risk.
  • Take the Excel file into your planning meeting. Every output is a live formula, so the team can argue with the inputs, not the answer.

Released under the MIT license, copyright RevOps Inflection, LLC. Keep the attribution when you share it.

Want this run on your real numbers?

Bring your target and your last four quarters of conversion data. We will build the plan with you and pressure-test it before it reaches the board.

Book a 30-minute working session