TrueStep HR
Browse Tools
Preview of the Training ROI Calculator
The returnThe full program cost, the value of the productivity gain, and the result read four ways, net benefit, ROI, dollars back per dollar, and paybackXLSX
HR calculator

Training ROI Calculator

See whether a training program earns back more than it costs, and by how much. Enter the cost, the hours, and the productivity gain you expect, and the workbook returns the full cost, the net benefit, the ROI, the payback, and the break-even point.

$29USD

One-time purchase, no subscription. Instant download.

Built by expert HR practitioners and leaders

  • Full-cost ROI in an open model: the direct spend plus the value of the time participants spend in training, weighed against the productivity gain, with every formula visible and editable in Excel or Google Sheets
  • A break-even line and a what-if at any level: the productivity gain the program has to clear to break even, and the return retested at any improvement you enter, so you can pressure-test the one number that is hardest to estimate
  • The result read four ways: the net benefit in dollars, the ROI as a percent, the dollars returned per dollar spent, and the months to payback, on one screen
  • A board-ready summary and sourced benchmarks: a one-page Summary for a leadership or finance review, and a Benchmark tab with current training-spend and cost-per-hour figures cited to published industry sources
  • A working file you keep: a pre-filled worked example, your numbers saved per program, and the method documented in plain English, not a one-time screen

The workbook computes from the numbers you enter. Your cost, hours, and the productivity gain are yours to set.

One-time purchase Instant download Editable files 14-day guarantee

Planning estimates and general business information, not legal or tax advice. The return rests on the productivity gain you enter, so estimate the share the training itself caused rather than every change around it, and treat the result as a way to size the value of a program, not proof of it.

Not the right fit? Take the 60-second match.

Last reviewed June 2026

One-time purchaseNo subscription
Instant downloadFiles you keep
Editable filesExcel, Word, PDF
14-day guaranteeMoney back
Secure checkoutSSL encrypted
What you get

One Excel workbook that turns a program’s cost and the gain it produces into a clear return

A working model, not a blank sheet. You enter the program and the gain you expect, the workbook returns the full cost and the return four ways, and it opens on a worked example so the logic is clear before you change anything.

XLSXExcel + Sheets

Training ROI Calculator

Enter the participants, the average salary and benefits load, the direct cost per participant, the training hours, the expected productivity improvement, and how long the gain lasts. The workbook values the participant time at a loaded rate, adds it to the direct spend for the full program cost, values the gain over the benefit period, and returns the net benefit, the ROI, the dollars back per dollar spent, and the payback.

XLSXBuilt in

A break-even line, a what-if, a board-ready summary, sourced benchmarks, and the method in plain English

A Break Even and Scenario tab shows the gain the program has to clear and retests the return at any improvement level. A one-page Summary carries the cost, the value of the gain, and the return for a leadership conversation, a Benchmark tab holds current training-spend and cost-per-hour figures from published sources, and the Notes tab documents how each number is built.

How it works

Three steps from a training plan to a return you can defend

You enter the program and the gain, read the return, and test the break-even. The workbook does the rest.

STEP 01

Enter the program and the gain

Fill the amber cells: the participants, the average salary and benefits load, the direct cost per participant, the training hours, the productivity improvement you expect, and how many months the gain lasts. The worked example runs ten people through a 24-hour course at a 5 percent improvement, change it to your own program.

STEP 02

Read the return

The workbook values the participant time at a loaded rate, adds it to the direct spend for the full cost, values the gain over the benefit period, and returns the net benefit, the ROI, the dollars back per dollar spent, and the payback. Above 100 percent means the gain more than covers the cost.

STEP 03

Test the break-even and a what-if

The Break Even and Scenario tab shows the productivity gain the program has to clear to break even, and lets you retest the return at any improvement level. If the program clears the bar at a one to two percent gain, the return holds even on a conservative estimate. The Summary rolls it up for a leadership conversation.

The standard

Most training is measured by attendance, not by what it returned

Two habits get training measurement wrong. The first stops at completion, counting who attended rather than what changed. The second counts only the invoice and forgets the hours people spend in the room instead of working. A full-cost model weighs both sides, the direct spend plus the participant time against the gain, so the result is one a finance partner will accept.

