Tutorials › Exam ASTAM - Advanced Short-Term Actuarial Mathematics › Backtesting Projections Against Mature Accident Periods

Exam ASTAM · Development Data and Chain Ladder · Tutorial 706 of 979

Backtesting Projections Against Mature Accident Periods

Use later-matured losses to measure historical chain-ladder projection accuracy and diagnose what the resulting errors do—and do not—show.

Beginner 10 min read

What You'll Learn

  • Reconstruct an ultimate projection using the data and selected development factors available at its original valuation date
  • Define signed, absolute and percentage projection errors against a subsequently observed mature ultimate
  • Calculate and interpret bias, MAE, MAPE and weighted absolute percentage error
  • Compare historical projections fairly by aligning accident periods, maturity, valuation dates and loss bases
  • Recognize limitations such as immature actuals, zero denominators and repeated valuation snapshots

Why Backtest Chain-Ladder Projections?

A chain-ladder ultimate is a projection made using information available at a particular valuation date. Backtesting asks a later question: how close was that archived projection to the loss amount eventually observed for the same accident period? The comparison provides evidence about historical performance; it does not establish that a projection method will be accurate in every future period.

A valid test preserves the information boundary. Reconstruct or retrieve each projection using only the triangle, development factors and tail selection available at its original valuation date. Compare it with a later observed ultimate on a consistent basis. Substituting factors estimated with later data would introduce information that was unavailable when the projection was made and would make the backtest misleading.

Definition: For accident period \(i\), let \(\hat U_i^{(t)}\) be the ultimate projected at valuation date \(t\), and let \(U_i^*\) be the subsequently observed ultimate on the same loss basis. The signed projection error is \(e_i^{(t)}=\hat U_i^{(t)}-U_i^*\). A positive error means the projection was high; a negative error means it was low.

Set Up a Comparable Test

For a standard cumulative chain-ladder projection, write \(C_{i,j}\) for cumulative losses for accident period \(i\) at development age \(j\), and \(F_j\) for the selected cumulative development factor from that age to ultimate, including any selected tail factor. The projection at the original valuation is

$$ \hat U_i^{(t)}=C_{i,j}F_j. $$

This form assumes that the cumulative amount and development factors are defined on a consistent basis and that the selected factors are appropriate for the data being projected. In a backtest, use the factors selected at valuation date \(t\), not factors recalculated using later development. The later observed \(U_i^*\) should be sufficiently mature for the purpose of the test. If it is still developing materially, it is an interim comparison amount, not a settled measure of the projection’s accuracy.

The error identity explains what the comparison measures. If \(U_i^*=C_{i,j}+R_i\), where \(R_i\) is the subsequently observed development after age \(j\), then

$$ e_i^{(t)} =C_{i,j}F_j-(C_{i,j}+R_i) =C_{i,j}(F_j-1)-R_i. $$

Thus, the signed error compares the future development anticipated by the factor with the future development later observed. It is not an error in the cumulative amount already recorded at the valuation date.

1
Freeze the original information.
Record the accident periods, valuation date, cumulative losses, selected factors and tail assumption used for each archived projection.
2
Choose the later comparison amount.
Use subsequently observed losses for the same accident periods and the same definition of loss. State the later valuation date and whether the amounts are considered mature.
3
Calculate errors consistently.
For each period, subtract the later observed ultimate from the archived projection, then calculate the chosen summary measures.
4
Interpret the test in context.
Check for patterns by accident period, valuation date or development age, and consider whether the tested periods are comparable.

Measures of Projection Accuracy

For \(n\) tested accident periods, the mean signed error measures average direction, while the mean absolute error measures average error size in dollars. Mean absolute percentage error expresses each absolute error relative to that period’s observed ultimate. These measures answer different questions.

$$ \text{Mean signed error} =\frac{1}{n}\sum_{i=1}^{n}e_i^{(t)},\qquad \text{MAE} =\frac{1}{n}\sum_{i=1}^{n}|e_i^{(t)}|. $$
$$ \text{APE}_i =\frac{|e_i^{(t)}|}{U_i^*}\times100\%,\qquad \text{MAPE} =\frac{1}{n}\sum_{i=1}^{n}\text{APE}_i. $$

