Calculating An Incurred Triangle Cell

What an Incurred Triangle Cell Represents

An incurred triangle cell summarizes the loss position for a particular claim group at a particular valuation date. Its two components are the payments already made for that group through the valuation date and the case reserves held at that same date for its reported claims. The central calculation is simple; the important discipline is using components that refer to the same group, date, and loss basis.

For example, if a cell is for an accident year at 24 months of development, its paid component is the cumulative amount paid on that accident year's claims through the 24-month valuation. The reserve component is the outstanding case reserve for those same claims at that valuation. A payment made after that valuation does not belong in the cell.

Definition: Let $P_{i,j}$ be cumulative paid loss through valuation age $j$ for origin period $i$, and let $R_{i,j}$ be the outstanding case reserves at that valuation for the same claim group. The incurred-loss cell is $$ I_{i,j}=P_{i,j}+R_{i,j}. $$ The calculation uses amounts on a consistent loss basis and valued at the same date. A cell constructed from reported-claim payments and case reserves does not automatically include an estimate for claims that have not been reported; include other reserve components only if the stated data definition includes them.

“Cumulative” matters. The paid amount is the total paid from the beginning of the relevant development period through the stated valuation, not merely the payments made since the preceding valuation. Case reserves are a valuation-date balance: they estimate the unpaid amount currently reserved on reported claims. They are not payments, and they are not added once for every earlier valuation.

The same principle applies whether the origin period is an accident year, policy year, or report year. The meaning of the origin-period row is determined by the triangle being constructed; the incurred-cell arithmetic itself remains paid to date plus case reserves at the cell's valuation. The open and closed claim distinction is useful when checking reserve amounts: a closed claim will commonly have no outstanding case reserve, while an open claim may have one. Use the reserves actually specified for the valuation, rather than assuming a reserve amount from the claim's status alone.

Calculate the Cell in a Consistent Order

A reliable calculation begins by identifying the cell, not by adding every number associated with the claims. Confirm the origin-period group and valuation date. Then take cumulative paid loss through that date, take outstanding case reserves at that date, and add the two amounts. If the supplied paid amount is incremental, first convert it to cumulative paid loss through the valuation.

Identify the cell.
State the origin-period claim group and valuation date or development age.

Match the paid amount.
Use payments through the valuation date for that group. If only incremental payments are provided, accumulate them through the date.

Match the reserve amount.
Use outstanding case reserves for the same group and valuation date, including zero for claims or groups with no outstanding case reserve when that is what the data specify.

Add and check.
Calculate $I_{i,j}=P_{i,j}+R_{i,j}$, then confirm both inputs share the cell's date, group, and loss basis.

Worked Example: A Single Origin-Period Cell

A hypothetical commercial equipment insurer is preparing the accident-year 2024 cell at the December 31, 2025 valuation, corresponding to 24 months of development. Cumulative paid loss for the group through that date is $126,400. Outstanding case reserves at that date are $38,600. Calculate the incurred cell.

Method and assumptions. Use the cumulative-paid-plus-case-reserve definition. Interest rate: 0% for this arithmetic illustration; no discounting is applied. Mortality assumption: not applicable. Distribution and parameters: no probability distribution is assumed; the supplied amounts are deterministic.

Step 1: Identify the components. The paid amount is $P_{2024,24}=\$126{,}400$, and the reserve amount is $R_{2024,24}=\$38{,}600$. Both are for accident year 2024 at the December 31, 2025 valuation.

Step 2: Add them.

I_{2024,24}=\$126{,}400+\$38{,}600=\$165{,}000.

Check. The incurred amount exceeds paid loss by exactly the outstanding reserve: $\$165{,}000-\$126{,}400=\$38{,}600$. The cell is $165,000. The mistake to avoid is adding reserves from a different valuation date merely because they are available in the data; only the reserve balance at this cell's valuation belongs here.

Why the Addition Gives Incurred Loss

The formula follows from separating the loss estimate into what has already been paid and what remains outstanding. At a valuation date, cumulative payments represent the settled portion of losses included in the group. Case reserves represent the estimated unpaid portion currently recorded for reported claims. Adding these non-overlapping portions gives the incurred amount on this basis.

