In the context of calculating monthly mortgage payments, you simply just need three parts of data and an advanced mortgage calculator or spreadsheet. This data will derive an estimated monthly mortgage payment from which you can find out which kind of home you can afford to buy depending upon present mortgage interest rates. Here, in this article, you will find how to calculate monthly mortgage payments in simple steps.
Steps for calculation
• Get your FICO scores from TransUnion, Experian, and Equifax. You are legally entitled to score 1 time every year from each credit agency. Here the three largest and most commonly used agencies are listed. Your credit score is necessary because it helps in determining which kind of interest rate you will have to pay. For example let us take a $ 200,000 home at an interest rate of 5.0% for 30 years on a payment of $ 1075.00 per month. Now again take the same $ 200,000 home at an interest rate of 6.0% for 30 years. Now you have to pay $ 1200.00. Now you can see that there is a difference of $ 125.00. So it is important to know if mortgage brokers, bank lenders or realtors will be helping you in securing a lower or higher interest rate. Paying points is something which no one will like. There are many interest rates of different companies which can be found which are competitive and do not need purchasing points. Points are generally a percentage which is normally 1% of home price which make a home buyer capable to buy down the interest rate. You can also finance again in the future or go around for lower rates. You should not buy the publicity of purchasing a point or two.
• Determine a loan amount like interest rate, mortgage rate, loan rate etc. Present and competitive interest rates can be found at different financial websites. Depending upon your credibility and some other factors like where you are planning to buy, how much you are going to put down will determine your rate. There is a word associated with rates, i.e. ‘term’. This word stands for how long do you need to own the loan. A maximum of 40 years exists for fixed rates. A fixed rate stands for your agreement of paying a specific interest rate for a given duration of time. When looking for loans, always confirm that there is no penalty for payment of the loan earlier than that of the duration that was fixed.15 yrs and 30 yrs are mostly applied as the duration of payment of loans. Experts suggest asking for 30 yrs and paying it off earlier. A modifiable interest rate may be a 3/1, 5/1 or 7/1 arm. It means you have to pay a certain rate for the first 3 years and then after those 3 years the loan amount will be raised. Normally it is like first 5.0% for the 1st 3 years then after that it is raised to 8.0%. These loans have different specific uses, so you need to consult a professional mortgage broker for better knowledge.
• Real Estate Taxes vary vastly from place to place. If you are looking for a property at some place, only the realtor of that place can tell you the original real estate taxes the present property owner is paying. Real estate taxes are generally combined together with the school taxes, trash, fire / police etc. into one real state tax amount. This is something that is generally underestimated a lot by the average first time home buyer. You should research properly on this fact. You should call the city tax authority and determine what you have to pay.
• For the calculation, type Home Price in the 1st row of an Excel sheet. Then enter a desired value beside that cell. In the example we have taken, it as $ 200,000.
• Type Interest Rate in the 2nd row then enter the desired interest rate to the cell right to it. The value for 5.50% will be entered as 0.055.
• Type term in the 3rd row then enter the desired term beside the cell. In our example it would be 30. 30 will represent the numbers of year.
• Generate the PMT computation. This has to be a fixed interest rate payment calendar. Place in a function in the 4th row known as Payment. Besides the Payment cell, put the Fx button.
• Fill up the function dialog box as given below:
Rate = value of interest rate i.e. 0.055 / 12
N per = value of terms i.e. 30 * 12
Pv = loan amount in negative i.e. -200000
Fv = 0
Type = 1
after all this calculation you will find the result i.e. 1130.40 in this example.
• Type Taxes below the payment cell. Enter = annual tax amount / 12 to the right of that cell.
• This will compute your monthly real estate taxes. In this example, we have to use 4500 / 12 which will equal to $ 375.00 per month.
• If you are not willing to put 20% of the home price then you have to factor $ 50.00 in PMI for every $ 100,000 on loan. When you get 20% equity in your home then you can request to stop this. Keep away from paying PMI all together. Do not let this discontinue you from receiving your home. It is just a bit to be aware of. This does not have to be counted towards paying your loan. You can check online for more information on this.
• Add up the value of cell of payments together with the cell value of taxes and the PMI cell value. The value you obtain will be your total monthly payment. One thing to be noted is that it is an app. Value. Remember, you will significantly reduce the amount of time you will be having for your loan if you make one additional monthly payment in a year. Make sure that specifically the amount of your additional payment should be kept directly in your exceptional principal amount and not in another monthly payment.
Tips and warnings
• Always study the fine print.
• Ask for suggestions from the people or friends and family who have successfully used it.
• Keep away from complex terminology. Ask the person to make it understandable to you.
I hope this article would have proved helpful to you in calculation of monthly mortgage payments.
Related Tags: how to calculate a monthly mortgage payment, calculate the monthly payment of 125 00
Related Content: