Some Information As To What A Mortgage Calculator Formula Is

A mortgage calculator formula is a specific equation used in many software programs for producing an idea of what a particular amount of money when borrowed will cost someone to pay back over the term of the loan. When these formulas are used they help to produce a table or schedule which shows exactly the amount that has been borrowed along with the monthly payments which can then be broken down further to show how much will be paid against the interest and how much against the principal part of the loan.

Get Equifax Credit Watch Gold 3-in-1 Now!

There are many software packages that you can use in order to set up your own mortgage calculator formula or you could even use your Excel spreadsheet if you so wish. However, probably the best thing to use is an Excel spreadsheet as this you will already have set up on your computer. You will need to open up a new worksheet in your Excel program and insert a few basic headings. In to the first cell A1 you should put in the heading "Monthly Loan Repayments" then in the next cell A2 you should type in "Amount of Loan" then in cell A3 "Interest Rate" and cell A4 "Length of Loan" then into cell A6 "Monthly Repayment".

So in order for you to work out what your monthly interest rate is going to be you need to take the value from B3 and then divide this by 12. The formula you use should look something like this B3/12. Then in order to work out what the monthly payments are going to be on your mortgage you simply take the number of years which are shown in cell B4 and then multiply this by 12. The formula for this is B4*12. It really is that simple to use.

But the best and probably the coolest part about this simple tool for using to produce a mortgage calculator formula is that it will tell you really quickly whether borrowing a large amount of money from one particular bank is worth it and in fact whether you can really afford the mortgage that you are looking at. Also it will help you to see what impact if any there would be on your budget if the interest rate went up say by 2 or 3% in the future.