Cost Per Hire Calculator helps to calculate the costs associated with the advertising, recruiting and staffing etc borne by a company to fill an open position. In other words, Cost Per Hire or CPH means expenses incurred by an employer for recruiting a new staff from advertising to joining an employee against the total number […]
Download Free HR Metrics Templates in Excel
HR metrics are measurements used to determine the value and effectiveness of HR initiatives, typically including such areas as turnover, training, return on human capital, costs of labor, and expenses per employee. We have created Ready-To-Use HR Metrics Excel Templates with predefined formulas.
All excel templates are free to download and use. Click the link to visit the page to find the detail description of each template and understand how each template has been prepared.
If you didn't find any HR template here, please use our suggestion form.
HR professionals prepare the Attrition report monthly or yearly to monitor and rectify the causes of attritions in the organizations. What is Attrition? Attrition means the reduction in the number of employees of an organization through resignation, retirement or death. In other words, attrition is defined as a voluntary and involuntary reduction of a company’s […]
Revenue Per Employee Calculator is a ready-to-use Excel Template to calculate Revenue per employee on quarterly, half yearly and yearly basis. What is Revenue Per Employee? Revenue per employee is an HR metric used to measure the average revenue generated by each employee for a particular time period. It measures the performance of the human resources […]
Profit Per Employee calculator is a ready-to-use excel template to measure monthly, quarterly, half yearly and yearly Profit Per Employee (PPE) of an organization. In this article, we will discuss the about a ready-to-use excel template Profit per employee Calculator, what it is and how to use this template. What is Profit Per Employee? Profit […]
Time To Hire Calculator is a simple and ready-to-use excel template to calculate Time To Hire HR metrics for a single as well as multiple employees. What is Time To Hire (TTH)? Time To Hire is the number of days to between a position opening up and signing of job contract by the candidate or […]
Time To Fill Calculator is a simple and ready-to-use excel template to calculate Time To Fill and Time To Hire HR metrics for a single job post and multiple job posts. Time To Fill is always higher than Time To Hire. The basic reasons behind this are: Long Notice Periods of the Joining Candidate Personal […]
Employee Absent Rate Calculator is a simple, ready-to-use and hassle-free excel template with predefined formulas that you can use to calculate the percentage of monthly and yearly Absenteeism of your organization. What is Absent Rate? Absent Rate is the percentage of employees absent during a particular period against the strength of the organization in that […]
Yield Rate Calculator is an easy and ready-to-use excel template to calculate the yield rate at each stage during the staffing process starting from receiving applications to recruiting the candidate. What is the Yield Rate? Yield Rate is an HR metric which is used to measure the percentage of candidates passing to the next level against […]
Human Capital ROI Calculator is an excel template with predefined formulas that will help calculate HCROI against the money spent on pays and benefits. This template consists of both a simple calculation as well as a detailed calculation bifurcating each head. What is Human Capital ROI? Human Capital ROI or HCROI is an HR Metric […]
Training Cost Per Employee Calculator is a ready-to-use excel template with predefined formulas to calculate the training cost spent on each employee. In this template, you just need to enter the total cost spent on training and the number of trainees and it will automatically calculate the Training Cost PEr Employee (TCPE) for you. What […]
Employee Productivity Calculator is an excel template that helps you calculate employee productivity for manufacturing, sales/marketing, and service industries. Enter the required data and you can calculate productivity in terms of units, dollars, hours etc. What is Employee Productivity? Employee Productivity is the production/revenue received during a specific period against the number of employees or […]
Employee Retention Rate Calculator is a ready-to-use excel template to calculate employee retention rates for companies on a yearly, half-yearly, quarterly and monthly basis. Employee Retention Rate is a very important HR metric regularly used by HR professionals. What Is Employee Retention Rate? Employee Retention is the ability of a company to retain its employees. […]
Employee Turnover Cost Calculator is an Excel template with predefined 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 helpful to small business owners, hr assistants and hr professionals. Before we move further, let us understand employee turnover […]
Job Vacancy Rate Calculator is a ready-to-use excel template to calculate the vacancy rate of any organization, department or group at a given period of time. With the help of this template, you can calculate the vacancy rate in general at a particular date and also monthly job vacancy rate for every month. Job Vacancy – Definition Job […]
Post Occupancy Rate Calculator is a simple and easy excel template prepared to calculate the occupancy rate of your company or any particular department of the company for a given period of time. With the help of this template, you can calculate the occupancy rate at a particular date and also record the monthly post occupancy rate […]
Vacancy Costs Calculator is a ready-to-use Excel Template to calculate direct costs associated with vacant positions. You need to enter the required information and it will automatically calculate the vacancy costs as well as the cost per vacancy. What are Vacancy Costs? Vacancy costs are different from Cost Per Hire. Cost per hire are the expenses […]
Offer Acceptance Rate Calculator is an excel template with predefined formulas to calculate the percentage of offer acceptance of your organization. Enter only 2 details and it will calculate the Offer Acceptance Rate for you. This template can be useful to small business owners, HR assistants, HR professionals, HR consultants etc to calculate the Offer […]
Offer Decline Rate Calculator is a ready-to-use excel template with predefined formulas to calculate the percentage of offers declined during a recruiting process. Before we proceed further let us understand the term. What is Offer Decline Rate? Offer Decline Rate is an HR metric that provides the percentage of offers refused by the candidates for […]
Promotion Rate Calculator is an excel template to calculate the percentage of promotion taking place in a company during a specific period of time. By just entering 2 fields you can calculate the promotion rate for your company. Before we move forward, let us understand the term Promotion and Promotion rate. What is Promotion? Purpose […]
Total Compensation Spend Rate Calculator is an excel template with predefined formulas to calculate the percentage of Compensation Spend against the operating costs of an organization. Enter only 3 details and it will calculate the Compensation Spend Rate for you. Before we proceed to the template contents, we need to first understand the Total Compensation Spend Rate. […]
New Hire Turnover Rate Calculator is a ready-to-use Excel Template to calculate the percentage of new hires who leave the company in a given period of time. Before we move ahead, we need to understand what is it and how it is calculated. What is New Hire Turnover Rate? Turnover rate is the proportion employee […]
Employee Base Salary Increase Rate Calculator is an excel template with predefined formulas to calculate percentage increase of base salary for a given period. It can be annual, half-yearly or quarterly. You can also calculate the Base Salary Increase Rate department wise with this template. Before we discuss the template, let us understand what is […]
Benefits Spend Rate Calculator is a ready-to-use excel template with predefined formulas to calculate the percentage of total compensation spent on employee benefits. Before we discuss the template in details, let us understand the following terms: Employee Benefits Benefit Spend Rate Employee Benefits Employee Benefits are the non -wage compensation provided to an employee apart from […]
Annual Benefit Spend Change Report is the annual comparison report between the amount spent on employee benefits in the current and the previous year. You can also calculate the Benefit Spend Change against the Total Compensation between two periods. What are Employee Benefits? What is Annual Benefit Spend Change? Annual Benefit Spend Change is the […]
EBIT Per FTE Calculator is a ready-to-use excel template to calculate the earnings before investment and taxes per full-time employee. Simply enter the required amounts from your income statement and you can derive EBIT Per FTE in just two steps. Before we proceed further let us understand What is EBIT and What is EBIT Per […]
Training Spend Rate Calculator is a ready-to-use excel template to calculate the percentage of Training cost spent against HR Costs and Operating Costs. This template consists of predefined formulas. Just enter the required data and the template will automatically calculate the Training Spend Rate for you. What is Training Spend Rate? Training Spend Rate is an […]
Average Training Hours Calculator is a ready-to-use excel template with predefined formulas to calculate average training hours per employee. You just need to enter a few data and it will calculate it for you. What is Average Training Hour? Average Training Hours means the total training hour divided by hours the total number of employees taking […]
Employee Retirement Rate Calculator is a ready-to-use excel template that helps you calculate the rate of retirements in your organization. This Human Resource metric is useful for recruitment planning, forecasting retirement rates, study retirement trends and define future recruitment strategies.
HR to Employee Ratio Calculator is a simple and easy-to-use excel template with predefined formulas that helps you calculate HR to Employee Ratio. You can calculate the HR to Employee Ratio department-wise as well as of the organization with this template. Just enter a few details and the template will calculate the HR to Employee Ratio for you.
We have created a simple and easy Overtime Percentage Calculator Excel Template with predefined formulas. All you need to do is to enter a few details. It will automatically calculate the Overtime Percentage for you. You can find overtime percentage for an individual, department-wise and company as a whole with this calculator.