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. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. Texas has several exemptions from local property tax for which taxpayers may be eligible. Find out who qualifies.