Create an Input Table utilizing the below provided information. Annual Rate of the Loan

amount is $6\mathrm{.}5\%$

$10$ Points Total

DO NOT HARDCODE THE VALUES IN THE FORMULAS

$1.$What are the payments? $(2$ Points$)$

What is the total of all payments? $(2$ Points$)$

How much interest will I pay? $(2$ Points$)$

What are the values if the Interest Rate changes? Do it for $3\%$ to $7\%$ with an increase of $\mathrm{.}5\%(4$ Points$)$

$4.$What are the payments?

What is the total of all payments?

How much interest will I pay?