The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Note: this spreadsheet is for educational purposes only.5, A fixed principal loan results in declining payments over the loan period. In this article, we will introduce you to five Excel functions that make it easy to create an amortization schedule to track our monthly payment. Live Oak and McMullen Counties experienced a year of significant events, activities, and accomplishments. Prepayment of current FHA Mortgage. The loan's amortization schedule. Access an online loan calculator with annual payments, such as the one at mycalculators.