Hi. Could you help me with this please? I tried but I couldn't figure it out! Thank you very much! The links are below provided
https://docs.google.com/spreadsheets/d/159bLl7Dart_b7x3Hmqv2BuFLIvxPMoA5PJ627EcQgHM/edit?usp=sharing_eil_m&ts=613582ab
https://docs.google.com/spreadsheets/d/1l3elHJpg8GA3rJuIgYjcfn-xPsd6yWYLmo4uxuzf4eA/edit?usp=sharing_eil_m&ts=61358388
A A P C ... 3 Apll 1 Home Insert Draw Page Layout Formulas Data Review Tell me Share Comments Arial v 12 AA =E ap Wrap Text v General LIX V V Paste BI UV V DVAv E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data J20 X V fx =120 A C D E F G H I J K L M N 0 P Q R S APLII INPUT: 9 DEATH BENEFIT [APLII B3] = $100,000 10 ISSUE AGE [APLII A7] = 24 GUARANTEED INTEREST RATE [APLII G3] = 2.5% 12 CURRENT INTEREST RATE [APLII H3] = 5.0% Questions 1, 2 and 3 may be performed simultaneously. 14 1) Review the CSO tables on the APLII Base Information [AF to AX] 15 a. What is the Cost of Insurance Per $1,000 of Death Benefit based on the 2001 CSO Table by Risk Rate Class [D3]? 16 MALE FEMALE AGE PREFERRED_STANDARD_ PREFERRED_STANDARD_SMOKER 17 SMOKER 18 24 = 19 44 = 20 64 = 11 11 11 21 84 22 23 b. What is the Cost of Insurance Per $1,000 of Death Benefit based on the 2017 CSO Table by Risk Rate Class [D3]? 24 MALE FEMALE 25 AGE PREFERRED_STANDARD_SPREFERRED_STANDARD_SMOKER 26 27 24 $ 0.69 $ 0.82 $ 1.00 $ 0.27 $ 0.32 $ 0.40 28 44 = 29 64 = 11 11 11 30 84 : 31 c. List observations with respect to the change in mortality rates over time or by risk rate class. 32 33 2) Review the CSO tables on the APLII Base Information [AF to AX] 34 a. What is the Percentage Probability of Premature Death based on the 2017 CSO Table by Risk Rate Class [D3]? 35 MALE FEMALE 36 AGE PREFERRED_STANDARD_S PREFERRED_STANDARD_SMOKER 37 38 24 39 44 = 11 1 1 1 11 11 11 11 40 64 = 41 84 = 42 43 44 45 a. List observations with respect to the change in mortality rates over time or by risk rate class. 46 47 D Sheet1 Sheet2 + Ready Circular References + 100%3 Apll 1 Q A P Y C ... Share Comments View ? Tell me Home Insert Draw Page Layout Formulas Data Review v 12 AA ab Wrap Text v General LIX V V Calibri (Body) Insert Delete Format Sort & Find & Analyze = $ ~ % 9 00 20 Conditional Format Cell Filter Select Data Formatting as Table Styles Paste BIUV E Merge & Center v D70 fx R S E F G H I J K L M N P Q A B C D 42 43 44 45 a. List observations with respect to the change in mortality rates over time or by risk rate class. 46 47 3. Estimate the Life Expectancyes, Number of Years.Number of Months [Traditional Whole Life B] by changing Gender [C3], Risk Rate Class [D3] and CSO Mortality Table [F3]. Issue Age is 24. 48 49 Hint: Life Expectancy is when Proportion Living is 50% Stan Smoker 50 Female Preferred a. 198 b. 200 = 54 55 C. 201 Preferred Stan Smoker 56 Male 57 d. 198 58 59 e. 200 60 61 f. 201 62 g. What observations do you have about the above? 63 64 65 66 67 68 69 70 71 73 75 76 77 78 79 80 81 82 D Sheet1 Sheet2 + + 100% Ready
