Free template with formulas. Open Excel and select "Loan Amortization Schedule" from the template gallery.Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. The model is a hybrid of HEC-l and an EXCEL spreadsheet. The repayment of principal through these serial and term bonds is the amortization schedule for the bond issue as a whole. Charter. Obligor. Investors. Conduit. Solution for W History Bookmarks Window Help d Loans - 21516 MAT142 Topics in College Math DERIVITA Tiana Klughart Ad2l.pima. View Excel Skill Chapter 5.