Download Cost Per Hire Calculator Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

FIFA Women’s World Cup Schedule

On this page, you will find FIFA Women’s World Cup schedule and scoresheet with Soccer …

Read More

Nascar Standing Table

Two weeks ago, I watched Nascar race on my TV. The race is taken place …

Read More

UAE VAT Tax Invoice

The business issues an invoice to his customers for goods or services rendered. Today, we …

Read More

Uneven Cash Flow Calculator

Calculating the present or future value of any investment is easy, as long as that …

Read More
Generic filters

Use this Online Cost Per Hire Calculator to get desire metric free template in Excel.

Cost Per Hire Calculator helps to calculate the costs associate with advertising, recruiting and staffing, etc. borne by a company to fill an open position.

In other words, Cost Per Hire or CPH means expenses incur by an employer for recruiting new staff from advertising to joining an employee against total number of recruitments.

Moreover, CPH or Cost Per Hire is one widely used HR metrics to measure effectiveness of the recruiting process.

Thus, it is advisable to have low CPH while recruiting. We should keep in mind that maintaining the quality of recruits is also necessary.

Cost Per Hire = Direct Expenses + Indirect Expenses / No of Candidates Recruited.

Direct Expenses = Salaries of recruiting staff, expenses incurred by recruiting staff, candidate background checks, reference checks, etc.

Indirect Expenses = Recruiter Fees, Advertising costs, Career Fair Expenses, Job board postings, etc.

Thus, CPH varies according to size of the organization, recruitment channels, the seniority of position, etc.

Moreover, to simplify and ease CPH calculations, we have created a Cost per Hire calculator excel template. Just add your details and it will automatically calculate Cost per Hire for you.

Contents of Cost Per Hire Calculator Template

This template consist of 7 sections

  1. Header
  2. Summary Section
  3. Advertising Costs Sections
  4. Reviewing Costs Section
  5. Interviewing Costs
  6. Joining Costs Section
  7. Miscellaneous Costs Section

1. Header Section

Firstly, the header section consists of the company name, company logo, and heading of sheet “Cost Per Hire Calculator”.

2. Summary Section

Secondly, the summary section consists of calculations of cost per candidate for expense.

Cost Per Hire = Advertising cost per candidate + Reviewing Cost + Interviewing Cost  + Joining Costs + Miscellaneous Costs.

3. Advertising Costs

Moreover, Advertising costs include advertising in newspapers, through job portals, and other social media. After adding all advertising costs it is divided by the number of candidates recruited to get Advt. Cost Per Candidate.

4. Reviewing Process Cost

However, CV reviewing cost includes cost of scrutinizing and finalizing the candidates’ applications.

So, Reviewing Cost Per Candidate = No. of HR staff employed X No. of days X Cost per Day / No. of Candidates Recruited.

5. Interviewing Process Cost

Thus, All cost related to interviewing candidate is Interviewing costs.

So, Interviewing Cost per Candidate = No. of interviewers X No. of days X Cost Per Day / No. of Candidates Recruited.

6. Joining Costs

Moreover, The joining cost includes all expenses on candidate to join the organization. It includes the medical examination, training of candidates, and other expenses.

Thus, Joining Cost Per Candidate = Medical Examination Expenses + Training Expenses + Other Expenses / No .of Candidates Recruited

7. Miscellaneous Cost

Somehow, Miscellaneous costs include cost incurred to conduct the background checks on the candidates and confirming the references provided by the candidates.

So, Misc. Cost per Candidate = Total Costs / NO of Candidates Recruited

Furthermore, while calculating the CPH, it should be kept in mind that CPH should be specific to a period like annual, six months, or quarterly.

Download Cost Per Hire Calculator Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Cost Per Hire Calculator Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: