Answer first
What this calculator tells you
Calculate the turnover rate from separations and the average headcount. Track how many people you lose each period against the size of the team. Formula: Turnover rate = separations ÷ average headcount × 100; average headcount = (start + end) ÷ 2. At the worked-example inputs, the turnover rate is 14.4%. Holding every other input steady, moving employees who left from 14 to 22 moves the result from 11.2% to 17.6%.
Transparent method
The formula
Track how many people you lose each period against the size of the team.
Worked example
Example inputs
How to interpret the result
Turnover compares the number of people who left with the size of the team, using the average headcount so that growth does not distort it. Eighteen departures from a team that averaged 125 people is 14.4 percent for the period. The same 18 leaving a team of 40 would be 45 percent, which is why the raw count alone says little.
At the worked-example inputs the turnover rate is 14.4%. It rises with employees who left and falls as headcount at end and headcount at start increase.
These are planning metrics, not audited accounting or a valuation opinion.
Before you rely on it
What to check
Decide whether the count includes retirements, layoffs and seasonal staff, and keep the same rule from one period to the next.
The common error
Where people go wrong with employee turnover rate calculator
Comparing a monthly rate with an annual one. A 2 percent monthly rate is not 2 percent a year, and annualizing it gives a much larger figure.
Sensitivity evidence
How employees who left changes the turnover rate
Holding every other input at the worked-example value, moving employees who left from 14 to 22 moves the turnover rate from 11.2% to 17.6%: a spread of 6.4%, or 44% of the worked-example result.
| Employees who left | Turnover rate | Average headcount |
|---|---|---|
| 14 | 11.2% | 125 |
| 16 | 12.8% | 125 |
| 18worked example | 14.4% | 125 |
| 20 | 16.0% | 125 |
| 22 | 17.6% | 125 |
Every input, tested
Which input moves the turnover rate most
Of the 3 inputs, employees who left moves the turnover rate most (3.2% across the range tested) and headcount at start moves it least (1.4%).
| Input | Tested from | To | Turnover rate at each end | Swing |
|---|---|---|---|---|
| Employees who left | 16 | 20 | 12.8% to 16.0% | 3.2% (22%) |
| Headcount at end | 117 | 143 | 15.2% to 13.7% | 1.5% (10%) |
| Headcount at start | 108 | 132 | 15.1% to 13.7% | 1.4% (9.6%) |
Two variables at once
Turnover rate by employees who left and headcount at start
Across the grid the turnover rate runs from 10.2% to 19.5%. Moving employees who left from 14 to 22 shifts it by 6.4% at the middle column, and moving headcount at start from 96 to 144 shifts it by 2.8% at the middle row, so employees who left is the bigger lever here.
| Employees who left \ Headcount at start | 96 | 120 | 144 |
|---|---|---|---|
| 14 | 12.4% | 11.2% | 10.2% |
| 16 | 14.2% | 12.8% | 11.7% |
| 18 | 15.9% | 14.4% | 13.1% |
| 20 | 17.7% | 16.0% | 14.6% |
| 22 | 19.5% | 17.6% | 16.1% |
The highlighted cell is the worked example: 14.4%.
Step by step
The worked example, input by input
| Input | Value used | What it means |
|---|---|---|
| Employees who left | 18 | Enter the employees who left used in this calculation. |
| Headcount at start | 120 | Enter the headcount at start used in this calculation. |
| Headcount at end | 130 | Enter the headcount at end used in this calculation. |
| Turnover rate | 14.4% | |
| Average headcount | 125 | |
Inputs, definitions and assumptions
Employees who left
Enter the employees who left used in this calculation. The prefilled worked-example value is 18.
Headcount at start
Enter the headcount at start used in this calculation. The prefilled worked-example value is 120.
Headcount at end
Enter the headcount at end used in this calculation. The prefilled worked-example value is 130.
How to use this calculator
- 1Verify the inputs. Gather employees who left, headcount at start and headcount at end from your own documents; the prefilled values are examples.
- 2Save a baseline. The worked example puts the turnover rate at 14.4%. Store your own version of it as Scenario A.
- 3Test one change. Start with employees who left, the input with the biggest effect here: moving employees who left from 16 to 20 takes the turnover rate from 12.8% to 16.0%, a swing of 22% of the worked-example figure.
- 4Check the extremes. At half the example employees who left (9) the turnover rate is 7.2%; at double (36) it is 28.8%.
People also ask
Frequently asked questions
How do you calculate employee turnover rate?
Turnover rate = separations ÷ average headcount × 100; average headcount = (start + end) ÷ 2. At the worked-example inputs the turnover rate is 14.4%.
What does the employee turnover rate result mean?
Track how many people you lose each period against the size of the team. At the worked-example inputs the turnover rate is 14.4%. It rises with employees who left and falls as headcount at end and headcount at start increase.
How much does employees who left change the turnover rate?
Holding every other input at the worked-example value, moving employees who left from 14 to 22 moves the turnover rate from 11.2% to 17.6%, a spread of 6.4%.
What are the limits of this employee turnover rate calculator?
These are planning metrics, not audited accounting or a valuation opinion. The tables on this page test employees who left only from 14 to 22; a value outside that range is not tabulated here.
Which input moves the turnover rate most in the employee turnover rate calculator?
Ranked by how far each moves the turnover rate across the range tested: employees who left (3.2%, 22%), headcount at end (1.5%, 10%) and headcount at start (1.4%, 9.6%).
If I double employees who left in the employee turnover rate calculator, does the turnover rate double?
Doubling it from 18 to 36 takes the turnover rate from 14.4% to 28.8%, which is 2.00 times the worked-example figure. So the result scales almost exactly in proportion. Halving it to 9 gives 7.2%.
How much does headcount at start matter in the employee turnover rate calculator?
The worked example uses 120. Holding every other input at its worked-example value, moving headcount at start from 108 to 132 takes the turnover rate from 15.1% to 13.7%, a swing of 9.6% of the worked-example figure.
How much does headcount at end matter in the employee turnover rate calculator?
The worked example uses 130. With the other inputs left at the worked example, moving headcount at end from 117 to 143 takes the turnover rate from 15.2% to 13.7%, a swing of 10% of the worked-example figure.
Which inputs change the average headcount in the employee turnover rate calculator?
At the worked-example inputs it is 125. Headcount at start takes it from 119 to 131 and headcount at end takes it from 118.5 to 131.5.
Why do late-paying customers matter so much?
Late payment lengthens the cash conversion cycle, ties up working capital and can force borrowing. Tracking days sales outstanding shows the problem before it becomes a cash shortage.
Sources and evidence
Free Calculators Online is independent and is not affiliated with or endorsed by the source organizations. Educational estimates only.