Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8.Use the following formulas to show the total payment, interest portion of the payment, and principal portion of the payment. We're going to create an amortization table that basically shows as you make payments how much of that goes towards interest. This video shows how to construct an amortization table in Google Sheets using fills and the PMT function. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. In the next section, you can see the greetings part of the mail. Check out the web's best free mortgage calculator to save money on your home loan today. How to create an amortization schedule in Excel Create column A labels. Enter loan information in column B. Calculate payments in cell B4.