# The Private Investigation Agency Owner: companion files

Julian R. Sterling

## What is here

- PIAO_1_Hours_and_Utilization.xlsx (Chapter 3; Hours and Utilization workbook of Appendix A): sheets Planning, Investigators, Client Types, Subcontracted, then Checks. Planning figures per case, paid and billable hours by investigator, utilization (67.7 percent then 71.5 percent for the employed investigators together), cases month by month and billable hours by client type (3,702 then 6,781), and the subcontracted share (30.5 percent in FY2026).
- PIAO_2_Rates_and_Surveillance_Day.xlsx (Chapters 4 and 5; Rates and Surveillance Day workbook): sheets Rates, Surveillance Day, Flat Fees, then Checks. Rates, mileage and rebilled fees, revenue a case by client type, the surveillance day as a unit of revenue ($733.00) and of cost for an employee ($479.84) or a subcontracted investigator ($507.50), and the effective hourly fee of flat-fee due diligence ($138.46 in FY2026).
- PIAO_3_Clients_and_Retainers.xlsx (Chapters 6 to 8; Clients and Retainers workbook): sheets Revenue by Client Type, Matters, Retainers, then Checks. Revenue and share by client type (Gellingford Mutual at 43.3 percent then 40.2 percent), revenue a case or matter, and client money: retainers received, applied, returned unused or still held.
- PIAO_4_Investigator_Pay.xlsx (Chapters 9 to 11; Investigator Pay workbook): sheets Wages, Payroll Costs, Loaded Cost, Cost per Billable Hour, then Checks. Wages, payroll costs at the case rate, the loaded hour ($36.29 in FY2026) and the cost per billable hour ($50.79) beside a subcontracted billable hour ($50.94).
- PIAO_5_Cash_and_Decisions.xlsx (Chapters 14 and 15; Cash and Decisions workbook): sheets Receivables, Line of Credit, Framework, New Investigator, then Checks. Days to collect by client type (45.8 for the agency at 30 September 2026), the line of credit month by month (at most $44,274), and the two year-two choices priced in hours: the carrier's framework (50.1 extra hours a month to break even) and a new investigator (17.3 billable hours a week), both projections.
- PIAO_6_Profit_and_Value.xlsx (Chapters 13 and 16; Profit and Value workbook): sheets Income Statement, Margin, SDE, Adjusted SDE, then Checks. Both income statements ($4,184 then $57,722 of net income), net margin, seller's discretionary earnings ($81,605 then $152,068) and SDE after a hired manager ($62,748). No multiple and no price.
- PIAO_Private_Investigation_Agency_Owner_Checklists.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

Each sheet that Appendix A names holds its own inputs in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every formula reads the Used column. On the Client Types sheet, the cases accepted month by month are typed in place: overwrite them with your own. Black type is a formula, green type a link to another sheet. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how, and which chapter explains it.

Two inputs to try first:

1. In PIAO_1_Hours_and_Utilization.xlsx, on Investigators, type your own billable hours for one investigator: that person's utilization and the employed investigators' together move at once.
2. In PIAO_2_Rates_and_Surveillance_Day.xlsx, on Rates, type your own hourly rate for one client type: revenue a case and the revenue of a surveillance day move with it.

To use a workbook on your own agency, fill the yellow column from your time records, invoices, the payroll register, the bank and loan statements and your engagement letters, in the order Appendix A gives, and keep a copy with the case column for comparison. Keep the fiscal year aligned: the case runs from 1 October to 30 September. Date every input. The workbooks are separate files with no link between them.

## A word of caution

Ardmoyle Investigations, the city of Brisendale, its founder, investigators and office manager, the carrier, the law firm, the bank and the group that wrote to the founder are fictional. Rates, hours, miles, wages, fees, rents, premiums and costs are teaching assumptions, not market norms or recommendations. A case in these files is a client type, hours, miles, a rate, a fee and a date, and nothing in them describes how to work a case. Licenses, client money, worker classification, overtime, consumer reporting and privacy rules, leases, loans and insurance are questions for counsel, your outside CPA, the state licensing body, the lender and your insurance broker. No real agency, carrier, law firm, company, database vendor, software, bank or buyer is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
