Complete the following problems using Excel. All answers are to be completed using the financial functions in Excel, with each input of the calculation having its own unique cell.

12. If you deposit 5,500 at the end of each year for the next 20 years into an accounting paying 10.3%, how much will you have in 20 years? How much will you have 30 years if you don't make any additional payments after the first 20 years? 13. You want to have $100,000 in your savings account 12 years from now. If you are prepared to make equal annual deposits at the end of each year, how much must you deposit each year if you can earn 8.5% annually. 14. Bank of America is offering you a $60,000 5-year loan at an annual interest rate of 9%. What if your annual payment? 15. You want to purchase a Tesla for $69,500. Bank of America is offering 60-month auto loans at 5% APR (compounded monthly). What is your monthly payment