Justification: At the valuation date, the paid portion is $P_{i,j}$ and the unpaid case-reserve portion is $R_{i,j}$. Since the cell's incurred amount on this basis includes both portions, their total is $$ \text{paid to date}+\text{outstanding case reserve} =P_{i,j}+R_{i,j} =I_{i,j}. $$ This is an accounting-style decomposition of the cell, not a claim that the reserve is the final amount that will ultimately be paid.

The distinction between an outstanding estimate and a future payment is important. A case reserve is the amount held at the valuation date, not a guarantee of the amount eventually paid. If later information changes the estimate, or a claim is paid for an amount different from its reserve, the incurred amount at a later valuation can change. The cell records the valuation-date components; it is not a statement that the estimate will never be revised.

Worked Example: Open and Closed Claims in One Cell

A hypothetical insurer reviews three claims in the same origin-period group at one valuation date. Claim A has cumulative paid loss of $14,250 and an outstanding case reserve of $5,750. Claim B is closed, has cumulative paid loss of $8,900, and has no outstanding case reserve. Claim C is open, has no payments to date, and has an outstanding case reserve of $12,600. Calculate the cell.

Method and assumptions. Calculate each claim's paid-plus-reserve amount and sum those amounts for the group. Interest rate: 0%; no discounting. Mortality assumption: not applicable. Distribution and parameters: deterministic claim amounts; no probability distribution is used.

Step 1: Calculate each claim's incurred amount.

\begin{aligned} \text{Claim A: }&\$14{,}250+\$5{,}750=\$20{,}000,\\ \text{Claim B: }&\$8{,}900+\$0=\$8{,}900,\\ \text{Claim C: }&\$0+\$12{,}600=\$12{,}600. \end{aligned}

Step 2: Sum the paid and reserve components separately. Cumulative paid loss is $\$14{,}250+\$8{,}900+\$0=\$23{,}150$. Outstanding case reserves total $\$5{,}750+\$0+\$12{,}600=\$18{,}350$.

Step 3: Calculate the cell.

I=\$23{,}150+\$18{,}350=\$41{,}500.

Check. The claim-level amounts also sum to $\$20{,}000+\$8{,}900+\$12{,}600=\$41{,}500$. Claim B contributes its paid amount even though it is closed; Claim C contributes its reserve even though it has no payments yet. The common mistake avoided here is treating closed status as a reason to omit past payments, or treating open status as a reason to omit the paid amount.

Working Across Two Valuation Dates

When a question gives information at more than one valuation, calculate each cell using the components at its own date. A useful check is to reconcile the change in incurred loss. If cumulative paid loss increases by an incremental payment amount and case reserves change between valuations, then the change in incurred loss equals the paid increase plus the change in reserves. A reserve decrease therefore offsets some of the additional paid loss.

I_{\text{later}}-I_{\text{earlier}} = (P_{\text{later}}-P_{\text{earlier}}) + (R_{\text{later}}-R_{\text{earlier}}).

This relationship is obtained by subtracting the earlier cell formula from the later one:

(P_{\text{later}}+R_{\text{later}}) -(P_{\text{earlier}}+R_{\text{earlier}}) = (P_{\text{later}}-P_{\text{earlier}}) +(R_{\text{later}}-R_{\text{earlier}}).

Worked Example: Updating a Cell from Incremental Paid Loss

For a hypothetical liability claim group, cumulative paid loss at 12 months is $72,500 and the case reserves at that valuation total $40,000. Between 12 and 24 months, an additional $28,700 is paid. At 24 months, outstanding case reserves are $28,800. Calculate the 24-month incurred cell and check the change from 12 months.

Method and assumptions. First update cumulative paid loss, then add the case reserve at 24 months. Interest rate: 0%; no discounting. Mortality assumption: not applicable. Distribution and parameters: deterministic amounts; no probability distribution is assumed.

Step 1: Find cumulative paid loss at 24 months. The $28,700 is incremental for months 12 to 24, so add it to the 12-month cumulative paid amount:

