$18$

The $3-$Finance worksheet contains inputs for a loan.

In cell F$2,$ insert the PV function to calculate the loan. Use cell references in the Input Area and Basic Output Area.

$19$

You are ready to insert formulas and functions in the loan amortization table.

In cell C$7,$ enter a reference to the Payme hit that is stored in cell D$2.$ Use mixed reference so that the row number does not change. Copy the formula from cell $C$ to the range C$8$:C$42.$