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.

8. You expect to receive $20,000 at graduation two years from now. You plan on investing it at 11% until you have 100,000. How long will you wait from now? 9. What is the present value of the following cash flows if the discount rate is 10%? What is the present value if the discount rate is 14%? Year Cash Flow 10,000 0 25,000 25,500 10. What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (Future value at year 4). Year Cash Flow 12,000 1,000 2,000 5,500 Effective Annual Rate % 11. Calculate the EAR in each of the following cases: APR% Number of Time compounded 5% Semi-Annual 11% Monthly Weekly 10% Daily 9% Infinite 9% 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