Fill in the "Period" column. Fill in the column titled "Period" with your payment dates.Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Free template with formulas. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage.