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.Loan amortization schedule. 3. 4, Enter values, Loan summary. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly 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. Create a Loan Amortization Schedule in Excel and include optional extra payments. An easy-to-use amortization calculator. Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8.