Fill out the rest of the schedule using the crosshairs. To complete your amortization schedule, highlight cells B9 to H9.Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. An amortization schedule is the plan for monthly repayment. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. An Excel spreadsheet is simply a collection of cells that you can use to enter data. Each cell is given a name based on its position in the spreadsheet. Check out the web's best free mortgage calculator to save money on your home loan today.