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, TotalThis calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. To use our amortization calculator, type in a dollar figure under "Loan amount.