Insurance agency numbers explained
An insurance agency can write plenty of new business and still find the bank balance flat at the end of the year. The reason sits in a few numbers: how many policies you keep, what your book of business (the policies and clients your agency writes and services, and the commission they pay) brings in at renewal, what each producer brings in, what a new policy costs to win and how commission is shared. This guide explains each of them in plain terms, using only your own figures, and links the calculator that does the arithmetic. A producer is a licensed person who sells and services policies. Commission structures and client fees are set by carriers, contracts and your jurisdiction; the calculators simply apply the terms you enter.
1. Retention is the number the book lives on
Retention is the share of the policies in your book still on the books at the end of a period. Take three counts from your agency management system for the same period: policies in force at the start, policies lost (cancelled, lapsed or not renewed) and new policies written. Count them the same way every time. If one quarter counts a multi-line client as one policy and the next counts each line, the trend means nothing. The policy retention rate calculator takes those counts and your commission per policy, and gives retention and lapse rates, policies at the end of the period, net growth, and the commission lost and retained. For the same idea seen as clients leaving rather than policies staying, the churn rate calculator works from customer counts.
2. What the book pays at renewal
A renewal commission is the commission a carrier pays when a policy you placed renews for another term. It is often a different rate from the first-year commission, and your carrier contracts and commission statements show which rate applies to which line. Renewals are where retention compounds. Each year you keep a policy, it pays again; each year you lose one, every later renewal goes with it. Pull policy counts and premium from the management system and the renewal rates from your contracts. The renewal commission calculator takes policies, premium, renewal rate, your own retention, the number of years and the new-business rate, and shows annual book commission, first-year renewal, the residuals over the years you choose and the policies still in force each year. Run it twice with retention a little higher and a little lower to see how much one point of retention is worth to your own book.
3. Revenue per producer and the compensation ratio
Revenue per producer tells you how much commission and fee income each selling person supports. Take total revenue from your accounts, the number of producers and support staff from payroll, total compensation including employer costs, and new-business revenue from carrier statements. The revenue per producer calculator gives revenue per producer and per employee, the compensation ratio (pay as a share of revenue) and the share of revenue that came from new business. Compare the results with your own earlier periods, not with a figure from someone else's agency, because your mix of personal and commercial lines, staffing and pay plans is your own. The revenue per employee calculator gives the whole-team view on its own, and if producers leave, the employee turnover cost calculator puts a figure on replacing them.
4. What a new policy costs to win and what it pays back
New business is not free just because producers are paid on commission. Add up marketing spend and lead purchases from the accounts, count leads and policies written from the management system, and value producer time at its real cost: hours spent quoting multiplied by what those hours cost you. The cost per policy acquired calculator takes those figures with first-year and renewal commission, your retention and the years you expect to keep a policy, and gives cost per policy, lifetime commission, the value-to-cost ratio and how many policies pay back the spend. Use the retention you measured in section 1, not a hopeful one. For the same idea in months rather than policies, the CAC payback calculator and the lifetime value calculator work from monthly figures.
5. The split: two views of the same commission
Every commission cheque is shared. The carrier pays the agency, and the agency pays the producer a split under the producer compensation plan, sometimes after an agency fee or desk charge. The producer sees what lands in their pay; the agency sees what is left to cover staff, rent and systems. Both are right, and both should work from the same numbers. Take premium and carrier rates from the commission statement and the split and fees from the compensation plan. The agent commission split calculator gives gross commission, the agent and agency shares, the agent's net after fees and the effective share of premium each side keeps. For a simple rate on a sale, the commission calculator does the one-line version. Review the split whenever a carrier changes its rates, because the agency share moves even when the plan does not.
6. Commission arrives after the work
Commission statements arrive after a policy is written, and renewal commission arrives after the renewal, sometimes a month or more later depending on the carrier and whether billing is direct or through the agency. Payroll, rent and producer draws do not wait. Some carriers also take back commission when a policy cancels early, which can turn a good month into a short one. Match statement dates to the policies they cover, and note any chargebacks separately. Add up a month of fixed costs from the accounts and the cash in the bank, then use the cash runway calculator to see how many months you could cover if statements slowed. The renewal commission calculator shows how much of next year's income is already in the book.
7. Review the book quarterly and act on the line that moved
None of these figures is useful once. Pick a date each quarter, after the last carrier statements have arrived, and update policy counts, losses, new business, revenue, compensation and acquisition spend. Run the policy retention rate calculator first, by line of business if your system can split it, then look at whichever number changed most since last quarter. Falling retention in one line points to service or pricing at renewal. A rising compensation ratio points to the pay plan or to producers carrying too small a book. A higher cost per policy points to a lead source. Fix one thing, then look again next quarter. If you want the whole review in one place, the Insurance Agency Numbers Workbook on the kits page keeps these figures together so the quarterly check is quicker. The revenue per producer calculator is the second number to check.
The mistakes that cost the most
- Counting retention differently each time. A change in how you count looks like a change in the book. Fix the method and keep it.
- Celebrating new business while the book shrinks. New policies that replace lost ones are not growth. Check net growth, not just policies written.
- Treating producer time as free. Quoting hours cost money even on commission pay. Include them in the cost per policy.
- Planning spending from policies written. Commission arrives later and can be taken back. Plan from statements received and the cash in the bank.