Insurance Risk Modelling using Excel (Coming Soon)

Insurance companies need to simulate Claims Loss Distribution for the Policies sold, to meet the Solvency requirements set by regulator. This module goes step by step to demonstrate the process of generating Loss Distributions for an insurance company.
The zip contains the following excel sheets-
1. Probability Distributions using Excel
2. Number of claims using Excel: Frequency distributions
3. Size of claims using Excel: Severity distributions
4. Fitting distributions to data: Parameter estimation – MME & MLE
5. Examining Chie Square Goodness of fit
6. Aggregate loss modelling – using Monte Carlo Simulation
7. Fitting Copulas- Elliptical & Archimedean Copulas
The excel sheets comes accompanying with a PPT explaining all the steps.