Aggregate Deductibles and Excess-Loss Payments

Why the Aggregate Attachment Matters

A deductible can apply to each claim separately or to the total covered losses over a specified period. Those contract designs can produce different payments from the same set of claims. With an aggregate deductible, the losses are first combined; the attachment is then applied once to that aggregate. This makes the order of calculation essential.

This tutorial focuses on calculating payments for a specified aggregate loss. It does not require a probability model for the losses: once the aggregate amount is known, the payment follows directly from the contract terms. The same calculation can also be applied separately to each possible outcome when aggregate loss is uncertain.

Definition: Let $S$ be the aggregate covered loss over the contract period, and let $d\geq 0$ be an aggregate deductible or attachment. The payment above the attachment is $(S-d)^+=\max(S-d,0)$. If an insurer pays only the amount above the policyholder's aggregate deductible, this is the insurer's payment. If a reinsurer covers the insurer's losses above its aggregate retention $d$, this is the reinsurer's recovery, subject to the treaty terms.

The notation $(x)^+$ means the positive part of $x$: it equals $x$ when $x>0$, and equals zero when $x\leq 0$. In particular, when $S=d$, the payment is zero. The attachment is not itself an additional payment; it is the amount of aggregate loss that must be reached before any payment above it begins.

Payment and Retention in an Unlimited Cover

For an unlimited aggregate excess-of-loss arrangement with attachment $d$, the amount above the attachment is $(S-d)^+$. The part of the aggregate retained below or at the attachment is $\min(S,d)$, assuming $S\geq0$. These amounts partition the aggregate loss:

S=\min(S,d)+(S-d)^+.

This identity provides a useful check. If the contract is a reinsurance treaty, the insurer initially faces gross losses $S$, receives a recovery of $(S-d)^+$, and has net loss $\min(S,d)$, assuming there are no other contract terms, expenses, or recoveries. If instead the deductible is in a policy between the insurer and the policyholder, the policyholder bears $\min(S,d)$ and the insurer pays $(S-d)^+$. The numerical layer calculation is the same, but the parties and the meaning of “retained” differ.

Assumptions for the basic formula: $S$ is the aggregate of covered losses for the stated period, $d$ is a nonnegative attachment applied once to that aggregate, and the cover above $d$ has no payment cap or coinsurance. If a contract has exclusions, a cap, coinsurance, or a different aggregation period, the basic formula alone does not describe its full payment.

Why the Positive-Part Formula Works

The formula follows directly from the two possible relationships between the aggregate loss and the attachment. If the aggregate does not reach the attachment, there is no amount above it. If the aggregate exceeds the attachment, the payment is the difference.

When $S\leq d$.
The excess above the attachment is not positive, so $\max(S-d,0)=0$. The entire loss $S$ is retained below the attachment.

When $S>d$.
The amount above the attachment is $S-d$, so $\max(S-d,0)=S-d$. The retained part is $d$.

Combine the cases.
The payment is $(S-d)^+$ in both cases, and the retained part is $\min(S,d)$. Adding them gives $S$, confirming that the loss is fully allocated.

The identity also explains why the attachment must be applied at the correct level. The aggregate formula uses the sum of covered losses as $S$; it does not apply $d$ separately to each claim.

Worked Example: One Aggregate Deductible on Several Claims

A hypothetical insurer has an unlimited aggregate excess-of-loss treaty with an annual retention of $d=\$50{,}000$. During the year, three covered claims are $\$12{,}800$, $\$19{,}600$, and $\$33{,}250$. Calculate the aggregate loss, the reinsurer's recovery, and the insurer's net retained loss.

Method. Add the covered claims to obtain the annual aggregate, then apply the attachment once. This avoids treating the treaty retention as a per-claim deductible.

First calculate the aggregate:

S=\$12{,}800+\$19{,}600+\$33{,}250=\$65{,}650.

Since $S>d$, the reinsurer pays the amount above the retention:

(S-d)^+=\max(\$65{,}650-\$50{,}000,0)=\$15{,}650.

The insurer's net retained loss is:

\min(S,d)=\min(\$65{,}650,\$50{,}000)=\$50{,}000.

Check. The retained loss and recovery add back to the aggregate: $\$50{,}000+\$15{,}650=\$65{,}650=S$. The method avoids subtracting the treaty retention from each claim individually.

Applying the Attachment to the Aggregate, Not Each Claim

The difference between an aggregate deductible and a per-claim deductible can be substantial. With an aggregate deductible, smaller claims can combine to push the total above the attachment. A per-claim deductible instead tests each claim separately. Unless the contract says otherwise, do not change an aggregate attachment into a separate deductible for every loss.

Worked Example: Several Claims Below the Attachment Individually

A hypothetical reinsurer covers an insurer's annual aggregate losses above $d=\$45{,}000$, with no cap. Four covered claims during the year are $\$8{,}500$, $\$14{,}250$, $\$21{,}000$, and $\$6{,}250$. Find the treaty recovery and the insurer's retained loss.

Method. Sum the annual claims first. The common mistake to avoid is testing each claim against the full annual attachment.

The aggregate loss is:

S=\$8{,}500+\$14{,}250+\$21{,}000+\$6{,}250=\$50{,}000.

Apply the attachment once:

(S-d)^+=\max(\$50{,}000-\$45{,}000,0)=\$5{,}000.

The insurer retains:

\min(S,d)=\min(\$50{,}000,\$45{,}000)=\$45{,}000.

Check. $\$45{,}000+\$5{,}000=\$50{,}000$, equal to the aggregate loss. If the attachment were incorrectly applied claim by claim, each claim would be below $\$45{,}000$ and the calculated recovery would be zero. That is not the stated aggregate treaty.

