Begin completing the Amortization Schedule as follows:

a$.$ Insert a formula without using a function in cell J$4$ that subtracts the

value in cell I$4$ from the value in cell H$4$ to determine how much of the

loan principal is being paid each year.

b$.$ Copy the formula you created in cell J$4$ to the range J$5$:J$18$ without

copying any cell formatting. $($Hint: Use the Paste Gallery.$)$

$6.$ In cell K$4,$ create a formula using the IF function to calculate the interest paid

on the mortgage $($or the difference between the total payments made each year

and the total amount of the principal paid each year$)$ as follows:

a$.$ Use the IF function to check if the value in cell H$4($the balance remaining

on the loan each year$)$ is greater than $0.$

b$.$ If the value in cell H$4$ is greater than $0,$ multiply $12$ by the value in cell

D$5$ and then subtract the value in cell J$4.$ Use an absolute cell reference

to cell D$5$ and a relative cell reference to cell J$4.$

c$.$ If the value in cell H$4$ is not greater than $0,$ return a value of $0.$

d$.$ Copy the formula you created in cell K$4$ to the range K$5$:K$18$ without

copying any cell formatting. $($Hint: Use the Paste Gallery.$)$

$7.$ In cell K$20,$ insert a formula that references the defined name

Down$\_$Payment to insert the down payment amount.

$8.$ To make parts of the worksheet easier to print, assign names to ranges as

follows:

a$.$ Use Amortization$\_$Schedule to define a custom name for the range

G$2$:K$21.$

b$.$ Define names for the cells in the range D$5$:D$7$ based on the values in the

range C$5$:C$7.$

$9.$ Protect the Inn Mortgage worksheet against unauthorized changes as follows:

a$.$ Select and unlock the range B$5$:B$6.$

b$.$ Select and unlock cell D$3.$

c$.$ Protect the worksheet without a password