Companion files · The Private Markets Career Guides

The Insurance Agency Owner

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 workbook, the toolkit and the read-me, in one archive81 KB

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.

The files

Three numbers to reproduce first

The EBITDAReported 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 offerAt 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 roadsIn 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.