Download Employee Turnover Rate Calculator Free Excel Template

Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Employee Turnover rate calculator is a free excel template with predefined fields and formulas. Using this template you can easily and instantly calculate Turnover Cost per employee and Estimated Turnover Cost per year for a particular department.

This template can be useful for small business owners, HR Assistants, HR Personnel and professionals. This blog post will help you understand the overall concept around employee turnover rates, how to compute it and how to use the excel template provided herein.

What is Employee Turnover Rate ?

Employee turnover rate is the percentage of employees leaving the company during a specific time and is the post is then replaced by the company. These turnovers usually occur due to promotions, transfers, voluntary resignations, dismissals, retirements etc.

Employee turnover cost is computed by taking your empty or vacant position coverage cost plus cost to fill the vacant position plus onboarding & orientation costs plus the productivity ramp up cost multiplied by the number of employees lost in that position in a given year multiplied by 12 to give you your annual rate.

We will discuss the above formula in brief below with respect to the template provided in this blog post.

What Are Employee Turnover Costs ?

Tangible an Intangible cost involved in replacing an employee or employees are called Employee Turnover Costs. These costs include the final settlement of the employee, filling a position, training etc.

Turnover not only causes a loss in terms of productivity but has a huge impact on companies financial and operations. Many unseen and unaccounted expenses are there which directly impact on the company’s budget.

These unseen and unaccounted costs include the cost of covering the vacant post, the cost of loss of productivity of leaving employee and the Cost of productivity of the new employee. Usually, these costs aren’t taken into consideration.

How To Use this Employee Turnover Cost Calculator excel template ?

Employee Turnover Cost Calculator template has many fields but broadly, consists of 6 sections. Each section introductory brief is given below –

  1. Benchmark Employee Costs – Benchmark employee costs mean the total compensation of the departed employee. Divide these compensations into daily and monthly rates. This will help us to accurately define the costs till the position remains empty.
  2. Vacant Position Coverage Costs – The post of the employee remains vacant until the new employee joins the organization. Thus, the workload is either distributed to other employees or remains undone.
  3. Cost To Fill – When an employee leaves, you need to recruit another employee at his place. This is a complete process starting from receiving the applications to employee joining the organization.
  4. Training Costs – Just enter the cost of trainer per day and the number of training days and the total training cost will be displayed.
  5. Productivity Ramp Up Costs – When a new employee joins, initially for 60-90 days he is in the learning process. Thus he doesn’t give 100% productivity as the previous employee. A study shows that he gives 50% productivity. It is called productivity ramp up.
  6. Turnover Calculations – Turnover Cost Per employee is the total of A+B+C+D+E whereas the estimated turnover cost per year is the number of turnovers per year multiplied by the Turnover cost per employee.

Download and use employee turnover cost calculator excel template

To download and use this free employee turnover cost calculator excel template, follow the steps below –

Click the button below to Download Employee Turnover Rate Calculator Excel Template

By Downloading this Free Excel Template, it is implied that you comply with Download Instructions

Download Instructions

If the excel templates can not be downloaded, Leave us a message in the Comment Section. We will solve the related problems for you as soon as possible. All Excel templates and dashboards and tools are sole property of As a User, you can download and use the excel templates, dashboards and calculators for personal and business use with no payment i.e. for free, but without permission, you can not distribute it on the Internet website or CD/DVD channels !

Without permission granted from us/ management team of, use of these excel templates and dashboards is not allowed. However, if you want to share this templates and dashboards with your friends and peers, we have provided sharing option in various social media and platform via which you can share our content.

We hope that you can get our help in making your personal and business activities easier with the use of free excel templates and dashboards, and at the same time, support the construction of our website by considering our efforts and aforesaid instructions.