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