Training ROI Template
A training ROI calculator, not a guess. Load every cost, evidence every benefit, and get the net benefit, ROI percent and payback for a program, with a confidence score on each benefit before you put the number in front of finance.
Reviewed by Pradeep Arora, Chief Strategy Officer
- A cost side that is fully loaded, including the learner time most ROI claims leave out
- A benefit side where each line is evidenced, not asserted, before it counts
- Net benefit, ROI percent and payback that calculate as you type in Excel
- A confidence score on every benefit, so you know what the number can bear
What is inside
- An ROI calculator that takes your fully loaded costs and your evidenced benefits and returns the net benefit, the ROI percent and the payback period, so the headline number is calculated, not guessed.
- An ROI method checklist that keeps the figure honest: a baseline captured, the effect isolated conservatively, costs fully loaded, benefits evidenced, and every assumption written down.
- A benefit confidence matrix that scores each benefit on evidence, attribution, size, durability and conservatism, so you know which lines the number can bear and which are still soft.
- An assumptions tab that records every input and its source, so when finance asks where a figure came from, the answer is in the file rather than in someone's memory.
Who it is for
Anyone who has to plan what people learn, and answer for whether it landed.
- L&D and training teams
- People managers and team leads
- Heads of function and department
- HR business partners
- Compliance and risk teams
- Onboarding and enablement teams
- Operations and delivery leads
- COOs and HR directors
How to use this template in 4 steps
- Pick your format. Download the PDF to share, the Word file to edit, or the Excel file to work in live. All three are free.
- Make it yours. Adapt the sections, fields and wording to your team, roles and process so it fits how you actually work.
- Put it to work. Fill it in, circulate it to stakeholders for sign-off, or roll it out to your team.
- Track and improve. Review it on a set cadence and refine it as your goals, roles and priorities change.
What is inside
- An ROI calculator that takes your fully loaded costs and your evidenced benefits and returns the net benefit, the ROI percent and the payback period, so the headline number is calculated, not guessed.
- An ROI method checklist that keeps the figure honest: a baseline captured, the effect isolated conservatively, costs fully loaded, benefits evidenced, and every assumption written down.
- A benefit confidence matrix that scores each benefit on evidence, attribution, size, durability and conservatism, so you know which lines the number can bear and which are still soft.
- An assumptions tab that records every input and its source, so when finance asks where a figure came from, the answer is in the file rather than in someone's memory.
This is a starting structure to model and present training ROI, not financial or accounting advice. Agree the cost basis, the attribution method and the discount approach with your finance team, and treat the worked figures here as illustrative, not benchmarks.
The ROI calculator
The core of the template. The cost lines and the benefit lines sit in one place, and the net benefit, ROI percent and payback fall out of them. Enter your own figures in the Excel and the three results recalculate as you type. The numbers below are a worked example to show the shape, not a benchmark.
| Line item | Amount |
|---|---|
| Cost: content design and build | 18,000 |
| Cost: delivery and facilitation | 12,000 |
| Cost: learner time (hours x loaded rate) | 40,000 |
| Cost: platform and tools | 6,000 |
| Total cost | 76,000 |
| Benefit: productivity gain | 120,000 |
| Benefit: error and rework reduction | 45,000 |
| Benefit: retention saving | 60,000 |
| Benefit: revenue lift | 80,000 |
| Total benefit | 305,000 |
| Net benefit (benefit minus cost) | 229,000 |
| ROI (net benefit over cost) | 301% |
| Payback period | 3.0 months |
The point of this calculator is to prove impact by tying learning to a business number, not a completion rate. That is how Disprz programs reach up to 8X ROI: the learning is built against the metric it is meant to move, so the before-and-after is a real figure on the P&L, not a survey score.
Keep the number honest
An ROI figure is only as good as its method. These checks are the difference between a number finance accepts and one it picks apart. Tick them as you build yours, it stays in this browser. The download has the same list with an owner column.
- Baseline captured before the program startedBaselineL&D
- The metric the training should move is named and measurableBaselineL&D and finance
- Design, delivery and tool costs all includedCostsL&D
- Learner time costed at a loaded hourly rateCostsFinance
- Each benefit backed by a measured before-and-afterBenefitsL&D and function
- The training effect isolated, not the whole swing claimedAttributionFinance
- A control group or discount factor applied to benefitsAttributionFinance
- Benefits judged durable, not a one-off spikeDurabilityL&D and function
- Every assumption written down with its sourceAssumptionsL&D
- The figure reviewed and signed off with financeGovernanceFinance partner
The most common failure is a cost side that leaves out learner time. When hundreds of people spend hours in training and that time is not costed, the ROI looks spectacular and collapses the moment finance adds the hours back. Load the costs fully or do not present the number.
How much to trust each benefit
The calculator gives one number, but not every benefit behind it is equally solid. This matrix scores each benefit line on five tests, so a well-evidenced productivity gain is not treated the same as a hopeful revenue lift. Score each benefit and the soft ones stand out before you present. In Excel the confidence and gaps calculate as you type.
| Benefit | Amount | Evidence | Attribution | Size | Durability | Conservatism | Ready |
|---|---|---|---|---|---|---|---|
| Productivity gain | 120,000 | 2 | 2 | 2 | 2 | 2 | 100% |
| Error and rework reduction | 45,000 | 2 | 2 | 1 | 2 | 2 | 90% |
| Retention saving | 60,000 | 2 | 1 | 2 | 1 | 1 | 70% |
| Revenue lift | 80,000 | 1 | 0 | 2 | 1 | 0 | 40% |
| Coverage at required | 75% | 50% | 75% | 50% | 50% | 75% |
Revenue lift is the exposure here: strong in size but weak on attribution and conservatism, so it is the hardest line to defend yet one of the largest. Firm up its evidence and isolation before you lean on it, or present the ROI figure both with and without it.
The assumptions behind the number
Every input in the calculator rests on an assumption. This tab records each one with its value and its source, so the model is auditable and the next person can see exactly how the figure was built. When finance asks where a number came from, the answer is a row here.
| Assumption | Value | Source |
|---|---|---|
| Loaded hourly cost of learner time | 25 per hour | Finance, fully loaded salary model |
| Learner hours per person on the program | 8 hours | Program design, module runtime |
| People trained | 200 | L&D assignment records |
| Productivity gain attributed to training | 30 percent of observed | Control group comparison |
| Error reduction value per avoided defect | 150 | Quality team cost-of-rework data |
| Attrition reduction from the program | 2 percentage points | HR exit and retention data |
| Revenue lift attribution factor | 20 percent of observed | Finance, conservative estimate |
| Benefit horizon used for ROI | 12 months | Finance convention for L&D programs |
How to use it
- Capture the baseline first
Record the before number for whatever the training is meant to move, before the program starts. Without a baseline there is no honest ROI.
- Load every cost
Add design, delivery, platform and tools, and the one people skip: learner time at a loaded hourly rate. A light cost side makes every figure a fiction.
- Evidence each benefit
Record the measured change and the number behind each benefit. If you cannot evidence it, leave it out rather than inflate the total.
- Isolate the training effect
Other things moved the number too. Attribute conservatively with a control group or a discount factor, and never claim the whole swing.
- Calculate net benefit, ROI and payback
Net benefit is total benefit minus total cost, ROI is net benefit over cost, payback is cost over monthly benefit. The Excel does all three.
- Score confidence, then present one number
Rate each benefit on the five tests, present the figure you can defend, and flag the benefits that are still soft.
Do not present a single hero number with no range. Finance trusts a figure that shows its working, its assumptions and its weak spots far more than a confident round number with nothing behind it. The confidence matrix exists so you can say what the number can and cannot bear.
Common mistakes this template prevents
- A cost side that leaves out learner time, so the ROI looks far higher than it is.
- Benefits that are asserted rather than evidenced, with no measured before-and-after behind them.
- Claiming the whole improvement for training when other things moved the number too.
- No baseline, so there is nothing to measure the change against.
- One confident figure with no assumptions, no sources and no sense of which benefits are soft.
Which format should you use?
| Format | Best for | What is inside | Editable | Size |
|---|---|---|---|---|
| Sharing and print | The full template, formatted to print or circulate | No | 57 KB | |
| Word | Editing the wording | Every section as editable text you can adapt | Yes | 87 KB |
| Excel | Filling it in live | The grid and fields set up as a working spreadsheet | Yes | 66 KB |
Questions people ask
What is training ROI?
How do you calculate training ROI?
Why include learner time as a cost?
How do I make the benefits credible?
Does the Excel version work in Google Sheets?
Do I have to fill the form three times?
A number on a slide is not impact. Impact is a business metric that moves. That is the part we run.
Bring your training ROI model to a 30-minute working session. We will show how Disprz ties each program to the metric it is meant to move, tracks completion and skill gain where the learning is delivered, and makes the before-and-after provable in an export, so the ROI case is built on live data rather than estimates.