Note: The purchased version of this document includes a Loan Amortization Schedule Calculator (in Microsoft Excel format). In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization.Total Real Estate Broker Fees. 800. Items Payable in Connection with Loan. 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. GREAT Day utilizes Oxford Abstracts for its conference platform. Of course, in some cases, doing so could end up costing you more.