How to Create a Mortgage Calculator With Microsoft Excel Saratoga Springs NY

An article describing how to create an Excel spreadsheet that calculates the monthly payment needed to pay off the loan and the total cost of the loan, assuming a constant yearly rate. The spreadsheet displays a table showing how much of the monthly payment is applied to interest and to principle. The workbook is also flexible enough to show how the loan and subsequent payments are affected if any extra money is put against the principle.

Over the course of a 30-year mortgage, you may end up paying more than twice the amount of your principal. The rest goes towards paying interest. That interest is money in the bank's pocket, not in your bank account. Prepaying your mortgage is paying extra principal, especially during the early years of your loan, meaning that your house will be paid off that much sooner, and you will pay less total interest over the life of the loan. It could put you that much closer to retirement.