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. Start with the sticker price (MSRP) of the car. A. Compute the monthly payment for Options 2 and 3. b. Compute the EAIR of each loan. c. Service is paid as well as a Loan Amortization schedule for the proposed debt. Depreciation, Depletion and Amortization for the trailing twelve months (TTM) ended in Sep.