Free Templates · Insurance Agency M&A

Insurance Agency Valuation Calculator (Excel)

A 4-tab, 100% formula-driven Excel workbook comparing commission multiples, pro forma EBITDA normalization, and SBA 7(a) acquisition DSCR limits.

Direct download (free, no registration required)

Pre-loaded with the Tamberlow Insurance Agency P&C case ($35.00M written premium, $4.69M core commissions, $1.38M pro forma EBITDA, $11.04M platform valuation, and $7.59M SBA 7(a) deal structure at 1.26x DSCR). Editable blue inputs, standard Excel formulas only, 0 macros.

Download Excel Calculator Explore The Insurance Agency Owner

What the Workbook Computes Dynamically

TabScope & Formulas
Inputs_and_SummaryEditable blue cells for personal and commercial written premium, commission rates, retention, producer splits, and valuation multiples, feeding a live value bridge across Commission Multiple, Platform EBITDA ($11.04M), SBA 7(a) Deal Price ($7.59M), and +1% retention value ($193.9k).
EBITDA_NormalizationFull P&L rebuild from written premium to reported EBITDA ($1.19M), Quality of Earnings add-backs (owner replacement pay, one-off legal costs), 3-year contingent commission smoothing (-$40k haircut to $1.38M pro forma EBITDA), and a Carrier A loss-ratio catastrophe stress test.
SBA_7a_Deal_StructureModels 10% buyer equity, statutory $5.00M SBA 7(a) cap (MIN formula), 10-year monthly PMT amortization, subordinated seller note, live DSCR underwriting check (1.26x vs. 1.25x floor), exact maximum supportable purchase price ($7.68M / 5.56x), and a Year-1 retention clawback adjustment.
Controls8 live mathematical identity checks returning OK or CHECK (0 hardcoded constants) verifying revenue, EBITDA bridge, SBA sources of funds, $5.0M loan cap, 10% equity floor, and DSCR compliance as you edit inputs.

Read the complete valuation walkthrough

See the line-by-line methodology behind commission multiples, contingent haircuts, producer non-piracy covenants, and SBA 7(a) debt ceilings in How to Value an Insurance Agency: Commission Multiples vs. Pro Forma EBITDA, or get the full 9-tab companion model in The Insurance Agency Owner.