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
- Advantages and Disadvantages of Refinancing
Refinancing your mortgage is when you get a new mortgage loan out and use the money from the new loan to pay off your old mortgage loan. In some cases refinancing home loan options are a good idea, and in some cases, refinancing your home loan is not such a good idea. Sometimes, refinancing your mortgage may cost you more money in the long run.
- How to Follow the Mortgage Accelerator Plus Program
- How to Prepay Your Mortgage
- How to Avoid Foreclosure by Knowing Your Mortgage Type
- How to Talk to Mortgage Lenders
- Real Estate Note
- Green Mortgages
- How to Understand a N.I.N.J.A. Mortgage
- How to Choose a Mortgage Broker
- Flexible Mortgage For Self Employed