With an Excel spreadsheet, calculate a reserve in year 2 5 for a single surviving policyholder who is fully diversified for life at age 35 and requires a premium equal to 2,265.98 and covers the $400,000 declaration at the end of the year of the Quillen holder's death. The 5% protection rate assumed that death beneficiaries follow current 2010-12 life tables (female rates) and are active investors.

Please With an Excel spreadsheet