Reinsurance as a Loss Transformation

Reinsurance Decision Lab

Compare quota share and per-loss excess cover on one simulated portfolio without hiding contract assumptions.

Reinsurance Decision Lab

Harbour Mutual expects 40 claims per year. Ground-up severity is modelled as lognormal with mean about £5,000 and log-scale SD 1. Compare:

  • No treaty;
  • 40% quota share: insurer retains 60% of each covered loss;
  • £20,000 xs £20,000 per loss: ceded =min{(X20,000)+,20,000}=\min\{(X-20{,}000)_+,20{,}000\}.

This is a loss-only comparison: premium, commission, reinstatement, expenses, counterparty default, and dependence are excluded.

1. Check three claims by hand

Gross claim40% quota cededQuota retainedXL cededXL retained
£10,000£4,000£6,000£0£10,000
£30,000£12,000£18,000£10,000£20,000
£70,000£28,000£42,000£20,000£50,000

The XL layer targets medium-large claims but exposes the insurer again above £40,000.

2. Simulate annual outcomes

Py

Gross, quota-share, and excess-of-loss outcomes

Idle

Monte Carlo output varies slightly. The comparison is reproducible because the seed, sample size, distribution, and treaty functions are visible.

3. Interpret, do not rank mechanically

ObservationInterpretationMissing decision input
quota share cuts every loss by 40%broad capital and volume transferceded premium and commission
XL focuses on claims above £20kmore tail-targetedattachment-region fit and exhaustion risk
annual XL recovery varieslarge-claim frequency mattersdependence and event aggregation
simulated 99% metrics differtreaties reshape the distributionparameter/model uncertainty

The lowest net VaR is not automatically the best treaty. Compare net underwriting result after reinsurance price and consider liquidity, counterparty, basis, and strategic constraints.

4. Validate the simulation

For compound Poisson gross loss with independent severity,

E[S]=λE[X]=40(5,000)=£200,000.E[S]=\lambda E[X]=40(5{,}000)=£200{,}000.

Also,

Var(S)=λE[X2].\operatorname{Var}(S)=\lambda E[X^2].

Simulation mean and SD should be close to analytical values within Monte Carlo error. If not, inspect parameterisation and units before interpreting tail results.

5. Extend one assumption at a time

Try these in the cell:

  1. multiply each severity by 1.10 while keeping layer terms fixed;
  2. increase log-scale σ\sigma from 1.0 to 1.3 while preserving mean;
  3. add an annual catastrophe state that increases count and severity together;
  4. change the treaty to £50,000 xs £10,000;
  5. add a second reinstatement-limited occurrence layer only after defining events.

For each change, predict direction before running. Then explain whether mean, SD, attachment, exhaustion, VaR, or TVaR moved most.

6. Decision memo template

Conclude in six lines:

  1. portfolio and valuation basis;
  2. treaties and precise loss functions;
  3. gross versus net mean and tail metrics;
  4. price/commission assumptions;
  5. key sensitivity and data limitation;
  6. recommendation and condition that would reverse it.

Next, connect the transformed losses to aggregate risk models.

Copyright © 2026