Reinsurance Decision Lab
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 .
This is a loss-only comparison: premium, commission, reinstatement, expenses, counterparty default, and dependence are excluded.
1. Check three claims by hand
| Gross claim | 40% quota ceded | Quota retained | XL ceded | XL 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
Gross, quota-share, and excess-of-loss outcomes
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
| Observation | Interpretation | Missing decision input |
|---|---|---|
| quota share cuts every loss by 40% | broad capital and volume transfer | ceded premium and commission |
| XL focuses on claims above £20k | more tail-targeted | attachment-region fit and exhaustion risk |
| annual XL recovery varies | large-claim frequency matters | dependence and event aggregation |
| simulated 99% metrics differ | treaties reshape the distribution | parameter/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,
Also,
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:
- multiply each severity by 1.10 while keeping layer terms fixed;
- increase log-scale from 1.0 to 1.3 while preserving mean;
- add an annual catastrophe state that increases count and severity together;
- change the treaty to £50,000 xs £10,000;
- 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:
- portfolio and valuation basis;
- treaties and precise loss functions;
- gross versus net mean and tail metrics;
- price/commission assumptions;
- key sensitivity and data limitation;
- recommendation and condition that would reverse it.
Next, connect the transformed losses to aggregate risk models.