2.5 Mortgages: Part II – Calculations

P&I Payments

When you borrow money, you must pay back what you borrowed (principal) plus extra (interest) to the lender. While your actual mortgage payment will be higher (discussed shortly), we will begin by reviewing the loan payment problems from last module.

Let’s try one together…

Sara took out a 30-year mortgage for $157,000 at a fixed rate of 7.2%. Calculate her monthly payment.
Answer: $1,065/month

PMI

When you are unable to produce a down payment of 20%, banks generally require private mortgage insurance or PMI. Once a borrower surpasses 20% equity, they can stop paying for PMI. As mentioned earlier, PMI is meant to cover the costs of foreclosure for the bank in the event you are unable to continue to pay for the house.

Let’s try one together…

Jo and Zane bought a house for $146,000, taking out a $135,000 mortgage. Its been three years and their mortgage balance has dropped to $132,833.15 and due to renovations, the market value of the house has increased to $168,000. Can they apply to have PMI removed?
Answer: Yes (20.9% equity)

Property Tax

Jurisdictions will levy a tax on the assessed value of a property. It should be noted that the assessed value is not necessarily the market value. Some jurisdictions only assess at a certain percentage of the market value.

Additionally, homeowners generally have to pay multiple property taxes. In Pennsylvania it is typical to have to pay property taxes to your city or township, your county, and your school district. Some of these bills are combined (generally the city/township and county) or each bill may be separate.

As mentioned, property tax is generally given in mills, which is thousandths of a dollar. So if the tax rate is 20 mills, then for every dollar of appraised value, you owe $1. Some examples follow…

Let’s try one together…

Hamid has a house with a market value of $525,000 in Peters Township. His jurisdiction uses an appraisal value of 100% of fair market value. The county rate is 2.43 mills, the township rate is 1.622 mills and the school district rate is 14.16 mills. Calculate his property tax bill.
Answer: $9,564.30

Let’s try one together…

Anne has a house with a market value of $180,000. Her jurisdiction uses a appraisal value of 80% of fair market value. The county rate is 11 mills, the city rate is 8 mills and the school district rate is 30 mills. Calculate her total property tax bill.

Answer: $7,056

Tax rates can vary greatly between municipalities, school districts, and counties. For instance, the total tax rate for a house in Peters Township is around 18 mills whereas the total tax rate for a house in Jefferson Hills is around 30 mills. That means that a $400,000 house in Peters Township will cost you $7,200 per year whereas the same house in Jefferson Hills would cost you $12,000 per year. That comes out to an extra $400 per month for the house in Jefferson Hills.

PITI

As mentioned earlier, your mortgage payment is generally more than just the principal and interest. To prevent non-payment of taxes (which would put the ownership of the property in peril) or non-payment of property insurance (which would be disastrous for the bank if something happened to the property and the insurance wasn’t active), banks will generally require you to pay money into an escrow account. An escrow account is simply an account where your money is held. The bank has access to this account and will use the funds to pay your property taxes, homeowner’s insurance, and PMI. Therefore, the actual amount you pay each month is called the PITI payment which stands for Principal, Interest, Taxes, and Insurance payment. We will run through a few examples, but before we do it is important to point out that when determining what you can afford, you need to look at the PITI and not the P&I. As we saw in the property tax section, houses with the same price tag could have very different PITI payments based on the tax rates.

Let’s try one together…

Jan purchases a house in Jefferson Hills. The purchase price (and we will assume the assessed value) was $375,000. Jan makes a 10% down payment on the house. The bank approves Jan for a 30-year mortgage at a rate of 3.75%. The bank also makes Jan pay for property tax, homeowners insurance, and PMI with each payment. In Jefferson Hills, the property tax rates are as follows: county rate of 4.73 mills, township rate of 5.66 mills, and school rate of 20.236 mills. The homeowners insurance is expected to cost $1,200/year. The monthly PMI is $120. Calculate the PITI payment.

Answer: $2,740.08

Let’s try one together…

Repeat the problem above, but let the house be located in East Washington. The Washington County rate is 2.43 mills, the East Washington Borough rate is 2.75 mills, and the Washington School tax is 15.158 mills.
Answer: $2,418.58

Amortization Schedule

We talked about amortization schedules in the last module, but let us take a look at the initial payments for a mortgage.

Let’s try one together…

Jack purchases a house for $300,000. He puts 20% down. The bank charges him a rate of 3.75%. Create an amortization schedule for the first three payments. Note: You need to calculate the payment!
Answer: Payment = $1,111.48, see video for amortization table

Let’s try one together…

Suppose that Jack only puts 10% down. Calculate his new payment. Compare his total expenditures (be sure to include the down payment) between 10% and 20% down payments.
Answer: See video (pays about $20,000 less with 20% down)

 

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

The Math of Money Copyright © 2022 by J. Zachary Klingensmith is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book