Tutorials › CAS Exam 5 - Basic Ratemaking and Estimated Claim Liabilities › Sparse Data and Immature Accident Years

CAS Exam 5 · Chain Ladder Estimation · Tutorial 688 of 989

Sparse Data and Immature Accident Years

Assess the stability of chain ladder projections by examining factor sample size, accident-year maturity, and the sensitivity of projected claims to selected development factors.

Intermediate 11 min read

What You'll Learn

  • Define the observations available for estimating each age-to-age factor
  • Explain why few link ratios can make a selected factor sensitive to individual observations
  • Measure the effect of changing one selected factor on projected cumulative claims
  • Identify which accident years are affected by a factor selection
  • Distinguish projection sensitivity from a statistical measure of estimation uncertainty

Why Sparse Data and Immaturity Matter

A chain ladder projection depends on selected age-to-age development factors. When few historical link ratios are available for a factor, one observation can have substantial influence on its selection. When an accident year is immature, its projected ultimate depends on more selected factors, so more factor choices enter its estimate. These are related concerns, but they are not the same: the number of observations informs how much evidence supports a factor, while maturity determines which factors enter a particular projection.

This distinction is useful when reviewing a triangle. A factor based on only one observed link ratio may be uncertain even if it applies to only the newest accident year. Conversely, a factor based on many observations may still have a material effect on several accident-year estimates if those years have not yet reached the corresponding development age.

Definition: Let \(C_{i,j}\) denote the cumulative loss for accident year \(i\) at development age \(j\). The observed link ratio from age \(j\) to age \(j+1\) for accident year \(i\) is \(C_{i,j+1}/C_{i,j}\), when both values are observed and the denominator is nonzero. Let \(f_j\) be the selected age-to-age factor for that transition. The number of usable observed link ratios informing \(f_j\) is its observation count. A projected cumulative value is immature when one or more subsequent development factors must still be applied to estimate a later age or ultimate.

In an ordinary run-off triangle, newer accident years have fewer observed development ages. Thus fewer link ratios are usually available for later transitions than for early transitions. The actual count must be read from the data: irregular data, exclusions, or missing observations can change it. A factor calculated from one ratio has no cross-accident-year replication in that dataset, while a factor calculated from several ratios can be compared across those observations. Neither count alone establishes whether the selected factor is appropriate.

How Factor Choices Propagate

For an accident year observed through development age \(j\), the chain ladder projection to a later age \(k\) is the observed cumulative value multiplied by each selected factor for the intervening transitions. If \(k\) is the ultimate age, the same product projects ultimate losses.

$$ \widehat{C}_{i,k} = C_{i,j}\prod_{r=j}^{k-1} f_r $$

This formula makes the maturity connection explicit. An accident year observed at age \(j\) is affected by every factor \(f_r\) from \(j\) through \(k-1\), but not by a factor for a transition it has already passed. A selection change to \(f_r\) therefore affects only accident years that are still before that transition. Among those years, the factor acts multiplicatively on the projected cumulative value.

A useful sensitivity calculation changes one selected factor while holding all other factors fixed. If \(f_r\) changes to \(f_r^{*}\), and the accident year still needs that transition, then:

$$ \frac{\widehat{C}_{i,k}^{*}}{\widehat{C}_{i,k}} = \frac{f_r^{*}}{f_r}, \qquad \widehat{C}_{i,k}^{*}-\widehat{C}_{i,k} = \widehat{C}_{i,k} \left(\frac{f_r^{*}}{f_r}-1\right) $$

The result follows by writing the original projection as \(C_{i,j} f_r Q\), where \(Q\) is the product of all other selected factors. Under the revised selection, the projection is \(C_{i,j} f_r^{*} Q\). Dividing the revised projection by the original cancels both \(C_{i,j}\) and \(Q\), leaving \(f_r^{*}/f_r\). This is a relative change: a given proportional change in a factor produces that same proportional change in every affected projection. The dollar or thousand-dollar change depends on the size of each projection.

