Use excel

To purchase a car, you take out a $5-$year auto loan with monthly payments. The total purchase price of the car is $$37,500,$ and the down payment equals $$5,000.$ The annual interest rate $($APR$)$ is $6\mathrm{.}0\%.$

A$.$ What is the monthly payment required by this auto loan? $(3$ Points$)$

B$.$ How much of each month's payment goes to paying interest and how much to reducing the principal balance? $(5$ Points$)$

C$.$ What is the total amount of interest you pay over the life of the auto loan? $(2$ Points$)$

D$.$ Create a Data Table to examine the monthly payment under various annual interest rates. $(5$ Points$)$

$\backslash$table$[[$Annual Interest Rate,$5\mathrm{.}0\%,5\mathrm{.}5\%,6\%,6\mathrm{.}5\%,7\mathrm{.}0\%$