Tutorials › CAS Exam 8 - Advanced Ratemaking › Worked Annual Aggregate Deductible Calculation

CAS Exam 8 · Large Deductible Program Design · Tutorial 653 of 989

Worked Annual Aggregate Deductible Calculation

Learn to track cumulative eligible losses, identify when an annual aggregate deductible is exhausted, and reconcile each claim’s insured and insurer portions.

Intermediate 10 min read

What You'll Learn

  • Define eligible losses and the annual aggregate deductible used in an allocation
  • Calculate each claim’s cumulative eligible loss and remaining deductible
  • Split the claim that exhausts the annual aggregate deductible
  • Reconcile claim-level shares to annual totals
  • Avoid errors involving annual resets and the deductible’s exhaustion point

How an Annual Aggregate Deductible Allocates Losses

An annual aggregate deductible applies to eligible losses over a policy year, rather than restarting at each claim. The insured bears eligible losses as they accumulate toward the deductible. If a claim takes cumulative eligible losses past the deductible, that claim is split: the insured bears the remaining deductible amount, and the insurer bears the balance. Eligible losses after exhaustion are allocated to the insurer, subject to the policy terms.

The calculation is only as reliable as the amount entered for each claim. Here, an eligible loss means the amount to which the annual aggregate deductible applies under the contract. It may already reflect claim-level deductibles, limits, exclusions, or other coverage terms. Do not apply those terms again unless the problem specifically instructs you to do so.

Definition: Let \(D\) be the annual aggregate deductible and let \(L_j\) be the eligible loss for claim \(j\), listed in the order in which the policy allocates the losses. Define cumulative eligible loss through claim \(j\) as \(C_j=\sum_{k=1}^{j}L_k\), with \(C_0=0\). The insured’s share of claim \(j\) is \(R_j=\min(L_j,\max(0,D-C_{j-1}))\). The insurer’s share is \(I_j=L_j-R_j\). Thus, the insured bears eligible losses up to \(D\); the insurer bears eligible losses above \(D\).

This definition assumes a single annual aggregate deductible, no separate cap on the insured’s reimbursement, and no other provision that changes the allocation. If the deductible is not exhausted during the year, the insurer’s share under this allocation is zero. If total eligible loss exceeds the deductible, the insured’s annual share is \(D\), and the insurer’s annual share is the excess.

A Claim-by-Claim Calculation

A convenient way to work is to track the amount of deductible still unexhausted immediately before each claim. For claim \(j\), the insured’s share is the smaller of the eligible claim amount and the remaining deductible. The insurer receives any remainder of that claim. After allocating the claim, subtract the insured’s share from the deductible balance, but do not allow the balance to fall below zero.

1
Confirm the inputs.
Use the policy-year eligible amounts in the required allocation order. Identify any claim-level terms that have already been reflected.
2
Track the deductible balance.
Start with \(D\). For each claim, record the balance remaining before that claim.
3
Split the claim if needed.
Allocate the lesser of the claim amount and the remaining deductible to the insured; allocate the rest to the insurer.
4
Reconcile.
For every claim, check \(R_j+I_j=L_j\). For the policy year, check that total eligible loss equals total insured share plus total insurer share.

Why the Allocation Formula Works

Before claim \(j\), the cumulative eligible loss is \(C_{j-1}\). The amount of the deductible that has already been used cannot exceed \(D\), so the remaining deductible is \(\max(0,D-C_{j-1})\). The insured cannot be allocated more than either that remaining amount or the current eligible loss. Therefore the insured’s share is the smaller of those two amounts, giving \(R_j=\min(L_j,\max(0,D-C_{j-1}))\). The insurer bears the rest, \(I_j=L_j-R_j\).

An equivalent formula makes the crossing claim especially clear. The insurer’s cumulative share through claim \(j\) is the eligible loss above the aggregate deductible, if any:

$$ \sum_{k=1}^{j} I_k=\max(0,C_j-D), \qquad I_j=\max(0,C_j-D)-\max(0,C_{j-1}-D). $$

The second equation follows by subtracting the insurer’s cumulative share before claim \(j\) from its cumulative share after claim \(j\). It handles all three cases: the deductible is still unexhausted, the current claim crosses it, or it was exhausted earlier. Summing the claim-level insurer shares telescopes to \(\max(0,C_n-D)\) for \(n\) claims. The insured’s annual total is then \(C_n-\max(0,C_n-D)=\min(C_n,D)\).

Worked Example: Locating the Exhaustion Claim

A hypothetical policy has an annual aggregate deductible of $42,000. The eligible losses, in allocation order, are $16,000, $14,000, $19,000, and $12,000. Calculate the insured and insurer shares by claim and identify the exhaustion claim. Assume deterministic stated amounts, no probability distribution, no mortality assumption, and a 0% interest rate because the amounts are allocated without discounting.

Method. Maintain the remaining deductible before each claim, allocate that amount to the insured up to the claim’s eligible loss, then allocate any claim balance to the insurer.

Claim 1. The remaining deductible is $42,000. The eligible loss is $16,000, so the insured pays \(\min(16{,}000,42{,}000)=\$16{,}000\), and the insurer pays $0. The deductible balance becomes $42,000 − $16,000 = $26,000.

Claim 2. The remaining deductible is $26,000. The insured pays \(\min(14{,}000,26{,}000)=\$14{,}000\), and the insurer pays $0. The balance becomes $26,000 − $14,000 = $12,000.

Claim 3. The remaining deductible is $12,000, while the eligible loss is $19,000. The insured pays $12,000, exhausting the deductible. The insurer pays $19,000 − $12,000 = $7,000. Claim 3 is the exhaustion claim.

Claim 4. The deductible is already exhausted, so the insured pays $0 and the insurer pays $12,000.

The insurer’s total is $0 + $0 + $7,000 + $12,000 = $19,000. The insured’s total is $16,000 + $14,000 + $12,000 + $0 = $42,000. Total eligible loss is $61,000, and $42,000 + $19,000 = $61,000, so the allocation reconciles. A common mistake is to subtract $42,000 from the cumulative loss through claim 3 and report that result as the insurer’s full annual share; that gives $49,000 − $42,000 = $7,000, which is only the insurer’s share through claim 3. Claim 4 adds another $12,000.

Worked Example: Splitting the Exhaustion Claim

A hypothetical equipment policy has a $50,000 annual aggregate deductible. Its eligible losses are $12,000, $9,000, $18,000, $17,000, and $11,000, in allocation order. Find the split of the claim that exhausts the deductible and the annual shares. Assume deterministic amounts, no probability distribution or mortality assumption, and a 0% interest rate for this undiscounted allocation.

Method. Add eligible losses cumulatively and compare each cumulative amount with $50,000. The amount above the deductible at a claim date is the insurer’s cumulative share at that date.

After claim 1, cumulative eligible loss is $12,000, so the insured has $50,000 − $12,000 = $38,000 of deductible remaining. After claim 2, cumulative loss is $12,000 + $9,000 = $21,000, leaving $29,000. After claim 3, cumulative loss is $21,000 + $18,000 = $39,000, leaving $11,000.

Claim 4 is $17,000, which is greater than the $11,000 remaining deductible. The insured pays $11,000 of claim 4; the insurer pays $17,000 − $11,000 = $6,000. Claim 4 is the exhaustion claim. Claim 5 occurs after exhaustion, so the insurer pays all $11,000.

The insurer’s annual share is $6,000 + $11,000 = $17,000. The insured’s share is $12,000 + $9,000 + $18,000 + $11,000 = $50,000. Total eligible losses are $67,000, and $50,000 + $17,000 = $67,000. A common mistake is to allocate all $17,000 of claim 4 to the insurer because that claim crosses the deductible. Only the amount above the $11,000 remaining deductible is the insurer’s share of that claim.

Worked Example: Applying Claim-Level Terms Before the Annual Deductible

A hypothetical program applies a $5,000 per-claim retention first. The amounts eligible for the annual aggregate deductible are therefore the portions of each stated loss above $5,000. The annual aggregate deductible is $20,000, and gross losses are $14,000, $22,000, and $9,000. Determine each claim’s eligible amount and the allocation under the aggregate deductible. Assume the stated losses are deterministic, with no probability distribution, no mortality assumption, and a 0% interest rate.

Method. Apply the per-claim retention once to each gross loss to find the eligible amounts. Then apply the annual aggregate deductible to those amounts in claim order.

