Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Use our self-service options on this website to pay your taxes or make a phone or video appointment at your convenience.I am looking for some additional information on balloon loans; and would like to create a spreadsheet to help me analyze offers relating Following are general guidelines and program requirements intended to assist a lender in completing the form.