In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. Access vital forms: Organizational Chart, Personal Finance Statement, Rent Roll Template for Multifamily, Commercial Mortgage Loan Calculator, and more.Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. A "balloon payment" is the final installment of a loan to be paid in an amount that is disproportionately larger than the regular installment. A chattel mortgage must be signed. CACE220 11787 pending in the 17 Judicial Circuit in and for Broward County, Florida. 4.