This calculation is a sensitivity analysis, not a confidence interval or a probability statement. It shows the consequence of an alternative factor selection while holding the rest of the chain ladder calculation fixed. It does not, by itself, measure the probability that either selection is correct.

Worked Example: Counting Sparse Link Ratios and Changing a Late Factor

A hypothetical cumulative loss triangle is reported in thousands of dollars. Development ages are 12, 24, 36, and 48 months:

Accident year12 months24 months36 months48 months
A12182122
B91417
C711
D10

Use volume-weighted link ratios for the observed transitions. Project accident year D from 12 months to 48 months. Then replace the 36-to-48-month selection with 1.10 and measure the change. Assume all cumulative values are positive and that the selected factors are applied multiplicatively.

Method and factor counts. The 12-to-24-month transition has three observed ratios, from accident years A, B, and C. Its volume-weighted factor is the sum of the 24-month values divided by the sum of the corresponding 12-month values:

$$ f_{12\text{-}24} = \frac{18+14+11}{12+9+7} = \frac{43}{28} = 1.535714 $$

The 24-to-36-month transition has two observed ratios, from A and B:

$$ f_{24\text{-}36} = \frac{21+17}{18+14} = \frac{38}{32} = 1.187500 $$

The 36-to-48-month transition has one observed ratio, from A:

$$ f_{36\text{-}48} = \frac{22}{21} = 1.047619 $$

Base projection. Accident year D has only a 12-month cumulative value, so it needs all three factors. Its projection is:

$$ 10 \times 1.535714 \times 1.187500 \times 1.047619 = 19.105 $$

The projected 48-month cumulative loss is approximately $19.105 thousand. The first factor is supported by three ratios, the second by two, and the last by only one. For D, a revised selection of any of these factors affects the projection; the late factor is especially thinly supported here because its triangle contains just one usable ratio.

Sensitivity to the late-factor alternative. Replacing \(22/21\) with 1.10 multiplies the original projection by \(1.10/(22/21)=1.05\). The revised projection and change are:

$$ 19.105 \times 1.05 = 20.060, \qquad 20.060 - 19.105 = 0.955 $$

To three decimal places in thousands, the alternative is $20.060 thousand, an increase of $0.955 thousand. This is a 5% change, exactly matching the 5% proportional increase from \(22/21\) to 1.10. Common mistake avoided: changing the late factor and then applying the other factors again would double-count development. The factor ratio already gives the change in the fully projected amount.

Which Accident Years Are Most Sensitive?

Sensitivity has two useful dimensions. The first is which projections a factor can affect: a change to \(f_r\) applies only to accident years that have not yet reached age \(r+1\). The second is how much the projected amount changes: for a specified alternative factor, the proportional change is the same for each affected accident year, but larger projected amounts have larger absolute changes.

An immature accident year generally depends on more factors than a mature one. That creates more opportunities for selected-factor changes to affect its projection. It does not mean that every immature year is necessarily more sensitive to every individual factor: a year already past a transition is not affected by that transition at all. It is helpful to list each accident year’s remaining transitions before comparing alternative projections.

For a single factor change, percentage sensitivity is determined by the ratio of the alternative factor to the selected factor. For several changed factors, their ratios multiply. For example, if two applicable factors change from \(f_a\) and \(f_b\) to \(f_a^{*}\) and \(f_b^{*}\), the projected amount changes by the multiplier \((f_a^{*}/f_a)(f_b^{*}/f_b)\). A calculation that adds the two percentage changes is only an approximation when changes are small; the exact effect is multiplicative.

Worked Example: Comparing Early- and Late-Factor Sensitivity

A hypothetical portfolio has selected factors \(f_{12\text{-}24}=1.60\), \(f_{24\text{-}36}=1.25\), and \(f_{36\text{-}48}=1.08\). Accident year R has $100 thousand of cumulative loss at 12 months, while accident year S has $150 thousand at 36 months. Assume the factors are fixed except for the stated alternative, and project both years to 48 months.

