Catastrophe Excess of Loss Across Multiple Claims

Why Catastrophe Losses Must Be Aggregated

A single catastrophe can generate claims under many policies. A catastrophe excess of loss treaty typically responds to the combined covered loss from a defined event, rather than treating each policy claim as a separate attachment test. The key calculation is therefore to identify which losses belong to the event, determine the covered amount for each, and aggregate those amounts before applying the treaty retention and limit.

This calculation answers two different questions: how much does the reinsurer pay for the event, and how much covered loss remains with the cedent after that recovery? The event definition and covered-loss wording come from the contract. The calculations below assume the claims are all covered, are assigned to the stated event, and are subject to a single event retention and limit. Actual treaty wording may specify different terms.

Definition: Let $C_i$ be the covered amount for claim $i$ after applying any relevant policy terms, and let $Z=\sum_i C_i$ be the total covered loss attributed to one catastrophe event. For an event excess of loss layer with retention $R$ and maximum recovery $L$, the treaty recovery is $Y=\min(\max(Z-R,0),L)$. The cedent’s net covered loss is $N=Z-Y$. A layer described as “$L$ excess of $R$” has a retention of $R$ and a maximum recovery of $L$.

The retention is the cedent’s first-loss amount for the event under the treaty. The limit $L$ is the most the reinsurer can pay for that event under the layer; it is not the total loss level at which the layer ends. The layer attaches at $R$ and is exhausted at $R+L$. In this tutorial, “event loss” means the sum of the covered amounts in the stated event, not necessarily the total economic damage caused by the catastrophe.

Calculate in the Right Order

The general sequence is to establish the loss amount that the cedent is responsible for under the underlying policies, group the relevant claims by event, and only then apply the event retention and treaty limit. A policy deductible, if applicable, is applied according to the policy terms to the relevant claim; it is not automatically the same thing as the catastrophe treaty retention.

Determine covered claim amounts.
Apply relevant policy terms to each claim to obtain $C_i$. Do not include amounts that are not covered by the treaty unless the contract says otherwise.

Aggregate by event.
For the event being tested, calculate $Z=\sum_i C_i$. Do not combine claims from distinct events merely because they occur in the same year.

Apply the event layer.
Calculate the amount above the retention, $\max(Z-R,0)$, and cap it at the event limit $L$.

Reconcile the cedent’s amount.
Subtract the treaty recovery from the covered event loss: $N=Z-Y$.

Why the Recovery Formula Works

Before the event loss reaches the retention, the layer has not attached, so it pays zero. Once the event loss exceeds $R$, the amount above the retention is $Z-R$. That amount is the recovery only while it is no greater than the treaty limit. If it exceeds $L$, the treaty pays at most $L$. These conditions give the formula directly:

Y = \begin{cases} 0, & Z \le R,\\ Z-R, & R < Z < R+L,\\ L, & Z \ge R+L. \end{cases}

The cases meet consistently at their boundaries: at $Z=R$, recovery is zero; at $Z=R+L$, recovery is $L$. Since the cedent’s covered loss is divided between what the treaty reimburses and what it retains, $Z=N+Y$, or equivalently $N=Z-Y$. This net amount includes the retained loss below the treaty retention and any amount above the treaty’s exhausted layer.

Worked Example: Six Claims From One Catastrophe

A hypothetical windstorm produces covered claims of $1,200,000, $2,000,000, $1,600,000, $1,200,000, $2,000,000, and $1,600,000 across six policies. All six are assigned to one event. The catastrophe treaty is $3,000,000 excess of $2,000,000 per event. Calculate the event recovery and cedent net covered loss.

Method. Aggregate the covered claims for the event first. Then apply the $2,000,000 event retention and cap the recovery at $3,000,000.

Step 1: Aggregate the claims. The total is $1,200,000+2,000,000+1,600,000+1,200,000+2,000,000+1,600,000 =9,600,000$. Thus $Z=\$9,600,000$.

Step 2: Calculate the amount above retention. $Z-R=\$9,600,000-\$2,000,000=\$7,600,000$.

Step 3: Apply the treaty limit. The uncapped amount of $7,600,000 exceeds the $3,000,000 limit, so $Y=\min(\$7,600,000,\$3,000,000)=\$3,000,000$.

Step 4: Calculate net loss. $N=Z-Y=\$9,600,000-\$3,000,000=\$6,600,000$. The reconciliation checks: $\$3,000,000+\$6,600,000=\$9,600,000$.

Common mistake avoided. Applying the $2,000,000 retention separately to each policy claim would produce no recovery: none of the individual claims exceeds $2,000,000. That is not the stated event-based cover. The six claims first combine into a $9,600,000 event loss, which exhausts this layer.

Separate Policy Terms From Treaty Terms

The amounts aggregated for the treaty may already reflect policy-level deductibles, limits, or other coverage terms. Those adjustments are distinct from the treaty’s event retention. Keeping them separate prevents deducting the same amount twice or treating a policy deductible as though it were one event-level treaty retention.

Worked Example: Policy Deductibles Before Event Aggregation

A hypothetical flood event generates gross claims of $1,200,000, $2,000,000, and $1,600,000. Each policy has a $200,000 deductible, and all remaining amounts are covered and subject to one catastrophe layer of $1,000,000 excess of $2,500,000 per event. Find the treaty recovery and the cedent’s net covered loss.

Method. Apply each policy deductible to its own claim to find the covered claim amounts. Then aggregate those amounts and apply the catastrophe layer.

Step 1: Find the covered amount for each claim. The three amounts are $1,200,000-200,000=\$1,000,000$, $2,000,000-200,000=\$1,800,000$, and $1,600,000-200,000=\$1,400,000$.

Step 2: Aggregate covered losses. $Z=\$1,000,000+\$1,800,000+\$1,400,000=\$4,200,000$.

Step 3: Apply the retention and limit. The amount above the $2,500,000 retention is $\$4,200,000-\$2,500,000=\$1,700,000$. The recovery is capped at $1,000,000, so $Y=\min(\$1,700,000,\$1,000,000)=\$1,000,000$.

Step 4: Calculate the cedent’s net covered loss. $N=\$4,200,000-\$1,000,000=\$3,200,000$. The covered-loss reconciliation is $\$1,000,000+\$3,200,000=\$4,200,000$. The three policy deductibles total $600,000, so the full gross-claim reconciliation is $\$600,000+\$1,000,000+\$3,200,000=\$4,800,000$, equal to the gross claims.

Common mistake avoided. The $200,000 policy deductible is applied three times, once to each claim, before aggregation. It is not subtracted once from the event total as a substitute for the $2,500,000 treaty retention.

Recognize When the Layer Is Partly or Fully Used

The event loss can be below the attachment point, within the layer, or high enough to exhaust it. Checking which case applies before calculating the net amount is a useful way to catch a mistaken limit interpretation. If $Z\le R$, the cedent retains all of $Z$. If $R<Z<R+L$, the recovery is $Z-R$, leaving the cedent with $R$. If $Z\ge R+L$, the recovery is capped at $L$, and the cedent retains $Z-L$.

Worked Example: A Layer Reached and Exhausted

A hypothetical earthquake produces covered losses of $2,400,000, $1,900,000, and $3,200,000 under three policies. One event catastrophe treaty provides $4,000,000 excess of $2,000,000. Calculate recovery and net covered loss, and state whether the layer is exhausted.

Method. Sum the covered event claims and compare the event total with both the attachment point and exhaustion point.

Step 1: Aggregate the event loss. $Z=\$2,400,000+\$1,900,000+\$3,200,000=\$7,500,000$.

Step 2: Find the layer’s exhaustion point. $R+L=\$2,000,000+\$4,000,000=\$6,000,000$. Since $Z=\$7,500,000$ is greater than $6,000,000, the layer is exhausted.

Step 3: Calculate recovery. The amount above the retention is $\$7,500,000-\$2,000,000=\$5,500,000$, which exceeds the limit. Therefore $Y=\$4,000,000$.

Step 4: Calculate net loss and check. $N=\$7,500,000-\$4,000,000=\$3,500,000$. The cedent retains the first $2,000,000 and the $1,500,000 above the exhausted layer; together these equal $3,500,000. Adding the $4,000,000 recovery gives the original $7,500,000 event loss.

Common mistake avoided. The cedent does not retain only the $2,000,000 attachment amount once the layer is exhausted. It also retains the loss above the layer’s top, which here is $\$7,500,000-\$6,000,000=\$1,500,000$.

Common Exam Traps and Practical Checks

Applying the retention to each claim. For event cover, aggregate the claims assigned to the event before testing attachment.
Using the limit as the layer’s top. A limit of $L$ above retention $R$ means exhaustion at $R+L$, not at $L$.
Confusing gross claims and covered losses. First apply relevant policy terms to find covered claim amounts; then aggregate those amounts for the treaty.
Combining different events without contractual authority. An event-based layer is tested separately for each defined event. The fact that losses occur in the same year does not by itself make them one event.
Failing to reconcile. For the covered event loss, verify that cedent net loss plus treaty recovery equals the aggregate covered loss.

The calculation matters because a catastrophe can create a substantial event loss even when no individual policy claim reaches the treaty retention. Correct aggregation determines whether the layer attaches and how much of its limit is used. In practice, the contract’s event definition, coverage provisions, and any special terms control which claims enter the calculation; this tutorial assumes those decisions have already been made.

Key takeaway: For a catastrophe excess of loss layer, determine each treaty-eligible claim amount, aggregate claims belonging to the event, calculate the amount above the event retention, cap the recovery at the event limit, and subtract that recovery from the covered event loss.

Check Your Understanding

For each problem, treat the stated claims as covered amounts unless policy deductibles are specified. All dollar amounts are hypothetical.

A single storm produces covered claims of $900,000, $1,400,000, and $2,100,000. The event treaty is $1,500,000 excess of $2,000,000. Find the recovery and cedent net covered loss. (Answer: recovery $1,500,000; net loss $2,900,000.)
One event produces covered claims of $600,000, $800,000, and $1,100,000. The treaty is $2,000,000 excess of $3,000,000 per event. Find the recovery and net loss. (Answer: recovery $0; net loss $2,500,000.)
A hypothetical event produces gross claims of $1,000,000, $1,700,000, and $2,300,000. Each policy has a $100,000 deductible. The catastrophe treaty is $1,200,000 excess of $2,500,000. Find the aggregate covered loss, recovery, and cedent net covered loss. (Answer: eligible aggregate $4,700,000; recovery $1,200,000; net loss $3,500,000.)
A single event produces covered claims of $2,300,000, $1,900,000, and $1,200,000. The treaty is $2,500,000 excess of $1,500,000. Determine the layer recovery and cedent net loss. (Answer: recovery $2,500,000; net loss $2,900,000.)
Two distinct events produce covered losses of $3,200,000 and $2,800,000. Each event is subject to a separate $1,000,000 excess of $2,000,000 layer, with no annual aggregate limit or other adjustment. Find the combined recovery and combined cedent net loss. (Answer: combined recovery $1,800,000; combined net loss $4,200,000.)

What You'll Learn