In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization. Select the appropriate Checklist tab.Submit documents from the Deferred Loan Checklist when your borrower has a Purchase Contract and is already in escrow. Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. The purpose of this guidance is how to identify, verify, analyze and adjust sale comparables for both seller and financing concessions. Loan estimate: Completed sample forms ; Refinance (en Español). Download PDF ; Balloon payment. Lutheran Church Extension Fund (LCEF) offers loans for churches and individuals who qualify as Rostered Church Workers.