INSU 4395 INSURANCE DATA ANALYSIS APPLICATION PROJECT #4 PAGE 1 OF 2 Session 4: Homeowner Segmentation Decision Recommendation Enter the results of your spreadsheet analysis in the highlighted spaces With 20% Overall Rate Increase (36 points) Segments 1 2 3 4 5 Overall Loss Ratio Loss Ratios (current) 30% Rate Increase 20% 45% 70% 105% 20% 20% 20% 120% 20% Retention % Loss Ratio after increase Current With 20% Increase % Difference Total Policies Total Premium Loss Ratio Losses Company $ With Segmented Rate Increase (36 points) Segments 1 2 3 4 5 Overall Loss Ratio Loss Ratios (current) 30% 45% Rate Increase 5% 70% 7% 10% 105% 120% 20% 27% Retention % Loss Ratio after increase Current With Seg Increase % Difference Total Policies Total Premium Loss Ratio Losses Company $