Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8.Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Mortgage or loan schedule, is a list of payments that shows each loan repayment and a breakdown of the principle amount and the interest. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. Free template with formulas. Download a Free Balloon Loan Payment Calculator for Excel. Calculate the balloon payment and amortization schedule for variaous loans.