SOA_FAP_Mod7Exercise01-02bAssignmentSpreadsheetWithHelp_050509.xls

This preview shows page 1 - 2 out of 3 pages.

Module 7 - Group Life Exercise - Task 3 QUESTION w FORMULAS MutualOne existing block of business data (last 5 years) Mortality Rates/ 1000 Coverage Age Band M F total 15-19 0.15 0.02 0.085 6,000 20-24 0.1 0.03 0.065 300,000 25-29 0.08 0.04 0.06 480,000 30-34 0.06 0.06 0.06 600,000 35-39 0.08 0.06 0.07 1,200,000 40-44 0.12 0.08 0.1 1,800,000 45-49 0.15 0.09 0.12 600,000 50-54 0.3 0.2 0.25 600,000 55-59 0.5 0.28 0.39 300,000 60-64 0.8 0.2 0.5 60,000 65-69 1 0.8 0.9 15,000 70+ 2 1.2 1.6 6,000 Avg 0.12 5,967,000 Industry data - Trended to curr Yr M F total 15-19 0.05 0.02 0.035 10,000,000 0.047 20-24 0.08 0.025 0.0525 20,000,000 25-29 0.08 0.04 0.06 40,000,000 30-34 0.09 0.07 0.08 50,000,000 0.085 35-39 0.1 0.08 0.09 60,000,000 40-44 0.12 0.08 0.1 80,000,000 0.121 45-49 0.2 0.1 0.15 60,000,000 50-54 0.3 0.2 0.25 50,000,000 0.338 55-59 0.55 0.3 0.425 50,000,000 60-64 0.9 0.4 0.65 20,000,000 65-69 1.6 0.9 1.25 10,000,000 1.383 70+ 2.6 1.5 2.05 2,000,000 0.21 452,000,000 GreenCo Experience year 1 year 2 year 3 year 4 year 5 avg y1-y5 < 25 0.04 0.06 0.08 0.04 0.06 0.056 8,000 0.8 25-29 0.09 0.12 0.07 0.4 0.08 0.152 24,000 0.8 30-39 0.07 0.5 0.2 0.32 0.07 0.232 32,000 0.4 40-49 0.12 0.11 0.02 0.12 0.1 0.094 32,000 0.3 50-59 0.3 0.3 0.4 0.35 0.48 0.366 32,000 0.2 60-64 0.65 1 0.65 0.9 0.62 0.764 16,000 0.1 65+ 2.5 1.5 1 1.2 10 3.24 4,000 0 0.26 0.37 0.25 0.37 0.49 0.35 148,000 0.38 Mortality Improvement by Age - SOA study data Industry Factors - MutualOne Rate Manual Blue collar M F 15-19 0.0% 0.0% 0.000 15-19 1.2 0.83 0.8 1.127 20-24 -1.0% 0.6% 0.000 20-24 1.25 0.80 0.8 1.160 25-29 -1.0% 0.6% 0.000 25-29 1.25 0.80 0.8 1.160 30-34 -2.5% -0.1% -0.001 30-34 1.15 0.87 0.4 0.982 35-39 -2.0% 1.5% 0.000 35-39 1.15 0.87 0.4 0.982 40-44 -0.2% 2.0% 0.001 40-44 1.2 0.83 0.3 0.943 45-49 1.1% 2.4% 0.002 45-49 1.22 0.82 0.3 0.940 50-54 1.4% 1.6% 0.002 50-54 1.15 0.87 0.2 0.926 55-59 1.8%

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture