Why Aggregate Covers Require a Different Calculation
A reinsurance contract may respond to an individual claim, an occurrence, or the total covered losses over a defined period. An aggregate excess-of-loss or stop-loss cover uses the last of these bases: the insurer first combines the contractually defined subject losses for the period, then compares that annual total with an attachment point. A year containing many moderate claims can therefore trigger a recovery even when no individual claim is large.
The calculation depends on the treaty’s wording. In particular, distinguish the attachment point, the percentage of excess loss covered, and the limit. A limit may cap the reinsurer’s payment, or it may specify the maximum width of loss above the attachment to which a percentage applies. Those descriptions do not always produce the same recovery.
The \(X_j\) values must reflect the treaty’s definition of subject loss. For example, wording may specify whether losses are gross or net of other recoveries, which policies are included, and how the treaty year is determined. Do not substitute a portfolio’s total reported claims for \(S\) without checking that they are all treaty-subject losses.
Aggregate Excess-of-Loss Calculation
When a treaty covers a percentage \(c\) of all annual subject loss above attachment \(A\), subject to an annual limit \(M\) on the reinsurer’s payment, calculate:
Here \(R\) is the annual recovery. The positive-part term \(\max(S-A,0)\) makes the recovery zero when the annual total does not exceed the attachment. If there is no stated recovery cap, omit \(M\). If the wording instead defines a maximum covered-loss layer of width \(L\), then the recovery before any additional payment cap is \(c\min(\max(S-A,0),L)\). Read the limit provision carefully: a payment cap and a layer-width limit are different terms.
Why the Recovery Formula Works
The treaty responds only to the part of annual subject loss above the attachment. If \(S\le A\), there is no excess to cover, so the eligible excess is zero. If \(S>A\), the eligible excess is \(S-A\). Both cases are represented by \(\max(S-A,0)\). The reinsurer pays fraction \(c\) of that eligible excess, but cannot pay more than the annual recovery limit \(M\). Taking the smaller of the uncapped payment and \(M\) gives the formula.
This is a contractual calculation, not a probability model: the formula determines the recovery for a given realized annual total. Estimating an expected recovery would require additional assumptions about the distribution of annual losses; those assumptions are not needed to calculate a recovery from known losses.
Worked Example: Applying One Attachment to the Annual Total
A hypothetical insurer has four treaty-subject losses during a year: $1.2 million, $0.8 million, $2.1 million, and $1.4 million. An aggregate excess-of-loss treaty attaches at $4.0 million and pays 100% of annual excess, up to a $1.0 million annual recovery limit. Calculate the recovery and the insurer’s net subject loss after this recovery.
Method. Aggregate the subject losses first, then apply the annual attachment, covered percentage, and payment cap.
Step 1: Calculate annual subject loss. In millions of dollars, \(S=1.2+0.8+2.1+1.4=5.5\).
Step 2: Calculate excess above attachment. \(S-A=5.5-4.0=1.5\) million. Since \(S>A\), the eligible excess is $1.5 million.
Step 3: Apply the covered percentage and annual limit. The uncapped payment is \(1.00\times1.5=1.5\) million. The annual limit is $1.0 million, so \(R=\min(1.0,1.5)=1.0\) million.
Step 4: Calculate net subject loss. \(5.5-1.0=4.5\) million remains with the insurer. The recovery is positive, does not exceed the $1.0 million cap, and is no greater than the $1.5 million excess available.
Common mistake avoided: applying the $4.0 million attachment separately to each claim would produce no recovery because every individual loss is below $4.0 million. That is a per-claim calculation, not this annual aggregate calculation.
Covered Percentages and Different Meanings of “Limit”
A covered percentage changes the reinsurer’s share of eligible loss; it does not change the annual attachment unless the treaty specifically says otherwise. Also identify what the limit caps. The following two structures are distinct.
| Treaty wording in substance | Recovery calculation | Meaning of limit |
|---|---|---|
| Pay \(c\) of annual excess above \(A\), subject to payment cap \(M\) | \(\min(M,c\max(S-A,0))\) | Maximum amount the reinsurer pays |
| Pay \(c\) of the first \(L\) dollars of annual excess above \(A\) | \(c\min(\max(S-A,0),L)\) | Maximum excess-loss layer width before applying \(c\) |
If both a layer-width limit \(L\) and a payment cap \(M\) apply, the general calculation is \(R=\min(M,c\min(\max(S-A,0),L))\). Use this only when the wording actually specifies both restrictions. If the percentage is applied to a different base, such as a defined loss ratio excess, follow that definition rather than assuming it applies to the entire excess.
Worked Example: Applying Coinsurance and a Payment Cap
A hypothetical agricultural insurer reports annual treaty-subject losses of $2.4 million, $1.7 million, $2.0 million, $1.3 million, and $1.1 million. The treaty pays 80% of aggregate subject loss above $5.0 million, subject to a $2.4 million annual cap on the reinsurer’s payment. Find the recovery and the insurer’s net subject loss.
Method. Treat $2.4 million as a cap on payment, not as the width of the covered loss layer.
Step 1: Aggregate the losses. \(S=2.4+1.7+2.0+1.3+1.1=8.5\) million.
Step 2: Find excess above attachment. \(8.5-5.0=3.5\) million.
Step 3: Apply the covered percentage. The uncapped recovery is \(0.80\times3.5=2.8\) million.
Step 4: Apply the annual payment cap. \(R=\min(2.4,2.8)=2.4\) million.
Step 5: Calculate net subject loss. \(8.5-2.4=6.1\) million remains with the insurer. The calculation respects the cap; the uncapped amount exceeds it by $0.4 million.
Common mistake avoided: multiplying the $2.4 million cap by 80% would treat the payment cap as though it were a layer-width limit. The treaty states a maximum payment, so the correct cap is $2.4 million, not \(0.80\times2.4\).
Stop-Loss Covers With a Loss-Ratio Attachment
A stop-loss treaty commonly sets its attachment as a percentage of a specified premium base. If the contract attaches when the annual loss ratio exceeds \(r\), and the defined premium base is \(P\), the dollar attachment is \(A=rP\). The loss ratio used in this calculation must use the treaty’s specified loss and premium definitions; an earned-premium denominator, for example, should not be replaced with written premium without contractual support.
This formula assumes the treaty pays percentage \(c\) of the dollar amount by which subject loss exceeds \(rP\), with \(M\) limiting the reinsurer’s annual payment. A treaty may define the loss ratio differently or describe a covered loss-ratio band; in that case, translate its exact terms into a dollar layer before calculating.
Worked Example: Stop-Loss Attachment Based on Earned Premium
A hypothetical insurer has $8.0 million of earned premium for a treaty year and $7.9 million of subject losses. Its stop-loss cover attaches at a 75% loss ratio, pays 90% of excess losses, and has a $1.5 million annual payment limit. Assume the treaty defines its loss ratio using these earned premiums and subject losses. Calculate the recovery and the insurer’s net subject losses.
Method. Convert the loss-ratio attachment into dollars, then apply the covered percentage and annual payment cap.
Step 1: Convert the threshold to a dollar attachment. \(A=0.75\times8.0=6.0\) million.
Step 2: Calculate excess subject loss. \(S-A=7.9-6.0=1.9\) million.
Step 3: Apply the 90% covered percentage. The uncapped recovery is \(0.90\times1.9=1.71\) million.
Step 4: Apply the annual payment limit. \(R=\min(1.5,1.71)=1.5\) million.
Step 5: Calculate net subject losses. \(7.9-1.5=6.4\) million remains with the insurer. The payment cap binds because the uncapped amount is $0.21 million greater than the limit.
Common mistake avoided: applying 75% directly to the $7.9 million loss total would not calculate a loss-ratio attachment. The 75% threshold applies to the $8.0 million premium base, giving a $6.0 million attachment.
A Reliable Calculation Sequence
The order below keeps annual aggregation, threshold conversion, and contractual caps separate. It is especially useful when a problem provides many claim amounts and multiple treaty terms.
Identify which losses enter the treaty and which treaty year they belong to. Sum only the covered items to obtain \(S\).
Use the stated dollar attachment, or calculate \(A=rP\) if the attachment is a percentage of a specified premium base.
Calculate \(\max(S-A,0)\). This prevents a negative recovery when the annual loss total is below attachment.
Multiply by \(c\), limit the covered loss layer if a layer width is stated, and apply any cap on the reinsurer’s payment.
The recovery cannot be negative, cannot exceed an applicable payment cap, and cannot exceed the covered share of eligible loss.
Common Exam Traps and Checks
- Applying the attachment to each claim. Aggregate covers use the annual total \(S\). Do not calculate \(\sum_j\max(X_j-A,0)\) unless the treaty explicitly has a per-claim attachment.
- Subtracting the attachment more than once. First sum subject losses, then subtract the annual attachment once. The attachment is not a deductible for every loss item.
- Confusing a payment cap with a layer width. A payment cap applies after the covered percentage; a loss-layer width limits the excess amount before applying that percentage.
- Using the wrong premium measure. A percentage-of-premium threshold requires the premium base named in the contract. Mixing written and earned premium changes the dollar attachment.
- Combining separate treaty years. If the attachment and limit reset annually, calculate each year separately. An unused limit in one year does not automatically transfer to another.
Check Your Understanding
For each hypothetical treaty, calculate the recovery using the stated subject losses and contract terms.
- A treaty pays 100% of annual subject loss above $3.2 million, with a $0.7 million annual payment cap. Subject losses are $0.9 million, $1.4 million, and $1.8 million. What is the recovery? (Answer: $0.70 million.)
- A treaty pays 75% of annual excess above $4.5 million, subject to a $1.5 million payment cap. Annual subject losses are $1.2 million, $1.6 million, $2.0 million, and $1.4 million. What is the recovery? (Answer: $1.275 million.)
- A stop-loss treaty attaches at 65% of $12.0 million earned premium, pays 80% of excess losses, and has a $1.1 million annual payment cap. Subject losses are $9.0 million. What is the recovery? (Answer: $0.960 million.)
- A treaty pays 70% of the first $2.0 million of annual excess above $2.5 million, subject to a separate $1.2 million annual payment cap. Annual subject loss is $4.0 million. What is the recovery? (Answer: $1.05 million.)
- An annual treaty attaches at $4.0 million and pays 100% of excess, up to $0.75 million per year. Year 1 subject losses total $4.5 million and Year 2 losses total $6.0 million. What is the combined recovery across both years if the treaty limits reset annually? (Answer: $1.25 million.)