Microsoft Excel Mortgage Caculator XLS Worksheet. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. There are three fields to fill in: home price, down payment and mortgage interest rate. In the dropdown box, choose your loan term. Download a Free Balloon Loan Payment Calculator for Excel. Calculate the balloon payment and amortization schedule for variaous loans. Your loan program can affect your interest rate and total monthly payments. Otherwise, you can use Table 1 to determine your qualified loan limit and deductible home mortgage interest. This form is a statement of final loan terms and closing costs.