Spreadsheet dependancy and pricing
Spreadsheets are frequently used for pricing due to their ability to build complex calculations quickly in a flexible coding environment. Read our guide now.
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
More insights
Create a pricing application from a spreadsheet pricing model
When setting a price for a new product, the starting point is almost always Excel. Find out how to create a pricing application from a spreadsheet pricing model here.
Optalitix Models Use Cases
Insurance often involves using pricing models in spreadsheets. Use Optalitix Models to simplify processes by transforming these spreadsheets into a system.
The emergence of digital exchanges in the London Insurance Market
The Optalitix team were invited to contribute to a discussion where the digitisation on the underwriting process for the London Market.