The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. 13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, TotalAdding extra principal payments in order to pay off the loan earlier than the loan contract calls for. In this tutorial we will add this feature. Examples of two simple amortizing loans: A 2-page Microsoft Excel printout. View Notes - _e06ch11_grader_h1_Loans. Clerk IV. Contra Costa County Superior Court.