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.Microsoft Excel Mortgage Caculator XLS Worksheet. This amount WILL NOT include Monthly Mortgage MI or Future Escrow Shortage Payment Amount. I am trying to create an amortization schedule for my mortgage but need to add in for escrow payments.