In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. Download a Free Balloon Loan Payment Calculator for Excel.Calculate the balloon payment and amortization schedule for variaous loans. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly. And they might choose to always round down, usually resulting in a small "balloon payment" (extra principal) with the last payment. Do you need help understanding your debt financing terms? For a printable payment schedule, click on "Create Amortization Schedule" and a new browser window will open. Fill in the spreadsheet for Ann. Fill in the column titled "Period" with your payment dates. Input the month and year for the first payment loan within cell A8.