Use these calculator templates to help you navigate your loans, budgets, net worth, and more. This finance video tutorial explains how to create an amortization table in excel.Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. Free template with formulas. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Fill in the column titled "Period" with your payment dates.