Payroll 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.

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.

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.

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.