Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
How to Forecast Headcount Spend
Your headcount spend is one of the most important numbers to project correctly.
Most people don’t realize that their headcount typically accounts for 50-80% of their cash burn. But it makes sense — a company’s biggest asset is its people, so it shouldn’t come as a surprise that it may be the biggest expense as well.
That’s why it’s crucial to understand your headcount forecast. Even the slightest mistake can make a huge impact on planning.
When you project your headcount spend correctly:
You get insights into who you can hire and when
You understand where your cash is going
You get ahead of any surprises
When done incorrectly:
Your cash-out date hits sooner than expected
You may be forced to do layoffs, with exit packages and other unexpected costs
Company morale takes a hit as others fear for their job security
Let’s get into the why, how, and what of forecasting headcount the correct way.
Why Should You Forecast Your Headcount Spend?
Your headcount spend will often account for 50 to 80% of your cash burn each month. Within this, the salary costs are the main driver of structure costs.
A good forecast can help determine the break-even point for the company to cover the structure costs. It provides the sales volume needed to reach profitability.
Your headcount spend can also be one of the most challenging costs to reduce, with a number of challenges ensuing from lay-offs — including severance, lawsuits, and decreased work morale.
Forecasting your headcount expense will allow you to make better informed decisions as you plan for your cash burn for the next 12-18 months.
How Do You Forecast Your Headcount Spend?
To begin, you need to define your needs for the next 12 to 24 months depending on your backlog and sales projections.
Start by collecting information on your existing hires from your payroll platform, and entering it into a spreadsheet.
Next, begin adding your projected hires one by one.
For a long-range forecast (12 months or more into the future), add roles in bulk.
If you have department heads, it may be best to check with each on their upcoming hiring plan.
Consolidate and review the consistency of all headcount with the management team.
How Do You Calculate Projected Spend?
Now that you have your inputs, it’s time to calculate your projected spend for each month. There are two ways to go about doing this:
The Simple Method
Determine the departments with direct FTE.
Apply the business growth ratio to the direct FTE to calculate the traditional headcount.
Use one salary increase rate across the board to calculate the salary costs for next year.
Your salary costs for next year should be (# of FTE next year X average salary per FTE current year X (1 + salary increase).
The Detailed Method
Prorate the salary for any hires who joined this month or were terminated.
Full-time employees have a number of other incidental costs:
Employer payroll taxes which are around 8 to 10% of salary
Health benefits which are around 8 to 10% of salary, or a fixed dollar amount per employee
Payroll processing fees which is around 2.5% of salary, or a fixed dollar amount per employee
Other payroll costs to consider
Bonuses
Commissions (could be monthly, quarterly, or annually)
Recruiting fees (often a percentage of first year salary)
Training costs
Additional structure costs that include place, energy, and equipment — these could be marginal if the structure is already big, but for a smaller team, this is an impact to consider
Putting It All Together
Once you have all the information entered, you can start to use it to analyze your headcount:
Slice and dice your data on a department basis, and by each cost type
Use graphs to understand costs and hires by department and across multiple periods
Use ratios like FTE increase VS sales increase
Being in full control of your headcount planning allows you to analyze the data in a variety of ways. This includes:
Headcount: The evolution per month and compared to your budget.
Percentage of direct employees: A direct employee works directly on a project or production order, whereas an indirect employee has more of a supervisory or a support function role — figure out what employees are working directly on projects and which are supporting.
Flexibility: You gain flexibility through contractors or temporary workers, and understanding this will help you know how much you can reduce or increase your activity to adapt to the business demand.
Capacity: Compare the gross capacity (hours before holidays, sickness, leaves) as well as the net capacity to help explain why there are fewer or more hours worked.
Turnover rate: The number of employees leaving the company compared to the total number of employees. You can see if there is some anomaly in some departments or some reason for the turnover.
The key is to not just create the headcount forecast and stop there. You want to provide ongoing reporting to ensure that the company continues to stay aligned on its plan, and its progress against that plan.
Additional Resources
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.