The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Enter values, Loan summary.This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. As management, we assert that, to the best of our knowledge and belief, this financial report is complete and reliable in all material respects.