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.Watch as a build a fully dynamic, mortgage amortization 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.