please provide dynamic arrays excel equations to complete columns c$-$g:

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 $($lx$)$ 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 $=$

$110).$

$1.$ 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 $$ in Column F $($the expected future lifetime of someone aged

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

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

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

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

$(4\%).$