13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total Adding 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. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. Excel Amortization Schedule With Irregular Payments v. 2 - Free download as Excel Spreadsheet (. We have included an excel spreadsheet for your use so that multiple scenarios can be entered to find the best option for you. This loan amortization schedule calculator figures your monthly payment and interest into a helpful amortization schedule for printing. Simple and flexible.