The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This finance video tutorial explains how to create an amortization table in excel.Fundwave makes it possible for investors to plugin variables such as principal, interest rates, moratorium periods, etc to set up an amortization schedule. Loan period in years, 1, Actual number of payments, 10. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments. The tool dynamically calculates the period wise debt servicing based on payment frequency annual, biannual, quarterly or monthly. Use ICICI Bank's education loan calculator to calculate your student loan EMIs and study loan payments. Several loan and amortization table calculators are available online. Director Quadrozzi (Beverly Hills, Michigan). 3.