Why Ultimate and Paid Loss Must Be Reconciled
An insurer may have already paid part of the losses arising from a group of claims, while some payments remain to be made. To estimate the loss liability at a valuation date, the actuary compares the selected estimate of the group’s total eventual loss with the cumulative loss already paid. The difference is the estimated amount still unpaid.
This comparison is simple only when the amounts are defined consistently. The selected ultimate and paid-to-date amounts must refer to the same claims or cohort, loss components, currency, and gross or net basis. The paid amount must also be cumulative through the valuation date; it is not just the payments made during the latest accounting period.
The Relationship and Its Conditions
Let \(U\) denote selected ultimate loss for a specified group, \(P\) denote cumulative paid loss for that group through the valuation date, and \(R\) denote unpaid loss at that date. When all three amounts use a consistent basis, the relationship is:
Solving for the unpaid amount gives the central calculation:
The equation follows by partitioning the eventual total into two parts. Each dollar of ultimate loss is either already paid by the valuation date or remains unpaid at that date. If those parts do not overlap and together include the full ultimate amount, then \(U=P+R\). Subtracting \(P\) from both sides gives \(R=U-P\).
This is an accounting and estimation relationship, not a method for selecting ultimate loss. The ultimate is an estimate when some claims remain unsettled; it may change as new information emerges. The equation says how to calculate the unpaid amount from a selected ultimate and paid amount, not how to choose either input.
Calculating Unpaid Loss From Selected Amounts
The arithmetic is direct, but a reliable calculation begins by identifying the valuation date and the scope of each input. For multiple groups, calculate the difference for each group or sum the consistent amounts first; both approaches should give the same aggregate liability.
Worked Example: Unpaid Loss for Two Claim Groups
A hypothetical insurer is valuing two groups of claims at December 31. The selected ultimate losses and cumulative paid losses, all in dollars and on the same gross loss basis, are: Group A, ultimate $860,000 and paid $517,000; Group B, ultimate $1,140,000 and paid $802,000. Calculate the unpaid loss for each group and in total.
Method. Apply \(R=U-P\) separately to each group. Because the two groups are distinct and use the same basis and valuation date, their unpaid amounts can then be added.
Group A. The unpaid loss is:
Group B. The unpaid loss is:
Total. Add the two selected ultimate amounts and the two paid amounts:
The aggregate unpaid loss is \( \$2{,}000{,}000-\$1{,}319{,}000=\$681{,}000\). Checking by group gives \( \$343{,}000+\$338{,}000=\$681{,}000\), so the two approaches agree.
Common mistake avoided. Subtracting only one group’s paid amount from the combined ultimate would mix scopes. The calculation pairs each group’s ultimate with its own cumulative paid amount before aggregating.
Working With Units and Multiple Periods
Data may be reported in thousands, or by accident period, policy period, or another grouping. The relationship is unchanged, but the units and period labels must be preserved. In particular, payments made in a calendar year are not automatically the cumulative paid amount for an accident-year cohort. The amounts must be selected for the same defined group.
Worked Example: Aggregate Liability From Amounts in Thousands
A hypothetical commercial insurer has selected the following ultimate and cumulative paid losses at the same valuation date. Amounts are in thousands of dollars and refer to the same loss components and gross basis in each row.
| Claim group | Ultimate (thousands) | Cumulative paid (thousands) |
|---|---|---|
| Group X | 475 | 392 |
| Group Y | 690 | 514 |
| Group Z | 335 | 248 |
Calculate the unpaid loss by group and in total, and report the total in dollars.
Method. Subtract cumulative paid loss from selected ultimate loss for each group. Keep the calculations in thousands until converting the final aggregate.
Group X: \(475-392=83\) thousand dollars unpaid.
Group Y: \(690-514=176\) thousand dollars unpaid.
Group Z: \(335-248=87\) thousand dollars unpaid.
The total unpaid amount is \(83+176+87=346\) thousand dollars. As a cross-check, total ultimate is \(475+690+335=1{,}500\) thousand dollars, and total paid is \(392+514+248=1{,}154\) thousand dollars. Their difference is \(1{,}500-1{,}154=346\) thousand dollars, or $346,000.
Common mistake avoided. The table is stated in thousands, so the total difference of 346 is not $346. Converting units at the end gives $346,000.
How the Liability Changes Between Valuation Dates
The unpaid amount can change because payments are made, because the selected ultimate is revised, or both. Suppose the selected ultimate at a later valuation date is \(U_2\), the cumulative paid amount then is \(P_2\), and the earlier amounts are \(U_1\) and \(P_1\). Since unpaid loss is ultimate less cumulative paid at each date, the change in unpaid loss is:
This identity helps distinguish a payment from a change in the estimate. A payment increases cumulative paid loss and, all else equal, reduces unpaid loss. An increase in selected ultimate increases unpaid loss if paid loss is unchanged. The two effects can occur together.
Worked Example: Reconciling Two Valuation Dates
For a hypothetical group of claims, the selected ultimate loss at March 31 is $1,780,000 and cumulative paid loss is $1,105,000. At June 30, the selected ultimate is revised to $1,825,000, while cumulative paid loss has increased to $1,246,000. Calculate unpaid loss at both dates and explain the change.
Method. Calculate the unpaid amount independently at each valuation date, then reconcile the change using the movement in ultimate and cumulative paid loss.
At March 31:
At June 30:
The unpaid loss decreased by \( \$579{,}000-\$675{,}000=-\$96{,}000\). During the interval, selected ultimate increased by \( \$1{,}825{,}000-\$1{,}780{,}000=\$45{,}000\), while cumulative paid increased by \( \$1{,}246{,}000-\$1{,}105{,}000=\$141{,}000\). Therefore:
The reconciliation agrees with the direct calculations. The larger increase in cumulative payments than in selected ultimate explains the reduction in unpaid loss.
Common mistake avoided. The $141,000 increase in paid loss is not itself the change in the liability. The ultimate estimate also changed, so both movements must be included in the reconciliation.
Interpretation and Common Traps
A selected unpaid amount is a liability estimate at a particular valuation date. It is not the amount expected to be paid during the next period: it includes all loss still unpaid at the valuation date, even if some payments will occur much later. Nor is it necessarily a final known amount; if the ultimate estimate changes, the calculated unpaid amount changes as well.
The relationship also does not turn an inconsistent subtraction into a meaningful estimate. For example, subtracting calendar-year payments from an accident-year ultimate may be wrong if those payments include claims from other accident years or omit payments made earlier on the accident-year claims. A useful check is to state the period and basis in words before doing the arithmetic.
- Use cumulative paid loss. Do not substitute payments made during only the latest month or year.
- Match the scope. Pair the paid and ultimate amounts for the same claim group or period.
- Match the measurement basis. Do not subtract net paid amounts from a gross ultimate, or mix included and excluded loss components.
- Keep valuation dates clear. A paid amount is cumulative only through its stated valuation date.
- Check the result. On a consistent basis, unpaid loss equals ultimate less paid loss; equivalently, paid plus unpaid must equal ultimate.
This basic reconciliation is aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus. It provides a foundation for interpreting claim liability estimates without confusing a selected total ultimate with amounts already paid.
Check Your Understanding
For each question, use the stated valuation date and basis, and check the result by adding paid and unpaid loss.
- A hypothetical claim group has selected ultimate loss of $875,000 and cumulative paid loss of $526,400 at September 30. What is its unpaid loss? (Answer: $348,600)
- At a valuation date, a hypothetical portfolio has two groups on the same basis. Group A has ultimate loss of $1,460,000 and paid loss of $635,000; Group B has ultimate loss of $720,000 and paid loss of $284,000. Find total unpaid loss. (Answer: $1,261,000)
- Amounts are in thousands of dollars. For three hypothetical accident-period groups, ultimate losses are 420, 310, and 180; cumulative paid losses are 375, 226, and 95, respectively. Find the aggregate unpaid loss in dollars. (Answer: $214,000)
- At the first valuation date, a hypothetical claim group has ultimate loss of $2,400,000 and cumulative paid loss of $1,650,000. At the next date, selected ultimate is $2,470,000 and cumulative paid is $1,820,000. Calculate unpaid loss at both dates and its change. (Answer: $750,000 initially, $650,000 later, a decrease of $100,000)
- A hypothetical claim group has ultimate loss of $1,125,000 at December 31. Cumulative paid loss at that same date is $438,000. During the next calendar year, $126,000 is paid and the selected ultimate is unchanged. What is unpaid loss at December 31 of the next year? (Answer: $561,000)