Loan Types and Loan Amortization Equal Payment AutoSum Creating an equal payment amortization schedule is similar to the equal principal amortization schedule. First, we need to calculate the loan payment for the 15 year loan, which we can calculate using the PMT Loan amount: $ 350,000 Interest rate: 9% This means that the equal annual payments will be: Equal payments: ? So, the equal annual payment amortization table will look like this: Beginning Total Interest Principal Ending Balance Payment Paid Payment Balance 1 $ 350,000.00 ? ? 2 ? ? ? ? 3 ? ? ? 4 ? ? ? 5 ? ? ? 6 ? ? 2 7 ? 1? 8 1? ? ? ? 9 ? ? 1? 10 le ? ? ? ? 11 ? ? ? 12 ? ? ? ? 13 ? ? ? ? 14 ? ? ? ? 15 ? ? ? ? ? $ ? ? 2 ? ? ? ? ? ? 2