Companion files · The Private Markets Career Guides
How to Start a Collection Agency and Run a Debt Collection Business That Pays: Commissions, Placements, Collectors, Compliance, Trust Accounts and Valuation.
These are the companion files of the book. Five workbooks follow Dorrowgate Recovery, the fictional agency of the case, across two fiscal years: commissions and placements, portfolio and margin, collectors and calls, trust and break-even, and earnings and sale. Each keeps the case’s figures in one column, an empty column for yours, and a cell on its Inputs sheet that chooses which one the formulas read. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the five 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.
Chapters 5 and 6
One creditor segment’s monthly commission at a steady pace from accounts placed, average balance, liquidation and commission, the named creditors’ segments side by side, and a flat fee per account set against the commission on the same placements, with the margin each leaves and the liquidation at which they pay the same. Sheets: Inputs, Placement value, Flat fee. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 116 KBChapters 7 and 8
A one-time placement of older accounts from balances to expected commission, collector hours, onboarding and what is left, and one creditor’s steady month from commission to loaded labor, onboarding and what is left, four creditors side by side. Sheets: Inputs, Older accounts, Creditor margin. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 217 KBChapters 9 and 10
Collector hours needed for a year’s placements against productive hours, the monthly bonus pool with a register for your own months, and the call review: conversations reviewed, failed items, complaints and disputes per accounts placed. Sheets: Inputs, Capacity, Bonus, Call review. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 317 KBChapters 13 and 14
The trust account at month end, the agency’s commission inside it and what is owed to creditors, a register for your own reconciliation, fixed costs added from their lines on Inputs and break-even revenue with staff treated as fixed. Sheets: Inputs, Trust, Break-even. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 416 KBChapters 14 to 16
Seller’s discretionary earnings with each add-back on its own line, net income per owner hour, a buyer’s indication with its earnout and the largest creditor, and transferable earnings. Sheets: Inputs, SDE, Indication, Transferable. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 518 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to try first.
Download the read-me5 KB| One placement’s commission | 380 accounts x $410 x 18 percent x 25 percent = $7,011 a month |
| The trust account | $451,832 received in June 2026 - $95,441 of commission = $356,391 owed to creditors |
| The indication | $180,531 of FY2026 SDE x 1.9 to 2.5 = $343,009 to $451,328 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Dorrowgate Recovery, Dorrowgate, Pellinshaw, Gorsemont, Merriwade, Ravelmoor, the buyer and every party are fictional, and the commissions, balances, liquidation rates, wages, minutes, counts and multiples are the book’s assumptions, not market terms or the practice of any real company. Rules change and differ by State: check the current texts, your signed agreements, your insurance broker, your outside accountant and your counsel.
Learn to develop and finance a data center campus, step by step: the Data Center Development & Finance course →