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. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. Are you paying high interest rates on your debts? LendingTree's personal loan payment calculator can help you see how much your loan could cost, including principal and interest. From this example, you can see how the interest rate paid goes down every month, and the amount towards principal goes up. Use LendingTree's SBA Loan Calculator to estimate monthly payments on SBA Loans. You can calculate the payments as shown below.