SCF

Business

Staffing Cash Flow Calculator

Paid employees and productive-equivalent employees are intentionally different. New hires consume full payroll and recruiting cash while contributing only the entered first-month productivity. The forecast uses a transparent linear headcount schedule so opening and closing monthly cash contribution can be reconciled.

Opening paid headcount after current-month hiresNew hires entering each monthExpected departures each monthFirst-month productivity for new hires (%)Billable utilization of productive hours (%)Paid hours per employee-monthCollected billing rate per billable hourShare of billed revenue collected in period (%)Cash salary per employee-monthPayroll tax and benefit burden (%)Recruiting and onboarding cash per new hireMonthly management, systems, and office cash costStaffing cash-flow forecast months

Opening productive-equivalent headcount-

Opening billable hours-

Opening billed service revenue-

Opening-period cash collections-

Salary plus payroll burden per paid employee-

Opening paid-headcount payroll cash-

Recurring recruiting and onboarding cash-

Opening cash collections less payroll, recruiting, and overhead-

Scheduled hires minus departures per month-

Final-month paid headcount-

Final productive-equivalent headcount-

Final-month billable hours-

Final-month modeled collections-

Final-month payroll cash-

Final-month cash contribution-

Cash contribution per fully productive employee before fixed cost-

Fully productive headcount needed for monthly fixed and recruiting cash-

Linear-ramp cash contribution through horizon-

Decision view

Paid headcount, productive capacity, and cash contribution timeline

Paid headcount, productive capacity, and cash contribution timelineMonthly paid headcount and ramp-adjusted productive headcount drive collected billing, loaded payroll, recruiting cash, and contribution.

Exact scenario comparisonNew hires entering each month changes while all other entered assumptions remain constant.

New hires entering each month	Opening productive-equivalent headcount	Opening billable hours	Opening billed service revenue	Opening-period cash collections	Salary plus payroll burden per paid employee	Opening paid-headcount payroll cash	Recurring recruiting and onboarding cash	Opening cash collections less payroll, recruiting, and overhead	Scheduled hires minus departures per month	Final-month paid headcount	Final productive-equivalent headcount	Final-month billable hours	Final-month modeled collections	Final-month payroll cash	Final-month cash contribution	Cash contribution per fully productive employee before fixed cost	Fully productive headcount needed for monthly fixed and recruiting cash	Linear-ramp cash contribution through horizon

Period-by-period detail

Monthly staffing cash-flow forecast

Every row follows paid headcount, ramp-adjusted productive capacity, collections, payroll, recruiting cash, and contribution through the entered forecast.

How to use Staffing Cash Flow Calculator

Freeze the opening paid roster and the forecast period so payroll, hiring, billing, and collections use the same monthly basis.
Enter monthly hires, expected departures, and first-month productivity using documented start dates and a realistic ramp assumption.
Enter paid hours, billable utilization, billing rate, and the share of invoices expected to be collected inside the modeled period.
Build loaded payroll from salary and burden, then add recruiting cash and fixed monthly overhead without burying either in the billing rate.
Compare opening, closing, and horizon cash contribution, then replace the linear averages with a roster and receivables schedule before approving actual hires.

Calculator guide

Understanding Staffing Cash Flow Calculator

Forecast staffing cash contribution from paid headcount, monthly hires and departures, new-hire ramp, billable utilization, collected billing, loaded payroll, recruiting cash, and fixed operating overhead.

Ramp separates pay from output New hires receive full cash cost before reaching full productive capacity.

Utilization drives billing Only the billable share of paid hours produces modeled service revenue.

Collections drive cash Billed revenue is reduced to the amount expected to be collected in period.

Headcount changes linearly Constant monthly hires minus departures determine the closing workforce.

Detailed calculation process

Translate paid staffing into productive capacity and monthly cash contribution

The default uses 12 paid employees, one hire and 0.5 departures per month, 50% first-month ramp, 72% utilization, 160 hours, $110 billing, 95% collections, $6,500 salary, 22% payroll burden, $5,000 recruiting per hire, $12,000 overhead, and 12 months.

General formula: H_eff,0 = max(H_0 - H_new, 0) + H_new r/100B_0 = H_eff,0 h u/100CashRev_0 = B_0 p c/100C_loaded = S(1+b/100)Payroll_0 = H_0 C_loadedRecruit = H_new C_recruitCF_0 = CashRev_0 - Payroll_0 - Recruit - FDeltaH = H_new - H_leaveH_n = max(H_0 + DeltaH(n-1), 0)H_eff,n = max(H_n-H_new,0)+H_new r/100CF_n = H_eff,n h u/100 p c/100 - H_n C_loaded - Recruit - FU_FTE = h u/100 p c/100 - C_loadedH_BE = ceil((F+Recruit)/max(U_FTE,epsilon))CF_H = (CF_0+CF_n)n/2 Paid headcount determines payroll, while productive-equivalent headcount determines billable hours. The newest cohort is discounted by the ramp rate. The horizon total uses the trapezoid average because headcount changes linearly under constant monthly hires and departures.

What each symbol means

H_0, H_new, H_leave, H_n Opening paid headcount, monthly hires, departures, and closing paid headcount (FTE).

r, H_eff New-hire productivity (%) and productive-equivalent headcount (FTE).

h, u, p, c Paid hours (h/FTE), utilization (%), billing rate ($/h), and collection rate (%).

S, b, C_loaded Salary ($/FTE-month), payroll burden (%), and loaded employee cost ($/FTE-month).

Recruit, F Monthly recruiting/onboarding cash and fixed overhead ($/month).

CF_0, CF_n, CF_H Opening, closing, and horizon cash contribution ($).

