# Payroll Forecast

A 12-month forecast of fully-loaded payroll cost across Engineering, Sales, Marketing, G&A, and CX. Splits gross wages from the employer-side burden - FICA Social Security, Medicare, FUTA, SUTA, healthcare benefits, 401(k) match, bonus accrual - and rolls into a Y1 summary with loaded cost per head and a burden multiplier.

- Canonical: https://finamodel.com/templates/payroll-forecast
- Excel download: https://finamodel.com/templates/payroll-forecast.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Beginner
- Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, Controllers, Heads of People
- Tags: payroll, compensation, fp&a, people, fully-loaded cost

## Overview

A payroll forecast is a 12-month plan that translates a department-level headcount build into fully-loaded compensation cost, split between the gross wages an employee sees and the employer-side burden that doesn't appear on the paycheque. The workbook tracks five departments - Engineering, Sales, Marketing, G&A, and CX - with starting headcount and monthly hires per department, an average annual salary that compounds at a configurable rate, and a uniform employer-burden treatment that applies the same payroll-tax, benefits, retirement, and bonus rates across the org.

The Headcount sheet builds ending FTE per department as a rolling balance: M1 = HC_Start + Hires_M1, subsequent months add the same monthly hires onto the prior ending balance. The Gross Pay sheet multiplies ending HC by the monthly salary (annual / 12) with salary growth compounding on the M1 base. The Employer Costs sheet runs the burden split on totals: FICA Social Security (6.2% to the wage base, applied uniformly here as a planning approximation), FICA Medicare (1.45%), FUTA (0.6% effective rate), SUTA (employer-experience-rated, default 2.7%), healthcare benefits (a fixed annual dollar per head divided by 12 and multiplied by total HC), 401(k) match (default 4% of gross), and bonus accrual (default 12% of gross). Total burden plus gross equals the fully-loaded cost; the burden multiplier (loaded / gross) lands between 1.25–1.35× for US tech orgs and is shown in the Summary as a sanity check.

CFOs, FP&A teams, controllers, and heads of people use this template for annual budget compensation builds, headcount-plan cost sanity checks, and benefits / 401(k) plan-design reviews. The Y1 Summary rolls per-department gross wages, payroll tax, benefits, 401(k), bonus accrual, fully-loaded cost, M12 HC, and loaded annual cost per head onto a single tab - the canonical view for any conversation about whether a hiring plan fits the comp envelope. Pair it with the hiring-model template (HC planning) and the budget-vs-actuals template (variance tracking) to close the loop on people-cost management.

## What's included

- 12-month Headcount with starting HC and monthly hires per department
- 12-month Gross Pay with compounding salary growth per department
- Employer Costs sheet splitting payroll tax into FICA SS, Medicare, FUTA, SUTA
- Benefits, 401(k) match, and bonus accrual on the employer-cost roll-up
- Total employer burden, fully-loaded cost, and burden multiplier per month
- Y1 Summary per department: gross, tax, benefits, 401(k), bonus, loaded cost, loaded per head
- 12-month Headcount sheet with starting HC and monthly hires per department
- 12-month Gross Pay sheet with compounding salary growth per department
- Employer Costs sheet splitting payroll tax (FICA SS, Medicare, FUTA, SUTA) from benefits, 401(k) match, and bonus accrual
- Total employer burden and fully-loaded cost per month with a burden multiplier
- Y1 Summary rolling per-department gross, payroll tax, benefits, 401(k), bonus, and loaded cost
- Loaded annual cost per head and overall burden multiplier as sanity checks

## Payroll Forecast: How the Model Turns Headcount Plans into Fully Loaded Cost

This payroll forecast template builds a 12‑month, department‑level view of fully loaded compensation for a US operating company. It separates cash pay, non‑cash equity, and employer‑side burden such as payroll taxes, benefits, and 401(k) match.

The design emphasizes cap‑aware tax mechanics, per‑state SUTA, and a reconciliation‑first rollup for planning review.

### Operating Drivers Behind the Forecast

The model begins with a headcount plan that varies by department and month, rather than a single annual hiring total. Monthly hires feed a headcount roll‑forward that nets attrition, with an optional backfill toggle.

- Because salaries are blended from role‑level bands, department‑level seniority mix, and a location mix weighted by state cost‑of‑living adjustments, the same number of hires can produce different cost paths depending on where and at what level they are added.

- Variable pay, equity compensation, and employer‑side costs are then layered on top. Each department carries its own base, variable, and equity percentages; equity is treated as non‑cash, ratable expense.

Benefits are per‑head dollar amounts, not a percentage of gross, and the 401(k) match applies only to base wages after an eligibility wait. Contractor spend is tracked separately and excluded from the fully loaded FTE burden.

### How the Calculation Flows Across Sheets

