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.
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
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
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.
Record the accident periods, valuation date, cumulative losses, selected factors and tail assumption used for each archived projection.
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.
For each period, subtract the later observed ultimate from the archived projection, then calculate the chosen summary measures.
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.
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.
Check Your Understanding
For each problem, use projection minus observed ultimate as the signed error. Amounts are dollars unless stated otherwise.
- 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%.)
- 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%.)
- 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%.)
- 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.)
- 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.)