The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft ExcelAdding extra principal payments in order to pay off the loan earlier than the loan contract calls for. In this tutorial we will add this feature. 13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments.