Document Library · Budget · Free Excel (.xlsx)

Training Budget Template — With Worked Example

An Excel workbook: enter headcount, sessions, hours and unit price for each course, and it totals instructor fees, materials, venue, meals and VAT automatically. It also shows your quarterly spending plan, cost per employee and spend against budget.

FormatExcel (.xlsx) — swap in your company name and numbers and it’s ready to use
What's insideA blank template + a worked example filled in for a fictional company
How to get itEnter your company, name, and email for an instant download plus a copy by email
CostFree

Get this free document See how to use it

Training Budget Planner preview — Sample entry · Example 1: Budget by Course

Enlarge ⤢

Worked examples · Example ① Budget by course

What’s in this document

Course costs calculated automatically, with VAT shown separately
Quarterly spending plan and running totals
Cost per employee · training hours per employee
Actual Spend vs. Budget
Worked example — 12 courses planned for the year

How to use it

Enter the vendor’s quote as is in the unit price cell. Pick the fee basis (per hour, per session, or per person) and the VAT treatment (excl. VAT, incl. VAT, or exempt), and the totals update automatically.
Setting aside a separate contingency of around 5% makes it easier to handle additional courses during the year.
Assign each course to the quarter when training actually takes place. If sessions bunch up in the peak seasons of the first and second half of the year, instructor fees may rise.
Log actual spending each month in the Execution Rate sheet to see your remaining year-end budget early.

Sample entries — view as a table

Part of the worked example, built for a fictional company (Hanbit Precision Co., an auto parts manufacturer with 280 employees), is shown below as a table. The file contains the blank template and the full example. The amounts and figures in the example are illustrative assumptions.

Example 1: Budget by Course

Input — white cells	Auto-calculated	Input	Auto-calculated	Input
Course Name	Instructor Fee Subtotal	VAT classification	VAT	Notes
New Hire Onboarding Program		Taxable (excl. VAT)		Jan · 2-day in-house session
5 Statutory Mandatory Courses		Taxable (excl. VAT)		Feb · E-learning fees
New Team Leader Feedback & Coaching Program		Taxable (excl. VAT)		Mar · External venue (same amount as approval request)
Generative AI for Work		Taxable (excl. VAT)		Apr · 2 classes
Shop-Floor Supervisor Safety Leadership		Taxable (excl. VAT)		May
Performance Review Practice		Taxable (excl. VAT)		June
Excel Data Analysis		VAT-exempt		Jul · Individual instructor (3.3% withholding tax)

Check the file for the auto-calculated cells (formulas).

Example ② Quarterly execution

No	Q1	Q2	Q3
1	1
2	1
3	1
4		2
5		1
6		1
7			1
8			1

Check the file for the auto-calculated cells (formulas).

Get the Training Budget Planner

FAQ

How much training budget should we set per employee?

It varies widely by company size and industry. This file automatically calculates cost per employee and training hours per employee from the course-level budget, so you can compare against the previous year.

Are the example amounts market rates?

No. They are illustrative assumptions to show how the calculations work. Use actual vendor quotes to calculate your real figures.

Are the documents free?

Yes, they are free. Leave your company name, name, and email to download right away, and we will also email a copy of the same files as a single zip file. We do not collect phone numbers.

Can I adapt these as my company's own documents?

Yes. You can change the company name, figures, and approval boxes and use the documents internally as they are. Please credit the source (Nanum Consulting) only if you redistribute them externally.