Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet.Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years. Free template with formulas. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Note: The purchased version of this document includes a Loan Amortization Schedule Calculator (in Microsoft Excel format). To download the Calculator (Excel format), just click the download link below. Free Excel Mortgage Amortization Calculator. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. Otherwise, you can use Table 1 to determine your qualified loan limit and deductible home mortgage interest.