# The Insurance Agency Owner: companion files

Julian R. Sterling

## What is here

- **Insurance_Agency_Owner_Model.xlsx**: the workbook that rebuilds the Tamberlow case and reproduces the figures of the book with live formulas. Sheets: Inputs, Revenue, Growth, P&L, Producers, Book Purchase, Valuation, Roads, Perpetuation, Checks.
- **Insurance_Agency_Owner_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapters 3, 4 and 9: Revenue (premium placed $35.00 million, commissions $4.69 million, the Carrier A contingent grid, 2026 revenue $5.02 million, premium by carrier, the premium trust account)
- Chapter 5: Growth (the book rolled forward to 2031, organic growth 4.9 percent in 2027, EBITDA $1.71 million in 2031, the value of one point of retention)
- Chapter 6: P&L (reported EBITDA $1.19 million, pro forma EBITDA $1.38 million)
- Chapters 7 and 8: Producers (a new producer's first three years, cumulative net $0.17 million; a producer who leaves, $2.48 million of value at risk without protection)
- Chapter 10: Book Purchase (Ottercliff at $0.99 million, total paid $0.92 million, payback in year 3)
- Chapters 11 and 13: Valuation (the platform pays $11.04 million at closing; earn-out $1.41 million on the base projection)
- Chapter 12: Roads (platform $12.10 million, stay independent $14.50 million, cluster $15.03 million, internal sale $7.84 million, in today's money)
- Chapter 14: Perpetuation (internal price $8.28 million, debt service $1.13 million a year, cover 1.28x)
- Appendix A: 15 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, lower commercial retention from 90 percent to 88 percent: watch organic growth on Growth and the roads on Roads.
2. On Inputs, lower the platform's multiple from 8.0x to 7.0x: watch the payment at closing on Valuation. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs. Amounts are in $ million unless stated; line items are rounded to $0.01 million before they are added, as in the book.

Tamberlow Insurance Agency, Ottercliff Insurance Agency, the platform, the cluster and the carriers are fictional; commission rates, retention, contingent grids, costs, splits, multiples and loan terms are teaching assumptions, not market rates, market multiples or market data. Licensing and trust rules are set state by state and change: check the current text. Provided as is, without warranty. Not legal, tax, accounting or investment advice.
