Tutorials › Exam ASTAM - Advanced Short-Term Actuarial Mathematics › Deriving Volume-Weighted Development Factors

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

Deriving Volume-Weighted Development Factors

Learn to derive and calculate a volume-weighted development factor from the paired cumulative losses in a development triangle.

Beginner 9 min read

What You'll Learn

  • Define the paired accident periods used for a development factor
  • Derive the ratio-of-sums formula from individual link ratios
  • Calculate factors using cumulative losses in consistent units
  • Handle incomplete triangles by using only observed paired cells
  • Distinguish cumulative amounts from incremental losses
  • Check a factor calculation using current-volume weights

Why Derive the Volume-Weighted Factor?

A development triangle records losses for accident periods at successive development ages. To estimate how losses typically change from one age to the next, an actuary can combine the observed pairs of cumulative amounts at those ages. The volume-weighted development factor is the ratio of the total next-age cumulative losses to the total current-age cumulative losses across the usable pairs.

The word volume refers to the size of the current-age cumulative amounts. A period with more current cumulative loss contributes more to the combined factor than a period with less. The derivation makes that weighting precise and helps prevent a common error: averaging ratios without considering how much loss each ratio represents.

Definition: Let \(C_{i,j}\) be the cumulative loss for accident period \(i\) at development age \(j\). Let \(I_j\) be the set of accident periods with observed cumulative losses at both ages \(j\) and \(j+1\). The volume-weighted development factor from age \(j\) to age \(j+1\) is
$$ \hat f_j^{\,\mathrm{VW}} = \frac{\displaystyle\sum_{i\in I_j} C_{i,j+1}} {\displaystyle\sum_{i\in I_j} C_{i,j}}. $$
The numerator and denominator must use the same paired accident periods and the same monetary units. The denominator must be nonzero.

The factor is a multiplier: a value of \(1.20\) means that, for the paired observations used in its calculation, the total cumulative amount at the later age is 1.20 times the total at the earlier age. It does not mean that every accident period individually grew by that percentage.

Deriving the Ratio of Sums

For a paired accident period with a positive current-age cumulative amount, its individual age-to-age link ratio is \(C_{i,j+1}/C_{i,j}\). The volume-weighted factor is the current-age-amount-weighted average of these individual ratios. The derivation follows by writing each next-age amount as its current-age amount multiplied by its ratio.

1
Define each individual ratio.
For each paired period \(i\), set \(f_{i,j}=C_{i,j+1}/C_{i,j}\), provided \(C_{i,j}>0\).
2
Assign a current-volume weight.
Let \(w_{i,j}=C_{i,j}/\sum_{k\in I_j}C_{k,j}\). When current cumulative amounts are nonnegative and their total is positive, the weights are nonnegative and sum to 1.
3
Combine the weighted ratios.
Substitute the individual ratio and weight, then cancel the current-age amount in each term.
$$ \begin{aligned} \sum_{i\in I_j} w_{i,j}f_{i,j} &= \sum_{i\in I_j} \left( \frac{C_{i,j}}{\sum_{k\in I_j}C_{k,j}} \right) \left( \frac{C_{i,j+1}}{C_{i,j}} \right)\\ &= \frac{\sum_{i\in I_j}C_{i,j+1}} {\sum_{k\in I_j}C_{k,j}}\\ &=\hat f_j^{\,\mathrm{VW}}. \end{aligned} $$

Thus the ratio of sums and the current-volume-weighted average of the individual ratios are the same quantity, provided the stated ratios and weights are defined. The cancellation in the second line explains why large current-age amounts have more influence: they receive larger weights before the ratios are combined. If a current amount is zero, that period's individual ratio is undefined, so the weighted-average derivation does not apply to that period as written; the ratio-of-sums formula itself can still be used if its total denominator is positive.

Worked Calculations

Worked Example: Combining Three Paired Accident Periods

A hypothetical insurer has cumulative paid losses, in thousands of dollars, for three accident periods at two successive development ages. The pairs are \(90\) and \(108\), \(150\) and \(180\), and \(260\) and \(299\). Calculate the volume-weighted factor and verify it using current-volume weights.

Method. Use the ratio of sums, then check the result by calculating the individual ratios and their current-volume weights. All three periods have observations at both ages, and each current amount is positive.

Step 1: Add the current-age amounts. \(90+150+260=500\) thousand dollars.

Step 2: Add the next-age amounts. \(108+180+299=587\) thousand dollars.

Step 3: Divide the totals. \(\hat f^{\,\mathrm{VW}}=587/500=1.174\). Rounded to four decimal places, the factor is \(1.1740\).

Step 4: Verify with individual ratios and weights. The ratios are \(108/90=1.20\), \(180/150=1.20\), and \(299/260=1.15\). The corresponding weights are \(90/500=0.18\), \(150/500=0.30\), and \(260/500=0.52\). They sum to \(1.00\). Therefore, \(0.18(1.20)+0.30(1.20)+0.52(1.15)=0.216+0.360+0.598=1.174\).

Check. Both methods give \(1.1740\) to four decimal places. The largest current amount, \(260\), receives the largest weight, \(0.52\).

Worked Example: Using Only Complete Pairs in an Uneven Triangle

A hypothetical property insurer reports cumulative losses in thousands of dollars at development ages 12, 24, and 36 months. Its triangle is:

Accident period12 months24 months36 months
A240312350
B180225270
C120156Not yet observed
D90Not yet observedNot yet observed

Calculate the volume-weighted factor from 12 to 24 months and the factor from 24 to 36 months. Identify which periods enter each calculation.