For claim 1, eligible loss is $14,000 − $5,000 = $9,000. For claim 2, eligible loss is $22,000 − $5,000 = $17,000. For claim 3, eligible loss is $9,000 − $5,000 = $4,000. The cumulative eligible losses are $9,000, $26,000, and $30,000.

Claim 1’s $9,000 is below the $20,000 aggregate deductible, so the insured bears all $9,000 of eligible loss. Before claim 2, the remaining aggregate deductible is $20,000 − $9,000 = $11,000. The insured pays $11,000 of claim 2’s $17,000 eligible amount, and the insurer pays $17,000 − $11,000 = $6,000. Claim 2 exhausts the aggregate deductible. The insurer then pays all $4,000 of claim 3’s eligible amount.

Under the annual aggregate allocation, the insured bears $9,000 + $11,000 = $20,000, and the insurer bears $6,000 + $4,000 = $10,000. The separate per-claim retentions total $5,000 × 3 = $15,000. Thus, the insured’s total share of the gross losses is $15,000 + $20,000 = $35,000, while the insurer’s share is $10,000. The gross losses total $45,000, and $35,000 + $10,000 = $45,000. The common mistake is to apply the $20,000 aggregate deductible directly to gross losses after already calculating the per-claim retentions; the aggregate deductible here applies only to the eligible amounts.

Annual Boundaries and Checks

An annual aggregate deductible is applied separately to each policy year unless the contract says otherwise. A deductible balance does not automatically carry forward, and losses from different years should not be combined into one cumulative sequence. Also preserve the required allocation order: the identity of the exhaustion claim depends on the order, even though the annual insurer total remains the eligible annual total above the deductible when there are no other caps or adjustments.

Before finalizing a calculation, check both levels of reconciliation. For every claim, the insured and insurer shares must sum to the eligible loss. For the year, their totals must sum to total eligible loss. If total eligible loss is at most \(D\), insurer share is zero; if it exceeds \(D\), insured share is \(D\) and insurer share is the excess. If a stated cap, reimbursement feature, or other contract provision changes these outcomes, apply that provision explicitly rather than forcing the simple aggregate-deductible result.

Key takeaway: Track the deductible remaining before each eligible loss. The exhaustion claim is split at that remaining amount; later eligible losses are allocated to the insurer under the basic structure. Always reconcile claim-level shares and annual totals, and reset the calculation at each policy-year boundary.

Check Your Understanding

For each problem, use the stated eligible amounts and allocation order. Unless a problem specifies otherwise, assume deterministic amounts, no probability distribution or mortality assumption, and a 0% interest rate for the undiscounted allocation.

  1. A hypothetical policy has a $31,000 annual aggregate deductible and eligible losses of $10,000, $12,000, $15,000, and $8,000. Identify the exhaustion claim and calculate the annual insurer share. (Answer: Claim 3; insurer share $14,000.)
  2. A hypothetical program has a $24,000 annual aggregate deductible and ordered eligible losses of $5,000, $7,000, $10,000, and $9,000. How much of the last claim is paid by the insurer, and what is the insurer’s annual share? (Answer: Claim 4 is split $2,000 insured and $7,000 insurer; annual insurer share $7,000.)
  3. A hypothetical contract has a $20,000 deductible for each policy year. Year 1 eligible losses are $7,000, $16,000, and $5,000; Year 2 eligible losses are $6,000, $9,000, and $8,000. Calculate insurer share in each year and identify the exhaustion claim in each year. (Answer: Year 1 insurer share $8,000, exhausted on claim 2; Year 2 insurer share $3,000, exhausted on claim 3.)
  4. A hypothetical policy applies a $5,000 per-claim retention before its $20,000 annual aggregate deductible. Gross losses are $14,000, $22,000, and $9,000. Calculate the insurer’s share and the insured’s total share, including the per-claim retentions. (Answer: Insurer share $10,000; insured total share $35,000.)
  5. A hypothetical policy has a $35,000 annual aggregate deductible and eligible losses of $9,000, $14,000, $8,000, $12,000, and $10,000 in order. Find the exhaustion claim, the split of that claim, and the annual insured and insurer totals. (Answer: Claim 4; claim 4 is split $4,000 insured and $8,000 insurer; annual insured share $35,000 and insurer share $18,000.)
Clinical Biostats