Excel for Insurance Agents & Brokers: Premiums, Commissions, Renewals & Book of Business
20 hands-on labs for agents, brokers and account managers of a small independent agency: policy register cleanup, premium by line, new vs renewal commission, renewal calendar, retention, quote-to-bind, average premium, cross-sell, producer splits, book growth, loss ratio, a book dashboard, renewal rate changes, quote comparison, payment plans, mid-term pro-rata changes, coverage reviews, claims follow-up, client touchpoints and a renewal-season dashboard.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course gives insurance agents, brokers and account managers 20 interactive Excel labs built on the policy register of a fictional independent agency. You clean names and line codes, total premium by line with SUMIF and SUMIFS, look up new and renewal commission rates, build a renewal calendar, measure retention, quote-to-bind and cross-sell, split commission with producers, roll the book forward and check loss ratios. Then you compare expiring and renewal premiums, pick the cheapest quote that meets a client’s needs with MINIFS, price payment plans and mid-term changes pro rata, review home coverage against rebuild estimates, age open claims with COUNTIFS, track client contacts with MAXIFS and finish with a renewal-season dashboard and chart. Every cell is checked instantly.
Lessons
- Policy Register Cleanup: Clean Names, Line Codes and CountsFree
- Premium by Line of Business with SUMIF and SUMIFS Locked
- New vs Renewal Commission from a Rate Table Locked
- Renewal Calendar: Days to Renewal and Call Flags Locked
- Retention Rate: Renewed vs Lost Policies Locked
- Quote-to-Bind Conversion per Producer Locked
- Average Premium per Policy and per Client Locked
- Cross-Sell Ratio: Policies per Client and Mono-Line Clients Locked
- Commission Split with Producers: New and Renewal Rates Locked
- Monthly Book-of-Business Growth (Chart) Locked
- Simple Loss Ratio per Client with a Highlight Locked
- Mid-Course Dashboard: Book by Line with a Chart Locked
- Renewal Rate Changes: Expiring vs Renewal Premium, % Change and a Re-Market List Locked
- Quote Comparison: Five Carriers, the Client's Minimum Needs and the Cheapest Qualifying Quote Locked
- Payment Plans: Instalment Amounts, Fees per Instalment and the Extra Cost of Paying Monthly Locked
- Mid-Term Changes: Days Remaining, Pro-Rata Premium and Cancellation Refunds Locked
- Coverage Review: Insured Amount vs Rebuild Estimate, Gaps in Dollars and an Underinsured Flag Locked
- Claims Follow-Up: Days Open, Aging Buckets for Open Claims and the Average Time to Close Locked
- Client Touchpoints: Contacts per Client, Last Contact with MAXIFS and the Reach-Out List Locked
- Final Project: The Renewal Season Dashboard – Premium per Month, Expected Commission, Premium at Risk and a Chart Locked
Learner reviews
Be the first to review this course.