Commission Split with Producers: New and Renewal Rates
Lessons in this course
- 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