Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization.Given the following info, how do I calculate the balloon balance using a single cell? These calculator templates can help you with your mortgage, loans, budgeting, and more. I am looking for some additional information on balloon loans; and would like to create a spreadsheet to help me analyze offers relating âś“ Loan approval: After underwriting is complete, the file goes up against a loan approval committee. The committee can either approve or disap- prove your loan. When the binder is opened in Excel, add the Hire Purchase or Chattel Mortgage worksheet against the loan account.