This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. 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. No depreciation or amortization expenses are allowed. 292, 3), Fill in the annual operating expense amounts for the following line items as appropriate:.