First, you'll need to create a loan amortization schedule in the downloaded Excel spreadsheet. Create the table on the tab named "Part 2 Loan Amortization Sched." The following table illustrates the payments and interest amounts for a fixed-rate, 30-year, $500,000 mortgage, at a five-percent interest rate. The monthly payment will be $2,684.11. Payment Number Payment Amount 5% Interest Expense Principal Balance Annual Interest Expense 0 500,000.00 - 1 2,684.11 2,083.33 600.78 499,399.22 2 2,684.11 2,080.83 603.28 498,795.94 ...break in the sequence... Totals 466,278.03 500,000.00 359 2,684.11 22.22 2,661.89 2,671.41 360 2,682.54 11.13 2,671.41 - 855.56 The table serves as an example of what you'll create in Excel. Note that the table shows only the figures for the first and the last year of payments; you'll need to calculate the amounts for the remaining payments and fill them in. Once you've determined how each amount in the table is obtained, you can use relative and absolute cell references to fill in the full 360 payments. The following is an explanation of the columns in the table: Payment numberThe first column in the table shows the 360 payments required to pay off the mortgage loan (30 years, with 12 monthly payments per