Companion files · The Private Markets Career Guides
Running, Growing, Valuing and Selling an Independent Insurance Agency: Commissions, Retention, Producers, Book Purchases, Consolidators and Succession.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook rebuilds Tamberlow Insurance Agency, the fictional fifteen-person independent agency of the case: premium turned into commissions and revenue, the Carrier A contingent grid, the book rolled forward to 2031, reported and pro forma EBITDA, a new producer and a producer who leaves, the purchase of the Ottercliff book, the platform’s offer and its earn-out, four roads compared in today’s money, and an internal perpetuation. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3 to 14, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Revenue, Growth, P&L, Producers, Book Purchase, Valuation, Roads, Perpetuation. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 15 exercises of Appendix A run on it.
Download the workbook43 KBAppendix B
Licensing and appointments; Monthly trust account reconciliation; E&O and data controls; Producer agreement review; Producer departure day; Buying a book; Preparing the agency for sale; Internal perpetuation.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The EBITDA | Reported EBITDA of $1.19 million becomes $1.38 million pro forma once the owner’s pay, a one-off cost and the contingents are normalized |
| The offer | At 8.0x pro forma EBITDA the platform pays $11.04 million at closing; on the base projection the earn-out adds $1.41 million |
| The roads | In today’s money: platform $12.10 million, stay independent $14.50 million, cluster $15.03 million, internal sale $7.84 million |
The files are provided as they are, without warranty of any kind. The model is illustrative: Tamberlow Insurance Agency, Ottercliff Insurance Agency, the platform, the cluster and the carriers are fictional, and commission rates, retention, costs, splits, multiples and loan terms are the book’s assumptions, not market rates, market multiples or market data. Rules are set state by state and change. Nothing here is legal, tax, accounting or investment advice.