$318.$ 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

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

$220.$ 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.