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. Bank Offer Introductory Interest Standard Rate (after introductory rate) Tapiwa wants to invest 8500. % Years 9.0% 6.0% 4 The bank employee used a spreedsheet to calculate the values for the offer below. However, this spreadsheet is incomplete. 1 2 3 1 D Opening Balance 8,500.00 Interest 1 9.0% 765.00 Interest 2 Closing Balance 6.0% 9,265.00 4 2 5 3 6 4 11,007.75 7 5 719.91 12,718.35 8 6 9 7 10 8 11 9 12 13 Alternative Method 14 Introductory 8,500.00 9.0% 15 Standard Rate 11,998.44 6.0% 11,998.44 16,056.62 Required What is his investment worth at the end of Year 8? Choose... 0 What is the formula needed in Cell E14 to calculate the closing balance after 4 years? Choose... What is the formula needed in Cell E15 to calculate the closing balance after 9 years? Choose... 0 Bank Offer % Years Introductory Interest Standard Rate (after introductory rate) 9.0% 6.0% 4 Tapiwa wants to invest 8500. The bank employee used a spreedsheet to calculate the values for the offer below. However, this spreadsheet is incomplete. C E Opening Balance 8,500.00 Interest 1 Interest 2 9.0% 6.0% 765.00 Closing Balance 9,265.00 1 2 3 1 4567 2 3 4 11,007.75 5 8 6 9 7 10 8 11 9 12 13 Alternative Method 719.91 12,718.35 14 Introductory 15 Standard Rate 8,500.00 9.0% 11,998.44 6.0% Required What is his investment worth at the end of Year 87 Choose... 0 11,998.44 16,056.62 What is the formula needed in Cell E14 to calculate the closing balance after 4 years Choose... What is the formula needed in Cell E15 to calculate the closing balance after 9 years 814 C14- -B14 C14 A6 814*(1+C14) A6 =B14*(T+C14) (1-C15) B15 (1+C14)*(1+C15) -815*(1+C15)^(A11-A6) 815 C15 (A11-A6) 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. Bank Offer Introductory Interest Standard Rate (after introductory rate) Tapiwa wants to invest 8500. % Years 9.0% 4 6.0% The bank employee used a spreedsheet to calculate the values for the offer below. However, this spreadsheet is incomplete. 1 D Opening Balance 8,500.00 Interest 1 9.0% 765.00 Interest 2 Closing Balance 6.0% 9,265.00 23456 1 2 3 4 11,007.75 7 5 8 6 9 7 10 8 11 9 12 13 Alternative Method 719.91 12,718.35 14 Introductory 15 Standard Rate 8,500.00 11,998,441 9.0% 6.0% Required What is his investment worth at the end of Year 8? Choose.... O 11,998.44 16,056.62 What is the formula needed in Cell E14 to calculate the closing balance after 4 years? Choose... What is the formula needed in Cell E15 to calculate the closing balance after 9 years Choose... =B14 C14'4 -B14 C14 A6 B14 (1+C14) A6 =B14!(1+C14)^{1-695) =B15 (1+C14)*(1+015) =B15 (1-C15) (A11-A6) 815 C15 (A11-A6) Next pag