Download a Free Balloon Loan Payment Calculator for Excel. Calculate the balloon payment and amortization schedule for variaous loans.The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Loan amortization schedule. 3. 4, Enter values, Loan summary. The full text on this page is automatically extracted from the file linked above and may contain errors and inconsistencies.