A bank employee has been approached by a client, Tapiwa, who wants to know how much they would earn if they take advantage of the latest bank offers. Tapiwa wants to invest $11,320$The bank employee used a spreedsheet to calculate the values for the offer below. However, this spreadsheet is incomplete. Required What is his investment worth at the end of Year $8?$ Answer $1$What is the formula needed in Cell E$14$ to calculate the closing balance after $4$ years? Answer $2$What is the formula needed in Cell E$15$ to calculate the closing balance after $9$ years? Answer $2$