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 spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments.This spreadsheet is an allinone home mortgage calculator. It lets you analyze a fixed or variable rate home mortgage. This finance video tutorial explains how to create an amortization table in excel. Microsoft Excel Mortgage Caculator XLS Worksheet. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly. Contact your lender to ask if your loan can have an escrow account. Our net proceeds calculator gives you an estimate of how much cash in hand you will have when you sell your home, and factors in the various inputs.