Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates.SUNY-authorized schools must download the Excel spreadsheet entitled "Audited Financial Report. Regentsauthorized schools must download and complete the Excel spreadsheet entitled "Audited. In the mortgage amortization table for 240 months seen in Section 8.3. 2, only the formulas for month 1 were typed in. For a more complete description of this function refer to the Excel documentation. This is a presentation that I made for my Accounting Systems class at Frostburg State University. After doing so, we can fill the remaining cells below and must confirm that the outstanding balance in the final period is zero. Need to know how to make an amortization table in Excel?