Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly.In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. I am looking for some additional information on balloon loans; and would like to create a spreadsheet to help me analyze offers relating This feature is risky. In the Los Angeles area. He holds a Master's degree in Hospitality Management from. Here's what you need to know about the benefits and risks of taking out a balloon mortgage for a home purchase.