Risk Analysis for Insurance and Reinsurance | Vose Software

Industries / Insurance and reinsurance

Is the 1-in-200 year actually covered?

Model loss distributions, price premiums and reinsurance, and hold capital for a 1-in-200-year loss.

  • ModelRisk
  • ModelChoice

A motor insurer's claims next year

10,000 futures

1 in 200 $8.16M
99.5%covered0.5%not covered
Total claims for the year, US$ million
99.5% covered0.5% not covered
From the free example model IN-01 Aggregate Claims: Frequency × Severity, every claim summed. 10,000 futures.

The premium covers the year's claims in 97% of futures. The 1-in-200 year needs $0.66M of capital on top.

Clients in insurance and reinsurance

  • Munich Re
  • Aon
  • Marsh
  • Gallagher
  • Arch Insurance
  • Ariel Re

Across the business

Where uncertainty enters an insurer

From pricing a policy to the 1-in-200 year, each part of the business has its own question. Pick one to jump to it.

Questions we answer

The questions your board asks, with the numbers behind them

Charts marked with a model code come from a free example model you can open in Excel. The others are marked illustrative.

Where each product fits:
1PricingModelRisk

Same expected claims: same premium?

Both policies expect $100k of claims a year, but the property claims are far more volatile. Priced on the capital each one ties up, the property policy needs a risk premium 48% higher: $165.7k against $111.8k.

Premium $111.8k
67.6%premium covers32.4%claims exceed it
A year's claims, US$ thousand
67.6% premium covers32.4% claims exceed it

Mean claims $100k · loading 11.8%

From the free example model IN-06 Pricing a Policy: Premium Principles, priced on the cost of capital. 10,000 futures.
2Claims dataModelRisk

Which distribution for the large claims?

Three distributions fit the same 250 claims and disagree fourfold on the 1-in-1,000 claim, from $1.45M to $5.75M. The Pareto fits best, and allowing for the uncertainty in its parameters adds 9% to the 1-in-200 year.

Gamma$1.45M
Pareto, the best fit$3.24M
Lognormal$5.75M
From the free example model IN-02 Fitting Claim Frequency and Severity to Data: the 1-in-1,000 claim under each distribution fitted to 250 claims. 10,000 futures.
3CatastropheModelRisk

How large is the 1-in-200 storm year?

With 25 years of history the 1-in-200 year lies far beyond the data. A Lognormal fitted to every event puts it at $85.6M; extreme value theory on the large events gives $149.3M, and $161.1M with the uncertainty in the fitted tail.

Lognormal fitted to every event$85.6M
Extreme value theory, large events$149.3M
The same, with the uncertainty in the tail$161.1M
From the free example model IN-04 Catastrophe and Large-Loss Tail: the year's total losses at 1 in 200. 10,000 futures.
4ReinsuranceModelRisk

Excess of loss, quota share, or both?

Compare programmes on the same simulated claims. Excess of loss and quota share together lift the 1-in-200 result from −⁠$43.2M to −⁠$15.4M for $2.12M a year, and free $27.8M of capital.

Result $0
26.8%loss73.2%profit
Underwriting result for the year, US$ million
26.8% loss73.2% profit

Mean $3.59M · 1 in 200 −⁠$43.2M

From the free example model IN-03 Reinsurance Programme: Excess of Loss and Quota Share. 10,000 futures.
4ReinsuranceModelRisk

Which retention, cover and quota share?

The broker's programme loses $14.4M in a 1-in-200 year, more than the $10M of capital the insurer holds. The ModelRisk Optimizer chose the retention, the cover and the quota share together; its programme loses $9.8M in that year, for about the same expected cost.

The broker's programme$14.4M
Capital held$10.0M
The Optimizer's programme$9.8M
From the free example model IN-09 Reinsurance Programme Chosen by the Optimizer: the loss in a 1-in-200 year under each programme. 10,000 futures.
5CapitalModelRisk

How much capital for the 1-in-200 year?

Capital depends on how the risks go wrong together. With a t copula, which lets bad years coincide, the insurer needs $128.6M: 43% less than adding up each risk's own capital, and $25.4M more than if the risks were independent.

Sum of each risk on its own$227.0M
Square-root formula$136.6M
t copula$128.6M
Normal copula$118.1M
Independent risks$103.2M
From the free example model IN-07 Capital Requirement and Diversification: capital at 99.5% by model of dependence. 10,000 futures.
6LifeModelRisk

What is the block of policies worth?

On its best-estimate mortality, lapse and disability rates the block loses money in 0.5% of futures. Let those rates be as uncertain as the limited experience behind them, and the chance of a loss is 8.4%.

Break-even
0.5%loss99.5%profit
Value of 20,000 term policies over ten years, US$ million
0.5% loss99.5% profit

Mean $10.20M · chance of a loss 0.5%

From the free example model IN-08 Life Portfolio and Lapse. 10,000 futures.
7StrategyModelChoice

Enter cyber nationwide, in three states, or through an MGA?

A mid-size insurer weighs entering cyber insurance, where one ransomware event can wipe out years of profit. Piloting in three states has the best expected value, $3.2M; a nationwide launch comes out at −⁠$7.8M.

Full Launch NationwideEV −$7.8MLimited Launch (3 States)EV $3.2MBestMGA PartnershipEV $2.9MDon't LaunchEV $0.0M

From the free example Insurance Product Launch, rolled back in ModelChoice.

How it fits together

One capital model, from the claims history to the 1-in-200 year

Built in ModelRisk, in Excel. Each step has a free example model you can open.

  1. Step 1 · ModelRiskFit the claimsFrequency and severity fitted to the history, with parameter uncertainty.IN-02
  2. Step 2 · ModelRiskAdd them upA year's claims summed claim by claim.IN-01
  3. Step 3 · ModelRiskPrice the policiesPremiums that reflect the capital each policy ties up.IN-06
  4. Step 4 · ModelRiskReinsureExcess of loss and quota share on the same claims.IN-03
  5. Step 5 · ModelRiskCapitalRisks combined with copulas for the 1-in-200 capital.IN-07

Training

Risk analysis training

Risk analysis modelling courses can focus on your industry and on the problems you model, online or face-to-face.

See the courses

Consulting

Bring one model

Our consultants review one of your own models before a critical decision or a public review.

See consulting

FAQ

Common questions

Why not multiply the number of claims by one claim size?

Because that is not the sum of every claim. In the free aggregate claims example the shortcut puts the 1-in-200 year at $72.4M; adding up every claim gives $8.2M.

How do you estimate a 1-in-200 year that is beyond the data?

With a model of the tail rather than of the average event. In the free catastrophe example, extreme value theory on the large events puts the 1-in-200 year at $149.3M, where a Lognormal fitted to every event says $85.6M.

Can we model how risks move together in a bad year?

Yes. ModelRisk has 14 copulas, including the t copula, which lets risks go wrong together in the tail. In the free capital example the 1-in-200 capital is $128.6M with a t copula and $103.2M if the risks were independent.

Can we try it on one of our own models?

Yes. ModelRisk and ModelChoice each have a free 15-day trial, and our team can go through one of your own models with you.

Bring one model. We'll show you the tail.

Free 15-day trials of ModelRisk, ModelChoice and Tamara. For Pelican, we'll show it to you on risks like yours.