Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8.This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Often overlooked is the amortization schedule when calculating payments. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. An Excel spreadsheet is simply a collection of cells that you can use to enter data. Each cell is given a name based on its position in the spreadsheet. Have any changes occurred in the project since pre-application? Was this project previously submitted to the Ga Department of Community Affairs? Paying off your car loan early allows you to get back what you would've paid in interest.