Companion files · The Private Markets Career Guides
How to Run a Profitable Private Investigator Business: Billable Hours, Surveillance Day Costs, Insurance Clients, Retainers, Subcontractors, Cash Flow and Selling the Agency.
These are the companion files of the book. Six workbooks follow Ardmoyle Investigations, the fictional agency of the case, across two fiscal years: hours and utilization, rates and the surveillance day, clients and retainers, investigator pay, cash and decisions, and profit and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 3
Planning figures per case, paid and billable hours by investigator, utilization against the billable ceiling, cases month by month and billable hours by client type, and the subcontracted share. Sheets: Planning, Investigators, Client Types, Subcontracted. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 124 KBChapters 4 and 5
Rates, mileage and rebilled fees, revenue a case, the surveillance day as a unit of revenue and cost for an employee or a subcontracted investigator, and the effective hourly fee of flat-fee work. Sheets: Rates, Surveillance Day, Flat Fees. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 219 KBChapters 6 to 8
Revenue and share by client type, revenue a case or matter, and client money: retainers received, applied, returned or still held. Sheets: Revenue by Client Type, Matters, Retainers. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 317 KBChapters 9 to 11
Wages, payroll costs, the loaded hour and the cost per billable hour beside a subcontracted hour. Sheets: Wages, Payroll Costs, Loaded Cost, Cost per Billable Hour. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 418 KBChapters 14 and 15
Days to collect by client type, the line of credit month by month, and two year-two choices priced in hours: the carrier’s framework and a new investigator, both projections. Sheets: Receivables, Line of Credit, Framework, New Investigator. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 525 KBChapters 13 and 16
Both income statements, net margin, seller’s discretionary earnings and EBITDA, and SDE after a hired manager, with no multiple and no price. Sheets: Income Statement, Margin, SDE, Adjusted SDE. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 618 KBAppendix B
Obtaining the license and opening the agency; Accepting a case; The engagement letter and the retainer; The weekly review of hours and utilization; Hiring and onboarding an investigator or a subcontractor; A complaint or an incident; The founder’s monthly review; Preparing a sale.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| An hour paid, an hour billed | 3,840 / 5,374 = 71.5 percent utilization of the employed investigators in FY2026 |
| A surveillance day | $733.00 - $507.50 = $225.50 of contribution when a subcontracted investigator works it |
| The agency’s earnings | $57,722 + $72,000 + $8,388 + $9,000 + $4,958 = $152,068 of SDE in FY2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ardmoyle Investigations, Brisendale, the founder, the investigators, the office manager, the carrier, the law firm, the bank and every party are fictional, and the rates, hours, miles, wages, fees, rents, premiums and costs are the book’s assumptions, not market terms or the practice of any real agency. A case here is a client type, hours, miles, a rate, a fee and a date; nothing here describes how to work a case. Licenses, client money, worker classification and privacy rules depend on federal and state law and on your contracts: ask counsel, the state licensing body and your outside CPA.