The mean signed error can be close to zero even when individual errors are large, because overprojections and underprojections can offset. MAE cannot cancel in that way. MAPE gives equal weight to each period’s percentage error, so a small-dollar accident period can have as much influence on MAPE as a large one. When all \(U_i^*\) are positive, a size-weighted alternative is weighted absolute percentage error, \(\sum_i |e_i^{(t)}|/\sum_i U_i^*\times100\%\). It gives more weight to periods with larger observed ultimates.

MAPE is undefined for a period with \(U_i^*=0\), and can be unstable when the observed ultimate is very small. Do not silently divide by zero or remove such periods without explaining the treatment. In those cases, report dollar errors or a suitable aggregate measure and describe the limitation.

Worked Example: Assessing Three Archived Ultimates

A hypothetical insurer archived three 12-month chain-ladder projections. At that valuation, the cumulative losses and selected 12-month-to-ultimate factors were: period A, $400,000 and 2.00; period B, $500,000 and 2.00; period C, $600,000 and 2.00. A later valuation is judged sufficiently mature for this exercise, and the corresponding observed ultimates are $760,000, $1,100,000 and $1,140,000. Calculate signed errors, mean signed error, MAE and MAPE. Amounts are in dollars.

Method. For each period, multiply the original cumulative loss by the factor selected at the original valuation. Then calculate projection minus observed ultimate.

Period A: \(\hat U_A=400{,}000(2.00)=\$800{,}000\). Its signed error is \(800{,}000-760{,}000=+\$40{,}000\), and its absolute error is $40,000.

Period B: \(\hat U_B=500{,}000(2.00)=\$1{,}000{,}000\). Its signed error is \(1{,}000{,}000-1{,}100{,}000=-\$100{,}000\), and its absolute error is $100,000.

Period C: \(\hat U_C=600{,}000(2.00)=\$1{,}200{,}000\). Its signed error is \(1{,}200{,}000-1{,}140{,}000=+\$60{,}000\), and its absolute error is $60,000.

The mean signed error is \((40{,}000-100{,}000+60{,}000)/3=\$0\). The MAE is \((40{,}000+100{,}000+60{,}000)/3=\$66{,}666.67\), rounded to the nearest cent.

The APEs are \(40{,}000/760{,}000=5.2632\%\), \(100{,}000/1{,}100{,}000=9.0909\%\), and \(60{,}000/1{,}140{,}000=5.2632\%\). Therefore, MAPE is \((5.2632\%+9.0909\%+5.2632\%)/3=6.5391\%\), rounded to four decimal places.

Check. The signed errors sum to zero, so the mean signed error is zero, but the nonzero MAE confirms that the individual projections were not exact. The common mistake this example avoids is treating zero average signed error as evidence of zero error in every period.

Worked Example: Separating Bias From Error Size

A hypothetical liability portfolio has two accident periods with later observed mature ultimates of $200,000 and $250,000. Their archived chain-ladder projections are $230,000 and $230,000. Calculate the signed errors, mean signed error, MAE and MAPE.

Method. Subtract actual from projected for the signed error, and use absolute values for MAE and MAPE. For the first period, \(e_1=230{,}000-200{,}000=+\$30{,}000\). For the second, \(e_2=230{,}000-250{,}000=-\$20{,}000\).

The mean signed error is \((30{,}000-20{,}000)/2=+\$5{,}000\), indicating average overprojection by $5,000 per period. The MAE is \((30{,}000+20{,}000)/2=\$25{,}000\).

The first APE is \(30{,}000/200{,}000=15\%\). The second is \(20{,}000/250{,}000=8\%\). Thus, MAPE is \((15\%+8\%)/2=11.5\%\).

Check. The first projection is high and the second is low, while the positive mean signed error shows that the overprojection is larger in dollar terms. A common mistake is to report the mean absolute error as $20,000, perhaps by confusing it with one of the individual errors. The two absolute errors are $30,000 and $20,000, so their average is $25,000.

Comparing Projections at Different Valuation Dates

A later valuation can produce a revised ultimate for the same accident period because more development is available. Testing both archived projections against one common later mature amount can show how the projection changed as information emerged. However, the two errors are repeated measurements for one accident period, not two independent accident periods. Keep the valuation date attached to each projection and avoid combining repeated snapshots as though they were separate years of experience.

Worked Example: One Accident Period, Two Snapshots

