To add a monthly escrow amount to the loan amortization schedule in Excel, you can follow these steps: Insert a new row below the last payment row. This finance video tutorial explains how to create an amortization table in excel.This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. To get a better sense of the total costs of buying a home, use our home mortgage calculator and figure out what your future mortgage payments might be. Provides clients with exceptional title, escrow, and real estate closing services. 651-779-3075.