This finance video tutorial explains how to create an amortization table in excel. This video steps through the creation of a loan amortization schedule in Microsoft Excel and Google Sheets.Use these calculator templates to help you navigate your loans, budgets, net worth, and more. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Maintaining general ledger accounts; preparing adjusting entries, amortization of prepaid expenses, fixed asset depreciation and accruals.