Boundary Cases and Payment Schedules

Three cases are worth checking explicitly: an aggregate below the attachment, one exactly at the attachment, and one above it. Below or at $d$, the payment is zero; above $d$, it is the excess. A table of scenarios should apply the same rule to each scenario separately, rather than combining losses from different possible outcomes.

Aggregate loss $S$	Payment above attachment	Amount retained below attachment
$S<d$	$0$	$S$
$S=d$	$0$	$d$
$S>d$	$S-d$	$d$

Worked Example: Reinsurer Recoveries Across Three Scenarios

A hypothetical insurer has a treaty that reimburses aggregate covered losses above an annual retention of $d=\$80{,}000$, without a cap. Calculate the reinsurer's payment and the insurer's net loss in each of these possible scenarios:

Scenario A: claims of $\$22{,}000$, $\$31{,}000$, and $\$27{,}000$.
Scenario B: claims of $\$35{,}000$, $\$28{,}000$, and $\$41{,}000$.
Scenario C: claims of $\$56{,}000$, $\$49{,}000$, and $\$33{,}000$.

Method. For each scenario, find its own aggregate $S$, then calculate $(S-d)^+$ and $\min(S,d)$. The common mistake to avoid is adding losses from different scenarios together; they are alternatives, not simultaneous claim sets.

Scenario A. The aggregate is $\$22{,}000+\$31{,}000+\$27{,}000=\$80{,}000$. It is exactly at the attachment, so the recovery is $\max(\$80{,}000-\$80{,}000,0)=\$0$. The insurer retains $\min(\$80{,}000,\$80{,}000)=\$80{,}000$.

Scenario B. The aggregate is $\$35{,}000+\$28{,}000+\$41{,}000=\$104{,}000$. The recovery is $\max(\$104{,}000-\$80{,}000,0)=\$24{,}000$. The insurer retains $\min(\$104{,}000,\$80{,}000)=\$80{,}000$.

Scenario C. The aggregate is $\$56{,}000+\$49{,}000+\$33{,}000=\$138{,}000$. The recovery is $\max(\$138{,}000-\$80{,}000,0)=\$58{,}000$. The insurer retains $\min(\$138{,}000,\$80{,}000)=\$80{,}000$.

Check. In A, $0+\$80{,}000=\$80{,}000$; in B, $\$24{,}000+\$80{,}000=\$104{,}000$; and in C, $\$58{,}000+\$80{,}000=\$138{,}000$. In each scenario, the insurer's retained loss plus the reinsurer's recovery equals that scenario's aggregate.

Common Errors to Avoid

Applying the attachment per claim. For an aggregate deductible, sum the covered losses for the contract period before applying $d$.
Paying the attachment amount as well as the excess. If $S=\$92{,}000$ and $d=\$70{,}000$, the amount above the attachment is $\$22{,}000$, not $\$92{,}000$ and not $\$70{,}000+\$22{,}000$.
Forgetting the zero-payment case. When $S\leq d$, the payment above the attachment is zero, including when $S=d$.
Confusing gross payment with net retained loss. In reinsurance, $(S-d)^+$ is the recovery under the stated unlimited treaty, while $\min(S,d)$ is the insurer's net retained loss under the simplified assumptions used here.
Ignoring contract wording. The aggregation period and definition of covered loss determine $S$. A deductible applying per claim, per event, or to a different period is not automatically an annual aggregate deductible.

Key takeaway: First determine the covered aggregate $S$ for the contract period. Then calculate the payment above an aggregate attachment as $(S-d)^+$, and check the allocation using $S=\min(S,d)+(S-d)^+$.

Check Your Understanding

For each problem, apply the attachment to the stated aggregate, not separately to individual losses unless the question explicitly says otherwise.

A hypothetical treaty has an aggregate retention of $\$40{,}000$. Covered claims are $\$17{,}400$, $\$22{,}600$, and $\$9{,}000$. Find the reinsurer's recovery and insurer's net retained loss. (Answer: Recovery $\$9{,}000$; retained loss $\$40{,}000$.)
A policy has an aggregate deductible of $\$73{,}000$, and the covered annual aggregate is exactly $\$73{,}000$. How much does the insurer pay above the deductible? (Answer: $\$0$.)
A hypothetical reinsurance contract covers aggregate losses above $\$55{,}000$. The three covered claims are $\$16{,}000$, $\$24{,}000$, and $\$31{,}000$. Calculate the recovery and retained loss, and check their sum. (Answer: Recovery $\$16{,}000$; retained loss $\$55{,}000$; sum $\$71{,}000$.)
An insurer has an unlimited aggregate treaty with retention $\$90{,}000$. In one scenario, claims are $\$44{,}000$, $\$39{,}000$, and $\$32{,}000$. Find the aggregate, recovery, and insurer's net retained loss. (Answer: Aggregate $\$115{,}000$; recovery $\$25{,}000$; retained loss $\$90{,}000$.)
A hypothetical policy pays covered annual aggregate losses above a policyholder deductible of $\$125{,}000$. The covered losses total $\$212{,}000$. Find the insurer's payment and the amount borne by the policyholder, assuming no cap or other adjustment. (Answer: Insurer pays $\$87{,}000$; policyholder bears $\$125{,}000$.)

Aggregate loss \(S\)	Payment above attachment	Amount retained below attachment
\(S<d\)	\(0\)	\(S\)
\(S=d\)	\(0\)	\(d\)
\(S>d\)	\(S-d\)	\(d\)

What You'll Learn