The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.Visualize your loan payments and amortization schedule with our SBA 7(a) business loan calculator. â–« Debt service pattern such as equal payments or equal principal amortization,. Limited to the loan balance specified on Schedule 4.15A less post closing principal payments. Include an assumed interest rate and principal amortization schedule. Loan Repayment and Security Structure. Amortization of loan costs. 10. 10.