Workers' Compensation Ratemaking and Reserving from a Real Schedule P Triangle
Develop a real Allstate Ins Co Grp workers' compensation paid-loss triangle to ultimate via the chain-ladder method, then use the resulting loss ratios to indicate a rate change.
Background
You are the pricing/reserving actuary reviewing Allstate Ins Co Grp's countrywide workers' compensation experience, pulled from the CAS Loss Reserve Database (NAIC Schedule P, accident years 1988–1997, net of reinsurance, values in $000s). Your task mirrors a classic Exam 5 exercise: complete the paid-loss triangle to ultimate using the volume-weighted (chain-ladder) method, quantify IBNR reserves, and use the resulting loss ratios to indicate a rate level change.
Paid loss triangle ($000s)
Corresponding net earned premium by accident year (394,742; 1989: 280,320; 1991: 252,698; 1993: 174,381; 1995: 93,294; 1997: $7,651 (a partial, thin year of business).
Volume-weighted age-to-age factors
Computing each age-to-age (link ratio) factor as over accident years with data at both ages and gives:
| Age | 1→2 | 2→3 | 3→4 | 4→5 | 5→6 | 6→7 | 7→8 | 8→9 | 9→10 |
|---|---|---|---|---|---|---|---|---|---|
| 2.2230 | 1.3377 | 1.1584 | 1.0927 | 1.0586 | 1.0455 | 1.0314 | 1.0361 | 1.0109 |
Chaining these forward (assuming the triangle is fully developed by age 10, i.e. the tail factor beyond age 10 is 1.000) gives cumulative development factors (CDFs) to ultimate from each age:
| Age | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| CDF to ult | 4.5011 | 2.0248 | 1.5136 | 1.3066 | 1.1957 | 1.1295 | 1.0803 | 1.0474 | 1.0109 | 1.0000 |
Projected ultimate losses and IBNR
Applying each accident year's CDF (from its latest diagonal age) to its latest cumulative paid loss produces:
| AY | Latest paid ($000s) | CDF | Ultimate ($000s) | Reserve (IBNR + case, $000s) |
|---|---|---|---|---|
| 1988 | 325,322 | 1.0000 | 325,322 | 0 |
| 1989 | 273,873 | 1.0109 | 276,864 | 2,991 |
| 1990 | 256,788 | 1.0474 | 268,961 | 12,173 |
| 1991 | 239,195 | 1.0803 | 258,402 | 19,207 |
| 1992 | 159,496 | 1.1295 | 180,151 | 20,655 |
| 1993 | 87,215 | 1.1957 | 104,286 | 17,071 |
| 1994 | 91,077 | 1.3066 | 119,003 | 27,926 |
| 1995 | 87,311 | 1.5136 | 132,157 | 44,846 |
| 1996 | 44,916 | 2.0248 | 90,948 | 46,032 |
| 1997 | 691 | 4.5011 | 3,110 | 2,419 |
| Total | 1,565,884 | 1,759,204 | 193,320 |
Total indicated reserves (the sum of the last column) are **1,565.9M is projected to develop to $1,759.2M at ultimate.
Loss ratios and rate indication
Dividing each accident year's ultimate loss by its earned premium gives the ultimate loss ratio by year:
| AY | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 |
|---|---|---|---|---|---|---|---|---|---|---|
| ELR | 0.824 | 0.740 | 0.959 | 0.823 | 0.713 | 0.519 | 0.682 | 0.903 | 0.975 | 0.407 |
The premium-weighted ultimate loss ratio across all ten years is , i.e. 78.58%. Suppose the rate filing's permissible loss ratio (i.e., minus the expense-and-profit load) is 65%, reflecting a 35% combined expense ratio and target underwriting profit provision. The indicated rate change is
This straightforward comparison of experience loss ratio to permissible loss ratio is the core of the loss ratio method of ratemaking, one of the two classic methods (the other being the pure premium method) tested throughout CAS Exam 5.
Your task
Treat all figures above as given (do not recompute from scratch, though you should be able to reproduce any single cell if asked). Answer the questions below about the chain-ladder mechanics, the reserve estimate, and the rate indication.
Part A — Multiple choice (6 × 1 point)
The volume-weighted age-to-age factor from age 1 to age 2 is computed as 2.2230. Which formula correctly describes how this is derived from the triangle?
Accident year 1997 has only 1 month/age of paid data (7,651k), and gets a CDF to ultimate of 4.5011, the largest of any year. What is the primary actuarial concern with this AY's projected ultimate of $3.11 million?
Total reserves of $193.3 million represent the difference between which two quantities?
The indicated rate change is . Which combination of inputs directly drives this figure?
Why does the CDF-to-ultimate strictly decrease from age 1 (4.5011) to age 10 (1.0000)?
Suppose you learned that AY 1990's reported paid loss at age 8 (256,788) reflected an unusually large single claim settlement not expected to recur. What is the most appropriate first response for the reserving actuary, consistent with CAS Exam 5 principles?
Part B — Written response
Using the age-to-age factors given, show the calculation that produces AY 1996's ultimate loss of 44,916 (thousands) at age 2, and explain in words why applying a single CDF is equivalent to applying the individual factors sequentially.
The individual accident-year loss ratios range from 40.7% (1997) to 97.5% (1996), yet the rate indication uses a single premium-weighted average of 78.58%. Discuss (a) why an actuary would not simply use the single most recent year's loss ratio for ratemaking, and (b) one adjustment (e.g., trend, on-level premium) a real filing would additionally need before using multi-year historical loss ratios that this simplified exercise has omitted.