Uncertainty of Claims Provisions from the Analysis of Financial Statements

Data sheet used to develop the Article "Uncertainty of Claims Provisions from the Analysis of Financial Statements" to be published in a future edition of the RAC (Revista de Administração Contemporânea). The data used in the runoff triangles were obtained from Financial Statements of different insurance companies in Brazil. The calculus was based on a spreadsheet publicly available from CAS (Casualty Actuarial Society) to implement the bootstrap method described in England & Verrall paper, "Analytic and Bootstrap Estimates of Prediction Errors in Claims Reserving". Since the model involves Bootstrap simulation, the spreadsheet is constantly updated in order to obtain new simulations. Thus, it is not possible to obtain the exact results of the 10,000 simulations carried out for the data of each insurer in the paper. For more details about the methodology used, please consult the paper.