# Insurance Agency (P&C Broker) Model See how client retention, new business, commission income, and staffing shape an insurance agency. - Canonical: https://finamodel.com/templates/insurance-agency - Excel download: https://finamodel.com/templates/insurance-agency.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Independent agency owners and buyers, Insurance-sector PE and search-fund buyers, Agency network / aggregator M&A teams, Lenders and analysts - Tags: insurance-agency, insurance-brokerage, contingent-commission, commission-revenue, dcf ## Overview This model is built for an insurance agency that earns commission from placing coverage for clients. It connects the size of the book, retention, new business, commission rates, and staffing to the agency's revenue and profitability. Use it to assess an acquisition, growth plan, or change in carrier economics. The summary shows how those assumptions affect cash flow and value. ## What's included - Book of business inputs: seed premium in force, retention path, new-business production rate path - Commission structure: flat base commission rate, Y1 book loss ratio and its annual drift - Contingent commission tier schedule: seven loss-ratio bands each with a published contingent rate - Producer compensation: new-business and renewal payout rates, Y1 new/renewal mix assumption - Staffing: CSR ratio and comp, management and corporate FTE and comp, wage growth, benefits load - Other operating costs: E&O insurance, AMS/tech subscription, occupancy/marketing/G&A gearing % - Tax: corporate tax rate - Capex & depreciation: maintenance capex base, growth capex per seat, useful life - Working capital: DSO, base commission receivable - Valuation: WACC, terminal growth, net debt, shares outstanding - Operations sheet: premium-in-force roll-forward, the loss-ratio path and its seven-tier contingent resolution, CSR/management/corporate staffing, capex and PP&E, and the commission receivable - Revenue sheet: new-business and renewal base commission, contingent commission, total commission revenue, and revenue mix % - P&L sheet: revenue to net income with producer compensation as cost of revenue, the opex stack, margins, blended payout rate, identity check - FCF sheet: NOPAT, depreciation add-back, maintenance and growth capex, the commission-receivable working capital balance and its change, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, net debt, equity value, value per share, implied EV/EBITDA - Dashboard with premium in force, net book growth, contingent rate, effective take rate, revenue, EBITDA, EBITDA margin, enterprise value, value per share, a seven-year summary, trend grid and Revenue-to-Net-Income waterfall ## Insurance Agency (P&C Broker) Model: How the Template Works and What It Shows This insurance agency financial model explains a seven-year operating forecast and unlevered valuation for a retail property and casualty brokerage. It demonstrates how premium volume, retention, one separate contingency commission stream, and one producer compensation flow resolve into revenue, profit, and enterprise value. The summary below describes the workbook's documented mechanics without reproducing its numerical outputs. ### What drives the book of business The model is built for an independent P&C retail agency, not a carrier, so it places client premium and earns commission rather than underwriting risk. The book rolls forward from a seed premium using two percentages: a retention rate applied to the prior year's book and a separate new-business rate, also applied to the prior year's book. - Because those two rates sum to a constant total, net book growth stays steady across the horizon even though the mix quietly shifts toward renewals as retention improves and new-business production fades. The first forecast year has no prior year to split, so the model carries a documented assumption about its new versus renewal composition for producer compensation only. - This roll-forward is the engine beneath every downstream revenue and cost line. ### Two commission streams rather than one blended rate The defining mechanic is that base commission and contingent commission are modelled separately. Base commission is a flat percentage applied to the whole placed book every year. - Contingent or profit-share bonus is priced from a published, loss-ratio-banded schedule with several tiers, each with its own loss-ratio ceiling and corresponding rate. A loss-ratio path walks upward over the horizon, so the resolved contingent rate steps down through the tiers year by year. - That separation is what makes the model useful: total commission revenue can decline even while placed premium grows, because a rising loss ratio erodes the contingency bonus faster than the base book expands. A single blended commission percentage would hide this entirely. ### Costs, staffing and producer compensation Revenue flows through two cost-of-revenue and operating layers. Producer compensation is a derived payout on base commission only, split between new-business and renewal rates; contingent commission carries no producer payout, consistent with the profit-share bonuses accruing to agency ownership. - Because producer payout applies only to base commission, the blended payout rate drifts slightly as the book mix shifts toward renewals. CSR staffing scales continuously with premium in force rather than in rounded headcount, while management and corporate headcount are fixed. - Wages carry a benefits load and annual escalation; errors and omissions insurance, agency management system subscriptions, and gross-profit-geared occupancy, marketing and G&A complete the stack. This produces reverse operating leverage: margin compresses as high-margin contingent revenue declines while book-linked servicing costs keep rising. ### Cash flow, working capital and valuation Below EBITDA the model charges depreciation, applies tax at the unlevered level, and builds an unlevered free-cash-flow bridge from net operating profit after tax plus depreciation, less capex and the change in working capital. Working capital is the agency's own earned-commission receivable, not client premium held in trust, which is a fiduciary liability excluded from the model. - Because total commission revenue can decline, that receivable can shrink and release cash, partially offsetting margin compression. Capex combines a maintenance base with a seat-buildout growth component tied to incremental staffing. - The discounted cash flow discounts explicit-period free cash flow plus a Gordon-growth terminal value at WACC, then deducts net debt to reach equity value and value per share. The dashboard summarises the seven-year operating trend, revenue mix and the path from revenue to net income. ## Contingent commission is a tiered bracket, not a blended percentage Carriers pay agencies a flat 13.0% base commission on the whole placed book every year, plus a separate contingent/profit-share bonus priced off a published, seven-band loss-ratio schedule - resolved through seven visible, mutually-exclusive helper rows, each a nested IF against a tier ceiling, exactly like a real carrier contingency agreement rather than a single formula. As the book's loss ratio drifts from 51.0% to 69.0%, the contingent rate steps down one tier at a time from 3.00% to 0.00%, so total commission revenue falls every year, $6.40M to $6.21M, even as placed premium grows 19.4%. ## Operating leverage runs in reverse Contingent commission is 100%-margin revenue - no producer payout applies to it, since profit-share bonuses accrue to agency ownership, not to individual producers. As the contingent rate is extinguished, the revenue mix shifts toward the lower-margin base-commission stream at the same time CSR headcount (a continuous function of the growing premium book) keeps adding cost, so EBITDA margin compresses from both directions at once: 40.5% in Year 1 to 25.3% by Year 7. ## Designed for one-edit responsiveness Every input - the book roll-forward, the base rate and the full contingent-commission tier schedule, producer payout rates, staffing ratios and comp, agency-specific costs like E&O and AMS/tech, capex, DSO, and the WACC - is a named-range cell. Edit one and the operations build, revenue, P&L, free-cash-flow bridge, valuation, and dashboard all recompute. No formula rewrites are needed to test a hardening market, a renegotiated carrier contingency schedule, or an acquisition. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing (broker, not an insurer) - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Dashboard Headline KPIs, a seven-year summary, a trend grid, and an earnings waterfall. - KPI cards for premium in force, net book growth, the contingent commission rate and the effective/blended take rate - Revenue, EBITDA, EBITDA margin, enterprise value and value per share - Seven-year operating summary that feeds every chart - Trend grid including the contingent-rate staircase and the revenue mix shift, plus a Revenue-to-Net-Income waterfall ### Assumptions Every driver in one sheet: the book, the commission structure, the tier schedule, staffing, costs, tax, valuation. - Seed premium in force, retention path and new-business production rate path - Base commission rate and the book loss ratio path - The seven-band contingent commission tier schedule (loss-ratio ceiling and rate per band) - Producer payout rates for new business and renewal, and the Y1 new/renewal mix assumption - CSR ratio and comp, management and corporate FTE and comp, wage growth, benefits load - E&O insurance, AMS/tech subscription, occupancy/marketing/G&A gearing % - Corporate tax rate, maintenance and growth capex assumptions, useful life - DSO and base commission receivable - WACC, terminal growth, net debt, shares ### Operations Premium-in-force roll-forward, the seven-tier contingent-commission resolution, staffing, and capex. - Prior premium times retention plus prior premium times the new-business rate gives closing premium in force - The book loss ratio walks forward and resolves, via seven visible mutually-exclusive helper rows, a single contingent commission rate - CSR/account-management FTE scales continuously with premium in force; management and corporate FTE are fixed - Maintenance capex plus a growth-capex seat buildout roll into PP&E and depreciation - The agency's own earned-commission receivable (working capital) ### Revenue Base and contingent commission kept on separate rows, summing to total commission revenue. - New-business premium times the flat base rate - Renewal premium times the flat base rate - Placed premium times the resolved contingent commission rate - Total commission revenue and the revenue mix % between base and contingent ### P&L Revenue to net income with producer compensation as a derived cost-of-revenue line. - Producer compensation applies only to base commission - new-business payout rate plus renewal payout rate, never to contingent commission - Gross profit and gross margin % - CSR, management and corporate labour, E&O, AMS/tech, occupancy, marketing and G&A to EBITDA - Depreciation to EBIT, corporate tax, net income - Margins, the blended producer payout rate, and an identity check that resolves to zero ### FCF Unlevered free cash flow from EBIT to a discounted present value. - EBIT less unlevered tax equals NOPAT - Add back depreciation - Less maintenance capex and growth capex (seat buildout) - Less the change in the commission receivable, a shrinking balance as revenue declines - Unlevered FCF, discount factor and PV ### Valuation An unlevered DCF to enterprise value, equity value, and value per share. - Sum of explicit PV plus the PV of a Gordon-growth terminal value - Enterprise value less zero net debt (organic growth only) equals equity value - Value per share and an implied EV/EBITDA multiple read off mature-year (Year 7) earnings ## Features - **Contingent commission is a tiered bracket, not a blended percentage:** Carriers pay agencies a flat 13.0% base commission on the whole placed book every year, plus a separate contingent/profit-share bonus priced off a published, seven-band loss-ratio schedule - resolved through seven visible, mutually-exclusive helper rows, each a nested IF against a tier ceiling, exactly like a real carrier contingency agreement rather than a single formula. As the book's loss ratio drifts from 51.0% to 69.0%, it crosses a tier boundary almost every year, stepping the contingent rate down one tier at a time from 3.00% to 0.00% - and because contingent commission decays while base commission only grows with the (much slower) book, total commission revenue falls every year, $6.40M to $6.21M, even as placed premium grows 19.4%. - **Operating leverage runs in reverse:** Contingent commission is 100%-margin revenue - no producer payout applies to it, since profit-share bonuses accrue to agency ownership, not to individual producers. As the contingent rate is extinguished, the revenue mix shifts toward the lower-margin base-commission stream at the same time CSR headcount (a continuous function of the growing premium book) keeps adding cost, so EBITDA margin compresses from both directions at once: 40.5% in Year 1 to 25.3% by Year 7, on a revenue base that is itself shrinking. - **Working capital is the agency's own receivable, never client premium in transit:** Client premium held on its way to a carrier is a fiduciary trust-fund liability, not an agency asset, and is deliberately excluded from the model. Working capital is only the agency's own earned-commission receivable - total commission revenue times a 40-day DSO - so as revenue declines, the receivable shrinks too, throwing off a small cash tailwind that partially offsets margin compression without reversing the overall downward drift in unlevered free cash flow. ## Use cases - **Intrinsic valuation of an agency book:** Set the book size, retention and new-business path, the base and contingent commission structure, the cost stack and a WACC, and read enterprise value, equity value, value per share and an implied EV/EBITDA multiple off mature-year (Year 7) earnings - the range small, owner-operated P&C agencies actually trade at. - **Loss-ratio and contingency-schedule stress testing:** Flex the loss-ratio path, any tier boundary or contingent rate on the schedule to see how much a hardening (or softening) market compresses total commission revenue and EBITDA margin, and how much CSR-headcount discipline or a renegotiated carrier contingency schedule can offset it. - **Book acquisition and roll-up planning:** Flex retention, the new-business production rate, or the seed premium in force to model an agency acquisition or organic-growth plan, and see how quickly a growing book can still produce a shrinking top line if the loss ratio is left unmanaged. ## Frequently asked questions ### What is an insurance agency financial model? An insurance agency financial model captures the seven-year operating economics and intrinsic value of an independent P&C retail insurance agency or brokerage - a business that places client premium with carriers and earns commission on it, but never underwrites risk, never carries claim reserves, and never holds client premium on its own balance sheet. It rolls a book of business forward, resolves two separate carrier commission streams (a flat base rate and a loss-ratio-gated contingent bonus) against the resulting premium, and routes commission revenue through a producer-compensation cost-of-revenue line and a headcount-geared opex stack to EBITDA, then discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share. ### Why can commission revenue fall even while the book keeps growing? Because base commission and contingent commission are two structurally different streams, modelled separately rather than collapsed into one blended percentage. Base commission is a flat 13.0% on the whole book and grows only as fast as the book itself. Contingent commission is a separate profit-share bonus priced off a seven-band loss-ratio schedule, and as the book's loss ratio drifts upward, it steps down one tier at a time toward zero. Because the contingent stream decays faster than the base stream grows, total commission revenue falls every year - $6.40M to $6.21M - even as placed premium grows 19.4% over the same horizon. ### Why does producer compensation apply only to base commission? Because that reflects how real agencies actually pay producers. Contingent/profit-share bonuses from carriers accrue to agency ownership as a reward for book-wide loss performance, not to individual producers for the business they wrote, so the model charges producer payout rates only against new-business and renewal base commission. Applying a payout rate to contingent commission as well would double-count a bonus that never reaches the producer in the real business. ### Why does EBITDA margin compress even though the book is growing? Because operating leverage runs in reverse in this model. Contingent commission is 100%-margin revenue with no producer payout attached, so as it decays to zero, the revenue mix shifts toward the lower-margin base-commission stream. At the same time, CSR/account-management headcount is a continuous function of the growing premium book, so staffing cost keeps rising even as the higher-margin revenue disappears. The two effects compress EBITDA margin from both directions at once, from 40.5% in Year 1 to 25.3% by Year 7. ## Related templates - [Captive Insurance Company Model](https://finamodel.com/templates/captive-insurance-model) - [InsurTech Operating and Valuation Model](https://finamodel.com/templates/insurtech-model) - [Law Firm Model](https://finamodel.com/templates/law-firm)