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. I am trying to create an amortization schedule for my mortgage but need to add in for escrow payments. This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. The approximate initial credit support percentages shown in the table above for the Principal Balance Certificates do not take into account the VRR Interest.