1a) You would like to purchase a car that costs $34,000. You have decided to finance the car with a six-year car loan. If the APR (annual percentage rate) is 4.25 percent, compute your monthly payment.

1b) Construct a loan amortization table in Excel for the car loan in Problem 1a. You should do the problem in Excel using monthly payments and should submit the spreadsheet.