Download a Free Balloon Loan Payment Calculator for Excel. Calculate the balloon payment and amortization schedule for variaous loans.Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. 6. A stepbystep guide for making loan payment tables: How to create an amortization schedule in Excel? Examples and free templates.