Monthly loan paymentsPersonal Finance ProblemTim Smith is shopping for a used luxury car. He has found one priced at $35,000.

The dealer has told Tim that if he can come up with a down payment of $5,700,

the dealer will finance the balance of the price at a 77% annual rate over 22 years

(24 months).(Hint: Use four decimal places for the monthly interest rate in all your calculations.)

a.Assuming that Tim accepts the dealer's offer, what will his monthly (end-of-month) payment amount be?

b.Use a financial calculator or spreadsheet to help you figure out what Tim's monthly payment would be if the dealer were willing to finance the balance of the car price at an annual rate of 3.1%?

Please Post Excel Formulas ******