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.Looking for a flexible free downloadable mortgage calculator built in Excel? Try this free feature-rich mortgage calculator today! Use our free Auto Loan Calculator to estimate the overall cost of purchasing a car, including the sales price, sales tax, and the many charges and fees. Note: The spreadsheet is only valid for up to 780 payments (65-year monthly, 30-year biweekly, 15-year weekly, etc.) No. This spreadsheet is an allinone home mortgage calculator. It lets you analyze a fixed or variable rate home mortgage. Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan. Rate: The interest rate of the loan.