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.This form is furnished to give you a statement of actual settlement costs. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly.