Book a demo

ROI

Training ROI calculator: formula, inputs and a worked example

Training ROI is the monetary benefit that the training caused, minus the full cost, divided by the full cost. This calculator gives 15 lines to fill in, a worked example and the break-even point.

In short

  • ROI = (benefit due to training - full cost) / full cost. The formula is the easy part.
  • Count the full cost, including the hours of the participants.
  • Reduce the benefit to the share that the training caused, with an estimate and a confidence.
  • Show the break-even point next to the ROI. It tells how small a change pays for the program.

L&D teams fill in the cost side of ROI in an hour. The benefit side is where the CFO stops reading. This calculator puts both sides in one table. It is one part of our guide to AI roleplay for soft skills training.

The calculator needs a before-and-after measurement. The method is in how to measure leadership development ROI.

The training ROI formula gives two numbers: BCR and ROI

The ROI Institute uses two numbers. The benefit-cost ratio: BCR = benefits / costs. ROI = (benefits - costs) / costs × 100.

Measurement at Level 5 answers one critical question: Do the monetary benefits of the program meet or exceed the costs of the program?

Fifteen lines of the calculator, with a worked example

The example: 20 new team leads practise hard conversations for three months and take two assessments. The metric, agreed before the start, is the number of people who leave their teams. Copy the formula column and put your data in the last column.

LineInput or formulaExample (USD)
1. ParticipantsCount20
2. Hours per personSessions, assessments, preparation12
3. Hourly cost of a participantSalary with taxes / working hours40
4. Time cost= 1 × 2 × 39,600
5. Direct costLicences, trainer, design14,400
6. Full cost= 4 + 524,000
7. Leavers before12 months before, in teams of 140 people25
8. Leavers after12 months after the start21
9. Cost per leaver0.5 × average annual salary25,000
10. Gross benefit= (7 - 8) × 9100,000
11. Share due to trainingManagers’ estimate × confidence0.6 × 0.7 = 0.42
12. Benefit due to training= 10 × 1142,000
13. BCR= 12 / 61.75
14. ROI, percent= (12 - 6) / 6 × 10075
15. Break-even: leavers avoided= 6 / (9 × 11)2.3
Illustrative data, not client data. Benefit: the first 12 months after the start.

Line 9 is the weakest input. Gallup estimates the replacement cost at 40% of the salary for frontline employees, 80% for technical roles and 200% for managers. The example takes 0.5, below the technical figure. Use your HR number if it exists.

Isolate the share of the training before you show the number

Attrition can fall for other reasons, such as a new pay band. The ROI Methodology isolates the program effect before it converts the change to money. One method is a control group.

Without a control group, ask the managers which part of the change came from the training and how sure they are. In the example, they give 0.6 and 0.7, so line 11 is 0.42.

Show the break-even point first, then the ROI

The break-even point is the change that pays for the program. In the example, the program pays back if the teams of the 20 leads lose 2.3 fewer people in a year. "about 3 fewer leavers in 140 people" is easier to judge than "ROI 75".

It also answers a frequent objection. In our research with 130+ HR and L&D leaders, about a quarter said that the ROI of training cannot be measured. A break-even check needs fewer facts: was the change larger than the threshold? More findings: what 130+ HR and L&D leaders told us.

The opposite view: report expectations, not ROI

Kirkpatrick Partners call return on expectations (ROE) the ultimate indicator of value. The stakeholders define success at the start, and L&D shows evidence at each of the four levels.

The real shift was starting with the end in mind: begin with the result, then work backward to the behaviors, learning, and experiences that make it possible.

We agree with the start: lines 7 and 8 work only if the metric was agreed before the program. An L&D lead at a software product company described the same sequence to us: the metric with the team manager first, then the training, then a check after 2-3 months. But a budget owner compares programs in money, and the calculator shows each assumption.

What to do this week

  1. Agree on one metric with the budget owner. Write down lines 7 and 8 before the program starts.
  2. Fill in lines 1-6 from the invoices and the calendar, with the hours of the participants.
  3. Calculate the break-even point first. If the threshold looks unreal, change the program first.

For line 5, see the plans and pilot terms.

Questions and answers

How do you calculate training ROI?

Subtract the full cost from the monetary benefit that the training caused, divide by the full cost and multiply by 100. The full cost includes the hours of the participants.

Is there a training ROI calculator in Excel?

The 15-line table above is the calculator. Copy the formula column into Excel or Google Sheets and replace the example with your data.

How do you calculate the ROI of soft skills training?

Link the skill to one business metric before the program, for example attrition in the teams of the trained managers. Measure both before and after, convert the change of the metric to money and keep only the share of the training.

Sources

  1. ROI Institute: The ROI Methodology
  2. Gallup: 42% of Employee Turnover Is Preventable but Often Ignored (9 July 2024)
  3. Kirkpatrick Partners: Kirkpatrick Foundational Principles (2010-2018)
  4. Kirkpatrick Partners blog: The Problem Nobody Talks About: Why Training Spend Isn’t the Same as Performance (17 August 2026)
  5. Kovalenko, R., & Rohovynska, K. (2026). The Soft Skills Measurement Gap: What 130+ L&D & HR Leaders Can't Prove and Why. Zenodo.
Was this article useful?

Want this for your team?

We set up a pilot for up to 10 people.