The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Use these calculator templates to help you navigate your loans, budgets, net worth, and more.Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. State statute requires the retirement systems to amortize unfunded pension liabilities within 30 years. For the 20 year loan, create an amortization table. All Form 990 filers are required to complete Schedule O. Loan guarantee programs in the schedule.