Inputs live on dedicated assumption and location sheets, then cascade into headcount, gross pay, and employer‑cost blocks. Headcount drives both salary and per‑head benefit and tax calculations.

- Gross pay produces the cash gross used for uncapped tax lines, while employer costs compute statutory burden line by line for each department and month. The summary then aggregates the employer‑cost blocks by department, so rollups are sourced from the summed build rather than back‑derived from a blended rate.

- Payroll taxes are cap‑aware where statutory limits apply. Social Security and FUTA are calculated with year‑to‑date per‑head wage bases that stop accruing once a cap is reached.

Medicare is uncapped, and an additional Medicare line is included for senior heads whose blended annual base exceeds the threshold. SUTA uses a location‑weighted rate and wage base, also applied through the same year‑to‑date cap mechanic.

### What the Model Outputs and Discloses

The summary sheet reports, by department, year‑one loaded cash, average headcount, loaded cost per head, and a burden multiplier. The multiplier is defined as base plus taxes plus benefits plus 401(k) divided by base, and the template checks whether it lands inside a documented target band.

- Beyond the loaded cash view, the model also surfaces bonus cash payout, severance reserve, PTO accrual liability, merit and promotion pool, 401(k) vesting, contractor spend, and an implied month‑twelve annualized salary per head.

- Each of these disclosures comes with its own logic: bonus payout timing is tied to a chosen month, severance uses leavers times months times average monthly base, and PTO liability uses days times ending headcount and salary. A checks sheet performs reconciliation and validation steps, including summary‑to‑employer‑cost tie‑outs, headcount sums, cash composition, burden‑band compliance, and cap‑aware tax comparisons.

The model is intended for planning at department‑level aggregation, not for direct payroll‑system processing.

### Practical Use and Interpretation

This template is best used to evaluate how hiring pace, location mix, seniority blend, and benefit elections translate into fully loaded cost across a year. Because it separates cash compensation, non‑cash equity, employer burden, and contractor spend, a reviewer can isolate what changes when assumptions change.

- The cap‑aware tax treatment also shows when statutory wage limits materially reduce employer taxes, which is especially relevant for higher‑salary departments.

- The public download is a values‑only preview, so users should treat it as a structured example of the underlying model rather than a live calculation tool. The design emphasizes transparent operating drivers, a defined calculation flow, and reconciliation checks.

When reviewing the outputs, focus on whether the burden multiplier and loaded cost per head move sensibly with headcount, salary growth, and location assumptions, and whether disclosed items such as bonus, severance, and PTO align with the intended plan.

## Built for the people-cost line in a budget

When the question is "what does the headcount plan actually cost us?", a flat 1.30× multiplier hides where the money goes. This template breaks the burden into seven distinct lines so finance partners can defend the build.

## Designed for budget / hiring-plan handoff

Every figure in the Summary ties back to a clear source row on Headcount, Gross Pay, or Employer Costs. Replace assumptions with bookkeeping or payroll-system outputs and the workbook recomputes.

## Audit-friendly mechanics

Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans.

## Built for the people-cost line in a budget

When the question is "what does the headcount plan actually cost us?", a flat 1.30× multiplier hides where the money goes. This template breaks the burden into seven distinct lines so finance partners can defend the build.

## Designed for budget / hiring-plan handoff

Every figure in the Summary ties back to a clear source row on Headcount, Gross Pay, or Employer Costs. Replace assumptions with bookkeeping or payroll-system outputs and the workbook recomputes.

## Audit-friendly mechanics

Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: HC plan per department, salaries, payroll-tax rates, benefits, 401(k), bonus.

- Starting HC and monthly hires per department
- Average annual salary per department plus monthly salary growth
- Employer payroll-tax rates (FICA SS, Medicare, FUTA, SUTA)
- Annual healthcare benefits per head
- 401(k) match rate and bonus accrual rate (% of gross)

### Headcount

12-month ending FTE per department from M1 base plus monthly hires.

- Five departments: Engineering, Sales, Marketing, G&A, CX
- Ending HC = prior HC + monthly hires
- Total HC row across departments

### Gross_Pay

12-month gross wages per department with compounding salary growth.

- Gross pay = ending HC × annual salary ÷ 12
- Annual salary compounds at Salary_Growth monthly
- Total gross pay row across departments

### Employer_Costs

Payroll tax, benefits, 401(k), bonus accrual, total burden, and fully-loaded cost.

- FICA Social Security, FICA Medicare, FUTA, SUTA as % of gross
- Healthcare benefits = total HC × annual benefits / 12
- 401(k) match and bonus accrual as % of gross
- Total burden, gross pay reference, fully-loaded cost, burden multiplier

### Summary

Y1 rollup per department plus an overall burden multiplier.

