Please use excel to solve this question.

Congratulations you have graduated! You get your first job and decide to buy a new car. Not to be dramatic, but our earth is dying so you invest in a Tesla to help reduce your carbon footprint. The car costs $79,000. You pay $15,000 down and take out a loan for the rest. The loan is 5.5% compounded monthly over 6 years. What is your monthly payment? Year 3-year 20-year 1 2 3 4 5 33.33% 44.45 14.81 7.41 Depreciation rate for recovery period 5-year 7-year 10-year 15-year 20.00% 14.29% 10.00% 5.00% 32.00 24.49 18.00 9.50 19.20 17.49 14.40 8.55 11.52 12.49 11.52 11.52 8.93 9.22 6.93 3.750% 7.219 6.677 6.177 5.713 7.70 5.76 8.92 8.93 4.46 7.37 6.55 6.55 6.56 6.55 6.23 5.90 5.90 5.91 5.90 5.285 4.888 4.522 4.462 4.461 10 3.28 67890 H 11 12 13 14 15 5.91 5.90 5.91 5.90 5.91 4.462 4.461 4.462 4.461 4.462 2.95 16 17 18 19 20 4.461 4.462 4.461 4.462 4.461 21 2.231