Companion files · The Private Markets Career Guides
Staffing Agency Business by the Numbers: Bill Rates, Markup and Gross Margin, Payroll Burden, Weekly Payroll and Cash, Factoring, Recruiters, Co-Employment and What Your Agency Is Worth.
These are the companion files of the book. Seven workbooks follow Brevanton Staffing, the fictional staffing agency of the case, across two fiscal years: the bill rate and markup, the burden and the wage bases, the payroll gap, factoring and the line of credit, a recruiter desk, the conversion fee and the sale price. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no links between files, no password; the only functions are SUM, ROUND, MIN, MAX, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 2 and 4
One straight hour of one temp: the bill rate, the spread, the burden line by line, the loaded cost and the gross margin of the hour. Sheets: Inputs, Rate. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 112 KBChapter 3
One temp’s wages across a calendar year, FUTA and SUTA stopped at their wage bases, and the burden per hour. Sheets: Inputs, Burden. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 212 KBChapter 13
Thirteen weeks of payroll paid against cash received for one client, the cumulative gap and its deepest point. Sheets: Inputs, Gap. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 312 KBChapter 14
One invoice sold to a factor (advance, reserve, fee by days, rebate) and the same invoice financed on a line of credit. Sheets: Inputs, Factoring and Line. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 412 KBChapter 9
One desk’s quarterly commission under a threshold plan, with gross margin and hours per recruiter. Sheets: Inputs, Desk. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 511 KBChapter 7
The conversion fee when a client hires temps before the hours threshold, two clients side by side. Sheets: Inputs, Fee. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 611 KBChapter 16
A letter of intent’s price: adjusted EBITDA, enterprise value, the earnout, the working capital peg and the owner’s proceeds at closing. Sheets: Inputs, Price. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 712 KBAppendix B
Check-list 1: the rate sheet (chapters 2 and 5); Check-list 2: the burden review each January (chapters 3 and 12); Check-list 3: the weekly payroll and cash review (chapters 13 and 14); Check-list 4: the client agreement (chapters 7 and 8); Check-list 5: the new client (chapters 6 and 15); Check-list 6: the recruiter desk review (chapter 9); Check-list 7: the factoring or line review (chapter 14); Check-list 8: before a sale (chapter 16).
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own agency.
Download the read-me5 KB| The hour | Ollerwick Foods, FY2026: pay $17.50 x markup 1.46 = bill $25.55; burden $3.13; gross margin $4.92 an hour |
| The payroll gap | Quarbeck Packaging, weeks 53 to 65: $860,462 paid, $336,360 received, a largest cumulative gap of $564,429 |
| The sale price | Adjusted EBITDA $818,054 x 4.0 = $3,272,216; owner’s proceeds at closing $2,686,656, before taxes and fees |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brevanton Staffing, Dransmere and every party are fictional, and the pay rates, markups, burden rates, payment terms, factoring and line terms, fees, prices and multiples are the book’s assumptions, not market terms or the practice of any real agency, client, factor, bank or buyer. Rules change: check the current texts, counsel in the agency’s state, the insurer’s representative and the outside CPA before relying on any of them.