Cold Calling ROI & Headcount Calculator
A fill-in-the-numbers model that turns your dial volume, conversion rates, and deal economics into pipeline, revenue, cost-per-outcome, and the exact headcount you need to hit a target - with a fully worked example and a blank worksheet for your own numbers.
What's inside
- The 10 input variables every headcount model needs, defined in plain language
- Stage-by-stage conversion formulas: dials -> connects -> meetings -> opportunities -> closed-won
- Cost-per-outcome formulas: cost per dial, per connect, per meeting, per opportunity, per closed deal
- Ramp-adjusted new-hire capacity table (months 1-6) so month-1 hires aren't modeled at full productivity
- Reverse-solve formula: plug in a revenue or pipeline target, solve for reps needed
- Payback-period formula - months to recover a rep's fully-loaded cost
- A fully worked numeric example, start to finish, with every intermediate number shown
- A blank worksheet with the same fields, ready for your own numbers
- A 5-question sensitivity check to pressure-test the model before it goes in front of leadership
Use this to answer the two questions leadership always asks: "What do we get for the money?" and "How many reps do we actually need?" Work top to bottom - every later formula depends on the ones above it.
Step 1 - Define your 10 inputs
| # | Variable | Symbol | What it means |
|---|---|---|---|
| 1 | Working days per month | D | Usually 20-21 |
| 2 | Dials per rep per day | DPD | Count attempts, not connects |
| 3 | Connect rate | CR% | Live conversations / dials |
| 4 | Connect-to-meeting rate | CMR% | Meetings booked / connects |
| 5 | Meeting-to-opportunity rate | MOR% | Qualified opps / meetings held |
| 6 | Opportunity-to-close (win) rate | WR% | Closed-won / opportunities |
| 7 | Average contract value | ACV | Average first-year deal value |
| 8 | Fully-loaded annual cost per rep | FLC | Salary + benefits + tools + management overhead + commission at plan |
| 9 | Average sales cycle length | SCL | Days from opportunity created to closed-won |
| 10 | Ramp time to full productivity | RAMP | Months until a new hire dials at 100% of a tenured rep's volume and quality |
Step 2 - Stage-by-stage monthly output per rep
`` Dials/month = DPD x D Connects/month = Dials/month x CR% Meetings/month = Connects/month x CMR% Opportunities/month = Meetings/month x MOR% Closed-won deals/month = Opportunities/month x WR% Pipeline generated/mo = Opportunities/month x ACV Revenue closed/mo = Closed-won deals/month x ACV ``
Step 3 - Cost-per-outcome (uses FLC, fully-loaded annual cost)
`` Cost per dial = (FLC / 12) / Dials/month Cost per connect = (FLC / 12) / Connects/month Cost per meeting = (FLC / 12) / Meetings/month Cost per opportunity = (FLC / 12) / Opportunities/month Cost per closed deal = (FLC / 12) / Closed-won deals/month ``
Step 4 - Ramp-adjusted first-year capacity
New hires do not dial at full productivity from day one. Default curve (override with your own onboarding data):
| Month | Productivity % of a tenured rep |
|---|---|
| 1 | 25% |
| 2 | 50% |
| 3 | 75% |
| 4+ | 100% |
Effective capacity, Year 1 = 9 months at 100% + 0.25 + 0.50 + 0.75 = 10.5 "full months" of output. Use 10.5, not 12, when annualizing a new hire's Year-1 output.
Step 5 - Reverse-solve: revenue/pipeline target -> reps needed
`` Reps needed = Target annual pipeline / (Pipeline generated per rep per month x 12 x ramp factor) `` Ramp factor = 10.5/12 = 0.875 for a rep hired at the start of the year; use 1.0 for a rep who has already ramped.
Step 6 - Payback period
`` Monthly gross margin per rep = Revenue closed/month x Gross Margin % Payback period (months) = (FLC / 12) / Monthly gross margin per rep ``
Worked Example
Inputs: D=20, DPD=40, CR%=8%, CMR%=25%, MOR%=50%, WR%=25%, ACV=$18,000, FLC=$95,000, Gross Margin=70%.
| Stage | Formula | Result |
|---|---|---|
| Dials/month | 40 x 20 | 800 |
| Connects/month | 800 x 8% | 64 |
| Meetings/month | 64 x 25% | 16 |
| Opportunities/month | 16 x 50% | 8 |
| Closed-won/month | 8 x 25% | 2 |
| Pipeline generated/month | 8 x $18,000 | $144,000 |
| Revenue closed/month | 2 x $18,000 | $36,000 |
| Annual revenue per rep (steady state) | $36,000 x 12 | $432,000 |
| ROI ratio | $432,000 / $95,000 | 4.5x |
| Cost per dial | $7,916.67 / 800 | $9.90 |
| Cost per connect | $7,916.67 / 64 | $123.70 |
| Cost per meeting | $7,916.67 / 16 | $494.79 |
| Cost per opportunity | $7,916.67 / 8 | $989.58 |
| Cost per closed deal | $7,916.67 / 2 | $3,958.33 |
| Monthly gross margin | $36,000 x 70% | $25,200 |
| Payback period (steady state) | $7,916.67 / $25,200 | 0.31 months (about 9 days) |
Headcount-to-target example: Leadership wants $2,000,000 in annual pipeline sourced from cold calling. `` Reps needed = $2,000,000 / ($144,000 x 12 x 0.875) = $2,000,000 / $1,512,000 = 1.32 -> hire 2, or extend the target quarter. ``
Blank Worksheet - your numbers
| Variable | Your number |
|---|---|
| Working days/month (D) | |
| Dials/rep/day (DPD) | |
| Connect rate (CR%) | |
| Connect-to-meeting rate (CMR%) | |
| Meeting-to-opportunity rate (MOR%) | |
| Opportunity-to-close rate (WR%) | |
| Average contract value (ACV) | |
| Fully-loaded annual cost/rep (FLC) | |
| Average sales cycle (days) | |
| Ramp time (months) | |
| Dials/month | |
| Connects/month | |
| Meetings/month | |
| Opportunities/month | |
| Closed-won/month | |
| Pipeline generated/month | |
| Revenue closed/month | |
| Cost per meeting | |
| Cost per closed deal | |
| Reps needed for target |
5-Question Sensitivity Check (run before this goes to leadership)
- Is FLC truly fully-loaded - does it include tools/dialer/data licenses and management overhead, or just base salary?
- Is ACV the realized (post-discount) average or the list-price average? Rerun with realized ACV.
- What happens to cost-per-meeting and reps-needed if connect rate drops 2 points from list decay after 90 days?
- Is win rate (WR%) segmented by lead source? A blended company-wide win rate will overstate cold-sourced ROI.
- Did you model backfill/attrition time? A vacant seat for 6 weeks is a full ramp cycle lost, not zero.
How to use it
Fill in your own 10 inputs in the blank worksheet (Step 6), run the formulas in order (Steps 1-5 show you how), then use the reverse-solve section to answer 'how many reps do we need' before you ask for headcount budget.