background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street PrepWSP Certificates Now Enrolling for February 2025:
Private EquityReal Estate InvestingApplied Value InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Attrition Rate

Step-by-Step Guide to Understanding Attrition Rate in SaaS

Attrition Rate

  Table of Contents

How to Calculate Attrition Rate

The attrition rate measures the rate at which employees have left their positions at a company—voluntarily or involuntarily—within a specified time frame.

Employee retention is critical to a company’s long-term success, and the attrition rate provides insight into how effectively current employees are retained.

The amount of time allocated to recruiting activities can directly impede a company’s productivity since such efforts detract resources, such as time and attention, away from the core business.

Furthermore, the constant necessity to hire and train new employees to be productive can be costly, weighing down on a company’s profit margins (and reducing output).

Therefore, the attrition rate reflects the pace of employee turnover, expressed as a percentage, which serves as a key performance indicator (KPI) for a company’s organization structure and is thus closely monitored by the human resources (HR) department.

The step-by-step process of calculating the attrition rate is relatively straightforward and can be broken into four steps.

  • Step 1 ➝ Establish the Specific Time Parameters for Measurement
  • Step 2 ➝ Count the Number of Churned Employees
  • Step 3 ➝ Calculate the Average Number of Employees
  • Step 4 ➝ Divide the Churned Employees by the Average Number of Employees

Attrition Rate Formula

The formula for calculating the employee attrition rate divides the number of churned employees by the average number of employees.

Attrition Rate (%) = Number of Churned Employees ÷ Average Number of Employees

Where:

  • Number of Churned Employees = Churn Rate × Beginning Number of Employees
  • Average Number of Employees = (Beginning + Ending Number of Employees) ÷ 2

To express the attrition rate in percentage form rather than decimal notation, the resulting figure must be multiplied by 100.

For example, suppose a SaaS company began the month of June 2024 with 100 employees in total, of which 10 churned over the course of the month.

The number of churned employees in June 2024 is 10, which we’ll divide by the average between the beginning and end of period employee headcount, i.e. 100 and 90.

  • Employee Attrition Rate = 10 ÷ 95 = 10.5%

What is a Good Attrition Rate?

A high employee attrition rate suggests that a company’s employees are quitting frequently, whereas a low rate means the company’s employees remain on board for longer.

  • High Employee Attrition ➝ A high attrition rate implies that problems within the company need to be identified and fixed promptly.
  • Low Employee Attrition ➝ On the other hand, a low attrition rate—the outcome most companies strive to achieve—is often perceived positively and reflects that current employees are incentivized to remain with the company rather than pursuing different roles elsewhere.

Generally speaking, most companies with low employee turnover have a better organizational system and practices intact for retaining employees over the long run — which often coincides with outperformance relative to competitors, not just in revenue and profitability but also in attracting more qualified, higher-tier talent in their pool of potential candidates.

In contrast, a high employee turnover can be time-consuming, as resumes and cover letters must be reviewed, new candidates must undergo screening (i.e. background checks), and interviews must be conducted before the onboarding and new employee training can even start.

What Causes High Employee Attrition?

The following internal issues often contribute to higher employee churn:

  • Toxic Workplace Environment
  • Lack of Communication (and Leadership in Hierarchy)
  • No Structure in Organizational Hierarchy, i.e. Ineffective Task Allocation Process (“Bottlenecks”)
  • Employee Burnout from Physical Fatigue and the Accumulated Toll on Mental Health
  • Low Company-Wide Morale, i.e. Poor Culture and No Incentive for Employees to Outperform
  • Below-Market Compensation Relative to Competitors
  • Sub-Par New Employee Training and Onboarding Process
  • No “Open Door Policy” or Closed-Door Meetings for Discussion (i.e. Feedback for Improvements)

Attrition Rate vs. Employee Turnover: What is the Difference?

The terms attrition and employee turnover are essentially synonymous, yet formally, there is a subtle distinction.

While high rates of attrition and employee turnover signify potential “red flags”, attrition is more of a concern because employee turnover could be considered an inevitable part of an industry’s business model (e.g. investment banks are well-known for their high employee turnover, especially at the analyst level, where a one-to-two-year stint is considered the norm).

The high employee churn in such cases might be suboptimal. Still, it can also simply be how the business model works in specific industries, like investment banking, where analysts are expected to leave for the buy-side or seek other roles, such as corporate development, after spending time in banking.

