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.Watch as a build a fully dynamic, mortgage amortization in Excel. Use this free North Carolina mortgage calculator to estimate your monthly mortgage payments and annual amortization. Microsoft Excel Mortgage Caculator XLS Worksheet. Calculate your monthly payment for fixed rate or adjustable rate loans.