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. 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. Real estate excise tax (REET) is a tax on the sale of real property. Real property, or real estate, means any interest, estate, or beneficial interest in land.