For a hypothetical accident period, the archived 12-month cumulative loss is $450,000 and its selected 12-month-to-ultimate factor is 2.00. At 24 months, cumulative loss is $752,000 and the selected 24-month-to-ultimate factor is 1.25. A later mature valuation reports $960,000. Compare the two archived projections using signed error and absolute percentage error.

Method. Reconstruct each estimate using the cumulative loss and factor that were available at its own valuation date. At 12 months, \(\hat U^{(12)}=450{,}000(2.00)=\$900{,}000\). Its signed error is \(900{,}000-960{,}000=-\$60{,}000\), and its APE is \(60{,}000/960{,}000=6.25\%\).

At 24 months, \(\hat U^{(24)}=752{,}000(1.25)=\$940{,}000\). Its signed error is \(940{,}000-960{,}000=-\$20{,}000\), and its APE is \(20{,}000/960{,}000=2.0833\%\), rounded to four decimal places.

Check. The later snapshot is $40,000 closer to the mature ultimate, and its absolute percentage error is lower. This is evidence about this accident period only; it does not establish that every later snapshot or every accident period will improve.

Interpretation, Comparability and Common Traps

Backtest results are most useful when their scope is explicit. State the valuation date or development age, the accident periods included, the selected projection method and the maturity standard for the comparison amounts. If you summarize different valuation dates together, label them and explain how repeated accident periods are treated. A change in the mix of tested periods can change the summary even when the method itself has not changed.

The comparison also depends on a stable meaning for “loss.” For example, paid and incurred amounts are different measures; changing the loss definition between the archived projection and later amount breaks comparability. Confirm that the currency, gross or net basis, expense treatment and other material definitions agree. If amounts are adjusted to a common basis, specify the adjustment and apply it consistently. Identifying such changes is part of sound interpretation, not a reason to revise the archived projection after the fact.

  • Using hindsight in the projection. Re-estimating the original factors with later data does not test what the original projection anticipated.
  • Reversing the error sign. With \(e=\hat U-U^*\), positive means overprojection and negative means underprojection. State the convention before interpreting bias.
  • Letting errors cancel in an accuracy measure. Use absolute errors for MAE; signed errors measure direction, not typical error size.
  • Ignoring the MAPE denominator. MAPE is undefined at a zero actual and can be dominated by periods with very small actuals.
  • Comparing unlike amounts. An immature later value or a changed loss basis can make apparent accuracy misleading.

Backtesting is a diagnostic, not a guarantee. A pattern of errors may motivate closer examination of the data, assumptions or development behavior, but the summary alone does not identify the cause. A small average signed error can coexist with substantial period-level errors, and strong historical performance does not eliminate future uncertainty.

Key takeaway: Preserve the original information set, compare each archived ultimate with a sufficiently mature amount on the same basis, and report both direction and magnitude of error. Interpret summary measures with the number, size and comparability of the tested accident periods in view. This treatment is aligned with the SOA Exam ASTAM (Advanced Short-Term Actuarial Mathematics) syllabus.

Check Your Understanding

For each problem, use projection minus observed ultimate as the signed error. Amounts are dollars unless stated otherwise.

  1. A 12-month cumulative loss is $360,000 and the factor selected at that valuation is 1.75. The subsequently observed mature ultimate is $600,000. Find the archived projection, signed error and APE. (Answer: projection $630,000; signed error +$30,000; APE 5.0000%.)
  2. Two mature observed ultimates are $400,000 and $500,000; archived projections are $420,000 and $460,000. Find the mean signed error, MAE and MAPE. (Answer: mean signed error −$10,000; MAE $30,000; MAPE 6.5000%.)
  3. Observed ultimates are $250,000 and $500,000, with projections of $275,000 and $450,000. Find MAE, MAPE and weighted absolute percentage error. (Answer: MAE $37,500; MAPE 10.0000%; weighted absolute percentage error 10.0000%.)
  4. A projection is $15,000 and the comparison amount is zero. What is the absolute dollar error, and is the period’s APE defined? (Answer: absolute error $15,000; APE is undefined because the observed ultimate is zero.)
  5. For one accident period, an archived 12-month projection is $720,000 and its later mature comparison amount is $800,000. A separate archived 24-month projection is $780,000 against that same mature amount. Find both signed errors and state whether they are two independent accident-period observations. (Answer: 12-month error −$80,000; 24-month error −$20,000; no, they are two snapshots of one accident period.)
Clinical Biostats