The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates.Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. This pre-qualification worksheet will automatically calculate monthly housing expense, residual income and debt-to-income ratio. Several loan and amortization table calculators are available online. Any residual scrap value in the structure is equivalent to the cost of removal.