This a comprehensive actuarial task involving both answer writing on Word and analysis on Excel calculations. Please ensure you have strong Excel analysis skills (involving VBA to some extend) and solid actuarial knowledge before you are getting on this task.

Beside the information given by questions, most of the answers are also depended on the data and the results that is provided in corresponding Excel file. Therefore, all answer need to be highly relevant with the Excel data and the information that given by questions. And I did not expect that in each question all the answer are theoretical without any connection with data and calculation analysis.