Skip to main content
The Actuary: The magazine of the Institute and Faculty of Actuaries - return to the homepage Logo of The Actuary website
  • Search
  • Visit The Actuary Magazine on Facebook
  • Visit The Actuary Magazine on LinkedIn
  • Visit @TheActuaryMag on Twitter
Visit the website of the Institute and Faculty of Actuaries Logo of the Institute and Faculty of Actuaries

Main navigation

  • News
  • Features
    • General Features
    • Interviews
    • Students
    • Opinion
  • Topics
  • Knowledge
    • Business Skills
    • Careers
    • Events
    • Predictions by The Actuary
    • Whitepapers
    • Moody's - Climate Risk Insurers series
    • Webinars
    • Podcasts
  • Jobs
  • IFoA
    • CEO Comment
    • IFoA News
    • People & Social News
    • President Comment
  • Archive
Quick links:
  • Home
  • The Actuary Issues
  • March 2019
03

Taken to excess

Open-access content Wednesday 6th March 2019 — updated 1.11pm, Friday 3rd February 2023
Authors
Yiannis Parizas

Yiannis Parizas discusses an alternative approach to modelling excess levels in regressions

2


Excess level, or deductible, is the portion of the loss retained by the insured on each and every claim. It is used by insurance companies to reduce the cost of insurance and make prices more competitive. When modelling general insurance claims, the traditional regression approach is a frequency-severity model on ceded claims, for one or more claim types together. In such a model, excess levels are commonly incorporated as a factor to both frequency and severity. As such, the estimated frequency or severity will reduce with the increase in the excess level, as per the models' relativities.

This article describes an alternative approach to modelling excess levels. The proposed approach involves modelling the ground-up frequency or severity of claims and calculating the expected ceded claim. The results are compared to those obtained by following the current market practice.


The effect of an excess level on claim severity

Let's assume severity originates from a bell-shaped, positively skewed distribution. Figure 1 represents sampled claims from a lognormal distribution. On applying an excess level of £200, the first two bars of the histogram are removed from our data. This sort of data is typical for an insurance company, as it wouldn't get information about the losses below the excess level. Ceded claims is thus a truncated dataset. 

When a lognormal is fitted to the ceded claims, the fitted distribution will follow the yellow line. This is exactly what happens when we set the excess level as a factor in our regression models. The ceded claims distribution underestimates smaller claims and overestimates larger ones, thus overestimating expected ceded claim amounts. The higher the excess level, the more the severity overestimation - so the current market approach is more expensive on higher excess levels.

The ideal distribution would be the original, but with zero values below the excess level. To achieve this, we need to fit the ground-up claim severity distribution and derive an analytical solution for the expected value of ceded claims.

With a left truncated dataset, the algorithm will fit the distribution only after the excess level. However, letting the distribution 'free' before the excess level allows for a better fit after the excess level. One-way right truncated or censored models can be used in case pricing, where the analyst wants to slice the distribution, eg lognormal-Pareto, to better fit the attritional claims part.


p20-21_figure_1


The effect of an excess level on claim frequency

The next step is to adjust the frequency data and then fit the frequency distribution. Figure 2 demonstrates how the claims frequency is affected by an excess level. We sampled ground-up counts from a Poisson model with four claims on average. For the ceded frequency we sampled from the ground-up frequency and a binomial model, assuming the probability for a claim being ceded is 90%. The full claims frequency is higher and more positively skewed.

In order to convert frequency to the same basis with our ground-up severity model, we need to model the ground-up claim counts, including the claims we do not know about. The truncated regression modelling method doesn't allow for this because the frequencies are being excluded randomly, based on their severity. To correctly account for this, we use the severity distribution to tell us the proportion of claims that is less than the excess level. We can therefore use our ground-up severity model to estimate what portion of the policy data is expected to be below the excess level.  

There are two tested ways to account for the missing claims - increasing the claims count, or reducing the exposure by the proportion of missing claims. My preference is to reduce exposure and this is the method used in the next section. 


p20-21_figure_2


Testing the new methodology

For the purpose of assessing our new methodology, we generated data for 10,000 yearly policies. For each policy, we generated three factors - A, B and C (yes or no) -  and an excess level between £200 and £1,000, with steps of £100. We then assumed 5% claim rate, increasing by 25% for each factor. For severity we generated claims from a lognormal distribution with an average of £4,280, increasing by 28% with each factor, and a fixed volatility of £16,130. The modelling approach for both the original and the new method follows that described above. The process outcomes were averaged over 200 iterations to stabilise results.

Figure 3 compares the expected cost from the new and the old methodology to the actual numbers. The original method overstates the policy cost, as we predicted above. We can also note that the overestimation increases at higher levels of excess.