Method. For each transition, include only accident periods with both the current-age and next-age amounts observed. A blank cell is not a zero loss; it means the pair is unavailable.

Step 1: Factor from 12 to 24 months. Periods A, B, and C have both amounts. The current total is \(240+180+120=540\). The next-age total is \(312+225+156=693\). Thus the factor is \(693/540=1.283333\ldots\), or \(1.2833\) to four decimal places.

Step 2: Factor from 24 to 36 months. Only periods A and B have both amounts. The current total is \(312+225=537\), and the next-age total is \(350+270=620\). Thus the factor is \(620/537=1.154562\ldots\), or \(1.1546\) to four decimal places.

Check. Period C cannot enter the 24-to-36-month calculation because its 36-month amount is unobserved. Period D cannot enter either calculation because it has no observed next-age amount. The factors \(1.2833\) and \(1.1546\) use the correct paired observations for their respective transitions.

Worked Example: Converting Incremental Losses Before Calculating a Factor

A hypothetical insurer has the following incremental paid losses, in thousands of dollars. At 12 months, the three accident periods have paid \(100\), \(160\), and \(240\). During the following development interval, they pay an additional \(20\), \(56\), and \(48\), respectively. Calculate the volume-weighted factor from 12 to 24 months.

Method. The development factor uses cumulative amounts at both ages. First add each later interval's incremental payment to that period's 12-month cumulative amount.

Step 1: Construct the 24-month cumulative amounts. For the first period, \(100+20=120\). For the second, \(160+56=216\). For the third, \(240+48=288\). The paired cumulative amounts are therefore \((100,120)\), \((160,216)\), and \((240,288)\).

Step 2: Sum the 12-month amounts. \(100+160+240=500\) thousand dollars.

Step 3: Sum the 24-month amounts. \(120+216+288=624\) thousand dollars.

Step 4: Divide the cumulative totals. The factor is \(624/500=1.248\), or \(1.2480\) to four decimal places.

Check by weights. The individual ratios are \(120/100=1.20\), \(216/160=1.35\), and \(288/240=1.20\). The current-volume weights are \(100/500=0.20\), \(160/500=0.32\), and \(240/500=0.48\). The weighted result is \(0.20(1.20)+0.32(1.35)+0.48(1.20)=0.24+0.432+0.576=1.248\), matching the ratio of sums.

Check. The calculation uses cumulative amounts of \(500\) and \(624\), not just the interval payments of \(124\). The final factor is \(1.2480\) to four decimal places.

Conditions and Common Exam Traps

Before calculating, identify the development transition, the paired accident periods, and whether the displayed data are incremental or cumulative. The ratio-of-sums formula is a descriptive calculation on the selected observations; by itself, it does not establish that future periods will follow the same pattern. Its interpretation also depends on the data being comparable across periods and measured on a consistent basis.

  • Using an unpaired total. The numerator and denominator must cover exactly the same accident periods. Including a period in only one total creates a ratio that is not a volume-weighted factor from paired observations.
  • Treating a missing cell as zero. An unobserved amount is not an observed zero. Use only periods with both amounts available for that transition.
  • Using incremental amounts directly. The factor compares cumulative losses at successive ages. Convert interval payments to cumulative amounts before applying the formula.
  • Mixing units. If both totals are in thousands of dollars, the units cancel. If one total is in dollars and the other in thousands, convert them to the same unit first.

Common mistake, shown with a correction. Suppose the paired current amounts are \(80, 120, 300\), and the next amounts are \(96, 138, 330\). A mistaken calculation might report \(1.0800\). The correct current total is \(80+120+300=500\), and the correct next total is \(96+138+330=564\). Therefore the factor is \(564/500=1.1280\). As a check, the individual ratios are \(1.20, 1.15, 1.10\), and their weights are \(0.16, 0.24, 0.60\); the weighted result is \(0.16(1.20)+0.24(1.15)+0.60(1.10)=0.192+0.276+0.660=1.1280\). The incorrect answer does not agree with either calculation.

Key takeaway: For a specified age-to-age transition, select the periods with both cumulative amounts observed, add the next-age amounts, add the corresponding current-age amounts, and divide the first total by the second. When the current amounts are positive, the result is exactly their volume-weighted average of the individual link ratios.

Check Your Understanding

For each question, use paired cumulative amounts and round factors to four decimal places where needed.

  1. Two accident periods have current-age cumulative losses of \(100\) and \(200\), and next-age amounts of \(115\) and \(240\), all in the same units. Find the volume-weighted factor. (Answer: \(1.1833\))
  2. Three pairs are \((80,100)\), \((120,150)\), and \((300,330)\), where each pair is current age followed by next age. Calculate the ratio of sums and verify it by current-volume weights. (Answer: factor \(1.1600\); weighted average \(1.1600\))
  3. At 12 months, three periods have cumulative losses \(50,80, \) and \(0\); their incremental payments during the next interval are \(10,24,\) and \(18\). Using the resulting 24-month cumulative amounts, calculate the 12-to-24-month factor. (Answer: \(1.4000\))
  4. A triangle has paired observations from age \(j\) to \(j+1\) for three periods: current amounts \(200,300,500\) and next amounts \(230,360,550\). Calculate the factor and state which period has the greatest current-volume weight. (Answer: factor \(1.1400\); the period with current amount \(500\))
  5. For a 24-to-36-month transition, the first two periods have pairs \((100,120)\) and \((200,250)\); a third period has a current amount of \(300\), but its next-age cell is unobserved. Calculate the factor using available pairs. (Answer: \(1.2333\))
Clinical Biostats