Note: this spreadsheet is for educational purposes only. 5, A fixed principal loan results in declining payments over the loan period.The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This addition is part of a continued effort to promote transparency in the Budget process. Enrolled at least half-time and the principal payments are deferred.