Chain-ladder claims reserve · Calculation guide

Enter a complete upper triangle with nondecreasing cumulative payments.

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
11100
12150
2180
ResultValue
Unpaid reserve40
Projected ultimate claims270

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.

Chain-ladder claims reserve →

Sources