Review the Exhibit
P&C Insurer: Premium Written vs. Loss Ratio by Product Line (2020–2023)
A property and casualty insurance company is conducting a strategic portfolio review. The CFO and Chief Underwriting Officer are concerned that the current product mix may be creating hidden profitability risk despite headline premium growth.
Chart Notes
A combination graph with grouped bars (premium written, left axis, $M) and lines (loss ratio, %, right axis) for each of three product lines — Auto (dark blue bars, solid line), Home (medium blue bars, dashed line), and Commercial (light blue bars, dotted line) — plotted across 4 years (2020–2023). Auto bars are tallest and growing, but its loss ratio line rises steeply from 68% to 82%. Home bars are flat and short, loss ratio line nearly flat at 58–62%. Commercial bars grow from smallest to second-largest, while its loss ratio line falls from 52% to 44%. By 2023, Auto's loss ratio line is well above the 80% threshold typically considered unprofitable in P&C insurance.
Your Prompt
“Review the exhibit and walk me through what you see, what it means, and what you would do next.”
- → Start with the headline finding
- → Support with specific data points
- → Explain what it means for the business
- → Suggest what to analyze next