You are interested in purchasing a $$17,999$ new car. You are weighing your options regarding down payment and payment schedule. Your credit score indicates that you can secure a loan with a $5\mathrm{.}9\%$ interest rate for a $5-$year loan. The facts are summarized below.

Answer the questions below.

If you pay $10\%$ as a down payment $($so only need to borrow $90\%$ of the car price$),$ use an EXCEL formulas and functions to complete the following table assuming you make ANNUAL payments.

Payment amount:

Total repayment:

Total interest:

If you pay $10\%$ as a down payment $($so only need to borrow $90\%$ of the car price$),$ use an EXCEL formulas and functions to complete the following table assuming you make MONTHLY payments.

Payment amount:

Total repayment:

Total interest: