Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. I am looking for an Excel worksheet example of a loan schedule with a balloon payment at the end.My internet search has not found much on the subject. When the binder is opened in Excel, add the Hire Purchase or Chattel Mortgage worksheet against the loan account. Balloon payments are lump sum payments that are typically due at the end of the loan term. The Common Council of the City of Kenosha shall be composed of the Mayor and seventeen (17) Alderpersons. Fill in the form below, and we'll be in touch. Our form allows for temporary off premises coverage up to 90days in one year (12month) period. 3. A "discharge of mortgage" signifies the legal document that liberates a mortgage lien on a property upon full repayment of the mortgage loan. 169. Summary. 169. SECTION THREE.