# The Collection Agency Owner: companion files

Julian R. Sterling

## What is here

- DCAO_1_Commissions_and_Placements.xlsx (Chapters 5 and 6; Commissions and Placements workbook of Appendix A): sheets Inputs, Placement value, Flat fee, then Checks. One creditor segment's monthly commission at a steady pace (Merriwade: 380 x $410 x 18 percent x 25 percent = $7,011), the named creditors' segments side by side, and the flat fee Merriwade proposed against the commission on the same placements ($3,610 against $7,011 a month; $1,340.64 left against $4,741.64; the two pay the same at 9.3 percent liquidation).
- DCAO_2_Portfolio_and_Margin.xlsx (Chapters 7 and 8; Portfolio and Margin workbook): sheets Inputs, Older accounts, Creditor margin, then Checks. Pellinshaw's 2,640 older accounts placed once in October 2025 (expected commission $22,176, collector hours, onboarding and what is left), and one creditor's steady month from commission to what is left, with the four named creditors side by side (loaded collector hour $23.79 then $24.71).
- DCAO_3_Collectors_and_Calls.xlsx (Chapters 9 and 10; Collectors and Calls workbook): sheets Inputs, Capacity, Bonus, Call review, then Checks. Collector hours needed for a year's placements against productive hours (88.0 then 88.9 percent used), the monthly bonus pool ($2,367 in January 2026) with a register for your own months, and the call review with complaints and disputes per accounts placed.
- DCAO_4_Trust_and_Break_even.xlsx (Chapters 13 and 14; Trust and Break-even workbook): sheets Inputs, Trust, Break-even, then Checks. The trust account at 30 June, the agency's commission inside it and what is owed to creditors ($356,391 at 30 June 2026), a register for your own reconciliation, fixed costs added from their lines on Inputs and break-even revenue with staff treated as fixed ($978,299 then $1,152,465).
- DCAO_5_Earnings_and_Sale.xlsx (Chapters 14 to 16; Earnings and Sale workbook): sheets Inputs, SDE, Indication, Transferable, then Checks. Seller's discretionary earnings ($174,908 then $180,531) with each add-back on its own line, net income per owner hour, the fictional buyer's indication with its earnout and the weight of the largest creditor, and transferable earnings ($73,171).
- DCAO_Collection_Agency_Checklists.docx: the 15 checklists of Appendix B, editable (Taking on a creditor; A placement before the first letter; The validation notice and the validation period; A dispute; Calls and the dialer; Call review; A complaint; Credit reporting; Medical creditors; Older accounts; A legal referral; The trust reconciliation and the remittance; A recall; Hiring and access; The monthly review of the agency).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two columns side by side: Case, with the case's figures in blue on a light blue background, and Your agency, an empty yellow column for yours. A cell at the top of the Inputs sheet, and only there, chooses which column the formulas read; the Used column applies that choice (a blank yellow cell falls back to the case figure), and every other sheet reads the Used column. The Note column is yours: write the date and the record behind each input. Black type is a formula, green type a link to another sheet. 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 top cell reads Case. Each of the 12 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.

Two inputs to try first:

1. In DCAO_1_Commissions_and_Placements.xlsx, on Inputs, type the liquidation of one of your own creditor segments: the monthly commission moves, and the Flat fee sheet shows on which side of the meeting point the segment sits.
2. In DCAO_3_Collectors_and_Calls.xlsx, on Inputs, type the minutes you timed on your own collectors for a consumer and a commercial account: the hours needed and the use percentage follow.

To use a workbook on your own agency, set the top cell of Inputs to Your agency and fill the yellow column from your placement files, the collection system's reports, your payroll, the trust account's bank statement and your income statement, in the order Appendix A gives, and keep a dated copy at each year end. The workbooks are separate files with no link between them.

## A word of caution

Dorrowgate Recovery Services, LLC, the town of Dorrowgate, Pellinshaw Health Partners, Gorsemont Building Supply, Merriwade Home Services, Ravelmoor Dental Group and the regional receivables management firm that gave an indication are fictional. Commissions, balances, liquidation rates, wages, minutes, hours, counts, premiums, draws and multiples are teaching assumptions, not market norms or recommendations. Federal rules on debt collection, credit reporting, telephone calls and medical information, and State rules on licenses, surety bonds, trust accounts and time limits, change and may or may not reach a given agency, creditor, account or call: read them in their current text, with your compliance manager, your outside accountant, your insurance broker and your counsel. No company, creditor, consumer reporting agency, software or vendor is described or recommended. Nothing here is legal, tax, compliance or insurance advice.