While the new methodology is a  better fit in this scenario, the reader should take into account that the data is artificial and assumes perfect distributions. In reality, claims data is more random, and other factors that were ignored, such as claims inflation, incurred but not reported claims, and outliers, would distort the picture. 

A further consideration for personal lines is that we have an actual effect from excess levels, where the policyholder may not claim when the claim is slightly above the excess level. In this case, we can fit a truncated severity distribution and also have excess level as a factor (Figure 4).


p20-21_figure_3
p20-21_figure_4


Benefits of the new method

One of the main reasons to use the new method is to reduce model error, which allows better pricing, attracts better risks and increases profitability. The analytical solution for the excess level allows the client to choose any excess level. For example, in personal lines, this could let the client choose any excess level between two limits, with the price being calculated immediately. 

In commercial lines or reinsurance, this will provide faster negation when using the deductible or limits to optimise the account. The flexibility of modelling any excess level also allows continuous inflation adjustment of the historical excess level, along with claims inflation. Finally, the model needs no parameter for the excess level, as it is now incorporated in the severity model. The reduction of parameters will therefore make the model simpler and more accurate.


Yiannis Parizas is a pricing contractor at NetSim Analytics


This article appeared in our March 2019 issue of The Actuary .
Click here to view this issue

You may also be interested in...

2

An orderly transition

In a follow up to their October article, Simon Richards and members of the IFoA Working Party on LIBOR reform give feedback on the latest consultations and explain their potential consequences
Wednesday 6th March 2019
Open-access content
2

TPR publishes guidance for scheme valuations

The Pensions Regulator (TPR) has today published guidance outlining how it expects employers and trustees to approach upcoming scheme valuations.
Tuesday 5th March 2019
Open-access content
2

Majority of private investors see Brexit 'opportunity'

More than half of private investors in the UK view Brexit as an opportunity, with the overwhelming majority “confident” about the outlook for their investments.
Monday 4th March 2019
Open-access content
2

Global FinTech investment doubles

Financial technology investment more than doubled across the world last year, with the UK and US both enjoying record levels of fundraising.
Friday 1st March 2019
Open-access content
2

Solvency II rules amended to slash insurers' capital requirements

The European Commission has slashed capital requirements for insurers investing in equity and private debt after amending key Solvency II rules.
Wednesday 13th March 2019
Open-access content
ikon

Seeing the Bigger picture

Nico Aspinall explains why the ESG approach’s holistic view of risk is increasingly attractive to investors
Wednesday 6th March 2019
Open-access content

Latest from Archive

2

De-risking too far?

Simon Willes explains why investment de-risking a pension scheme without regard to employer covenant may not lead to optimal member outcomes
Monday 9th September 2019
Open-access content
2

Financial services stand to gain most from low-carbon transition

The financial sector is set to gain most from creating new sustainable products and services in response to climate change, a groundbreaking international study has revealed.
Tuesday 4th June 2019
Open-access content
2

Government gives green light to pension dashboards in 2019

UK savers will soon be able to see all their pension savings in one place after the government today unveiled proposals for a series of dashboards that could come online later this year.
Thursday 4th April 2019
Open-access content

Latest from Reinsurance

Natural catastrophes drive insured losses of $38bn

Natural catastrophes drive insured losses of $38bn

Unprecedented flooding in Australia and South Africa saw total insured losses from natural catastrophes reach $35bn (£29bn) in the first half of 2022, Swiss Re has found.
Wednesday 10th August 2022
Open-access content
Insured losses from natural disasters rise above 21st century average

Insured losses from natural disasters rise above 21st century average

Natural disasters resulted in around $39bn (£32bn) of insured losses during the first six months of this year, which is 18% higher than the 21st century average of $33bn.
Thursday 28th July 2022
Open-access content
Utilities struggling to insure new coal power, report claims

Utilities struggling to insure new coal power, report claims

New coal power capacity is becoming increasingly difficult to insure outside of China, with utilities now turning to inexperienced companies for coverage.
Wednesday 8th June 2022
Open-access content

Latest from March 2019

2

New pension funding code could raise deficits by £100bn

An updated funding code due in 2020 could add £100bn to defined benefit (DB) pension scheme deficits in the UK and cause employer contributions to double, KPMG analysis has revealed.
Friday 29th March 2019
Open-access content
2

Financial services sector pessimism rises as growth falls

UK financial services have suffered another quarter of falling business volumes, with growth in the investment management sector declining faster than at any point since the end of 2008.
Thursday 28th March 2019
Open-access content
2

'Fundamentally flawed' hiring process for actuarial consultants uncovered

