Excel-based solution helps companies calculate requirements using the new regulation’s standard formula

Broking group Aon’s global risk consulting unit has launched a Solvency II capital requirement calculation tool.

The Microsoft Excel-based solution, called ASTRA, is designed to help companies complete their capital requirement calculation using Solvency II’s standard formula.

Under the Solvency II regime, which is expected to come into force on 1 January 2016, companies can either use the standard formula to calculate their capital requirement, or use their own internal capital model, subject to regulatory approval.

Aon said ASTRA has already been licensed to a number of insurers across Europe, including Lloyd’s insurer Hiscox’s subsidiary Hiscox Insurance Company Limited.

Aon associate director of actuarial and analytics Jason Noronha said: “The standard formula calculation has proved more complex than expected for many companies.

“ASTRA allows our clients to minimise the time spent completing the calculation and instead focus on understanding the results using ASTRA’s suite of insightful management information reports.”

The 2025 Insurance Times Awards took place on the evening of Wednesday 3rd December in the iconic Great Room of London’s Grosvenor House.

Hosted by comedian and actor Tom Allen, 34 Gold, 23 Silver and 22 Bronze awards were handed out across an amazing 34 categories recognising brilliance and innovation right across the breadth of UK general insurance.
Many congratulations to all the worthy winners and as always, huge thanks to our sponsors for their support and our judges for their expertise.