Building an Incurred Loss Triangle from Valuation Snapshots

Introduction

An incurred loss triangle records an estimate of losses associated with each accident period as of successive valuation dates. To construct one from claim records, the key is to use the cumulative paid amount to date together with the case reserve still outstanding at each snapshot. A payment made earlier remains part of cumulative paid even if a later valuation shows a lower reserve or the claim has closed.

The distinction matters because valuation snapshots describe the claim position at particular dates. They are not, by themselves, records of payments made during the interval between those dates. This tutorial develops a consistent way to translate those snapshots into cumulative incurred observations and to check the resulting cells.

Definition: For a claim at a valuation date, cumulative paid is the total amount paid on that claim from its origin through that date. The case reserve is the amount currently held for the remaining reported claim obligation. The claim's incurred amount at that valuation is cumulative paid plus case reserve. For an accident period and development age, the incurred observation is the sum of those claim-level amounts for claims assigned to that accident period.

From Valuation Snapshots to Triangle Cells

Let $i$ denote an accident period, such as an accident year, and $j$ denote the development age at which the claims are valued. Write $P_{i,j}$ for cumulative paid losses and $R_{i,j}$ for case reserves at that snapshot. The incurred observation $I_{i,j}$ is

I_{i,j}=P_{i,j}+R_{i,j}.

The paid and reserve totals must refer to the same accident period, the same valuation date, and the same claim population. If records are available claim by claim, add each claim's cumulative paid and current case reserve, then sum across claims. Equivalently, sum all cumulative paid amounts and all case reserves separately, then add the two totals.

A case reserve is a current estimate, not a payment already made. A claim with no payment yet can therefore have positive incurred loss if it has a positive case reserve. Conversely, a closed claim generally has no remaining case reserve, but its past payments remain in cumulative paid. The incurred amount in this setting is based on reported claims and case reserves; it is not automatically an allowance for unreported claims or other separately estimated amounts.

Worked Example: Combining Paid-to-Date and Case Reserves

A hypothetical accident-year cohort has three reported claims. At 12 months, interval payments are $5,000, $2,000, and $0, and case reserves are $1,000, $3,000, and $4,000. At 24 months, additional interval payments are $1,000, $2,000, and $3,000, while current case reserves are $0, $1,000, and $2,000. Find the incurred observations at both ages.

Method. First convert interval payments into cumulative paid amounts at each valuation. Then add the reserves held at that same valuation.

At 12 months, cumulative paid is the interval payment to date:

P_{i,12}=5{,}000+2{,}000+0=7{,}000.

The reserve total at 12 months is $1{,}000+3{,}000+4{,}000=8{,}000$. Therefore:

I_{i,12}=7{,}000+8{,}000=15{,}000.

At 24 months, the additional payments total $1{,}000+2{,}000+3{,}000=6{,}000$. They are added to the $7,000 already paid, so cumulative paid is $7{,}000+6{,}000=13{,}000$. Current reserves total $0+1{,}000+2{,}000=3{,}000$. Thus:

I_{i,24}=13{,}000+3{,}000=16{,}000.

Check. Claim-level incurred amounts at 24 months are $6,000 + $1,000 + $2,000 = $9,000? That would omit the second claim's cumulative paid of $4,000 and the third claim's cumulative paid of $3,000. The correct claim-level amounts are: claim 1, $5{,}000+1{,}000+0=6{,}000$; claim 2, $2{,}000+2{,}000+1{,}000=5{,}000$; claim 3, $0+3{,}000+2{,}000=5{,}000$. Their sum is $16,000, agreeing with the aggregate calculation. A common error is to report $19,000 by carrying forward an incorrect paid or reserve total; the explicit totals above reconcile to $16,000.

Organizing Observations by Accident Period and Age

A triangle is formed by placing one accident period on each row and one development age on each column. The cell at row $i$, column $j$ contains the incurred amount as of that period's valuation at age $j$. For each cell, preserve the source date and distinguish the amount paid to date from the reserve at that date. This makes it possible to review how the incurred observation was obtained rather than relying on a total with no supporting detail.

Worked Example: Populating Cells for Two Accident Periods

A hypothetical insurer has two accident-year cohorts. At 12 months, the 2024 cohort has cumulative paid of $18,000 and case reserves of $7,000. At 24 months, its cumulative paid is $27,000 and its case reserves are $3,000. The 2025 cohort has, at 12 months, cumulative paid of $14,000 and case reserves of $9,000. Construct the observed incurred cells.

2024 at 12 months. Add the amounts from the 12-month snapshot: $18{,}000+7{,}000=25{,}000$. Hence $I_{2024,12}=\$25{,}000$.

2024 at 24 months. Use the 24-month cumulative paid and the 24-month case reserve: $27{,}000+3{,}000=30{,}000$. Hence $I_{2024,24}=\$30{,}000$.

2025 at 12 months. Add the 12-month snapshot amounts: $14{,}000+9{,}000=23{,}000$. Hence $I_{2025,12}=\$23{,}000$.

Accident period	Development age	Cumulative paid	Case reserves	Incurred
2024	12 months	$18,000	$7,000	$25,000
2024	24 months	$27,000	$3,000	$30,000
2025	12 months	$14,000	$9,000	$23,000

The observed triangle entries are therefore $25,000 and $30,000 in the 2024 row, and $23,000 in the 2025 row at 12 months. The 2025 cohort's 24-month cell is not calculated from the information given. Do not fill it by extrapolating the 12-month amount; it requires a valuation at the later age.

Check. The 2024 cumulative paid amount rises from $18,000 to $27,000, while the reserve falls from $7,000 to $3,000. The resulting incurred amount rises from $25,000 to $30,000. Both snapshots were combined independently using amounts from their own valuation dates.

