Sales Training ROI Calculator
A worked formula that models training cost against ramp-time reduction and attainment lift, with an honest attribution discount built in, so you can make (and defend) the enablement budget case to finance.
How to use it
Plug your own numbers into the fill-in table, choose an attribution-confidence tier honestly rather than optimistically, and present the discounted figure alongside the leading indicators if you're making the case before a full ramp cohort has completed.
What's inside
- Full input list (reps trained, loaded cost, ramp times, attainment %, deal value, program cost)
- Part A formula: Ramp Acceleration Value, with a worked numeric example
- Part B formula: Attainment Lift Value, with a worked numeric example
- The Attribution Discount step, why and how to discount the raw lift number
- Total program cost breakdown (design, delivery, tooling, opportunity cost)
- Net ROI and ROI % formulas
- Payback period formula
- Fill-in calculation table for your own numbers
- Leading indicators to track before lagging ROI is provable
A three-part model: what the program is worth in accelerated ramp, what it's worth in attainment lift, discounted for honesty, minus what it cost.
Inputs You'll Need
| Input | Symbol | Your number |
|---|---|---|
| Reps trained per year | N | |
| Fully-loaded cost per rep/year (salary+benefits+overhead) | C_rep | |
| Average monthly quota per rep | MQ | |
| Average attainment % during ramp, before program | A_ramp | |
| Ramp time in months, before program | R_before | |
| Ramp time in months, after program | R_after | |
| Average quota attainment %, tenured reps, before program | A_before | |
| Average quota attainment %, tenured reps, after program | A_after | |
| Annual quota per tenured rep | AQ | |
| Number of tenured reps covered by the program | N_tenured | |
| Program cost: design + delivery + tooling + opportunity cost | P_cost |
Part A, Ramp Acceleration Value
Formula: Ramp Value = (R_before − R_after) × MQ × A_ramp × N
Worked example:
- Ramp saved: 1.5 months
- Monthly quota: $50,000
- Typical ramp-period attainment: 60%
- New hires per year: 20
1.5 × $50,000 × 0.60 × 20 = $900,000 in accelerated productivity value
Part B: Attainment Lift Value
Formula: Attainment Value = (A_after − A_before) × AQ × N_tenured
Worked example:
- Attainment lift: 8 points (85% → 93%)
- Annual quota: $600,000
- Tenured reps covered: 80
0.08 × $600,000 × 80 = $3,840,000 in raw attributed value
The Attribution Discount (do not skip this step)
Training is never the only variable moving attainment: market conditions, comp plan changes, and management turnover all move the number too. Apply an Attribution Discount before you take this number anywhere near a CFO.
| Confidence in isolating the training effect | Discount to apply |
|---|---|
| High, controlled cohort vs. baseline comparison | 30% attributed to training |
| Medium: before/after with no control group | 15-20% attributed to training |
| Low: anecdotal, no comparison data | 10% attributed to training, or don't present a hard number yet |
Discounted Attainment Value = $3,840,000 × 0.20 = $768,000 (medium-confidence example)
A CFO respects a number that's been discounted more than one that hasn't: an undiscounted claim invites them to discount it themselves, at a worse rate than you would have chosen.
Total Program Cost
P_cost = Design/development cost + Delivery cost (facilitators, venue, travel) + Tooling/license cost + Opportunity cost of rep selling-time consumed
Opportunity cost formula: Hours out of field × hourly value of quota-carrying time
Net ROI and Payback
Net ROI = (Ramp Value + Discounted Attainment Value) − P_cost
ROI % = (Net ROI ÷ P_cost) × 100
Payback period (months) = P_cost ÷ (Monthly value generated by program)
Worked example total:
- Ramp Value: $900,000
- Discounted Attainment Value: $768,000
- Total benefit: $1,668,000
- Program cost: $400,000
- Net ROI = $1,268,000
- ROI % = 317%
- Payback period ≈ 2.9 months
Fill-In Table for Your Own Numbers
| Line item | Formula | Your result |
|---|---|---|
| Ramp Acceleration Value | (R_before − R_after) × MQ × A_ramp × N | |
| Raw Attainment Lift Value | (A_after − A_before) × AQ × N_tenured | |
| Discounted Attainment Value | Raw value × attribution % | |
| Total Benefit | Ramp Value + Discounted Attainment Value | |
| Total Program Cost | Design + Delivery + Tooling + Opportunity cost | |
| Net ROI | Total Benefit − Total Program Cost | |
| ROI % | (Net ROI ÷ Total Program Cost) × 100 | |
| Payback period | Total Program Cost ÷ Monthly value |
Leading Indicators to Track Before Lagging ROI Is Provable
Ramp and attainment lift take 2+ quarters to show up cleanly. Track these in the meantime so you're not flying blind:
- Certification pass rate (first attempt)
- Skill-observation score trend (see the Manager Skill-Observation Scorecard)
- Time-to-first-qualified-deal for new hires
- Manager-reported confidence in coaching to the new material