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.It's a document that covers the life of the loan and lists every single payment, breaking down principal and interest. A Comprehensive Excel Mortgage Calculator includes taxes and insurance to provide a thorough estimate of monthly home loan expenses. I am trying to create an amortization schedule for my mortgage but need to add in for escrow payments. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. There are two methods of obtaining a LIHTC allocation: 1) the competitive application process; and 2) taxexempt bond financing.