Whether you use Microsoft Excel, Google Sheets ... track the results if you make extra payments, and a loan amortization schedule template, which shows how the loan is retired over time.

How Do I Create a Loan Repayment Schedule in Excel? To create an amortization table or loan repayment schedule in Excel, you'll set up a table with the total loan periods in the first column ...

With the monthly payment amount calculated, you can now begin building out the amortization schedule. Start by creating a sequence of payment numbers using Excel’s SEQUENCE function. For ...