Organizations put real money into training, on the order of a thousand dollars a year per employee and, by recent ATD figures, about $165 for every hour of formal learning, and most never check whether it paid back. A program earns its keep only when the value it creates clears its full cost, the direct spend plus the hours people spend in the room instead of working. Above 100 percent, more than a dollar back for every dollar in, is the bar a credible result has to clear, and the hard part is how much of the gain you can fairly attribute to the training rather than a new process or a busy quarter.
The cost is more than the invoice. The hours participants spend in training are hours they are not working, and at a loaded rate that time is a real cost. In the worked example the time runs about $900 a head on top of the $1,000 course fee, so a result that counts only the fee overstates the return.
The benefit is the productivity gain, and only the part you can attribute. The workbook values a sustained improvement in output over the months you expect it to last, and counts only the share you can reasonably credit to the training. It leaves out retention and error reduction, so it runs conservative, and isolating the gain from everything else happening that quarter is the step that keeps the result credible.
Above 100 percent is the bar, and a small lasting gain clears it fast. The cost is largely one-time while the gain repeats across the benefit period, so even a few points of improvement usually returns more than a dollar for every dollar spent. The break-even line shows exactly how small a gain the program has to produce to pay back.
Is this for you

Who this calculator fits and where to go if that is not you

It puts a defensible number on a training program, the full cost against the productivity gain, with a break-even line and a board-ready summary. For the cost of turnover, the loaded cost of a role, or the cost of hiring against developing, the right tool is next to it.

Built for

  • An HR or learning leader justifying a training spend who wants a number a finance partner will accept, the full cost against an attributable gain, not a completion rate.
  • A finance or operations partner who wants the program costed in full, with the participant time counted and a break-even line to sanity check the gain.
  • An owner or manager weighing a course or a vendor who wants to see whether it pays back before committing the budget.

If you are looking for

  • Putting a number on the cost of losing an employee, the benefit a well-aimed training program can protect. The Cost of Turnover Calculator covers that.
  • The fully loaded cost of a role, salary plus taxes, benefits, and overhead. The Employee Cost Calculator builds it.
  • Weighing the cost of hiring against developing the people you have. The Cost Per Hire Calculator sizes the hiring side.
Questions

Before you buy

What format is it and can I edit it?
It is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep. Change any assumption, add notes, and duplicate the file to run a second program or to rerun the numbers next year.
How accurate is the result?
The cost side is solid arithmetic: the direct spend plus the participant time valued at a loaded rate. The benefit side rests on one estimate you provide, the productivity gain, so the result is only as good as that number. The workbook runs conservative by counting productivity alone and leaving out retention and error reduction, every figure foots to your inputs, and the Break Even and Scenario tab shows how sensitive the return is to the gain. The math is correct for the numbers you give it.
How is this different from the free calculator?
The free calculator gives you a quick read on screen: the ROI, the net benefit, the payback, and the break-even improvement. The workbook is for when you need to keep and defend that number. You own the file in Excel and Google Sheets, so your numbers stay saved per program and every formula is open to edit and audit. It adds a Break Even and Scenario tab that retests the return at any improvement level you enter, a one-page summary built for a board or finance review, and a Benchmark tab with training-spend figures cited to published industry sources. The free tool answers whether a program looks worth it; the workbook is the model you hand to finance.
How do I estimate the productivity improvement?
Pick one outcome the training is built to move, such as output per hour, error rate, or time to complete a task, and measure it before and after. For role-specific skills tied to measured output, an improvement of 3 to 8 percent is a defensible range; leadership and soft-skills training is harder to attribute and usually shows a smaller measured gain. Count only the share you can reasonably credit to the training, not every change in a busy quarter, and use the break-even line as a reality check: if the program clears the bar at a one to two percent gain, the return is robust. Report the gain as a range rather than a single number.
What is the refund policy?
Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.
What happens after I buy?
Checkout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets, enter your program, and read the return. If a file gives you trouble, email support@truestephr.com.
Can I expense this purchase to my business?

Most customers buy TrueStep HR tools for business use, and a tool you use for work often qualifies as a deductible business expense. Whether it does for you depends on your situation, so confirm with your accountant or tax professional. Your receipt arrives by email at checkout and works as documentation.

Free guide

The 6 red flags to check before you discipline or fire someone

A five-minute screen that catches the most common and most expensive people-decision mistakes before they happen. Free PDF, sent to your inbox. Unsubscribe anytime.

Get the calculator

Put a number on the training, not a hunch

Enter the cost and the gain, and the workbook returns the net benefit, the ROI, the payback, and the break-even point, in a file you keep.

$29
One-time purchase, no subscription

Planning estimates and general business information, not legal or tax advice. Last reviewed June 2026.