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 ? What is the formula needed in Cell E14 to calculate the closing balance after 4 years? What is the formula needed in Cell E15 to calculate the closing balance after 9 years