The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. You can create an Excel amortization table with changing interest rates.Here's how you can build it. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. How do I create an amortization schedule in Excel? This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. A stepbystep guide for making loan payment tables: How to create an amortization schedule in Excel? Examples and free templates.