P_{24}=\$72{,}500+\$28{,}700=\$101{,}200.

Step 2: Add the 24-month reserve.

I_{24}=\$101{,}200+\$28{,}800=\$130{,}000.

Step 3: Reconcile the change. The 12-month incurred amount is $\$72{,}500+\$40{,}000=\$112{,}500$. The reserve change is $\$28{,}800-\$40{,}000=-\$11{,}200$, so the incurred change is $\$28{,}700-\$11{,}200=\$17{,}500$. Adding that change to the earlier incurred amount gives $\$112{,}500+\$17{,}500=\$130{,}000$.

Check. Both direct calculation and change reconciliation give $130,000. The trap is to add the new incremental payment to the reserve while forgetting the earlier cumulative payments; the 24-month paid amount must include all payments through 24 months.

Common Errors and Practical Checks

The arithmetic is short, but a cell can be wrong if either input is misidentified. In particular, paid amounts and reserve balances answer different questions: paid loss accumulates over time, whereas outstanding case reserves are measured at a point in time.

Worked Example: Catching a Valuation-Date Mismatch

A hypothetical property claim group has cumulative paid loss of $54,000 at the March 31 valuation. Its case reserve at March 31 is $16,000; the reserve at the later June 30 valuation is $11,000. Calculate the March 31 cell. Then show the error from using the June 30 reserve in that cell.

Method and assumptions. Match both components to March 31. Interest rate: 0%; no discounting. Mortality assumption: not applicable. Distribution and parameters: deterministic amounts; no probability distribution is used.

Correct calculation. The paid loss and reserve both refer to March 31:

I_{\text{Mar 31}}=\$54{,}000+\$16{,}000=\$70{,}000.

Incorrect calculation. Substituting the later reserve gives $\$54{,}000+\$11{,}000=\$65{,}000$. This is not the March 31 cell because its reserve component is from June 30.

Correction and check. Use the March 31 reserve, so the correct cell is $70,000. The $5,000 difference equals the change between the two supplied reserve balances; it does not make the later balance appropriate for the earlier valuation.

Adding incremental paid loss as though it were cumulative. First add the incremental amount to prior cumulative payments; then use the resulting cumulative amount in the cell.
Combining different valuation dates. A paid amount and reserve balance must describe the same valuation date.
Adding earlier reserves again. A reserve is a balance at a particular valuation, not a cumulative payment. Use the reserve at the cell's date, not the sum of reserves from several valuations.
Omitting a component because of claim status. Include paid amounts for closed claims and include supplied case reserves for open claims. Status alone does not replace the component values.
Mixing loss bases. If one component is on a different gross, net, or expense basis from the other, the sum is not a consistent incurred cell until the bases are aligned.

Key takeaway: An incurred triangle cell is cumulative paid loss plus outstanding case reserves for the same claim group at the same valuation date. Check the time basis and loss basis of both inputs before accepting the sum.

Check Your Understanding

For each problem, calculate the requested incurred amount using only components that match the stated group and valuation.

A hypothetical accident-year group has cumulative paid loss of $46,780 and outstanding case reserves of $13,220 at the same valuation. What is the incurred cell? (Answer: $60,000.)
At one valuation, three claims in a group have paid loss and case reserves as follows: Claim A, $7,400 and $2,600; Claim B, $11,600 and $0; Claim C, $0 and $9,400. What is the group's incurred cell? (Answer: $31,000.)
At 6 months, cumulative paid loss is $18,500. Incremental payments from 6 to 12 months are $7,250, and the 12-month case reserve is $10,250. Calculate the 12-month incurred cell. (Answer: $36,000.)
A group has cumulative paid loss of $84,000 at an earlier valuation. By the current valuation, an additional $25,000 has been paid, and the current case reserve is $21,000. Calculate the current incurred cell. (Answer: $130,000.)
At the earlier valuation, cumulative paid loss is $90,000 and case reserves are $34,000. At the current valuation, cumulative paid loss is $105,500 and case reserves are $22,500. Calculate the incurred cell at both dates and the change in incurred loss. (Answer: earlier $124,000; current $128,000; increase $4,000.)

What You'll Learn