catastrophe excess of loss event

 
The calculation of catastrophe excess of loss event. The excel sheet attached contain the claim data in each countries to be considered when calculating the premium, catastrophe event and reinsurance fees. The lecturer want us to identify the catastrophic event in each countries mentioned and develop reinsurance programme with adequate premium. You can use burning cost analysis or exposure method when distributing the claim