Make math easier with these free calculator templates. 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. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly. Creating a loan amortization schedule and understanding balloon payments. For a printable payment schedule, click on "Create Amortization Schedule" and a new browser window will open.