Mortgage Analysis Worksheet Below is a worksheet you can use to start to do some economic analysis to compare mortgages. The first seven lines set the basis for the analysis and the remaining lines track the balance of the mortgage from the initial loan balance until the loan is paid off, a process known as amortization. Note: Payments 4 through 359 are not shown.