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.Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. This finance video tutorial explains how to create an amortization table in excel. This article will show you how to make a loan amortization schedule in Excel, providing a clear view of your loan repayment process. What is an Amortization Schedule? Free template with formulas. This will automatically populate your entire amortization schedule, showing how each payment affects your balance over time. A Loan Amortization schedule breaks down each payment into its interest and principal components for the full term of the loan.