The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Have a loan you want to pay off?Try this amortization schedule Excel template to calculate your payments and track your payoff progress. 13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total Again super quick, hope this helps. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. A loan amortization schedule is a table detailing each periodic payment of a loan or debt over time. Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8. This video shows how to create an amortization or loan schedule that also so cumulative amounts of payments, interest and pricipal paid.