- Per-department: Y1 gross, payroll tax, benefits, 401(k), bonus, loaded cost
- M12 HC and loaded annual cost per head per department
- Total row across all five departments
- Overall burden multiplier as a sanity check

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: HC plan per department, salaries, payroll-tax rates, benefits, 401(k), bonus.

- Starting HC and monthly hires per department
- Average annual salary per department plus monthly salary growth
- Employer payroll-tax rates (FICA SS, Medicare, FUTA, SUTA)
- Annual healthcare benefits per head
- 401(k) match rate and bonus accrual rate (% of gross)

### Headcount

12-month ending FTE per department from M1 base plus monthly hires.

- Five departments: Engineering, Sales, Marketing, G&A, CX
- Ending HC = prior HC + monthly hires
- Total HC row across departments

### Gross_Pay

12-month gross wages per department with compounding salary growth.

- Gross pay = ending HC × annual salary ÷ 12
- Annual salary compounds at Salary_Growth monthly
- Total gross pay row across departments

### Employer_Costs

Payroll tax, benefits, 401(k), bonus accrual, total burden, and fully-loaded cost.

- FICA Social Security, FICA Medicare, FUTA, SUTA as % of gross
- Healthcare benefits = total HC × annual benefits / 12
- 401(k) match and bonus accrual as % of gross
- Total burden, gross pay reference, fully-loaded cost, burden multiplier

### Summary

Y1 rollup per department plus an overall burden multiplier.

- Per-department: Y1 gross, payroll tax, benefits, 401(k), bonus, loaded cost
- M12 HC and loaded annual cost per head per department
- Total row across all five departments
- Overall burden multiplier as a sanity check

## Features

- **Burden split, not a flat multiplier:** Most planning tools collapse the employer-side burden into a 1.30× multiplier. This template breaks it into seven distinct lines so a CFO can see exactly which component is driving the gap from gross to loaded cost.
- **Department-level Y1 rollup:** Engineering, Sales, Marketing, G&A, and CX each get a row in the Summary with gross, payroll tax, benefits, 401(k), bonus, loaded cost, M12 HC, and loaded-per-head - so headcount and cost decisions sit on one tab.
- **Sanity-check burden multiplier:** The Summary computes total Y1 loaded cost divided by Y1 gross wages. US tech orgs land between 1.25–1.35× - a number outside that range means an input needs to be revisited.

## Use cases

- **Annual budget compensation line:** Pull the Y1 Summary into the operating budget as the people-cost line, with the employer-burden split visible to finance partners so the cost build is defensible in a budget review.
- **Headcount-plan cost sanity check:** Layer this template on top of an HC plan from the hiring-model template to see whether the planned hires fit the comp envelope before the plan goes to the board.
- **Benefits and 401(k) plan-design review:** Flex the healthcare benefits per head and the 401(k) match rate to see how much an upgraded benefits package adds to Y1 loaded cost and the burden multiplier.

## Frequently asked questions

### What is a payroll forecast?

A payroll forecast is a 12-month plan that translates a department-level headcount build into fully-loaded compensation cost, split between gross wages and the employer-side burden - payroll tax, healthcare, retirement match, and bonus accrual. It is how a CFO or controller pressure-tests whether the hiring plan fits the comp envelope before the budget closes.

### How is the employer-side burden calculated?

Each component is a named-range rate applied to either gross wages (payroll tax, 401(k) match, bonus accrual) or to ending headcount (healthcare benefits, modelled as a fixed annual dollar per head). The Employer Costs sheet sums all seven into a total burden line; loaded cost = gross + burden.

### Why doesn't FICA cap at the annual wage base?

The model applies FICA Social Security uniformly across all twelve months as a planning approximation. The actual wage base ($168,600 for 2026) only matters for high earners; for department-level aggregates with a blended salary, the approximation lands within 1–2% of the true full-year figure. For payroll-system handoff, use ADP / Gusto for the wage-base mechanics.

### What burden multiplier should I expect?

US tech orgs typically land 1.25–1.35× - gross wages plus the seven burden components total roughly 25–35% on top. European orgs run higher (1.30–1.50×) because of higher employer social charges in DE / FR / NL. The Summary computes the multiplier as a single sanity-check cell.

### Can I add or remove departments?

Yes. The builder is parameterised by a DEPTS list at the top of the file. Add or remove a tuple, extend the named-range list for starting HC, hires, and salary, and update the rows in Headcount, Gross Pay, and Summary. Employer Costs rolls up against totals so it doesn't change.

## Related templates

- [Hiring Model](https://finamodel.com/templates/hiring-model)
- [Budget vs Actuals Tracker](https://finamodel.com/templates/budget-vs-actuals)
- [3 Statement Model](https://finamodel.com/templates/3-statement-model)