Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Loan estimate: Completed sample forms ; Refinance (en Español).Download PDF ; Balloon payment. In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. This form is furnished to give you a statement of actual settlement costs. Extraordinary Redemption of Bonds. Agency names and numbers in bold below correspond to the divider tabs in the IAC binders. Update: Certain forms are now available on this site in two formats - the traditional and the new fill-in format. Methodist Church in Henrico County,. Virginia.