# How to Calculate Monthly Payments for a House Payment

Page content

## Why You Should Care

Knowing how to calculate monthly mortgage payments is one of those things people never really think about. The mortgage bill comes in the mail or email every month and you just pay what the statement says you owe. However, harsh economic times exacerbated by the housing crisis, is making people more aware of the importance of knowing how to calculate monthly payments for a house payment. In addition to making you more in control of your finances, and obtaining vital knowledge about what accounts for the mortgage bill each month, learning this calculation also helps you catch the occasional billing error made by the mortgage company. More importantly, it helps you know if you are getting a good deal or if you should be working on reducing your mortgage cost. Finally, when you know how to calculate your monthly mortgage payment you can decide to make extra mortgage payments to pay off your loan sooner.

There are two ways of calculating monthly mortgage payments: manually using a financial calculator and a spreadsheet which you configure, or automatically, by using an online calculator or preconfigured spreadsheet.

## Calculating Your Monthly Mortgage Payment Manually

In order to learn how to calculate monthly payments for a house payment, you need a financial calculator and a few figures. These include, the principal value of the loan, the interest rate, and the term of the loan. Let’s illustrate how to do this using an example of a \$200,000 house to be purchased with a 30-year mortgage at a 6 percent interest rate requiring a 20 percent down payment. Here are the steps to follow:

1. Calculate the principal value of the loan - In this case, this will be 80 percent of \$200,000 or \$160,000, since the mortgage requires a 20 percent down payment.
2. Calculate the monthly payment - Using a financial calculator, put in the value of the loan, the interest rate, and the length of the loan (in this case 30 years) to calculate the monthly payment. You will have to follow the instructions from your particular calculator for doing this. Your calculator will in turn compute the value of your monthly payment. Doing this will result in \$959.28 as the monthly payment.
3. Calculate the interest for the first month - The interest payment for the first month of the mortgage is calculated as follows: Principal times the interest rate divided by 12 = 160,000 x 6%/12 = \$800. This means that \$800 of the monthly payment for the first month will go toward interest while the balance of \$159.28 will go toward paying off the principal. The value of the interest payment will reduce in each subsequent month as the principal balance on the loan reduces until it becomes zero and the loan is paid off. This process is known as amortization.
4. Use the information in step 3 above to create an amortization table or amortization schedule - This gives you the value of the monthly payment each month stating what portion goes to pay off the principal and what portion covers the interest payment. Therefore in the second month of our example, the principal balance would be \$159,840.72 (\$160,000 - \$159.28). Remember that of the \$959.28 payment in the first month, only \$159.28 went toward paying off the principal, while the greater share, \$800 was an interest payment.
5. Manual Computation - If you click on the screenshot in the upper right, you can see an example on how to manually calculate your mortgage payment through preset mathematical computations.

Screenshot credit: Isnare.com (https://www.isnare.com)

## Calculating Your Monthly Mortgage Automatically

These automatically pre-configured spreadsheets are probably the easiest way to learn how to calculate monthly payments for a house payment.