Life insurers are failing to find value for money in actuarial consultants due to “intrinsic weaknesses” in the hiring process, a survey by Barnett Waddingham has uncovered.
Wednesday 27th March 2019
Open-access content

Latest from inline_image_missing_alt_text

TPR publishes coronavirus guidance

The Pensions Regulator (TPR) has published guidance to help UK pension trustees, employers and administrators deal with the financial and regulatory risks posed by coronavirus.
Monday 23rd March 2020
Open-access content
2

Bitcoin: In the vaults

Blockchain technology and the trading of bitcoin were introduced in October 2008 in the famous paper by Satoshi Nakamoto.
Wednesday 4th March 2020
Open-access content
web_p24_cat-and-fish_iStock-483454069.png

Sensitivity analysis: swimming lessons

Silvana Pesenti, Alberto Bettini, Pietro Millossovich and Andreas Tsanakas present their alternative approach to sensitivity analysis
Wednesday 4th March 2020
Open-access content

Latest from small_opening_image

2

COVID-19 forum for actuaries launched

A forum for actuaries has been launched to help the profession come together and learn how best to respond to the deadly coronavirus sweeping the world.
Wednesday 25th March 2020
Open-access content
2

Travel insurers expect record payouts this year

UK travel insurers expect to pay a record £275m to customers this year as coronavirus grounds flights across the world, the Association of British Insurers (ABI) has revealed.
Wednesday 25th March 2020
Open-access content
2

Grim economic forecasts made as countries lockdown

A sharp recession is imminent in the vast majority of developed and emerging economies as the deadly coronavirus forces businesses to shut down across the world.
Tuesday 24th March 2020
Open-access content

Latest from 03

seat

A seat at the table

Pauline Gordon, Monica Ho, Lesley-Ann Morgan, Reena Thakkar and Theny Thiagarajan discuss why so few women work in senior finance roles – and how this might be addressed
Wednesday 6th March 2019
Open-access content
2

Out of the echo chamber

Chika Aghadiuno on the importance of allowing our views to be challenged
Wednesday 6th March 2019
Open-access content
daisy

Guiding star

Speaking to Chika Aghadiuno, Daisy Coke reflects on a life at the vanguard of the Jamaican actuarial profession
Wednesday 6th March 2019
Open-access content

Latest from Yiannis Parizas

gc

Going for it

Welcome to the first issue of 2023. This year has already got off to a good start for many, not least the students who have just qualified.
Wednesday 1st February 2023
Open-access content
h

Agility trial: How can ‘agile methodology’ benefit insurance?

Stefania Varnava and Yiannis Parizas examine the benefits of using agile methodology within the insurance industry
Wednesday 30th November 2022
Open-access content
ij

Choosing a pricing architecture

Yiannis Parizas and Phanis Ioannou weigh up the benefits of open-source and commercial solutions for general insurance pricing
Wednesday 2nd November 2022
Open-access content
Share
  • Twitter
  • Facebook
  • Linked in
  • Mail
  • Print

Latest Jobs

Shape the Future of Insurance

London (Central)
£ excellent package
Reference
149090

Senior Pricing Actuary - Life Reinsurance

London (Central)
£ excellent
Reference
149089

Insurance Investment Leadership Opportunities

Flexible / hybrid with 2 days p/w office-based
£ dependent upon experience
Reference
149088
See all jobs »
 
 
 
 

Sign up to our newsletter

News, jobs and updates

Sign up

Subscribe to The Actuary

Receive the print edition straight to your door

Subscribe
Spread-iPad-slantB-june.png

Topics

  • Data Science
  • Investment
  • Risk & ERM
  • Pensions
  • Environment
  • Soft skills
  • General Insurance
  • Regulation Standards
  • Health care
  • Technology
  • Reinsurance
  • Global
  • Life insurance
​
FOLLOW US
The Actuary on LinkedIn
@TheActuaryMag on Twitter
Facebook: The Actuary Magazine
CONTACT US
The Actuary
Tel: (+44) 020 7880 6200
​

IFoA

About IFoA
Become an actuary
IFoA Events
About membership

Information

Privacy Policy
Terms & Conditions
Cookie Policy
Think Green

Get in touch

Contact us
Advertise with us
Subscribe to The Actuary Magazine
Contribute

The Actuary Jobs

Actuarial job search
Pensions jobs
General insurance jobs
Solvency II jobs

© 2023 The Actuary. The Actuary is published on behalf of the Institute and Faculty of Actuaries by Redactive Publishing Limited. All rights reserved. Reproduction of any part is not allowed without written permission.

Redactive Media Group Ltd, 71-75 Shelton Street, London WC2H 9JQ