# 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.

Free calculator/tool for sales leaders. Topic: [Cold Calling & Phone Skills](https://www.peerlab.ai/library/topic/cold-calling-phone-skills/). Published by PeerLab in the [Sales Enablement Resource Library](https://www.peerlab.ai/library/). Source: https://www.peerlab.ai/library/cold-calling-roi-headcount-calculator/

## 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.

## 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)

1. Is FLC truly fully-loaded - does it include tools/dialer/data licenses and management overhead, or just base salary?
2. Is ACV the realized (post-discount) average or the list-price average? Rerun with realized ACV.
3. What happens to cost-per-meeting and reps-needed if connect rate drops 2 points from list decay after 90 days?
4. Is win rate (WR%) segmented by lead source? A blended company-wide win rate will overstate cold-sourced ROI.
5. Did you model backfill/attrition time? A vacant seat for 6 weeks is a full ramp cycle lost, not zero.