Worked substitution with the default inputs

1. Calculate opening productive capacity H_eff,0 = (12 - 1) + 1×50% = 11.5 FTEB_0 = 11.5×160×72% = 1,324.8 h The current-month hire receives full payroll but contributes half of a productive FTE.

2. Convert billing to cash collections CashRev_0 = 1,324.8×$110×95% = $138,441.60 The collection rate prevents billed revenue from being treated automatically as available cash.

3. Calculate opening staffing cash C_loaded = $6,500×1.22 = $7,930Payroll_0 = 12×$7,930 = $95,160CF_0 = $138,441.60 - $95,160 - $5,000 - $12,000 = $26,281.60 Loaded payroll, recruiting cash, and fixed overhead are all deducted.

4. Build the closing month DeltaH = 1 - 0.5 = 0.5H_12 = 12 + 0.5×11 = 17.5H_eff,12 = 16.5 + 0.5 = 17 Eleven monthly intervals separate month one from month twelve.

5. Reconcile closing and horizon cash CF_12 = 17×160×72%×$110×95% - 17.5×$7,930 - $5,000 - $12,000 = $48,877.80CF_H = ($26,281.60 + $48,877.80)×12/2 = $450,956.40 The linear headcount path supports a trapezoid total across twelve months.

The default grows from 12 to 17.5 paid employees, increases monthly cash contribution from $26,281.60 to $48,877.80, and produces $450,956.40 over the linear twelve-month path.

Input evidence

Build the forecast from records that share one period

Staffing cash flow becomes misleading when payroll, utilization, billing, and collections come from different teams or time windows.

Paid-productive FTE bridge Opening effective headcount and closing paid headcount stay distinct while hires, departures, and ramp assumptions change productive capacity.

Collection-driven cash path Ramp-adjusted productive FTE creates billable service value, then the entered collection assumption determines cash received in the period.

Contribution endpoints Opening and closing cash contribution subtract loaded payroll, recruiting outlay, and fixed overhead, with break-even headcount retained as a separate marker.

Primary references: U.S. Bureau of Labor Statistics Employer Costs for Employee Compensation methodology (https://www.bls.gov/opub/hom/ecec/calculation.htm) and U.S. Small Business Administration financial-management guidance (https://www.sba.gov/business-guide/manage-your-business/manage-your-finances).

Timing discipline

Separate roster timing from productive capacity

The model pays each new hire in full while discounting only the newest cohort's first-month output, which is a planning simplification rather than a roster forecast.

Start-date cohorts Several hires starting on different dates need separate payroll and ramp rows rather than one average monthly hire count.

Departures A fractional departure rate is useful for scenarios, but severance, notice periods, vacancies, and replacement timing need named events.

Capacity steps Managers, software, office space, and support costs may rise in steps even though this page holds fixed overhead constant.

Decision boundary

Read cash contribution as a scenario, not a hiring order

Positive contribution shows that the entered collections exceed the listed staffing cash costs; it does not establish demand, service quality, or liquidity on every payment date.

Break-even is steady state The headcount threshold assumes fully productive employees and the entered rate, utilization, collection, and cost conditions remain available.

Contribution is not accounting profit Taxes, capital spending, debt, non-staff operating costs, and accrual adjustments may still change company profit and cash.

Stress one driver at a time Test slower collections, lower utilization, longer ramp, and higher loaded cost separately before combining a downside case.

Worked situations

Practical examples

With 12 paid employees and one current-month hire at 50% ramp, opening productive-equivalent headcount is 11.5.
One hire and 0.5 departures per month produce 17.5 paid employees in month 12 and about $48,877.80 closing monthly cash contribution.

Better inputs

Useful tips

Use fully loaded employee cost, including payroll taxes, benefits, recruiting, equipment, and onboarding.
Align each hire's start date and ramp period with the month when productive contribution begins.
Reflect billing and collection delays so recognized work is not mistaken for cash already available.

Before relying on the result

Limitations and common mistakes

The model assumes constant monthly hires, departures, utilization, rates, salaries, burden, and collection percentage.
Only the current month's new-hire cohort receives the ramp adjustment; longer or multi-stage ramps need a cohort schedule.
Payroll dates, overtime, bonuses, contractors, severance, taxes, invoice aging, bad debt, and financing are not scheduled.

Reference

Key terms

Paid headcount: Employees receiving full modeled salary and payroll burden in the month.
Productive-equivalent headcount: Paid headcount adjusted for the entered first-month productivity of new hires.
Cash contribution: Collected service revenue less loaded payroll, recruiting cash, and fixed monthly overhead.
Billable utilization: The share of paid hours expected to produce client-billable work during the modeled month.
Collection rate: The share of billed service revenue expected to become cash inside the modeled period.
Loaded employee cost: Salary plus the entered employer burden for benefits, payroll taxes, and related employment costs.
Ramp rate: The first-month productive share assigned to each new hire while full modeled payroll is still incurred.

Important note

Use this as a transparent staffing scenario, then replace constant averages with employee-level start dates, ramp curves, payroll timing, and invoice collection dates.

Frequently asked questions

Why can paid headcount be fractional?

The model treats departures as an average planning rate; a roster-level schedule would use whole people and exact dates.

Why does the new hire receive full payroll but partial productivity?

Ramp time typically reduces billable output before it reduces salary or benefits.

Is break-even headcount a hiring recommendation?

No. It is a steady-state fully productive threshold under the entered utilization, rate, collection, and cost assumptions.

Does horizon cash include collection delay?

Only through the entered collection percentage; invoice aging and timing need a dedicated receivables schedule.