Using Excel and all formulas.Monthly loan paymentsPersonal Finance ProblemTim Smith is shopping for a used car. He has found one priced at

$ 4 comma 300$4,300.

The salesman has told Tim that if he can come up with a down payment of

$700700,

the dealer will finance the balance of the price at an annual rate of

88%

over

22

years

(2424

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

55%?