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?
Assume that you decides to buy a house for $187,600. You will pay 20% down payment...
Assume that you decides to buy a house for $187,600. You will pay 20% down payment by your saving and fund the remaining amount (i.e., 80% of the house price) using a mortgage loan. The bank offers 30-year mortgage with monthly interest 0.5313%. You will pay backthe loan in equal amount at the end of each month for the next 30 years. (In other words, just like real-world practice, you will pay back the loan using equal-amount monthly payments).  How much...
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...
You are ready to buy a house and you have $85,000 for a down payment and...
You are ready to buy a house and you have $85,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $125,000. The bank is willing to allow your monthly mortgage payment to be equal to 28% of your monthly income. The interest rate on the loan is 4.5% per year with monthly compounding for a 30-year fixed rate loan. How much money will the bank...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT