Question

In: Finance

You are planning to buy a house in New Jersey. You put a 20% down payment,...

You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000.

a. Calculate the monthly payments.

b- Calculate the 1st month interest payment.

c-Calculate the 1st month principal payments

Solutions

Expert Solution

Given in the Question :
Price of the House = $400,000
Down Payment = 20%
Years of mortgage = 15 years
Mortgage Rates = 4.2%

Solution:
Down payment = 20% * 4,00,000
= $80,000

Remaining loan to be repaid (P) = $400,000 - $80,000
= $3,20,000

Number of monthly installments (n) = 15*12
= 180

Monthly rate of interest (r) = 4.2/100*12
= 0.35% or 0.0035 (This is calculated for a month because the rate of interest given is per annum and we want to calculated installment for a month)


Equal Monthly Installments (EMI) = Principal Amount * Rate of Interest * (1+r)n / ((1+r)n - 1

= P * r * (1+r)n ÷ {(1+r)n -1}

= $3,20,000 * 0.35% * (1 + 0.35%)180 ÷  {(1 + 0.35%)180 -1}

= $3,20,000 *0.0035 * (1+0.0035)180 ÷ {(1 + 0.0035)180 -1}     

= $3,20,000 * 0.0035* (1.0035)180 ÷ {(1.0035)180 -1}     

= $3,20,000 * 0.0035 * (1.8755) ÷   {(1.8755) -1 }

= $2100.612 ÷ {0.8755}

= $2,399.201


A) Therefore, the Equal Monthly Installments will be equal to $2,399

B) The first month interest payment will be = Outstanding Principal amount * rate of interest

= P * r

= $320000 * 0.35%

= $320000 * 0.0035

= $1,120

C. First month's principal payment = Monthly Installment Amount - First Month's interest payment (As EMI is the sum of interest on the pending principal and the principal paid in that installment)

= $2,399 - 1,120

= $1,279


Related Solutions

You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. A. Calculate the 1st month interest payments B.Calculate the 1st month principal payments C.  Calculate the monthly payments. Place answer in the box below and use 2 decimals and no $ sign
Shaun has enough money to put a 20% down payment on the new house he and...
Shaun has enough money to put a 20% down payment on the new house he and his family have picked out, but they will lose the emergency fund. Putting less than this down will increase his payments. What tradeoffs should he consider?
You want to buy a house that worth $250,000. You put done $60,000 down payment and...
You want to buy a house that worth $250,000. You put done $60,000 down payment and borrow the rest from a bank with interest rate 4.5% per year compounded monthly for 15 years. What is you monthly payment to the bank? How much interest you will pay to the bank in 15 years? How much interest you pay in the FIRST year?
You are planning to purchase a house that costs $480,000. You plan to put 20% down...
You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of $1700...
You are ready to buy a house and you have $50,000 for a down payment and...
You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 2.5% of the loan value.   You have an annual salary of $200,000. The bank is willing to allow your housing costs – mortgage, property tax and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and homeowner’s insurance will be $100/month. The interest rate on...
You are ready to buy a house and you have $50,000 for a down payment and...
You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 2.5% of the loan value.   You have an annual salary of $200,000. The bank is willing to allow your housing costs – mortgage, property tax and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and homeowner’s insurance will be $100/month. The interest rate on...
You are ready to buy a house, and you have $25,000 for a down payment and...
You are ready to buy a house, and you have $25,000 for a down payment and closing costs. Closing costs are estimated to be 4% of the loan value. You have an annual salary of $48,000 (monthly income $4000) , and the bank is willing to allow your monthly mortgage payment to be equal to 25% of your monthly income. The interest rate on the loan is 7.2% per year with monthly compounding (.6% per month) for a 30-year fixed...
You are ready to buy a house and you have $50,000 for a down payment and...
You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 2.5% of the loan value.   You have an annual salary of $200,000. The bank is willing to allow your housing costs – mortgage, property tax and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and homeowner’s insurance will be $100/month. The interest rate on...
Adrian wants to buy a house for $206,700. He is planning on making a 20% down...
Adrian wants to buy a house for $206,700. He is planning on making a 20% down payment, and closing costs will amount to $3,180. Annual property taxes are $4,890, and homeowners insurance is $816 per year. How much money will he need up front?
"I recently bought a new house for $200,000. There was a 20% down payment, and the...
"I recently bought a new house for $200,000. There was a 20% down payment, and the rest was financed at 4.8 percent APR with monthly compounding. Monthly payments starting from next month will be $1,248.66. How many years will it take the firm to pay off this debt?" Please let me know values used in calculator or any formulas.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT