$16.$ Starting at cell E$5,$ fill in the range of annual interest rates of $1\%$ through $10\%,$ in increments of $1\%.$

$17.$ Enter a reference for the loan payment $($cell B$10)$ into the appropriate location in the data table.

$18.$ Complete the two variable data table to display the loan payment for each corresponding loan

duration and annual interest rate.

$19.$ Open the Solver and set an objective of $700$ for the loan payment $($cell B$10)$ by changing the annual

interest rate $($cell B$5)$ and the loan duration $($cell B$7).$

$20.$ Add a Solver integer constraint for the loan duration $($cell B$7).$

$21.$ Run the Solver to solve for the solution. Keep the solution but do not generate any reports.

$22.$ Create a formula in cell B$12$ that calculates the cumulative principal repaid on the loan after $1$ year

of payments. Assume that loan payments are made at the end of the payment period.