https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/NVSR/68_07/Table02.xlsx

https://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/NVSR/68_07/Table03.xlsx

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. .

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%)