This finance video tutorial explains how to create an amortization table in excel. This video steps through the creation of a loan amortization schedule in Microsoft Excel and Google Sheets.This example teaches you how to create a loan amortization schedule in Excel. 1. We use the PMT function to calculate the monthly payment on a loan. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. How to find a loan payment amount and build an amortization schedule. Excel Loan Amortization =PMT formula.