$!!!!$ The excel sheet is attached and please provide dynamic arrays excel equations to complete columns c$-$g$!!($equations that don't require being dragged down and automatically fill columns $+$ explain which cell to type in $+$ how it works$)$

In the Excel Workbook "AssignmentTemplate", the first sheet "Part$-$A$"$ is a partial life

table $($values come from the female ALT$2015-17).$ Columns A $("$Age $x")$ and B $("$Ix$")$ are

already filled $($and you should not modify those columns$).$ Note that, contrary to usual

practice, the ages are in descending order $($and you should keep it that way$).$ Also, we

assume that everybody is dead by age $111($this is why the oldest age in the table is $=$

$.$

Your first task is to complete this life table, i$.$e$.,$ complete columns $C$ to $G.$ Note

you should do this by making reference to values found in sheet "Part$-$A$"$ only. For

the calculation of ex in Column $F($the expected future lifetime of someone aged

$x),$ you may make the assumption that people die exactly between two birthdays.

For the calculation of $ax$ in Column $G($this is$,$ following standard actuarial

notation, the EPV of payments of $1,$ made to someone age $x,$ at the end of each

year, for as long they are alive$)$ you should use the interest rate given in cell J$1$

$(4\%).$