The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Fill in the "Period" column.Fill in the column titled "Period" with your payment dates. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. Loan amortization schedule. 3. 4, Enter values, Loan summary. Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. Fund Financial Statements. Governmental Funds: Balance Sheet – Governmental Funds .