The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates.Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.