What a Cumulative Incurred-Loss Cell Records
An incurred-loss triangle records loss amounts by origin period and development age. For a cumulative incurred triangle, each observed cell represents the incurred amount for its origin period as of a particular valuation date. The central calculation combines payments made to date with the case reserves still held at that valuation.
The calculation uses a consistent loss definition and valuation basis across cells. For example, if the triangle is for indemnity losses, do not add an expense reserve to only some cells. Some data sets may include additional reserve components, such as bulk reserves; when they do, the data definition must be followed consistently. The examples here use cumulative payments plus case reserves only and do not add a separate provision for unreported claims.
Here, \(I_{i,j}\) is cumulative incurred loss for origin period \(i\) at development age \(j\), \(P_{i,j}\) is cumulative paid loss through that valuation, and \(R_{i,j}\) is the case reserve outstanding at that same valuation for the origin period. The paid amount is cumulative: it includes payments made at earlier development ages as well as payments made since the previous valuation. The reserve is a snapshot at the current valuation, not a cumulative sum of reserve snapshots.
From Claim Records to a Triangle Cell
To calculate a cell, first select the claims belonging to the relevant origin period and establish the valuation date represented by the cell. Then total their cumulative payments through that date and their case reserves at that date. Add those two totals. A closed claim normally contributes zero case reserve, but its prior payments remain in cumulative paid loss.
Specify the origin period and development age, which together identify the valuation represented by the cell.
Sum all payments for claims in that origin period made on or before the cell's valuation date.
Sum the case reserves outstanding for those claims at the same valuation date. Do not use a reserve from a different valuation.
Add cumulative paid loss and case reserves to obtain the incurred amount for that cell.
Worked Example: Aggregating Claims at One Valuation
A hypothetical insurer is preparing an incurred-loss cell for one origin period at year-end. Three claims have the following cumulative payments and case reserves at that date: Claim A has $12,400 paid and a $3,600 reserve; Claim B has $7,850 paid and no remaining reserve; Claim C has $4,200 paid and an $8,550 reserve. Calculate the cell. The stated amounts use the same loss definition and valuation date.
Step 1: Total cumulative paid loss. Add the payments for all three claims:
Step 2: Total case reserves. Claim B is closed for this purpose and contributes zero reserve:
Step 3: Calculate incurred loss.
The cumulative incurred-loss cell is $36,600. As a check, the claim-level incurred amounts are $16,000 for A, $7,850 for B, and $12,750 for C; their sum is also $36,600. The method avoids dropping the paid amount for a closed claim or counting a case reserve as though it had already been paid.
Placing Calculated Amounts in the Triangle
Each cell must be placed at the intersection of the correct origin period and development age. A triangle's observed cells correspond to valuations available by the data cutoff; cells for valuations that have not yet occurred are not calculated from the information available. The table below uses year-end valuations and development ages of 12, 24, and 36 months. Each entry is cumulative paid loss plus the case reserve at that age.
Worked Example: Constructing a Small Incurred Triangle
For a hypothetical portfolio, the data are as follows. Origin period 2023 has paid loss and case reserves of $30,000 and $18,000 at 12 months, $55,000 and $21,000 at 24 months, and $70,000 and $10,000 at 36 months. Origin period 2024 has $34,000 and $20,000 at 12 months, and $62,000 and $16,000 at 24 months. Origin period 2025 has $28,000 paid and $24,000 reserved at 12 months. Construct the cumulative incurred triangle.
Step 1: Calculate the 2023 row. Add paid loss and case reserves at each age:
Step 2: Calculate the observed 2024 cells.
Step 3: Calculate the observed 2025 cell.
The resulting triangle is:
| Origin period | 12 months | 24 months | 36 months |
|---|---|---|---|
| 2023 | $48,000 | $76,000 | $80,000 |
| 2024 | $54,000 | $78,000 | — |
| 2025 | $52,000 | — | — |
The 2023 row has three observed valuations, the 2024 row has two, and the 2025 row has one. The dashes indicate valuations not included in the supplied data; they are not calculated incurred amounts and should not be treated as zero. For example, the $78,000 in the 2024 row at 24 months means that, at that valuation, cumulative payments were $62,000 and case reserves were $16,000. It does not mean that $78,000 had been paid.
Why Incurred Amounts Can Change Between Valuations
Cumulative describes the paid component: it accumulates payments made through the valuation date. The case-reserve component is different. It is re-estimated at each valuation and can rise or fall as claim information changes. Consequently, cumulative incurred loss need not increase from one development age to the next.
The first difference is additional payments during the interval; the second is the change in case reserves. The formula follows directly by subtraction, and it explains why the incurred amount can rise, remain unchanged, or fall. In practice, newly reported claims or changes in the claims included in the data can also affect the totals, so a movement between cells should be interpreted using the data's claim and valuation definitions.
Worked Example: Reconciling a Reserve Revision
A hypothetical origin period has cumulative paid loss of $40,000 and case reserves of $32,000 at one valuation. At the next valuation, cumulative paid loss is $63,000 and case reserves are $7,000. Calculate both incurred amounts and explain the movement. Assume the same claims and loss definition are included at both valuations.
Step 1: Calculate incurred loss at the first valuation.
Step 2: Calculate incurred loss at the later valuation.
Step 3: Reconcile the change. Payments increased by $23,000, while case reserves decreased by $25,000:
Incurred loss fell by $2,000 even though additional payments were made, because the reserve reduction was larger than the payment increase. The later cell is $70,000, not the earlier $72,000 plus the later paid and reserve totals. The calculation avoids treating successive cumulative valuations as amounts to add together.
Interpreting a Cell and Avoiding Common Errors
A cumulative incurred cell is an estimate of paid-to-date loss plus the case-reserve estimate still outstanding for the included claims at one valuation. It is not, by itself, a statement of the amount ultimately expected to be paid on the origin period. Case reserves may change, claims may emerge or develop, and other reserving components may be defined separately. Later loss-development methods use triangle observations to estimate future amounts; the cell construction itself does not make that projection.
A common exam trap is to add cumulative paid loss to the sum of all case-reserve snapshots across development ages. That mixes amounts measured at different dates. Another is to add an earlier incurred cell to a later incurred cell, even though both cells already include payments made before their respective valuations. For each cell, use the paid-to-date total and the reserve snapshot from that cell's own valuation.
- Use cumulative paid loss, not only payments since the prior valuation. The cell includes all payments to date.
- Match the reserve to the same valuation. A reserve measured at an earlier or later date does not belong in the cell.
- Do not assume incurred values must increase with age. Case-reserve reductions can outweigh additional payments.
- Do not interpret an unobserved cell as zero. It represents a valuation not available in the displayed data.
Check Your Understanding
For each problem, calculate or interpret the requested incurred amount using the stated valuation and loss basis.
- A hypothetical origin period has cumulative paid loss of $18,750 and case reserves of $6,250 at a valuation. What is the cumulative incurred amount? (Answer: $25,000.)
- At one valuation, three claims have cumulative payments and case reserves of ($9,000, $2,000), ($5,000, $0), and ($3,000, $4,000), respectively. Find total cumulative paid loss, total case reserves, and the incurred cell. (Answer: Paid $17,000; reserves $6,000; incurred $23,000.)
- For one origin period, cumulative paid loss and case reserves are $41,000 and $12,500 at 12 months, then $53,000 and $9,000 at 24 months. Calculate both incurred cells and the change between them. (Answer: $53,500 at 12 months; $62,000 at 24 months; increase of $8,500.)
- At a valuation, a data extract reports cumulative paid loss of $88,000 and a case-reserve total of $14,000. A reviewer proposes adding the $88,000 paid amount to an earlier incurred cell of $70,000 and then adding the $14,000 reserve. What is the correctly calculated cell, and why is the proposal wrong? (Answer: $102,000; the current paid and reserve amounts already form the current cell, while adding the earlier incurred cell double-counts amounts.)
- For the same set of claims, the first valuation shows cumulative paid loss of $25,000 and case reserves of $40,000. At the next valuation, cumulative paid loss is $49,000 and case reserves are $12,000. Calculate each incurred amount and reconcile the change. (Answer: First $65,000; next $61,000; decrease of $4,000, from a $24,000 payment increase offset by a $28,000 reserve decrease.)