The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. 13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, TotalFill in the "Period" column. Fill in the column titled "Period" with your payment dates. An amortization schedule is made up of a list of monthly payments that a borrower makes to repay a loan that they owe to a lender.