Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization.Do you need help understanding your debt financing terms? Find useful forms for property assessments, real estate property and deeds, Military Discharge (DD214) requests, and more. Best mortgage lenders near me. I am trying to create a formula to calculate the annual interest on an amortising loan that has a ballon payment at the end. Please click here to search for Historical Deeds, Chattel Mortgage Book and Feme Sol Trader Offices; for the period 1792-1857.