Employee turnover creates costs across recruiting, onboarding, training, lost productivity, manager time, and disruption to the team. A credible estimate helps leaders understand the business impact and evaluate investments that may reduce unwanted turnover.
This free Excel workbook helps you calculate the cost of replacing an employee, estimate potential financial savings from turnover reduction, and show the relative size of major turnover cost components.
Two Excel tabs for entering assumptions and reviewing results
Editable input cells shaded yellow
Automatic calculations based on your inputs
An updating chart showing the relative size of turnover cost components
Start with a role or employee population where unwanted turnover is meaningful. Use assumptions you can explain, document the sources, and test a reasonable range rather than presenting a single estimate as precise. The model is most useful as a decision tool and conversation starter.
The worksheets are protected to prevent accidental edits, but there is no password. You can remove the protection and adapt the workbook to your organization.
Looking for more practical support connecting People decisions to business outcomes? Learn about People Leader Accelerator.
Employee turnover creates costs across recruiting, onboarding, training, lost productivity, manager time, and disruption to the team. A credible estimate helps leaders understand the business impact and evaluate investments that may reduce unwanted turnover.
This free Excel workbook helps you calculate the cost of replacing an employee, estimate potential financial savings from turnover reduction, and show the relative size of major turnover cost components.
Two Excel tabs for entering assumptions and reviewing results
Editable input cells shaded yellow
Automatic calculations based on your inputs
An updating chart showing the relative size of turnover cost components
Start with a role or employee population where unwanted turnover is meaningful. Use assumptions you can explain, document the sources, and test a reasonable range rather than presenting a single estimate as precise. The model is most useful as a decision tool and conversation starter.
The worksheets are protected to prevent accidental edits, but there is no password. You can remove the protection and adapt the workbook to your organization.
Looking for more practical support connecting People decisions to business outcomes? Learn about People Leader Accelerator.
This Excel workbook has protected sheets with editable cells shaded yellow. However, there is no password on the protection. So, feel free to un-protect and edit however you wish!
