Fill in the "Period" column. Fill in the column titled "Period" with your payment dates.13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. An amortization schedule is a detailed table that outlines the periodic payments over the loan tenure. The market realized this and gave them low valuations. In a way, the market is efficient.