This finance video tutorial explains how to create an amortization table in excel. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage.This video steps through the creation of a loan amortization schedule in Microsoft Excel and Google Sheets. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. This loan amortization calculator figures your loan payment and interest costs at various payment intervals. Simply input the principal amount borrowed. To reach the formula for compound interest, you algebraically rearrange the formula for CAGR. An amortization schedule is typically used to describe compound-interest loans that have a fixed amount to be paid each period (often months) This college cost and savings calculator projects future college costs and financial aid, so you can plan how much to save in a 529 plan each month.