The Free Balloon Payment Excel Templateallows you to create a quick and easy loan calculator to compute for your monthly payment, total monthly payments, total interest, total amount paid, and balloon payment due.. This loan payment template is compatible for Excel 2003 and later versions. You can use this template to calculate your balloon payment loan.
How to Calculate a Balloon Payment in Excel. In many cases, the balloon payment must itself be refinanced and paid off as an additional loan. Calculating a balloon payment or the payments that will be made on a loan with a certain balloon payment amount is simple using Microsoft Excel.