Finish. Sumit for Gradng

In the Specific Loan Data worksheet, insert the Payment function in B$13$ to calculate the monthly

$(15$ points$)$

payments for the Loan Amount. $($The formula result for the monthly payment should be a positive value.$)$ Then, beginning in cell D$5,$ complete the series of substitution values ranging from $4\mathrm{.}0\%$ to $6\mathrm{.}0\%$ in increments of $\mathrm{.}25\%$ vertically down column D$.$ Add references to the Payment, Total to Repay Loan, and Total Interest Paid formulas in cells E$4,$ F$4,$ and $G4,$ respectively. $($It may be helpful to create custom names for cells E$4,$ F$4,$ G$4$ to make it easier to read the table.$)$ Create a one$-$variable data table for the range D$4$:G$13$ using the APR as the input cell. Using the one$-$variable data table, What is the Payment if the APR for the loan were to be $5\%?$

$111,906\mathrm{.}94$

$231,906\mathrm{.}94$

$6,000\mathrm{.}00$

$7,806\mathrm{.}17$

$644\mathrm{.}19$