Staffing Agency Model
Operating Businesses Financial Model (Free Excel Download)
Model placements, bill rates, pay rates, recruiter productivity, fill rates, payroll funding, and client concentration to forecast staffing-agency cash flow.
professionals from Deloitte
Used by professionals from
About this model
A staffing agency succeeds when it can fill roles quickly, bill clients at the right rate, and manage the cost of its workforce. This model connects recruiter capacity, placements, contractor pay, and client revenue in a clear operating plan.
Use it to plan branch growth, assess a potential acquisition, or understand the economics of different staffing segments. It also shows how changes in fill rates and billing spreads flow through to value.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Staffing Agency Model
- Capacity inputs: Year-1 branches, new branches per year, recruiters per branch, desk size, billable hours
- Fill rate: Year-1 fill with an annual ramp and a practical ceiling
- Bill rates and gross margins: per-segment bill rate per hour and gross margin (the bill-to-pay spread)
- Permanent placement and managed services: placements per recruiter, average placement fee, managed fee per contractor, rate escalation
- Cost structure: recruiter comp, back-office per branch and wage, benefits, wage growth; occupancy, job boards, technology, and corporate SG&A as % of gross profit; depreciation (% of revenue); tax
- Capital and working capital: maintenance capex %, build-out cost per branch, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Dashboard with KPI cards, a seven-year operating summary, trend charts, a revenue-to-net-income waterfall, and key branch, contractor, margin, valuation, and revenue-mix metrics
How the Staffing Agency Financial Model Works: Drivers, Calculations and Outputs
This staffing agency financial model in Excel provides a seven-year operating forecast for a multi-branch commercial staffing agency, linking branch rollout, recruiter desk build, fill rates and segment billing to cash flow and valuation. It is a values-only preview when downloaded, but the full design captures contract and permanent placement economics.
Operating drivers: branches, desk capacity and fill rate
The model begins with a branch roll-forward: opening branches plus new branches equal closing branches. Each branch carries a set number of recruiters, and each recruiter manages a desk of a target number of contractors.
- Multiplying recruiters per branch by desk size and by a fill rate yields contractors per branch; closing branches times contractors per branch gives deployed contractors. The fill rate starts at a first-year input and ramps by a fixed step each year, capped at a practical ceiling.
- New branches also drive growth capital expenditure through a per-branch build-out cost, while closing branches determine recruiter and back-office headcount. This structure makes deployed contractors the central volume driver, and it allows a user to flex the rate at which new desks season.
From deployments to revenue: segment mix, bill rates and ancillary fees
Contract staffing revenue is built segment by segment across commercial-clerical, light-industrial, healthcare and IT-professional categories. For each segment, deployed contractors multiplied by segment share, billable hours and that segment's bill rate produces revenue, with all rates escalated annually.
- Because IT and healthcare bill at a premium, the blended bill rate emerges from the mix rather than being set directly. Permanent placement fees add recruiters times placements per recruiter times average fee, and managed-services income adds a per-contractor fee.
- Together these streams form total revenue, and the model lets an analyst flex segment shares, bill rates, and the perm-to-temp balance to see how the revenue composition and blended bill rate respond.
The bill-to-pay spread and the cost stack
Revenue less contractor pay and burden equals gross profit. Contractor pay is calculated as segment revenue times one minus the segment gross margin, making the bill-to-pay spread explicit.
- The implied pay rate, bill rate times one minus gross margin, is surfaced as a derived row for comparison with market wage data. The remaining cost structure includes headcount-driven recruiter and back-office labor, loaded for benefits and escalated by wage growth, plus overhead items such as occupancy, job boards, technology and corporate SG&A set as a percentage of gross profit.
- This recognizes that revenue is largely pass-through contractor pay, so gross profit is the true scale of the operating business. The model also captures a delivery cost for managed services, so that high-margin stream is not treated as cost-free.
Free cash flow and valuation: working capital, DCF and equity value
Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and growth capex, less the change in working capital. Working capital is built from days: the change in revenue times client payment-terms days, less the change in contractor pay times the contractor payroll-cycle days, each divided by 365.
- This creates a genuine cash drag because contractors are paid on a short cycle while clients settle on longer terms. The discounted cash flow sums the present value of explicit free cash flows and the present value of a Gordon-growth terminal value to reach enterprise value.
- Subtracting net debt gives equity value and value per share. The implied EV/EBITDA is calculated on a forward first-year basis, not last twelve months.
The model also includes a dashboard summarizing branches, deployed contractors, fill rate, revenue per branch, gross profit per contractor, revenue, EBITDA, EBITDA margin, enterprise value and value per share.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a staffing-agency model?+
A staffing-agency model captures the seven-year operating economics and intrinsic value of a multi-branch commercial staffing agency (temporary contract placement and permanent recruitment). It rolls a branch count forward, sizes recruiter desks and a fill rate into deployed contractors, bills those contractors across a commercial, light-industrial, healthcare, and IT-professional mix at a per-segment bill rate, nets the bill-to-pay spread into gross profit, layers permanent-placement fees and managed-service income, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
Why does the bill-to-pay spread matter so much?+
The bill-to-pay spread is the difference between the client bill rate and contractor pay plus burden. Most staffing revenue passes through to contractors, so the retained spread drives gross profit. The model makes bill rates and gross margins explicit by segment: changes in markup or the mix of IT, healthcare, and other placements flow through blended gross margin and EBITDA.
How is staffing-agency revenue built?+
Revenue starts with volume: deployed contractors equal closing branches times contractors per branch, where contractors per branch equal recruiters per branch times desk size times a fill rate. Contract staffing revenue is then the sum across segments of deployed contractors times each segment share times billable hours times its bill rate, escalated at a step-up rate. Permanent-placement fees and per-contractor managed-service income layer on top to total revenue.
Why an unlevered DCF instead of an EBITDA multiple?+
A staffing agency runs thin EBITDA margins on a large pass-through revenue base and carries a real working-capital drag because contractor receivables grow with the book, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less capex, less the change in working capital, and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.
Can I make it a perm-only or single-branch model?+
The template blends temporary contract and permanent placement. For a perm-only desk, set the desk size or fill rate so contract revenue is immaterial and let placements per recruiter and the average fee drive the top line; for a single branch, set the estate to one branch and size the recruiter desks, segment mix, and headcount to that location. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.
How does the fill-rate ramp work?+
The fill rate starts at the Year 1 input and steps up by a fixed number of percentage points per year, capped at a practical ceiling that reflects how slowly new desks season. Contractors per branch equals recruiters per branch times desk size times fill rate. Deployed contractors equals closing branches times contractors per branch - the single most important volume driver in the model.
Why is overhead benchmarked against gross profit rather than revenue?+
Revenue in a staffing business is largely pass-through contractor pay. Gross profit is the true operating scale the agency controls. Benchmarking occupancy, job boards, technology, and SG&A against gross profit produces ratios comparable across agencies of different segment mixes and avoids distorting the cost structure when contractor pay shifts.
What drives the working-capital drag in the FCF?+
Contractors are paid weekly; clients pay on net terms. As the book grows, contractor receivables absorb cash proportional to the revenue increase. The FCF sheet sets working capital as a percentage of the change in revenue, so faster growth means a larger cash use even when EBITDA is expanding. The NWC assumption is an editable input on the Assumptions sheet.
What do the default headline outputs look like?+
At the default inputs, Year 1 revenue is approximately $57.7M growing to approximately $131.7M by Year 7 across 14 to 26 branches. Blended gross margin runs near 36.5%, EBITDA margin near 5.9%, enterprise value near $21.2M, value per share near $2.21, and implied EV/EBITDA near 6.2x. All inputs are editable so those figures shift with the user assumptions.
Have more financial modelling questions? Contact us
Related templates
Consulting Firm
Five-year pyramid model: headcount, utilization, billable rate, comp, and margins.
Childcare Model
Plan and value a multi-center childcare operator using enrollment by age, tuition rates, staffing ratios, and a DCF.
Franchise Unit Economics Model
Economics template for franchise systems modeling unit-level P&L, franchise fees, royalties, and multi-unit growth scenarios.
Hiring Model
12-month headcount, comp expense, and sales-productivity forecast across five departments.
