Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. When the binder is opened in Excel, add the Hire Purchase or Chattel Mortgage worksheet against the loan account.In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. Loan estimate: Completed sample forms ; Refinance (en Español). Download PDF ; Balloon payment. Looking for a flexible free downloadable mortgage calculator built in Excel? Try this free feature-rich mortgage calculator today!