Tabellab

Renewal Rate Changes: Expiring vs Renewal Premium, % Change and a Re-Market List

Lesson 13 of 20 Lab 🔒 Locked

Lessons in this course

  1. Policy Register Cleanup: Clean Names, Line Codes and CountsLabFree
  2. Premium by Line of Business with SUMIF and SUMIFSLab Locked
  3. New vs Renewal Commission from a Rate TableLab Locked
  4. Renewal Calendar: Days to Renewal and Call FlagsLab Locked
  5. Retention Rate: Renewed vs Lost PoliciesLab Locked
  6. Quote-to-Bind Conversion per ProducerLab Locked
  7. Average Premium per Policy and per ClientLab Locked
  8. Cross-Sell Ratio: Policies per Client and Mono-Line ClientsLab Locked
  9. Commission Split with Producers: New and Renewal RatesLab Locked
  10. Monthly Book-of-Business Growth (Chart)Lab Locked
  11. Simple Loss Ratio per Client with a HighlightLab Locked
  12. Mid-Course Dashboard: Book by Line with a ChartLab Locked
  13. Renewal Rate Changes: Expiring vs Renewal Premium, % Change and a Re-Market ListLab Locked
  14. Quote Comparison: Five Carriers, the Client's Minimum Needs and the Cheapest Qualifying QuoteLab Locked
  15. Payment Plans: Instalment Amounts, Fees per Instalment and the Extra Cost of Paying MonthlyLab Locked
  16. Mid-Term Changes: Days Remaining, Pro-Rata Premium and Cancellation RefundsLab Locked
  17. Coverage Review: Insured Amount vs Rebuild Estimate, Gaps in Dollars and an Underinsured FlagLab Locked
  18. Claims Follow-Up: Days Open, Aging Buckets for Open Claims and the Average Time to CloseLab Locked
  19. Client Touchpoints: Contacts per Client, Last Contact with MAXIFS and the Reach-Out ListLab Locked
  20. Final Project: The Renewal Season Dashboard – Premium per Month, Expected Commission, Premium at Risk and a ChartLab Locked