To calculate employee retention rate, compare the original employees still working at period-end with the starting headcount, then multiply by 100. The result helps founders, owners, and managers see how well a company keeps its workforce over a chosen period.
The original employee cohort means the employees who were already employed at the start of the measurement period. This guide shows the calculation with small and large examples, including a group that grows through new hires. It also explains how to read the result and track it over time.
Managers can use the measure to check whether a team’s staffing remains steady, spot changes, and decide where to ask better questions. The number alone cannot explain why employees stayed or left. First, you need to measure who stayed; then you can judge what the percentage means for your organization.
Key Takeaways
- Follow the original employee cohort, not everyone on payroll at period-end.
- Keep the population and date boundaries consistent across comparisons.
- Exclude new hires from the original cohort count.
- Use the result as a signal, not a complete explanation.
- Compare trends alongside team feedback and departure reasons.
What Does Employee Retention Rate Measure?
Employee retention rate measures the percentage of an organization’s employees who remain employed over a specified period. The period is often a year, though managers can use another consistent interval to suit their goals.
The measure follows one defined group: employees already on the workforce at the start. The original employee cohort is the employees who were already employed at the start of the measurement period. This meaning of employee retention rate makes the group and its start date central to the result.
Retention follows the people who were already employed when the period began. New hires do not become part of that original group.
A focused retention rate measures continuity among those employees. It does not give a complete account of headcount changes, such as hiring, transfers, or changes in company size. A final headcount can rise even while some members of the original group leave.
That distinction matters when managers use retention to understand workforce stability. A single percentage can show how many members of the starting group remain, but it cannot explain their reasons or the experience of new hires.
Set a clear population before comparing results. A company-wide figure answers a different question from a measure for one location, role, or team.
Once the group is clear, managers can define the dates and apply the calculation. Those choices shape the meaning of every percentage that follows.
How to Calculate Employee Retention Rate
Use a defined starting group and count how many of those employees remain at period-end. Employee retention rate = (original employees still employed at period-end ÷ employees in the original cohort at period-start) × 100.
The group can include the whole organization or a defined team, role, or location. Set the start and end dates before calculating, and keep them consistent when comparing periods.
Choose the measurement period and employee group
Choose a period that fits the question, such as a year or quarter. Use the same length and date boundaries for each comparison. If you change from calendar years to fiscal years, note the change rather than treating the results as directly alike.
Define who belongs in the group, too. A location-level measure should use employees assigned to that location at the start, not a shifting mix of workers from later dates.
Apply the retention rate formula
The numerator is the number of people from the original employee cohort still employed at the end. The denominator is the starting number in that same cohort.
Divide the retained count by the starting count, then multiply by 100. The answer is a percentage for that given period. Keep the underlying counts so another manager can check the result.
Check which employees belong in the count
New hires who join after the start date are not part of the original cohort. They should not raise the retained count, even if they remain employed at period-end.
Directly identify original employees whenever possible. Subtracting new hires from ending headcount can fail when records include transfers, acquisitions, or other staffing changes. A headcount shortcut is not reliable if your records cannot track the starting group.
Use these steps to calculate employee retention consistently:
- Choose the group and the start and end dates.
- Record the starting headcount for that group.
- Count original employees still employed at period-end.
- Divide the retained count by the starting count, then multiply by 100.
A clear cohort rule makes the arithmetic repeatable. The examples show how departures and new hires affect the count in different ways.
What Does the Calculation Look Like in Practice?
In an illustrative, fictional organization, 200 employees begin the year in the group. If 20 original-cohort employees leave, 180 remain. The resulting retention rate is 90%.
The arithmetic uses the 180 employees still employed from the starting 200. The calculation is 180 divided by 200, multiplied by 100. The result describes that original group, not every person on the year-end payroll.
Each scenario below is illustrative and fictional. The table shows the starting count, the original employees still employed, and the resulting percentage.
| Scenario | Calculation | Retention rate |
|---|---|---|
| 200-person annual group | 180 ÷ 200 × 100 | 90% |
| 50-person group grows to 58 | 42 ÷ 50 × 100 | 84% |
| 3,200-person quarterly group | 3,138 ÷ 3,200 × 100 | 98% |
In the second fictional scenario, the starting group has 50 employees. At period-end, 58 people work in the group, including 16 new hires. That leaves 42 of the original employees still employed.
The new hires do not change how many original employees stayed. The calculation is 42 divided by 50, multiplied by 100, which gives 84%. Ending headcount rose by eight, but retention for the original group remained below the starting count.
In the third fictional scenario, a quarterly group starts with 3,200 employees. After 62 departures from the original cohort, 3,138 remain. Dividing 3,138 by 3,200 and multiplying by 100 gives a 98% retention rate.
These examples use the same cohort rule at different scales. A spreadsheet can apply it to a larger team, as long as the records separate original employees from new hires.
How Can You Calculate the Rate in Excel?
A consistent worksheet makes the employee retention rate easier to calculate and review. Keep the starting count, ending count, and new hires in separate cells so the team can see how each number affects the result.
The sample layout uses an illustrative group. It assumes the new-hire count includes employees hired during the period who still appear in the period-end headcount.
Set up a simple worksheet
Enter the starting headcount in B2, ending headcount in B3, and period-end new hires in B4. The formula in B5 subtracts those new hires from ending headcount before comparing the remaining count with the starting group.
| Cell | Entry | Illustrative value | Use |
|---|---|---|---|
| B2 | Starting headcount | 200 | Starting group size |
| B3 | Ending headcount | 190 | People employed at period-end |
| B4 | New hires still included at period-end | 10 | Remove from ending count |
| B5 | =((B3-B4)/B2)*100 | 90% | Calculated percentage |
How to Calculate Employee Retention Rate in Excel
The formula in B5 subtracts the ten new hires from the ending count of 190. It then divides the remaining 180 by the starting 200 and multiplies by 100.
This subtraction method works only when records consistently separate new hires from the original cohort. It can give a wrong result if other staffing changes affect headcount or if employee records do not match the chosen group.
When the data cannot identify new hires and original employees reliably, count the original employees directly. Then enter that retained count in a separate cell and use it in the calculation instead.
Use the worksheet to keep a repeatable organization-wide measure. Newly hired employees raise a separate question: whether people from a hiring group stay.
How Do You Calculate New-Hire Retention Rate?
“Who from the original team stayed?” differs from “Who from this hiring group is still here?” A new-hire measure follows its own cohort, defined by hire dates and a set follow-up point.
Count the employees hired in a defined window, then find the share still employed at the chosen follow-up point. Apply the same window and follow-up rule to every hiring group you compare.
Define the new-hire cohort and follow-up window
Set a consistent hire-date window, such as a quarter, and include employees whose start dates fall within it. Then choose a follow-up point, such as a set number of months after hire.
Apply that follow-up point consistently. A group hired in one quarter should not be judged after a shorter time than a group hired in another quarter. Make sure each person has reached the chosen point before comparing results.
Calculate the share still employed
Divide the number of people from the hiring cohort still employed at follow-up by the number hired in that cohort. Express the answer as a percentage for that defined group and follow-up point.
For an illustrative example, a company hires 20 employees in a defined period. If 16 remain employed at the chosen follow-up point, the new-hire retention rate is 80%.
Comparing like hire cohorts can help managers spot onboarding or early-tenure issues. A change in the result points to a question for closer review, not a cause by itself.
This measure tracks new hires, while the earlier measure tracks employees present at the start. Both describe who remains, but departures form another related measure.
How Does Retention Rate Differ From Turnover and Attrition?
Retention counts who stayed; turnover and attrition count who left. The measures follow different events, so their percentages do not always describe opposite sides of one group.
Retention follows the original cohort still employed at period-end. A turnover rate or attrition rate tracks departures during a period and may include new hires who leave before it ends.
For example, a new hire who starts halfway through a year and leaves before year-end may count as a departure in a turnover measure. That person was not in the original employee cohort used for the year’s retention calculation.
Methods also differ. A retention measure may compare a fixed starting group with its remaining members. A turnover rate may use departures against average headcount or another defined base. If the groups or methods differ, one percentage cannot be calculated simply by subtracting the other from 100%.
Organizations may use “attrition” to describe departures, often without distinguishing voluntary and involuntary exits. The term’s exact use can vary, so define which departures the company counts before comparing reports.
Employee turnover can include new hires who leave, while original-cohort retention excludes them. Read each rate with its population, time period, and counting method in view.
For a fuller discussion of employee turnover, use ValiantCEO’s guide to employee retention plans only if discussing ways to keep employees would help. [Unresolved: link is not a turnover guide.]
Knowing what each metric counts is only the first step. A retention result needs the organization’s context before managers can judge what it signals.
What Is a Good Employee Retention Rate?
A retention rate of 90% or higher is a broad reference point for good employee retention. It is not a universal target, because a useful result depends on the organization and the period measured.
Use the number as context, not as a stand-alone verdict. Industry, workforce size, hiring patterns, and organizational changes can all affect what a percentage means.
Use 90% as a broad reference point, not a universal target
A 90% rate means nine out of every ten people in the starting group remained employed through the period. This gives managers a simple reference, not a rule that every company must meet.
A small team can show a large percentage shift when only a few people leave. A larger workforce may show a steadier result, while industry and market conditions can shape hiring and employee movement.
Interpret a percentage in its organizational context
Check whether the measured period, population, and counting rules match earlier results. Changes in team size, hiring, or company structure may also affect how well two figures compare.
The table shows what each percentage means mathematically for a starting group of 100. None of these figures alone proves that a workforce is healthy or struggling.
| Starting cohort | Still employed | Retention rate |
|---|---|---|
| 100 | 90 | 90% |
| 100 | 83 | 83% |
| 100 | 70 | 70% |
| 100 | 50 | 50% |
Poor retention means a smaller share of the original cohort remained employed. Before diagnosing a cause, check the organization’s past results and comparable groups with the same definitions.
A rate becomes more useful when managers track the same groups and periods over time. Consistent tracking helps separate a lasting pattern from a one-period change.
How Should Managers Track and Interpret Retention Trends?
A sudden decline in one team’s result should prompt a closer review of that group. One change is a signal, not proof of a specific management or workplace problem.
Compare like populations over like periods before drawing conclusions. Review company-wide results and team-level patterns, then examine engagement feedback and departure reasons alongside the percentage.
Quarterly review is common practice, but the right cadence depends on the organization’s size and ability to respond. A small company may need a simpler review process than a large organization with many teams.
Keep each comparison consistent. If a team’s definition changes or the period shifts, record that detail so managers do not mistake a reporting change for a workforce trend.
Use this checklist to keep tracking useful:
- Define the population being measured.
- Preserve consistent period boundaries.
- Segment by role or team where useful.
- Compare the result with prior periods.
- Investigate a meaningful change before acting.
Engagement feedback can help explain how employees experience their work, while departure reasons add a view from people who left. Neither replaces the rate, and neither should be treated as a full diagnosis alone.
Look for patterns across groups and time, not just a single dip. Once managers have a clear pattern to investigate, they can choose a focused response to likely causes.
What Can Managers Do to Improve Retention?
Improving retention starts by testing possible causes with the affected employees and managers. Use the rate as a signal, not a diagnosis, and ask what is making people consider leaving.
Choose actions based on recurring concerns, rather than assuming one policy will keep every employee. A retention plan can help managers connect those concerns with clear steps.
A percentage can point to a group that needs attention. Employees and managers can help explain what changed and what response may help.
Use these questions to guide a focused review:
- Review compensation and benefits: Are pay and benefits keeping pace with the roles and needs of this group?
- Clarify career and development opportunities: Can employees see a realistic next step and learn skills for it?
- Strengthen onboarding: Do new hires get clear expectations, support, and the tools to do their work?
- Support managers in communication and workload conversations: Do employees get timely feedback and a fair workload?
- Collect stay and exit feedback, then act on recurring themes: What do employees who remain value, and why do others leave?
Competitive benefits, career growth, a positive work culture, and clear communication can all shape employees’ decisions. ValiantCEO’s employee retention plan guide discusses ways businesses can support employees who stay.
Financial support is a separate issue from workplace changes. The federal Employee Retention Credit was designed to help eligible businesses affected by COVID-19 retain employees on payroll. ValiantCEO explains its eligibility and records in this Employee Retention Credit guide.
No single step guarantees that employees will stay. Pick one recurring concern, ask the affected team about it, and assign a manager to test a practical response.
Conclusion
The useful rule is to compare the same kind of cohort across clearly defined periods. Identify the original employee cohort at the start, then count only those people still employed at period-end.
A consistent definition lets you track workforce growth and changes without mixing new hires into the starting group. The percentage shows continuity, while employee feedback and departure reasons help explain the pattern.
Choose one team and one period, calculate its baseline, and schedule a comparison using the same definition. Record the starting group and dates with the result.
FAQ
What does a high retention rate mean?
A high retention rate means a larger share of the original cohort remained employed through the measured period. It does not explain why employees stayed. Managers can compare the result with the same group’s past periods, then review employee feedback and departure reasons for added context. A high figure alone does not show whether new hires are staying.
Is 44% retention rate good?
A 44% retention rate means 44 of every 100 people in the starting cohort remained employed. Whether that result is concerning depends on the period, workforce, and relevant comparisons. Check the organization’s history using the same group and dates, then compare with a similar industry or role group before judging the number.
Is an 83% retention rate good?
An 83% retention rate is below the broad 90% reference point, but that alone does not settle whether it is concerning. Industry, company size, workforce changes, and measurement period all affect interpretation. Compare the figure with similar groups and periods, and check whether the same counting rules applied each time.
What is a reasonable retention rate?
Around 90% or higher is a general reference for a reasonable retention rate, not a universal target. Compare your result with internal history and relevant industry groups measured in a similar way. A short period, a small team, or a major organization change can make a percentage less comparable with another group’s result.
Is 50% retention rate good?
A 50% retention rate means half of the original cohort remained employed through the measured period. That is a clear reason to examine the period and the departures, but it does not identify the cause. Review comparable past results, employee feedback, and departure reasons before deciding what action fits.
What is considered a low retention rate?
A result well below the organization’s consistent historical level or a relevant industry comparison can be a warning. No single cutoff fits every workforce. Check that the periods, employee groups, and counting rules match before comparing rates. Then investigate meaningful changes instead of treating one percentage as a diagnosis.
Is 70% retention good?
A 70% retention rate means 70 of every 100 people in the original cohort stayed through the period. It is below the broad 90% reference point, but the organization’s size, industry, and measurement period matter. Compare it with similar internal results and review departure reasons before deciding whether the change needs action.
Can you have a retention rate over 100?
No, not when the same original cohort and definition are used. The retained count cannot exceed the number of people in that starting group. A result above 100% usually points to mismatched counts, changing group definitions, or data errors. Check the start and end dates, cohort list, and retained employee count.
