In cell $H4,$ insert a formula using the PV function and the monthly interest rate $($cell H$6),$ the loan period in months $($cell H$8),$ and the monthly payment $($cell $H10)$ to calculate the loan amount for the $20$ year scenario.

$12.$ In the third scenario, Liam could pay back the loan for eight years with a monthly payment of $$8,000$ and then renegotiate better terms. He wants to know the amount remaining on the loan after eight years or the future value of the loan.

In cell I$11,$ insert a formula using the FV function and the rate $($cell I$6),$ the number of periods $($cell I$8),$ the monthly payment $($cell I$10),$ and the loan amount $($cell I$4)$ to calculate the future value of the loan for the eight$-$year scenario.

$13.$ Liam plans to print parts of the Loan Calculator workbook. Prepare for printing as follows:

a$.$ Set row $3$ as the print titles for the worksheet.

b$.$ Set the range F$3$:I$11$ as the print area.

$14.$ Hide the Properties worksheet, which contains data Liam wants to keep private.

$15.$ Go to the Equipment Loan worksheet, which contains details about a loan the company used for computer network equipment. The worksheet contains two errors. Make sure Excel is set to check all types of errors, and then resolve the ones on the Equipment Loan worksheet as follows:

a$.$ Display the possible errors and solutions for cell $C2,$ and then select convert to number.

b$.$ Trace the precedents to the formula in cell I$9,$ which should multiply the scheduled payment amount by the number of scheduled payments. Correct the error.