Reserve Variability (Mack) and an Excess-of-Loss Retention Decision
Quantify reserve uncertainty on a real workers' compensation paid triangle with the Mack model, set a risk margin, and choose a per-occurrence retention for a large account using limited expected values.
Background
You are the reserving and reinsurance actuary for a workers' compensation writer. Two questions land on your desk in the same week:
- The appointed actuary wants a reserve range and a 75th-percentile risk margin for the paid workers' compensation triangle below, rather than a single chain-ladder point estimate.
- Underwriting is quoting a large manufacturing account and wants to know whether the company should keep a 500,000 per-occurrence retention and buy excess-of-loss cover above it up to $1,000,000.
Data — cumulative paid losses ($000)
Real cumulative paid workers' compensation losses for one large national carrier group, accident years 1988–1997, taken from the CAS Loss Reserve Database (NAIC Schedule P, Part 3):
| AY \ Age | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1988 | 22,190 | 60,834 | 85,104 | 100,151 | 108,812 | 114,967 | 118,790 | 121,558 | 123,492 | 125,049 |
| 1989 | 26,542 | 77,798 | 106,407 | 122,422 | 133,359 | 138,599 | 143,029 | 145,712 | 147,358 | |
| 1990 | 32,977 | 100,494 | 134,886 | 157,758 | 168,991 | 178,065 | 182,787 | 187,760 | ||
| 1991 | 38,604 | 114,428 | 157,103 | 181,322 | 197,411 | 208,804 | 213,396 | |||
| 1992 | 42,466 | 125,820 | 164,776 | 189,045 | 204,377 | 213,904 | ||||
| 1993 | 46,447 | 116,764 | 154,897 | 179,419 | 193,676 | |||||
| 1994 | 41,368 | 100,344 | 132,021 | 151,081 | ||||||
| 1995 | 35,719 | 83,216 | 111,268 | |||||||
| 1996 | 28,746 | 66,033 | ||||||||
| 1997 | 25,265 |
Part 1 — Chain ladder with Mack standard errors
Volume-weighted age-to-age factors are
| 12–24 | 24–36 | 36–48 | 48–60 | 60–72 | 72–84 | 84–96 | 96–108 | 108–120 |
|---|---|---|---|---|---|---|---|---|
| 2.6844 | 1.3421 | 1.1561 | 1.0823 | 1.0509 | 1.0274 | 1.0234 | 1.0134 | 1.0126 |
with no tail beyond 120 months. Projecting each accident year to ultimate gives a **total paid reserve of 103,885K.
Mack's distribution-free model treats the chain ladder as a sequence of weighted regressions through the origin, , and estimates the variance parameters as
The fitted fall from 3,158.9 at 12–24 months to 1.41 at the last two development periods, and the mean-squared-error formula
yields the following prediction standard errors by accident year (process plus parameter error):
| AY | Reserve ($000) | Std. error ($000) | CV |
|---|---|---|---|
| 1990 | 4,914 | 1,070 | 21.8% |
| 1992 | 16,907 | 1,969 | 11.6% |
| 1994 | 34,334 | 2,561 | 7.5% |
| 1996 | 59,713 | 4,313 | 7.2% |
| 1997 | 103,885 | 18,215 | 17.5% |
| Total | 304,882 | ≈19,476 | 6.4% |
The total standard error shown is the square root of the sum of the individual accident-year MSEs; the full Mack total also adds a positive covariance term for the shared factor estimates, so 6.4% is a slight understatement of the true coefficient of variation.
Fitting a lognormal to the total reserve with mean \sigma^2=\ln(1+0.064^2)=0.00408317.7M** and the 99.5th percentile about $358.7M.
Part 2 — Excess-of-loss retention for a large account
The account is expected to generate 180 claims per year. Its per-occurrence severity is modelled as lognormal with and (mean severity 9,897). The limited expected value of a lognormal at limit is
which gives
| Limit | LEV(x) | P(claim > x) | Expected claims > x per year |
|---|---|---|---|
| $250,000 | $29,015 | 2.18% | 3.9 |
| $500,000 | $32,132 | 0.71% | 1.3 |
| $1,000,000 | $34,015 | 0.24% | 0.4 |
Expected annual losses in the two candidate layers are therefore
| Layer | Expected ceded per claim | Expected ceded per year |
|---|---|---|
| 250K | 34,015 − 29,015 = $5,000 | 180 × 5,000 ≈ $900K |
| 500K | 34,015 − 32,132 = $1,883 | 180 × 1,883 ≈ $339K |
The reinsurer prices either layer at expected ceded loss × 1.30 (a 30% load for expenses, risk and profit): about **250K retention programme and **500K retention programme. The company's stated risk appetite is that no single occurrence may consume more than 1% of surplus, and surplus is $45 million.
Your task
Answer the questions below using the figures above as given. Show formulas where asked; numerical answers within rounding of the tables are acceptable.
Part A — Multiple choice (6 × 1 point)
Under the Mack model, which statement correctly describes the three assumptions that justify the chain-ladder estimator?
Using the table, the 1997 accident year's coefficient of variation (17.5%) is far higher than the 1994 year's (7.5%). Which is the best explanation?
The appointed actuary sets a risk margin equal to the 75th percentile of the lognormal total-reserve distribution minus the mean. Approximately what is the margin?
Which statement about the total-reserve standard error of ≈$19,476K is correct?
Using the LEV table, the expected annual ceded loss in the 250K sub-layer (i.e. between the two candidate retentions) is closest to:
Given surplus of $45M and a risk appetite that a single occurrence may not consume more than 1% of surplus, which retention is consistent with the appetite, and what is the annual expected cost of that consistency relative to the higher retention?
Part B — Written response
The CFO asks why the reserve range is so narrow (CV ≈ 6%) when 'everyone knows workers' compensation is long-tailed'. Write a short memo (bullet points acceptable) explaining (a) what the Mack standard error does and does not capture, (b) two specific sources of uncertainty in this triangle that Mack ignores, and (c) how you would supplement the Mack range before signing an opinion.
Underwriting proposes a 'compromise': retain 6.5M for the year. (a) Using the figures given, estimate the expected retained loss under a $500K retention and comment on how likely the stop-loss is to attach. (b) Explain qualitatively which risk the stop-loss addresses that the per-occurrence cover does not, and whether it satisfies the board's risk appetite. (c) State one pricing consideration for the reinsurer that differs between per-occurrence and aggregate covers.