Download a Free Balloon Loan Payment Calculator for Excel. Calculate the balloon payment and amortization schedule for variaous loans.Use the farm or land loan calculator to determine monthly, quarterly, semiannual or annual loan payments. Get ag-friendly, farm loan rates and terms. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. For a simple loan using this Excel spreadsheet template. 6. Beside those, we can also add balloon payment, which is an optional clause for loan contracts. LoanAmortizationCalculatorS002. For a printable payment schedule, click on "Create Amortization Schedule" and a new browser window will open. Reported in the FR Y14Q Corporate Loan schedule. 2. Eligible Activities.