Microsoft Excel Mortgage Caculator XLS Worksheet. This finance video tutorial explains how to create an amortization table in excel.This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. Loan amortization schedule. 3. 4, Enter values, Loan summary. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This tool helps you decide whether it makes sense to accelerate your monthly mortgage payments. On the left side of the calculator, enter your loan balance. Use our amortization calculator, type in a dollar figure under "Loan amount. I'm looking for a Biweekly Loan Amortization Schedule that will allow me to input various additional payments depending on ability.