How to Create a Mortgage Calculator With Microsoft Excel

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.

Related Articles
- How to Prepay Your Mortgage
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.
- Green Mortgages
- Real Estate Note
- Advantages and Disadvantages of Refinancing
- Flexible Mortgage For Self Employed
- How to Avoid Foreclosure by Knowing Your Mortgage Type
- How to Choose a Mortgage Broker
- How to Talk to Mortgage Lenders
- How to Understand a N.I.N.J.A. Mortgage
- How to Follow the Mortgage Accelerator Plus Program