Our client had required assistance with their spreadsheet based Technical Provisions methodology, and asked Dynamo to help run and improve the existing process. This involved liaising with both actuarial and finance to understand the data, carry out the necessary checks and manipulations, and question the relevance of assumptions and performing a detail peer review of the final submission.
Often with large spreadsheet based models, it is difficult to keep track of data flow and links and the process becomes unmanageable to a new user. We provided our client with thorough documentation on how to use the existing model, from data source to model output, as well as a data flow chart to help visualise the steps required to complete the model.
Our team has a strong working knowledge of the Technical Provisions calculation and we have implemented our Technical Provisions software in one of our Lloyd’s clients. If you would like to see our software brochure click here, or feel free to get in touch with us directly to discuss further.