SOA_FAP_Mod7Exercise01-02aAssignmentSpreadsheet_050509.xls...

This preview shows page 1 - 4 out of 5 pages.

Module 7 - Group Life Exercise - Task 3QUESTIONMutualOne existing block of business data (last 5 years)Mortality Rates/ 1000 CoverageAge BandMFtotal15-190.150.020.0856,000 20-240.10.030.065300,000 25-290.080.040.06480,000 30-340.060.060.06600,000 35-390.080.060.071,200,000 40-440.120.080.11,800,000 45-490.150.090.12600,000 50-540.30.20.25600,000 55-590.50.280.39300,000 60-640.80.20.560,000 65-6910.80.915,000 70+21.21.66,000 Avg0.125,967,000 Industry data - Trended to curr YrMFtotal15-190.050.020.03510,000,000 0.04720-240.080.0250.052520,000,000 25-290.080.040.0640,000,000 30-340.090.070.0850,000,000 0.08535-390.10.080.0960,000,000 40-440.120.080.180,000,000 0.12145-490.20.10.1560,000,000 50-540.30.20.2550,000,000 0.33855-590.550.30.42550,000,000 60-640.90.40.6520,000,000 65-691.60.91.2510,000,000 1.38370+2.61.52.052,000,000 0.21452,000,000 GreenCo Experienceyear 1year 2year 3year 4year 5avg y1-y5< 250.040.060.080.040.060.0568,000 25-290.090.120.070.40.080.15224,000 30-390.070.50.20.320.070.23232,000 40-490.120.110.020.120.10.09432,000 50-590.30.30.40.350.480.36632,000 60-640.6510.650.90.620.76416,000 65+2.51.511.2103.244,000 Avg Exposure Base/ 1000 coverageExposure Base/ 1000 coverageAvg factor in 10 yr bracketsExposure Base/ 1000 coverage
0.260.370.250.370.490.35148,000
Mortality Improvement by Age - SOA study dataIndustry Factors - MutualOne Rate ManualBlue collarMF15-190.0%0.0%15-191.20.8320-24-1.0%0.6%20-241.250.8025-29-1.0%0.6%25-291.250.8030-34-2.5%-0.1%30-341.150.8735-39-2.0%1.5%35-391.150.8740-44-0.2%2.0%40-441.20.83

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture