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. The loan will then be amortized based on a twenty year amortization with a balloon payment due at the end of year six. (7). Mortgage Loan Contains Negative Amortization.