Why Integrated Reserving Requires a Consistent Loss Basis
A catastrophe reserve estimate can involve several calculations that must fit together: projecting gross ultimate losses by event, applying the treaty terms to those losses, estimating the recoveries already paid, and determining the remaining recoverable. A correct treaty calculation on the wrong loss basis can still produce an incorrect net liability.
The central control is a reconciliation. For a defined group of claims and a consistent valuation date, gross unpaid losses less outstanding ceded recoverables equal net unpaid losses, provided the ceded amounts are fully collectible and no other adjustments are being made. The calculations below use hypothetical catastrophe programs and assume full collectibility unless stated otherwise.
Build the Estimate in a Controlled Sequence
An integrated estimate should preserve the same event definitions, valuation date, and loss basis throughout. In particular, an event-level treaty should generally be applied to the projected ultimate loss for each covered occurrence, not to a portfolio total that combines unrelated events. If treaties inure in sequence, calculate the loss subject to each later treaty only after applying the earlier treaty as required by the contract.
For each event, combine gross paid loss, case outstanding, and the selected estimate of additional unreported or future loss. Keep the event grouping consistent with the coverage definition.
Calculate recoveries event by event using each attachment point and limit. Then apply inuring provisions and annual aggregate limits in their contractual order.
Subtract paid gross losses from gross ultimate losses, and subtract paid ceded recoveries from ultimate ceded recoveries.
Compare gross unpaid loss less outstanding ceded recoverables with gross ultimate loss less ultimate ceded recovery, further reduced by net paid loss.
Per-Occurrence Recoveries and Their Rationale
The excess-of-loss formula follows directly from the covered layer. If \(X\le R\), the loss does not reach the attachment point, so the recovery is zero. If \(R<X<R+L\), the loss within the layer is \(X-R\). If \(X\ge R+L\), the layer is exhausted and the recovery cannot exceed \(L\). These cases combine as
This piecewise result is equivalent to the minimum-and-maximum formula in the definition. It also explains a frequent error: subtracting the attachment from the loss is not sufficient when the treaty limit has been reached. The recovery must be capped at \(L\).
Worked Example: Projecting Gross Loss Before Applying a Catastrophe Layer
A hypothetical wind event has gross paid loss of $1,800,000, case outstanding of $900,000, and selected additional IBNR of $600,000. A per-occurrence treaty covers $1,000,000 excess of $1,000,000, with a $1,000,000 limit. Estimate the event's gross ultimate loss, gross unpaid loss, ultimate recovery, and retained ultimate loss.
Method. First build the gross ultimate estimate; then apply the occurrence layer to that event's ultimate loss.
Gross ultimate loss is $$ 1{,}800{,}000+900{,}000+600{,}000=3{,}300{,}000. $$ Gross unpaid loss is ultimate less paid: $$ 3{,}300{,}000-1{,}800{,}000=1{,}500{,}000. $$ The layer attaches at $1,000,000. The loss above attachment is $$ 3{,}300{,}000-1{,}000{,}000=2{,}300{,}000. $$ The treaty limit caps the recovery at $1,000,000: $$ C(3{,}300{,}000)=\min(2{,}300{,}000,1{,}000{,}000)=1{,}000{,}000. $$ Retained ultimate loss is $$ 3{,}300{,}000-1{,}000{,}000=2{,}300{,}000. $$ The check is that retained loss plus ceded recovery equals gross ultimate loss: $2,300,000 + $1,000,000 = $3,300,000. The common mistake is to report the entire $2,300,000 excess above attachment as the recovery, ignoring the limit.
From Ultimate Recovery to Outstanding Recoverable
The ultimate treaty recovery is not itself the outstanding recoverable. Some recovery may already have been collected or otherwise paid. For a given treaty and consistent covered claim group, the basic reserve estimate is
The paid recovery should be taken from the same treaty layer and valuation date as the ultimate estimate. It is not generally valid to calculate paid recoveries by applying a layer formula to total paid losses alone: the allocation of paid amounts to an occurrence layer can depend on claim-level details and payment history. Use actual ceded payment data or a clearly stated allocation assumption.
Worked Example: Reconciling Two Occurrences to Net Unpaid Loss
A hypothetical insurer has two catastrophe occurrences. Event A has $1,200,000 gross ultimate loss and $700,000 gross paid. Event B has $800,000 gross ultimate loss and $300,000 gross paid. Each event is covered by two layers: Layer 1 is $250,000 excess of $250,000; Layer 2 is $500,000 excess of $500,000. Assume the stated gross paid amounts are consistent with the supplied paid recoveries. The ceded recoveries paid are $200,000 on Layer 1 and $150,000 on Layer 2 for Event A, and $150,000 on Layer 1 and $50,000 on Layer 2 for Event B. Estimate outstanding recoverables and net unpaid loss.
Method. Calculate ultimate recoveries by event and layer, subtract the paid recoveries by the same event and layer, and then reconcile to gross unpaid loss.
For Event A, Layer 1 recovery is $$ \min(1{,}200{,}000-250{,}000,250{,}000)=250{,}000. $$ Layer 2 recovery is $$ \min(1{,}200{,}000-500{,}000,500{,}000)=500{,}000. $$ Event A's ultimate ceded recovery is $750,000. Its outstanding recoverables are $250,000 - $200,000 = $50,000 on Layer 1 and $500,000 - $150,000 = $350,000 on Layer 2, totaling $400,000.
For Event B, Layer 1 recovery is $$ \min(800{,}000-250{,}000,250{,}000)=250{,}000. $$ Layer 2 recovery is $$ \min(800{,}000-500{,}000,500{,}000)=300{,}000. $$ Event B's ultimate ceded recovery is $550,000. Its outstanding recoverables are $250,000 - $150,000 = $100,000 on Layer 1 and $300,000 - $50,000 = $250,000 on Layer 2, totaling $350,000.
Across both events, ultimate ceded recovery is $750,000 + $550,000 = $1,300,000, and ceded recovery paid is $200,000 + $150,000 + $150,000 + $50,000 = $550,000. Therefore, the total outstanding ceded recoverable is $1,300,000 - $550,000 = $750,000.
Gross unpaid loss is $1,200,000 - $700,000 + $800,000 - $300,000 = $1,000,000. Net unpaid loss is $$ 1{,}000{,}000-750{,}000=250{,}000. $$ As a second check, total net ultimate loss is $2,000,000 - $1,300,000 = $700,000. Total net paid loss is $1,000,000 - $550,000 = $450,000. Their difference is $700,000 - $450,000 = $250,000, matching the reserve reconciliation. The common mistake is to subtract ultimate ceded recovery from gross unpaid loss; the unpaid liability must be reduced by outstanding, not ultimate, recovery.
Inuring Treaties and Annual Aggregate Limits
Some programs specify that one treaty applies to a loss net of recoveries under another treaty. Such an inuring provision changes the loss basis for the later treaty. An annual aggregate limit adds another constraint: even if occurrence-level calculations produce larger recoveries in total, the ceded amount for the year cannot exceed the stated aggregate cap. Both rules must be applied in the order required by the hypothetical contract.
Worked Example: Applying Inuring Order and an Aggregate Cap
A hypothetical program covers two events with gross ultimate losses of $2,600,000 and $1,400,000. Treaty A provides $500,000 excess of $500,000 per occurrence. Treaty B then applies to the loss net of Treaty A, providing $1,000,000 excess of $1,000,000 per occurrence, subject to a $800,000 annual aggregate limit. Assume chronological allocation of the aggregate cap, with Event 1 first. Gross paid losses are $1,500,000 and $600,000. Ceded recoveries paid are $300,000 and $200,000 under Treaty A for Events 1 and 2, and $250,000 under Treaty B for Event 1 and zero for Event 2. Estimate the outstanding recoverables and net unpaid liability.
Method. Apply Treaty A to gross event losses. Apply Treaty B to the remaining loss, then apply its annual cap. Subtract paid recoveries and reconcile.
For each event, Treaty A recovers its full $500,000 layer: Event 1 loss exceeds $1,000,000, and Event 2 loss is $1,400,000, also exceeding $1,000,000. The losses after Treaty A are $2,600,000 - $500,000 = $2,100,000 for Event 1 and $1,400,000 - $500,000 = $900,000 for Event 2.
Before the aggregate cap, Treaty B's Event 1 recovery is $$ \min(2{,}100{,}000-1{,}000{,}000,1{,}000{,}000)=1{,}000{,}000. $$ Its Event 2 recovery is zero because $900,000 does not reach the $1,000,000 attachment. The raw total is $1,000,000, but the annual aggregate cap is $800,000. Under the stated allocation assumption, Treaty B's capped recovery is $800,000 for Event 1 and zero for Event 2.
Treaty A's ultimate recovery is $500,000 + $500,000 = $1,000,000. Its paid recovery is $300,000 + $200,000 = $500,000, so its outstanding recoverable is $500,000. Treaty B's ultimate recovery is $800,000 and its paid recovery is $250,000, so its outstanding recoverable is $550,000. Total outstanding recoverables are $500,000 + $550,000 = $1,050,000.
Gross ultimate loss is $2,600,000 + $1,400,000 = $4,000,000. Gross paid loss is $1,500,000 + $600,000 = $2,100,000, so gross unpaid loss is $1,900,000. Net unpaid loss is $1,900,000 - $1,050,000 = $850,000.
The cross-check gives the same result: total ultimate ceded recovery is $1,000,000 + $800,000 = $1,800,000, so net ultimate loss is $4,000,000 - $1,800,000 = $2,200,000. Net paid loss is $2,100,000 - ($500,000 + $250,000) = $1,350,000. Thus net unpaid loss is $2,200,000 - $1,350,000 = $850,000. The common mistake is to calculate Treaty B on gross loss without first applying Treaty A, or to omit the annual aggregate cap.
Reconciliation Controls and Common Traps
A reconciliation is more than a final arithmetic check. It can reveal inconsistent event grouping, an omitted treaty limit, a mismatch between paid and ultimate recovery bases, or an aggregate cap applied in the wrong order. For a fully collectible program with no additional adjustments, the identity is
Rearranging shows why the same net amount can be obtained from ultimate and paid values:
When collectibility is less than certain, distinguish the contractual recoverable from any selected collectible amount or allowance. Do not silently treat a collectible estimate as though it were the treaty's gross contractual recovery. The basic reconciliation above assumes that the outstanding contractual recovery is fully available.
- Mixing event and portfolio bases. Apply occurrence terms to the loss for each covered occurrence, then combine results where appropriate.
- Ignoring treaty order. If a later treaty attaches to loss net of an earlier treaty, calculate its subject loss after the earlier recovery.
- Exceeding a limit. Cap each occurrence recovery at its per-occurrence limit and apply any annual aggregate limit as specified.
- Subtracting paid recoveries twice or not at all. Outstanding recoverable is ultimate recovery less ceded recovery paid.
- Using ultimate ceded recovery to reduce unpaid gross loss. Reduce gross unpaid loss by outstanding ceded recoverable, not by recovery already paid.
Check Your Understanding
For each hypothetical case, calculate the requested amount and check that you apply the treaty terms to the stated loss basis.
- An event has $420,000 paid, $180,000 case outstanding, and $100,000 IBNR. It is covered by a $250,000 excess of $250,000 layer with a $250,000 limit. Find gross ultimate loss and ultimate recovery. (Answer: gross ultimate loss $700,000; recovery $250,000.)
- Two occurrences have gross ultimate losses of $1,300,000 and $900,000. Each is covered by a $400,000 excess of $400,000 layer, with a $400,000 per-occurrence limit. Find the total recovery and total retained ultimate loss. (Answer: total recovery $800,000; retained ultimate loss $1,400,000.)
- An event has $1,600,000 ultimate loss and $900,000 paid loss. Its treaty recovery is $500,000, and $260,000 has been paid by the reinsurer. Find gross unpaid loss, outstanding recoverable, and net unpaid loss. (Answer: gross unpaid loss $700,000; outstanding recoverable $240,000; net unpaid loss $460,000.)
- A $1,500,000 event is first covered by a $300,000 excess of $300,000 treaty. A second treaty provides $600,000 excess of $600,000 on loss net of the first treaty. Find each ultimate recovery and the retained ultimate loss. (Answer: first recovery $300,000; second recovery $600,000; retained loss $600,000.)
- Two events have ultimate losses of $2,000,000 and $1,000,000. Each is covered by a $500,000 excess of $500,000 treaty with a $500,000 per-occurrence limit and a $700,000 annual aggregate cap. Allocate the cap chronologically, with the first event first. Find each capped recovery and total retained ultimate loss. (Answer: first recovery $500,000; second recovery $200,000; retained ultimate loss $2,300,000.)