G I J K L M N o P $1$ A C E F H Based on the remaining life expectancy, your company is selling a life insurance $2$ policy that pays off the Policy Amount at the time of death. Calculate the single payment $3($today$\text{'}$s dollars$)$ Present Value Cost of each policy based on the remaining life expectancy $4$ and the $4\mathrm{.}25\%$ rate of interest that is currently being promised. Format cells nicely $($keep ONE decimal$).$ Your Score: $/100567$ Interest Rate: $4\mathrm{.}25\%($Assumed$)$ Remaining Life Expectancy Policy Amount Present Value Cost $8$ Name $9$ Sarah Gonzalez $10$ Wayne Jackson $11$ Robert Herring $12$ Laura Samuels $1314$ Birthdate Gender $12-$Apr$-77$ Female $15-$Nov$-83$ Male $07-$Jun$-61$ Male $23-$Aug$-96$ Female $41472560250,000105,00060,00095,000<--$ Use PV or other functions to calculate the lump$-$sum cost of the policy $($today$\text{'}$s dollars$)$ for each person $-$ Copy the above formula here Copy the above formula here $<----$ Copy the above formula here $151617181920$