A balloon mortgage is usually rather short, with a term of five to seven years, but the payment is based on a term of 30 years. In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization.Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Do you need help understanding your debt financing terms? I am looking for some additional information on balloon loans; and would like to create a spreadsheet to help me analyze offers relating We are looking to fill this position for May 2022 and ramp up training for the summertime, so please send your resume and cover letter when you respond. Over 290 registered members gathered together for our 66th Annual Meeting! Download English and Spanish versions of TRID model and sample forms for different loan types. Fda form 3654 guidance residential.