Calculation guide
Volume-weighted age-to-age factors project each latest diagonal claim to the oldest observed maturity, with tail factor one.
f(j) = Σ C(i,j+1) / Σ C(i,j) over matching pairs. U(i) = latest(i) × Π f(j).
Inputs
Origin period (1 = oldest)
Example entry 1. Allowed range 1.0 to 30.0. Use whole numbers.
Development age (starts at 1)
Example entry 1. Allowed range 1.0 to 30.0. Use whole numbers.
Cumulative paid claims
Example entry 100 (in the selected currency).
Worked example
Cumulative paid loss triangle
| Origin period (1 = oldest) | Development age (starts at 1) | Cumulative paid claims |
|---|---|---|
| 1 | 1 | 100 |
| 1 | 2 | 150 |
| 2 | 1 | 80 |
| Result | Value |
|---|---|
| Unpaid reserve | 40 |
| Projected ultimate claims | 270 |
Interpreting the result
The reserve measures projected claims still unpaid at the latest development age. An older tail of late payments would require a separate estimate.
In this example, changing “Cumulative paid claims (row 1)” from 100 to 110 moves “Unpaid reserve” from 40 to 29.090909. All other inputs stay the same.
