The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments.13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. This calculator will help you compare the costs of a loan with a biweekly payment schedule and a loan with a monthly payment schedule. I'm looking for a Biweekly Loan Amortization Schedule that will allow me to input various additional payments depending on ability. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments.