at 35, I(x) = 99,209

A life insurance company sells a product where policyholders receive a claim amount of $500,000 at the end of the year of death, or if death does not occur in the next 30 years then the claim amount of $500,000 is paid in exactly 30 years and the policy ceases immediately. Use a spreadsheet tool to calculate the EPV of the claim amounts (to 2 decimal places) for a policyholder who takes out the policy at age 35. Assume mortality follows the rates described in Assessment Question 4.7, and that interest rates are 2.5% per annum. File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safe B112 X for 0 D E F G H 1 1 x 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 23 24 25 26 27 20 28 29 30 31 32 33 34 or B (x) 0 100,000 1 99,998 2 99,995 3 99,991 4 99,986 5 99,981 6 99,975 7 99,967 8 99,959 9 99,951 10 99,941 11 99,930 12 99,918 13 99,904 14 99,890 15 99,874 16 99,857 17 99,838 18 99,818 19 99,796 20 20 99,772 21 21 99,747 22 00 710 99,719 o con 23 99,689 DOC 24 99,656 25 99,621 26 99,583 27 99,541 28 99,496 29 99,448 30 99,395 31 99,338 32 99,276 19 Sheet1 A life insurance company sells a product where policyholders receive a claim amount of $500,000 at the end of the year of death, or if death does not occur in the next 30 years then the claim amount of $500,000 is paid in exactly 30 years and the policy ceases immediately. Use a spreadsheet tool to calculate the EPV of the claim amounts (to 2 decimal places) for a policyholder who takes out the policy at age 35. Assume mortality follows the rates described in Assessment Question 4.7, and that interest rates are 2.5% per annum. File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safe B112 X for 0 D E F G H 1 1 x 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 23 24 25 26 27 20 28 29 30 31 32 33 34 or B (x) 0 100,000 1 99,998 2 99,995 3 99,991 4 99,986 5 99,981 6 99,975 7 99,967 8 99,959 9 99,951 10 99,941 11 99,930 12 99,918 13 99,904 14 99,890 15 99,874 16 99,857 17 99,838 18 99,818 19 99,796 20 20 99,772 21 21 99,747 22 00 710 99,719 o con 23 99,689 DOC 24 99,656 25 99,621 26 99,583 27 99,541 28 99,496 29 99,448 30 99,395 31 99,338 32 99,276 19 Sheet1