Scheduled number of payments, 12. 7, Loan period in years, 1, Actual number of payments, 10.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. Free template with formulas.