An amortization schedule is a table that shows each loan payment and a breakdown of the amount of interest and principal. Fill out the rest of the schedule using the crosshairs.To complete your amortization schedule, highlight cells B9 to H9. Looking for a flexible free downloadable mortgage calculator built in Excel? Try this free feature-rich mortgage calculator today! Click the "File" menu and click the "New" option. Looking for a flexible free downloadable loan calculator built in Excel? Try this free feature-rich loan calculator today! The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Screens 1 2:Excel Spreadsheet Fill in the second row below with the formula used for each calculation on the spreadsheet.