The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Fill in the "Period" column.Fill in the column titled "Period" with your payment dates. I'm looking for a Biweekly Loan Amortization Schedule that will allow me to input various additional payments depending on ability. Daily updated south carolina real estate database. By using this amortization schedule, a person can easily create a loan payment schedule in no time.