Base projections. R needs all three factors:

$$ \widehat{C}_{R,48} = 100 \times 1.60 \times 1.25 \times 1.08 = 216.000 $$

S is already at 36 months, so it needs only the final factor:

$$ \widehat{C}_{S,48} = 150 \times 1.08 = 162.000 $$

Alternative A: revise the early factor. Increase \(f_{12\text{-}24}\) from 1.60 to 1.65. R still needs this transition, so its projection becomes:

$$ 216.000 \times \frac{1.65}{1.60} = 222.750, \qquad 222.750-216.000=6.750 $$

R’s projection increases by 3.125%. S has already passed the 12-to-24-month transition, so this change does not affect S.

Alternative B: revise the late factor. Increase \(f_{36\text{-}48}\) from 1.08 to 1.10. Both years still need this transition:

$$ \widehat{C}_{R,48}^{*} = 216.000 \times \frac{1.10}{1.08} = 220.000 $$
$$ \widehat{C}_{S,48}^{*} = 162.000 \times \frac{1.10}{1.08} = 165.000 $$

The increases are $4.000 thousand for R and $3.000 thousand for S, each a 1.8519% increase. The early-factor alternative has the larger effect on R in this example, while the late-factor alternative affects both years. These results show why sensitivity should be reported with both the affected years and the projected amounts. Common mistake avoided: assuming that the factor nearest ultimate is automatically the most important. Its impact depends on the alternative selected, the amount projected, and which years still require that transition.

How Sparse Observations Can Drive a Selection

An observation count is a diagnostic, not a selection rule. A small count means that the empirical evidence for a development factor comes from few accident years. A particular ratio may then have substantial influence, especially if the available observations differ materially. The ratio could reflect random fluctuation, a change in claim handling or settlement patterns, or another feature of the data. The count alone cannot identify the cause.

The following example compares plausible selections for a sparse transition. It illustrates why a projection can depend materially on selection judgment; it does not establish that one averaging method is always preferable. Any alternative should be considered in the context of the data and the assumptions underlying the chain ladder projection.

Worked Example: A Small Denominator and Alternative Selections

A hypothetical triangle has three observed 12-to-24-month transitions: $10 thousand develops to $12 thousand, $12 thousand develops to $15 thousand, and $5 thousand develops to $10 thousand. A newer accident year has $8 thousand at 12 months. For its remaining transitions, assume selected factors of 1.20 from 24 to 36 months and 1.05 from 36 months to ultimate. Compare the arithmetic mean and volume-weighted 12-to-24-month factors with the median of the three ratios. Treat amounts as thousands of dollars and hold the later factors fixed.

Calculate the observed ratios. They are \(12/10=1.20\), \(15/12=1.25\), and \(10/5=2.00\). There are three observations, but the 2.00 ratio comes from the smallest 12-month cumulative amount.

Calculate the alternatives. The arithmetic mean is:

$$ \frac{1.20+1.25+2.00}{3} = \frac{4.45}{3} = 1.483333 $$

The volume-weighted factor and the median are:

$$ f_{12\text{-}24,\mathrm{weighted}} = \frac{12+15+10}{10+12+5} = \frac{37}{27} = 1.370370, \qquad f_{12\text{-}24,\mathrm{median}}=1.25 $$

Project using each selection. The newer accident year needs all three factors. With the volume-weighted factor, its ultimate projection is:

$$ 8 \times \frac{37}{27} \times 1.20 \times 1.05 = 13.813 $$

With the median selection, the projection is:

$$ 8 \times 1.25 \times 1.20 \times 1.05 = 12.600 $$

The difference is \(13.813-12.600=1.213\) thousand, using amounts rounded to three decimal places. Before rounding, the relative difference compared with the median-based projection is approximately \(9.63\%\). The arithmetic-mean selection would produce \(8 \times 1.483333 \times 1.20 \times 1.05=14.952\) thousand. Thus the choice among these selections materially changes this immature year’s projection. The small denominator does not prove the 2.00 ratio should be excluded; it identifies an observation whose influence and context merit review. Common mistake avoided: treating three observations as equally informative without checking their sizes and the consequences of alternative selections.

Practical Review and Exam Traps

A disciplined review separates what can be calculated directly from what requires judgment. Observation counts and factor-change sensitivities are calculable from the triangle and selected factors. Whether an observed ratio is representative, whether a factor selection is reasonable, and whether a sensitivity warrants a different estimate require actuarial judgment and appropriate data context.

1
Count usable ratios for each transition.
Count observed links, not accident-year rows in the entire triangle. A row contributes to a transition only when both cumulative values needed for that ratio are observed and usable.
2
List each year’s remaining factors.
Start from its latest observed age and identify the transitions needed to reach the projection age. This determines which factor changes can affect that year.
3
State an alternative selection explicitly.
For each factor being tested, state its original and revised values. If multiple factors change, keep track of each factor ratio.
4
Calculate relative and absolute effects.
Use the ratio of alternative to selected factors for the exact relative effect, then apply it to each affected projection to obtain the absolute change.
5
Interpret the result without overstating it.
Describe the effect of the alternative assumptions. Do not label a sensitivity result a probability, confidence interval, or quantified estimation error unless a separate statistical model supports that interpretation.

Common exam traps include counting all accident years as evidence for every transition, applying a revised factor to years that have already reached that age, and reporting only an absolute change when the relative change is what the factor ratio determines directly. Another trap is inferring that a low observation count automatically requires a higher or lower factor. Sparse data signals limited empirical support; it does not determine the direction of a reasonable selection.

A clear chain ladder review therefore reports both the factor evidence and the projection consequence. State how many observed ratios inform a factor, which accident years still require it, and how an alternative changes their estimates. This approach is aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus and is also useful in professional reserve review.

Key takeaway: Sparse data concerns how much evidence supports a selected factor; immaturity concerns how many selected factors enter an accident year’s projection. Count the observations, identify the affected years, and quantify alternatives multiplicatively. Sensitivity demonstrates dependence on selections, not the probability that an estimate is wrong.

Check Your Understanding

For each problem, assume positive cumulative values and ordinary multiplicative chain ladder projections. Amounts are in thousands of dollars where stated.

  1. A hypothetical 12-to-24-month transition has observed links of $10 to $14, $20 to $30, and $25 to $30. Calculate the volume-weighted factor and state its observation count. (Answer: \(74/55=1.3455\), based on 3 observed ratios.)
  2. An accident year has $50 thousand at 12 months and remaining selected factors of 1.40, 1.20, and 1.10. Calculate its projected 48-month cumulative value. (Answer: $92.400 thousand.)
  3. An accident year has $80 thousand at 24 months and remaining factors of 1.15 and 1.04. If the first remaining factor changes from 1.15 to 1.30, calculate the revised projection and the absolute increase. (Answer: revised projection $108.160 thousand; increase $12.480 thousand.)
  4. A triangle has four observed ratios for 12-to-24 months, two for 24-to-36 months, and one for 36-to-48 months. An accident year is observed at 24 months. Which factor transitions can affect its projection to 48 months, and how many observed ratios inform each? (Answer: the 24-to-36-month factor, informed by 2 ratios, and the 36-to-48-month factor, informed by 1 ratio.)
  5. A projected ultimate is $240 thousand and includes a selected factor of 1.20. Holding other factors fixed, an alternative selection is 1.26. Calculate the revised ultimate and increase, and state whether this change affects a year already observed at the transition’s later age. (Answer: revised ultimate $252 thousand; increase $12 thousand; no, a year already at the later age does not require that transition.)
Clinical Biostats