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. Create a printable amortization schedule with dates to see how much principal and interest you'll pay over time. I am trying to create an amortization schedule for my mortgage but need to add in for escrow payments. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly. Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8. Provides clients with exceptional title, escrow, and real estate closing services.