Spreadsheet dependancy and pricing

See all insights
August 18, 2021
  1. Spreadsheets are frequently used for pricing

The widespread use of spreadsheets for pricing insurance has contributed to a business environment that is heavily dependent on spreadsheet results without due consideration for the need to connect these models to core operating systems. The reason for this adoption is that the user experience is simple and visual, and spreadsheet skills can be can be easily acquired. This has lead to significant adoption, making spreadsheets the most used tool for underwriters, actuaries and analysts in insurance.Spreadsheets allow for complex calculations to be built quickly in a flexible coding environment while simultaneously ensuring common calculations can be done repeatedly, although this is often at lower volume than a standard system.Surveys like the one performed by Milliman on actuaries in 2018 (see graph) highlighted the importance of spreadsheets to insurers – over 91% considered spreadsheets to have critical or medium importance to their work.

Source: Milliman UK survey, “Insurers, spreadsheets and Model Risk”, 2018

Dani Katz
Dani Katz
Founder Director

Dani’s actuarial experience and passion are key. He is a strong advocate of innovation, optimism and communication, both within the team and for the clients. Dani’s ability and experience with data ensure that we always maximise value and efficiency for every project, enabling us to unlock hidden value for the clients business.

Share this article
Get the latest insights in your inbox

Sign up to get the latest Optalitix updates and news straight to your inbox.

Thank you. You're now subscribed!
Oops! Something went wrong while submitting the form.

Improve your efficiency and reduce costs today