However, a high attrition rate stems more from vacated positions that result in lost opportunities (i.e. the opportunity cost of time), reduction in the quality of talent, lower productivity, etc. — but to reiterate, this difference is negligible to the human resources (HR) departments within certain companies.

Employee attrition is the inverse of employee retention. Therefore, a higher attrition rate corresponds to a lower retention rate (and vice versa), as one would reasonably assume.

  • Attrition Rate ➝ Percentage of Lost Employees in Period
  • Retention Rate ➝ Percentage of Retained Employees in Period

What are the Different Types of Attrition?

There are four primary types of employee attrition (or “churn”), as outlined in the following table:

Types of Attrition Description
Voluntary Attrition
  • The employee takes the initiative to voluntarily leave their current role in the company, most commonly due to personal reasons (e.g. family, moving elsewhere), sub-par compensation relative to the industry average, lack of benefits such as health insurance, and poor workplace culture.
Involuntary Attrition
  • The employee’s removal from their position was not by their own choice but rather the company’s decision, e.g. underperformance, downsizing, overlapping roles, or headcount reduction.
Internal Attrition
  • The employee is switching from their current role to another role within the company, so the employee is not leaving the company (i.e. the move could be due to a promotion, demotion, or a different department).
Demographic-Specific Attrition
  • The employee’s reason for leaving their current role is related to more concerning issues, such as racism in the workplace, where a particular group of people feels marginalized due to a lack of inclusion (and thus, these sorts of movements often occur in large numbers rather than on an individual basis, with the potential for long-lasting reputational damage).
What is Normal Attrition?

Another type of attrition is referred to as “normal attrition,” which is employee churn related to retirement, wherein the employee has reached a certain age where employment is no longer an option (e.g. due to physical constraints) or a “natural” decision after reaching a certain age, which would be categorized as voluntary attrition.

Attrition Rate Calculator — Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Employee Turnover Rate and New Hiring Rate Assumptions

Suppose we’re estimating the attrition rate of a company in its latest fiscal year, 2021.

The number of employees at the beginning of Q1-21 is 100,000; from there, the following assumptions will drive our model.

Employee Assumptions Q1-21 Q2-21 Q3-21 Q4-21
Quarterly Turnover Rate 12.0% 9.5% 7.0% 4.5%
New Hiring Rate 8.0% 6.0% 4.0% 2.0%

2. Churn and New Hires Forecast

For our two model drivers—the quarterly turnover rate and new hiring rate—the percentage assumption will first be multiplied by the beginning number of employees.

The number of churned employees is determined by multiplying the quarterly turnover rate by the beginning number of employees.

Churned Employees = (Quarterly Turnover Rate × Beginning Number of Employees)

On the other hand, the number of new hires in the coinciding period equals the new hiring rate multiplied by the beginning number of employees.

New Hires = New Hiring Rate × Beginning Number of Employees

3. Employee Roll-Forward Schedule Build

We are left with the following figures upon inserting those assumptions into our formula and linking them to our employee roll-forward schedule.

Employee Roll-Forward Schedule Q1-21 Q2-21 Q3-21 Q4-21
Beginning Number of Employees 100k 96k 93k 90k
Less: Churned Employees (12k) (9k) (6k) (4k)
Plus: New Hires 8k 6k 4k 2k
Ending Number of Employees 96k 93k 90k 88k

4. Attrition Rate Calculation Example

The final step is to take the number of churned employees in each quarter and divide it by the average number of employees for the period.

Quarter Churned Employees Average Number of Employees Quarterly Attrition
Q1–21 12,000 98,000 12,000 ÷ 98,000 = 12.2%
Q2–21 9,000 94,000 9,000 ÷ 94,000 = 9.7%
Q3–21 6,000 91,000 6,000 ÷ 91,000 = 7.1%
Q4–21 4,000 89,000 4,000 ÷ 89,000 = 4.6%

Therefore, we can derive that our hypothetical company improved its employee retention rate over time since the attrition rate declined from 12.2% in Q1-22 to 4.6% in Q2-22.

The total number of employees may have fallen from 96k to 88k, yet the retained employees are likely more productive; thereby, the reduction in the new hiring rate implies the company’s current capacity can still sufficiently handle its output requirements.

Attrition Rate Calculator

Comments
Subscribe
Notify of
0 Comments
most voted
newest oldest
Inline Feedbacks
View all comments

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.