Make math easier with these free calculator templates. In Excel the typical amortization schedule looks like this: In Workday Adaptive Planning most versions only go 15 years into the future.This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.