Why the Cell Formula Works

The formula follows directly from adding claim obligations within the accident period. Suppose the cohort contains $n$ claims. For claim $k$, let $P_{k,j}$ be cumulative paid and $R_{k,j}$ be its case reserve at age $j$. Its incurred amount is $P_{k,j}+R_{k,j}$. Summing those claim amounts gives:

\begin{aligned} I_{i,j} &=\sum_{k=1}^{n}\left(P_{k,j}+R_{k,j}\right)\\ &=\sum_{k=1}^{n}P_{k,j}+\sum_{k=1}^{n}R_{k,j}\\ &=P_{i,j}+R_{i,j}. \end{aligned}

The second line uses the distributive property of addition, and the final line defines the cohort totals. This also gives a useful reconciliation: summing claim-level incurred amounts must match the sum of the cohort's cumulative paid total and reserve total, provided both calculations use the same claims, date, and currency basis.

Worked Example: Reconciling Claim Records Across Snapshots

A hypothetical four-claim cohort is valued at 12 and 24 months. At 12 months, the claim-level pairs (cumulative paid, case reserve), in thousands of dollars, are: claim A $(4,2)$, claim B $(0,5)$, claim C $(7,0)$, and claim D $(1,6)$. At 24 months, the pairs are A $(6,1)$, B $(3,2)$, C $(7,0)$, and D $(4,0)$. Calculate incurred at each age and explain the change.

At 12 months. The cumulative paid total is $4+0+7+1=12$ thousand dollars. The reserve total is $2+5+0+6=13$ thousand dollars. Therefore $I_{i,12}=12+13=25$ thousand dollars, or $25,000.

The claim-level check is $(4+2)+(0+5)+(7+0)+(1+6)=6+5+7+7=25$ thousand dollars.

At 24 months. The cumulative paid total is $6+3+7+4=20$ thousand dollars. The current reserves total $1+2+0+0=3$ thousand dollars. Therefore $I_{i,24}=20+3=23$ thousand dollars, or $23,000.

The claim-level check is $(6+1)+(3+2)+(7+0)+(4+0)=7+5+7+4=23$ thousand dollars. The incurred observation has fallen by $25-23=2$ thousand dollars even though cumulative paid rose by $20-12=8$ thousand dollars. The reserve total fell by $13-3=10$ thousand dollars, so the net change is $8-10=-2$ thousand dollars. This is possible because case reserves are revised estimates; incurred observations need not increase at every valuation.

Check. Both aggregate and claim-level calculations agree at each age. The calculation uses cumulative paid at each snapshot, not just the new payments since the prior valuation.

Common Mistakes and Data Checks

The most frequent error is adding a current reserve to payments made only during the latest interval. The reserve is paired with all cumulative payments to date, not merely with the newest transactions. For example, if cumulative paid is $20,000 and the current reserve is $3,000, incurred is $23,000. If $8,000 of that paid total happened during the latest interval, calculating $8{,}000+3{,}000=11{,}000$ is wrong: it drops the earlier $12,000 of payments. The correction is $12{,}000+8{,}000+3{,}000=23{,}000$.

Other useful checks include:

Match dates. Do not combine cumulative paid from one valuation with reserves from another.
Confirm the payment basis. If the source gives interval payments, accumulate them through the valuation date before adding reserves.
Keep closed claims' payments. A zero reserve on a closed claim does not erase its prior cumulative paid amount.
Check units. If one input is stated in thousands of dollars and another in dollars, convert before adding.
Reconcile totals. The sum of claim-level incurred amounts should equal cohort paid-to-date plus cohort case reserves.

Building the observations accurately is necessary before interpreting development patterns. The incurred triangle summarizes reported payments and current case estimates at successive snapshots; it does not mean that every cell is a final or fixed measure of ultimate cost. A change between valuations can reflect payments, reserve revisions, or both.

Key takeaway: At each valuation snapshot, calculate incurred by adding the cohort's cumulative paid amount to its case reserves at that same date. Check whether payments are cumulative or interval amounts before constructing any triangle cell.

Check Your Understanding

For each problem, identify the relevant snapshot amounts before calculating the incurred observation.

A hypothetical cohort has cumulative paid of $6,000 and case reserves of $4,000 at 12 months. At 24 months, an additional $2,000 has been paid and current reserves are $1,000. What are the incurred observations at both ages? (Answer: 12 months, $10,000; 24 months, $9,000.)
Three claims have interval payments at 6 months of $2,000, $0, and $1,000. Between 6 and 12 months, they receive additional payments of $1,000, $3,000, and $0. At 12 months their current reserves are $0, $2,000, and $1,000. Find the 12-month incurred amount. (Answer: $10,000.)
At a valuation, a four-claim accident-period cohort has cumulative paid amounts of $5,000, $0, $3,000, and $2,000, and case reserves of $1,000, $4,000, $0, and $2,000. Find the aggregate incurred observation and verify it by claim-level summation. (Answer: $17,000.)
A cohort has incurred of $42,000 at 12 months, consisting of cumulative paid of $28,000 and case reserves of $14,000. At 24 months, additional payments are $9,000 and current case reserves are $5,000. Calculate 24-month incurred and its change from 12 months. (Answer: $42,000 at 24 months; no change.)
For one accident period, a 12-month snapshot has cumulative paid of $16,000 and case reserves of $11,000. At 24 months, cumulative paid is $25,000 and reserves are $4,000. A report instead adds the 24-month reserve to only $7,000 of interval payments. State the correct 24-month incurred and the amount by which the report is wrong. (Answer: Correct incurred, $29,000; report gives $11,000 and understates by $18,000.)

What You'll Learn