Actuarium

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.

Mack model
Reserve ranges & risk margins
Excess-of-loss pricing
Retention & risk appetite

Background

You are the reserving and reinsurance actuary for a workers' compensation writer. Two questions land on your desk in the same week:

  1. 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.
  2. Underwriting is quoting a large manufacturing account and wants to know whether the company should keep a 250,000or250,000 or 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 \ Age12345678910
198822,19060,83485,104100,151108,812114,967118,790121,558123,492125,049
198926,54277,798106,407122,422133,359138,599143,029145,712147,358
199032,977100,494134,886157,758168,991178,065182,787187,760
199138,604114,428157,103181,322197,411208,804213,396
199242,466125,820164,776189,045204,377213,904
199346,447116,764154,897179,419193,676
199441,368100,344132,021151,081
199535,71983,216111,268
199628,74666,033
199725,265

Part 1 — Chain ladder with Mack standard errors

Volume-weighted age-to-age factors are

12–2424–3636–4848–6060–7272–8484–9696–108108–120
2.68441.34211.15611.08231.05091.02741.02341.01341.0126

with no tail beyond 120 months. Projecting each accident year to ultimate gives a **total paid reserve of 304,882K,ofwhichaccidentyear1997alonecontributes304,882K**, of which accident year 1997 alone contributes 103,885K.

Mack's distribution-free model treats the chain ladder as a sequence of weighted regressions through the origin, Ci,k+1=fkCi,k+σkCi,kεi,kC_{i,k+1} = f_k C_{i,k} + \sigma_k \sqrt{C_{i,k}}\,\varepsilon_{i,k}, and estimates the variance parameters as

σ^k2=1nk1i=1nkCi,k(Ci,k+1Ci,kf^k)2.\hat\sigma_k^2 = \frac{1}{n-k-1}\sum_{i=1}^{n-k} C_{i,k}\left(\frac{C_{i,k+1}}{C_{i,k}} - \hat f_k\right)^2 .

The fitted σ^k2\hat\sigma_k^2 fall from 3,158.9 at 12–24 months to 1.41 at the last two development periods, and the mean-squared-error formula

mse^(R^i)=C^i,n2k=n+1in1σ^k2f^k2(1C^i,k+1j=1nkCj,k)\widehat{\mathrm{mse}}(\hat R_i) = \hat C_{i,n}^2 \sum_{k=n+1-i}^{n-1} \frac{\hat\sigma_k^2}{\hat f_k^2}\left(\frac{1}{\hat C_{i,k}} + \frac{1}{\sum_{j=1}^{n-k} C_{j,k}}\right)

yields the following prediction standard errors by accident year (process plus parameter error):

AYReserve ($000)Std. error ($000)CV
19904,9141,07021.8%
199216,9071,96911.6%
199434,3342,5617.5%
199659,7134,3137.2%
1997103,88518,21517.5%
Total304,882≈19,4766.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 304,882KandCV6.4304,882K and CV 6.4% gives \sigma^2=\ln(1+0.064^2)=0.00408,sothe75thpercentileisabout, so the **75th percentile is about 317.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 μ=9.2\mu = 9.2 and σ=1.6\sigma = 1.6 (mean severity 35,596;median35,596; median 9,897). The limited expected value of a lognormal at limit xx is

LEV(x)=eμ+σ2/2Φ ⁣(lnxμσ2σ)+x[1Φ ⁣(lnxμσ)],\mathrm{LEV}(x) = e^{\mu+\sigma^2/2}\,\Phi\!\left(\frac{\ln x - \mu - \sigma^2}{\sigma}\right) + x\left[1-\Phi\!\left(\frac{\ln x-\mu}{\sigma}\right)\right],

which gives

Limit xxLEV(x)P(claim > x)Expected claims > x per year
$250,000$29,0152.18%3.9
$500,000$32,1320.71%1.3
$1,000,000$34,0150.24%0.4

Expected annual losses in the two candidate layers are therefore

LayerExpected ceded per claimExpected ceded per year
750Kxs750K xs 250K34,015 − 29,015 = $5,000180 × 5,000 ≈ $900K
500Kxs500K xs 500K34,015 − 32,132 = $1,883180 × 1,883 ≈ $339K

The reinsurer prices either layer at expected ceded loss × 1.30 (a 30% load for expenses, risk and profit): about **1,170Kforthe1,170K** for the 250K retention programme and **441Kforthe441K** for the 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)

Q1
Mack model

Under the Mack model, which statement correctly describes the three assumptions that justify the chain-ladder estimator?

Q2
Mack model

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?

Q3
Reserve ranges & risk margins

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?

Q4
Reserve ranges & risk margins

Which statement about the total-reserve standard error of ≈$19,476K is correct?

Q5
Excess-of-loss pricing

Using the LEV table, the expected annual ceded loss in the 250Kxs250K xs 250K sub-layer (i.e. between the two candidate retentions) is closest to:

Q6
Retention & risk appetite

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

W1
Reserve ranges & risk margins
8 points

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.

0 words
W2
Excess-of-loss pricing
8 points

Underwriting proposes a 'compromise': retain 500Kperoccurrencebutbuyanaggregatestoplossthatreimbursestotalretainedlossesabove500K per occurrence but buy an **aggregate stop-loss** that reimburses total retained losses above 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.

0 words
Answer every question to submit.
Ask the tutor