You have decided to buy a car for $34,700 and finance it at 5.36% for 36 months.
a. How much is your monthly payment?
b. Need an amortization schedule using Excel. Show all 36 months.
c. Determine the total amount you would pay for the car and the total amount of interest paid.