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 Choose a Mortgage Broker
Buying a house can be a daunting task, and for a first time borrower you might not know all the ins and outs that are involved in taking out a home loan. A mortgage broker can help - they are the professionals that match your needs with a home loan from a selection of lenders. But it's important to choose the right broker - one who is knowledgeable, accredited, and covers a wide range of lenders.
- How to Prepay Your Mortgage
- How to Avoid Foreclosure by Knowing Your Mortgage Type
- Advantages and Disadvantages of Refinancing
- Real Estate Note
- Flexible Mortgage For Self Employed
- How to Talk to Mortgage Lenders
- How to Follow the Mortgage Accelerator Plus Program
- Green Mortgages
- How to Understand a N.I.N.J.A. Mortgage