This finance video tutorial explains how to create an amortization table in excel. Use these calculator templates to help you navigate your loans, budgets, net worth, and more.Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage.