Calculate the monthly payments, total interest, and the amount of the balloon payment for a simple loan using this Excel spreadsheet template. 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. Note: A value of Removed is used to indicate a field has been added and then deleted within the same release. Land Contract Calculator. Fill in the fields below. If you're thinking of investing in real estate, learn what investment property loans are available and how to qualify for them. This form is a statement of final loan terms and closing costs. Land – usually, the property on which you will be building is included in the real estate construction loan. Our income analysis tools are designed to help you evaluate qualifying income quickly and conveniently.