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 Avoid Foreclosure by Knowing Your Mortgage Type
Losing home in a foreclosure process is a miserable thing. And the reason behind foreclosure is that people stop making their mortgage payments. Ofen, you can avoid this unfortunate financial condition by reading the mortgage documents carefully, before signing on the dotted lines. Be sure to hire an attorney to help you understand what you are getting into.
- How to Prepay Your Mortgage
- How to Choose a Mortgage Broker
- Real Estate Note
- Green Mortgages
- Flexible Mortgage For Self Employed
- Advantages and Disadvantages of Refinancing
- How to Talk to Mortgage Lenders
- How to Understand a N.I.N.J.A. Mortgage
- How to Follow the Mortgage Accelerator Plus Program