Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Given National Vital Statistics Reports, Vol. 68, No. 7, June 24, 2019, Table 2 for Males and Table 3 for Females in the US,
1. Given National Vital Statistics Reports, Vol. 68, No. 7, June 24, 2019, Table 2 for Males and Table 3 for Females in the US, develop an actuarial table to use in your five-year term model.
(Male Life Table)
https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/NVSR/68_07/Table02.xlsx
(Female Life Table)
https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/NVSR/68_07/Table03.xlsx
. a. Use the lx , column D for males and column L for females in the Life Tables worksheet to develop the actuarial tables in the Actuarial Tables worksheet.
b. Develop the columns for Age lx dx qx Ax 5-Yr Term In columns A-F for males and I-N for females. Use and reference an interest rate stored in cell D1 (initially 5%