You are ready to start completing the loan amortization table.

In cell C$8,$ type a reference formula to cell B$1.$ The balance before the first payment is identical to the loan amount. Do not type the value; use the cell reference instead. In cell c$9,$ subtract the principal from the beginning balance on the previous row. Copy the formula to the range C$10$:C$19.$