Why Three Views of Loss Belong Together
A loss triangle can be shown gross of reinsurance, ceded to reinsurers, or net retained by the insurer. These are not three unrelated summaries: when they use the same loss definition, origin period, valuation date, development age, and paid or incurred basis, the amounts should reconcile cell by cell. That relationship makes the triangles useful both for organizing claim information and for checking that reinsurance has been reflected consistently.
The central calculation is simple: net loss equals gross loss less ceded loss. Applying it correctly requires care about what each triangle measures. A paid amount cannot be reconciled directly to an incurred amount, and a cumulative amount cannot be compared with an incremental amount. Empty future cells also mean “not yet observed,” not zero.
Reading a Loss Triangle
A triangle groups amounts by an origin period and a development age. The origin period might be an accident year, policy year, or another consistently defined cohort. Development age measures how long claims from that cohort have developed, often in increments such as 12, 24, and 36 months. A valuation date determines how much information is available at each age. For example, an accident year may have observations at 12 and 24 months but not yet at 36 months.
In a cumulative paid triangle, the cell at a given age is the total paid from the start of the origin period through that age. In an incremental paid triangle, a cell is the amount paid during just one development interval. To convert incremental amounts to cumulative amounts, add the current and all earlier increments for the same origin period. To convert cumulative amounts to increments, subtract the previous cumulative amount; the first increment is the first cumulative amount.
An incurred triangle usually records cumulative paid losses plus case outstanding amounts at the valuation date. Ceded incurred amounts likewise need to include ceded paid losses and the corresponding outstanding recoverables on the same basis. The net incurred amount is the difference between matching gross and ceded incurred amounts. Case reserves and recoverables can change over time, so incurred values are not necessarily increasing with age.
The reconciliation applies to every observed cell, not just to the latest diagonal or to a total across the whole triangle. If triangles use different origin periods, valuation dates, or loss definitions, subtracting their displayed values may give a number, but it will not establish a valid net amount.
Worked Example: Completing a Cumulative Paid Triangle
A hypothetical insurer prepares cumulative paid loss triangles, in thousands of dollars, for a treaty with a 25% quota share. At each observed cell, ceded paid losses are 25% of gross paid losses. Complete the net triangle for accident years 2023–2025. All three triangles are valued on the same date, and no discounting or additional expense adjustment is used.
Method. For each observed accident-year and age cell, subtract cumulative ceded paid losses from cumulative gross paid losses. The ceded amounts shown below are already cumulative, so they must be matched to cumulative gross amounts.
| Accident year | Development age | Gross paid | Ceded paid | Net paid |
|---|---|---|---|---|
| 2023 | 12 months | 1,200 | 300 | 900 |
| 2023 | 24 months | 2,100 | 525 | 1,575 |
| 2023 | 36 months | 2,700 | 675 | 2,025 |
| 2024 | 12 months | 1,400 | 350 | 1,050 |
| 2024 | 24 months | 2,500 | 625 | 1,875 |
| 2024 | 36 months | Not observed | Not observed | Not observed |
| 2025 | 12 months | 1,600 | 400 | 1,200 |
| 2025 | 24 months | Not observed | Not observed | Not observed |
| 2025 | 36 months | Not observed | Not observed | Not observed |
Calculations. For accident year 2023 at 12 months, net paid is \(1{,}200-300=900\). At 24 months, it is \(2{,}100-525=1{,}575\); at 36 months, it is \(2{,}700-675=2{,}025\). For accident year 2024, the observed net amounts are \(1{,}400-350=1{,}050\) and \(2{,}500-625=1{,}875\). For accident year 2025 at 12 months, net paid is \(1{,}600-400=1{,}200\).
Check. In every observed cell, gross equals ceded plus net: for example, \(2{,}500=625+1{,}875\). The unobserved cells remain blank; they are not zero-loss observations. Common mistake avoided: treating a blank future age as a zero or filling it with an estimate when the task is only to reconcile reported amounts.
Why the Cell-by-Cell Identity Holds
The identity follows from how each loss amount is partitioned. On a consistent basis, each covered loss amount is either ceded under the reinsurance arrangements or retained net by the insurer. Thus, for each relevant transaction or valuation component, gross amount equals ceded amount plus net amount. Adding those amounts through the same development age preserves the equality.
Here \(G_{a,k}\), \(C_{a,k}\), and \(N_{a,k}\) denote gross, ceded, and net losses for origin period \(a\) at development age \(k\), all measured on the same basis. For cumulative paid losses, the identity can also be seen by summing the corresponding incremental identities through age \(k\). For incurred losses, it applies when the gross incurred amount and ceded incurred amount include corresponding paid and outstanding components at the same valuation date.
This is an accounting reconciliation, not a development assumption. It does not imply that ceded losses are a fixed percentage of gross losses, nor does it predict future amounts. Treaty terms, limits, attachment points, and claim characteristics can make the ceded share vary by claim and over development. The equality only says that the net amount is the retained part after the ceded amount has been measured consistently.
Worked Example: Reconciling Incurred Triangles
A hypothetical insurer reports incurred losses, in thousands of dollars, at several valuation ages. For each cell, gross incurred equals gross paid plus gross case outstanding, while ceded incurred equals ceded paid plus the corresponding outstanding recoverable. Calculate net incurred amounts. Assume all amounts refer to the same covered loss definition and valuation date; no interest adjustment is applied.
| Accident year | Age | Gross paid | Gross case outstanding | Ceded paid | Outstanding recoverable |
|---|---|---|---|---|---|
| 2023 | 12 months | 800 | 700 | 160 | 140 |
| 2023 | 24 months | 1,400 | 500 | 280 | 100 |
| 2023 | 36 months | 1,800 | 400 | 360 | 80 |
| 2024 | 12 months | 900 | 600 | 180 | 120 |
| 2024 | 24 months | 1,500 | 700 | 300 | 140 |
| 2025 | 12 months | 1,000 | 800 | 200 | 160 |
Step 1: Calculate incurred amounts. For accident year 2023 at 12 months, gross incurred is \(800+700=1{,}500\), and ceded incurred is \(160+140=300\). At 24 months, gross incurred is \(1{,}400+500=1{,}900\), and ceded incurred is \(280+100=380\). At 36 months, the amounts are \(1{,}800+400=2{,}200\) gross and \(360+80=440\) ceded.
For accident year 2024, the 12-month amounts are \(900+600=1{,}500\) gross and \(180+120=300\) ceded. At 24 months, they are \(1{,}500+700=2{,}200\) gross and \(300+140=440\) ceded. For accident year 2025 at 12 months, they are \(1{,}000+800=1{,}800\) gross and \(200+160=360\) ceded.
Step 2: Subtract ceded incurred from gross incurred. For accident year 2023, net incurred is \(1{,}500-300=1{,}200\), \(1{,}900-380=1{,}520\), and \(2{,}200-440=1{,}760\) at 12, 24, and 36 months. For accident year 2024 it is \(1{,}500-300=1{,}200\) at 12 months and \(2{,}200-440=1{,}760\) at 24 months. For accident year 2025 at 12 months it is \(1{,}800-360=1{,}440\).
Check. At accident year 2024 and 24 months, gross incurred of 2,200 equals ceded incurred of 440 plus net incurred of 1,760. Common mistake avoided: subtracting ceded paid losses alone from gross incurred losses. That would omit the outstanding recoverable and would not compare amounts on the same incurred basis.
Moving Between Incremental and Cumulative Triangles
The gross, ceded, and net identity works for either incremental or cumulative triangles, provided all three are expressed in the same form. An incremental ceded value must be subtracted from an incremental gross value for the same interval. A cumulative ceded value must be subtracted from a cumulative gross value through the same age. When converting between forms, do so separately within each origin period and for each of the three views.
A useful check is that the difference between two successive cumulative net amounts equals the corresponding incremental gross amount less the incremental ceded amount. This follows by subtracting the earlier cumulative identity from the later one. The result is an independent way to find a transcription or basis mismatch.
Worked Example: Converting Incremental Paid Amounts
A hypothetical specialty insurer has the following incremental paid losses, in thousands of dollars, for accident year 2024: gross amounts of 600, 500, and 300 at 12, 24, and 36 months, respectively; ceded amounts of 120, 100, and 90 for those same intervals. Construct the incremental net amounts and cumulative triangles. These amounts are paid losses at a common valuation date, with no discounting.
Step 1: Calculate incremental net paid. At 12 months, net is \(600-120=480\). At 24 months, it is \(500-100=400\). At 36 months, it is \(300-90=210\). The incremental net total through 36 months is \(480+400+210=1{,}090\).
Step 2: Accumulate each triangle. At 12 months, the cumulative totals equal the first increments: gross 600, ceded 120, and net 480. At 24 months, cumulative gross is \(600+500=1{,}100\), cumulative ceded is \(120+100=220\), and cumulative net is \(480+400=880\). At 36 months, cumulative gross is \(1{,}100+300=1{,}400\), cumulative ceded is \(220+90=310\), and cumulative net is \(880+210=1{,}090\).
| Age | Incremental gross | Incremental ceded | Incremental net | Cumulative gross | Cumulative ceded | Cumulative net |
|---|---|---|---|---|---|---|
| 12 months | 600 | 120 | 480 | 600 | 120 | 480 |
| 24 months | 500 | 100 | 400 | 1,100 | 220 | 880 |
| 36 months | 300 | 90 | 210 | 1,400 | 310 | 1,090 |
Step 3: Verify both forms. At 36 months, cumulative net is \(1{,}400-310=1{,}090\), matching the sum of incremental net amounts. The 36-month incremental net of 210 also equals the change in cumulative net, \(1{,}090-880=210\). Common mistake avoided: the ceded percentage is not constant across the three intervals: the ceded amounts are 20%, 20%, and 30% of gross increments. Do not assume a fixed share unless the data and contract support it.
Common Reconciliation Traps
Most apparent failures of the gross-minus-ceded identity are caused by mismatched definitions or measurement bases rather than by the subtraction itself. Before treating a discrepancy as an error, establish exactly what each triangle includes and when it was valued.
- Mixing incremental and cumulative amounts. Subtract values in the same form and at the same age.
- Mixing paid and incurred amounts. Incurred includes outstanding amounts as well as paid losses; compare it with ceded incurred, not ceded paid alone.
- Using different valuation dates. Later claim payments or reserve updates can change one triangle while another remains frozen at an earlier date.
- Comparing different origin periods or age definitions. A 24-month cell for one origin period is not interchangeable with a 12-month cell for another.
- Including different components. Confirm that loss definitions and treatment of expenses or other adjustments are consistent. Ceding commissions are not loss recoveries and should not be silently included in ceded loss.
- Treating unavailable cells as zero. A blank future diagonal represents data not yet observed, not a measured zero.
For example, at 24 months in the incremental example, subtracting the incremental ceded amount of 100 from the cumulative gross amount of 1,100 gives 1,000. That is not the cumulative net amount: the matching cumulative ceded amount is 220, giving \(1{,}100-220=880\). The incorrect result mixes development bases and fails the cell-by-cell comparison.
Check Your Understanding
For each problem, identify the matching basis before reconciling the amounts. All scenarios are hypothetical, and all amounts are in thousands of dollars unless stated otherwise.
- A cumulative paid triangle shows gross losses of 950 and ceded losses of 190 for a particular origin period at 12 months. Find net paid losses and state the cell check. (Answer: Net paid is 760; \(950=190+760\).)
- At a specified valuation date, gross paid losses are 1,250 and gross case outstanding is 450. Ceded paid losses are 250 and the outstanding recoverable is 90. Calculate gross incurred, ceded incurred, and net incurred. (Answer: Gross incurred is 1,700; ceded incurred is 340; net incurred is 1,360.)
- For one origin period, incremental gross paid amounts are 500 at 12 months and 900 at 24 months. Incremental ceded amounts are 100 and 270. Find cumulative net paid at 24 months and verify it using incremental net amounts. (Answer: Cumulative net is \((500-100)+(900-270)=1{,}030\); equivalently, cumulative gross \(1{,}400\) less cumulative ceded \(370\) equals \(1{,}030\).)
- At 24 months, cumulative gross paid is 1,100 and incremental ceded paid for the 24-month interval is 100. An analyst reports net cumulative paid of 1,000. Explain the error and identify what additional value is needed to calculate the correct cumulative net amount. (Answer: The analyst mixed cumulative gross with incremental ceded. The cumulative ceded amount through 24 months is needed; subtract that from 1,100.)
- For accident year 2024, cumulative gross paid is 400 at 12 months and 950 at 24 months; cumulative ceded paid is 50 and 170 at those ages. For accident year 2025 at 12 months, cumulative gross paid is 600 and cumulative ceded paid is 120. Complete the observed net paid cells and state which cells should remain blank if no later ages are observed. (Answer: Accident year 2024 net is 350 at 12 months and 780 at 24 months; accident year 2025 net is 480 at 12 months. Unobserved later-age cells remain blank, not zero.)