Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. Looking for a flexible free downloadable mortgage calculator built in Excel?Try this free feature-rich mortgage calculator today! This form is furnished to give you a statement of actual settlement costs. In this video I'm going to show you how you can use Microsoft Excel to conduct a fairly straightforward exercise in loan amortization.