# Enablement ROI & Skill-to-Revenue Calculator

> A worksheet that models the revenue impact of moving a cohort of reps up one competency tier, using your own quota, headcount, and historical performance numbers, with a fully worked example and three sensitivity scenarios.

Free calculator/tool for sales leaders. Topic: [Skills, Competencies & Career Growth](https://www.peerlab.ai/library/topic/skills-competencies-career-growth/). Published by PeerLab in the [Sales Enablement Resource Library](https://www.peerlab.ai/library/). Source: https://www.peerlab.ai/library/enablement-roi-skill-to-revenue-calculator/

## How to use it

Pull your own tier-attainment numbers from the Team Skills Matrix, plug them into the six-step formula, and run all three sensitivity scenarios before presenting a business case, lead with the conservative number.

## What's inside

- The 7-step formula (tier delta, success rate, ramp-time factor, ROI, payback)
- Guidance for sourcing your own tier-delta number from the Skills Matrix
- A placeholder industry assumption for teams without historical data yet
- A fully worked numeric example
- A three-scenario sensitivity table (conservative/base/optimistic)
- A blank worksheet to run your own cohort's numbers

## Purpose
A worksheet to model the revenue impact of moving a cohort of reps up one competency tier: using your own quota, headcount, and historical performance numbers, not an industry-average benchmark that doesn't reflect your business.

## Before You Start: Get One Number From Your Own Data
This calculator only works if you can answer: **"Historically, what's the difference in revenue/quota attainment between a rep at competency tier N and a rep at tier N+1?"**

If you don't know this yet, pull it from your *Team Skills Matrix*: sort reps by Composite Score into tiers (e.g. <2.5 / 2.5-3.5 / 3.5-4.5 / 4.5+) and look at trailing-12-month quota attainment by tier. If you have fewer than ~15 reps of history, use the placeholder assumption below and revisit once you have real data.

**Placeholder assumption (only if you have no internal data yet):** a one-tier competency improvement is associated with roughly a 10-15% lift in quota attainment. Treat this as a rough industry pattern to sanity-check your own number against, not a substitute for measuring your own team.

## The Formula

**Step 1, Define the cohort.**
- Number of reps in cohort moving up one tier: `N`
- Current average annual quota per rep: `Q`
- Current average quota attainment %, this tier: `A_current`
- Historical average quota attainment %, next tier up: `A_next`

**Step 2, Tier delta (per-rep annual revenue lift).**
```
Tier Delta = Q x (A_next - A_current)
```

**Step 3, Apply a success-rate discount.**
Not every rep in the cohort will actually move up a full tier within the program period. Apply a realistic success rate based on program intensity:
- Light-touch (self-serve resources only): 20-30%
- Moderate (coaching cadence + skill-based 1:1s): 40-55%
- Intensive (coaching + framework + dedicated ramp support): 55-70%

```
Expected Movers = N x Success Rate
```

**Step 4, Apply a ramp-time discount.**
If the improvement doesn't happen on day 1 of the program, prorate for the months of the year it's actually in effect:
```
Ramp-Time Factor = Months Remaining in Year After Improvement / 12
```

**Step 5, Projected incremental revenue.**
```
Projected Incremental Revenue = Expected Movers x Tier Delta x Ramp-Time Factor
```

**Step 6, Program cost.**
```
Program Cost = Coaching Hours Cost + Tools/Content Cost + Manager Opportunity Cost
```
Where Manager Opportunity Cost = (extra manager hours/month required by the new cadence) x (manager's fully-loaded hourly cost) x (program duration in months).

**Step 7, ROI and payback.**
```
ROI = (Projected Incremental Revenue - Program Cost) / Program Cost
Payback Period (months) = Program Cost / (Projected Incremental Revenue / 12)
```

## Worked Example

Inputs:
- Cohort: N = 8 reps currently in the 2.5-3.5 competency tier
- Average annual quota, Q = $900,000
- Current tier average attainment, A_current = 78%
- Next tier average attainment (from own matrix history), A_next = 91%
- Program: Moderate intensity (coaching cadence + skill-based 1:1s) → Success Rate = 50%
- Program starts now, 8 months remain in the fiscal year → Ramp-Time Factor = 8/12 = 0.67
- Coaching Hours Cost: manager spends an extra 6 hrs/month on this cohort x 8 months x $75/hr fully loaded = $3,600
- Tools/Content Cost: $2,000 (one-time)
- Total Program Cost = $5,600

Calculation:
```
Tier Delta = $900,000 x (0.91 - 0.78) = $900,000 x 0.13 = $117,000 per rep

Expected Movers = 8 x 0.50 = 4 reps

Projected Incremental Revenue = 4 x $117,000 x 0.67 = $313,560

ROI = ($313,560 - $5,600) / $5,600 = 54.9x

Payback Period = $5,600 / ($313,560 / 12) = $5,600 / $26,130 = 0.21 months (about 6 days)
```

## Sensitivity Check: Run Three Scenarios, Not Just One
Never present a single number to leadership. Run conservative / base / optimistic on the two variables you're least sure of, Success Rate and Tier Delta.

| Scenario | Success Rate | Tier Delta Confidence | Projected Incremental Revenue |
|---|---|---|---|
| Conservative | 30% (light-touch level, to be safe) | Use placeholder 10% instead of measured 13% | 8 x 0.30 x ($900,000x0.10) x 0.67 = $144,720 |
| Base (worked example above) | 50% | Measured 13% | $313,560 |
| Optimistic | 65% | Measured 13% | 8 x 0.65 x $117,000 x 0.67 = $407,600 |

Even the conservative scenario clears the $5,600 program cost by more than 25x. That's the number to lead with when asking for budget or headcount to run the coaching cadence, not the optimistic one.

## Your Blank Worksheet

| Variable | Your Number |
|---|---|
| Cohort size (N) | |
| Average annual quota (Q) | |
| Current tier attainment % | |
| Next tier attainment % (from your Team Skills Matrix history) | |
| Tier Delta ($) | |
| Success rate assumption | |
| Expected movers | |
| Ramp-time factor | |
| Projected incremental revenue | |
| Program cost | |
| ROI | |
| Payback period (months) | |