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, TotalThis Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. Does anyone know how to calculate the principal and interest payments after a one time extra principal payment on a mortgage in excel? Adding 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. Instructions for a complete electronic submission are found under Instructions-Electronic Submit. To reflect that amortization of accrued net pension obligations could divert revenues out of future budgets and lead to funding shortfalls.