Question

In: Finance

You found your dream house. It will cost you $200000 and you will put down $40000...

You found your dream house. It will cost you $200000 and you will put down $40000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?

Solutions

Expert Solution

Loan amount (PV) = 200000 - 40000 = 160000

Nper = 30 years * 12 months = 360 months

Rate per month = 5.50%/12

The monthly payment can be calculated with the help of PMT function of Excel

=PMT(0.055/12,360,-160000,0,0)

= 908.46

Monthly mortgage payment = 908.46


Related Solutions

You found your dream house. It will cost you $200000 and you will put down $35000...
You found your dream house. It will cost you $200000 and you will put down $35000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)? Your Answer: Question 11 options: Answer Hide hint for Question 11 Mortgage monthly payment N=30 years*12 month each year=360 I/Y=monthly interest rate= annual interest rate/12 PV= house price- down payment (money you will need to borrow from the...
You found your dream house. It will cost you $300000 and you will put down $50000...
You found your dream house. It will cost you $300000 and you will put down $50000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?
You found your dream house. It will cost you $300000 and you will put down $30000...
You found your dream house. It will cost you $300000 and you will put down $30000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)
You found your dream house. It will cost you $300000 and you will put down $45000...
You found your dream house. It will cost you $300000 and you will put down $45000 as a down payment. For the rest you get a 30-year 4.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?
You will have to search for your dream house, calculate the down payment, and the monthly...
You will have to search for your dream house, calculate the down payment, and the monthly payments for a 30 and 15 years fixed loan. You will use the loan payment formula to determine your monthly payments for a 30-year fixed loan with an APR of 3.75% and for a 15-years fix loan with an APR of 2.97% with a down payment of 5%. You will make a decision on which loan you would take and provide reasons for your...
You own a house that cost $200000 to build. You buy a $15000 insurance policy to...
You own a house that cost $200000 to build. You buy a $15000 insurance policy to compensate you for damage to the house. The deductible $25000.(If your house suffers $4000 damage from a storm, you pay for all repairs yourself. If the house suffers $45000, in damage, you pay$25000 and the insurance company pays the remaining $20000.) Graph the positions of the unhedged home, the home insurance and the hedged home position on the profit and loss diagram. In the...
A couple has decided to purchase a $200000 house using a down payment of $15000. They...
A couple has decided to purchase a $200000 house using a down payment of $15000. They can amortize the balanxe at 10% over 25 years. What is their monthly payment? What is the total interest paid? What is the equity after 5 years? What is the equity after 20 years?
How much would you have to put down on a house costing $160,000 if the house...
How much would you have to put down on a house costing $160,000 if the house had an appraised value of $169,000 and the lender required an 80% loan-to-value ratio?
You bought a house for $150,000 and put down 10% and got a mortgage at an...
You bought a house for $150,000 and put down 10% and got a mortgage at an interest rate of 4.35 % per year. You would pay it back by paying an equal amount at the end of each month for 15 years? (Show all work) How much is your loan amount? How much is your monthly loan payment? How much is your loan balance after 2 years? How much is your total interest payment by the end of year 3?
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
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT