| ← Back to Cover Page | ||||||||
| Executive Summary Dashboard | ||||||||
| Key pricing metrics and model outputs at a glance | ||||||||
| Combined Ratio | Return on Equity | Indicated Rate Change | ||||||
| Target: | 98.0% | Target: | 4.6% | Direction: | +2.5% | |||
| 97.0% | FAIL | 10.0% | FAIL | Increase | ||||
| Expected Loss Ratio | UW Expense Ratio | Operating Profit (Pre-Tax) | ||||||
| Industry: | 62.0% | Fixed / Variable: | 26.5% | After-Tax: | $2,915,270 | |||
| 60.0% | Above Industry | 6.3% | 27.2% | $2,303,063 | ||||
| Pricing Summary by Risk Class | ||||||||
| Risk Class | Relativity | Adj Loss Ratio | Gross Premium | Policy Count | Total Premium | |||
| Class 1 - Preferred | 0.75 | 42.6% | $3,713 | 4,200 | $15,595,317 | |||
| Class 2 - Standard | 1.00 | 56.8% | $4,951 | 5,400 | $26,734,830 | |||
| Class 3 - Moderate | 1.25 | 71.0% | $6,189 | 3,000 | $18,565,854 | |||
| Class 4 - Substandard | 1.55 | 88.1% | $7,674 | 1,650 | $12,661,912 | |||
| Class 5 - High Risk | 2.00 | 113.7% | $9,902 | 750 | $7,426,342 | |||
| Total / Weighted Avg | 1.09 | 62.0% | $5,399 | 15,000 | $80,984,255 | |||
| Key Model Parameters | ||||||||
| Parameter | Value | Parameter | Value | |||||
| Experience Period | 5 Years | Target Profit Margin | 5.0% | |||||
| Credibility Weight (Z) | 0.8 | Target ROE | 10.0% | |||||
| Loss Trend Factor | 2.5% | Tax Rate | 21.0% | |||||
| Loss Dev Tail Factor | 1.03 | Premium-to-Surplus Ratio | 1.8x | |||||
| Investment Income Rate | 4.0% | CAT + Large Loss Loading | 2.5% | |||||
| Permissible Loss Ratio | 69.7% | Total Policies | 15,000 | |||||
| Note: This dashboard pulls all values dynamically from model sheets. Change assumptions to see real-time impact. | ||||||||