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.Free template with formulas. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Check out the web's best free mortgage calculator to save money on your home loan today. Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years. Pivot Tables: allows you to extract the significance from a large, detailed data set. Pivot Charts: the visual representation of a pivot table. Check out the web's best free mortgage calculator to save money on your home loan today. LendingTree helps you get the best deal possible on your loans.