Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. A balloon payment, simply put, is a large payment that is due at the end of a loan term.It is different from a fully amortized loan, where a loan is paid. A bullet loan, or balloon loan, is a loan that does not fully amortize over the term of the note, leaving a large balance due at maturity. Have cube with a few measures, and 2 of them are quantity, avgprice and money. Art O'Hare,for all your real estate needs.