Question

In: Finance

You decide to buy a house for a total of $214452. To get a mortgage loan,...

You decide to buy a house for a total of $214452. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 5% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage?

Solutions

Expert Solution

Step-1:Calculate Amount borrowed
Cost of house $ 2,14,452
Less:Down Paymwnt $ 2,14,452 x 10% = $     21,445
Borrowed Amount $ 1,93,007
Step-2:Calculate monthly amount
Monthly Amount = Loan Amount/Cumulative discount factor
= $ 1,93,007 / 186.1968
= $       1,037
Working:
Cumulative discount Factor = (1-(1+i)^-n)/i Where,
= (1-(1+0.00417)^-360)/0.00417 i = 5%/12 =    0.00417
=    186.1968 n = 30*12 = 360
Step-3:Calculate total amount of monthly amount
Total monthly payment = $       1,037 x 360
= $ 3,73,167
Thus, Total monthly payment is   $ 3,73,167

Related Solutions

1.You decide to buy a house for a total of $198842. To get a mortgage loan,...
1.You decide to buy a house for a total of $198842. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 6% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage? 2.A company has $96 million in outstanding bonds, and 10 million shares of stock...
You decide to buy a house for a total of $305,469. To get amortgage loan,...
You decide to buy a house for a total of $305,469. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 4% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much is the TOTAL monthly payment for this mortgage?Enter your answer in dollars, rounded to the nearest cent (2 decimals).
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge interest at the rate of 9% annually and requires a minimum monthly payment of $500. At the end of five years, you must pay off the entire mortgage by a “balloon payment”. You plan to pay only the minimum amount each month and then pay off the loan with the final payment. Find this balloon payment. (Answer: $49966.07) please answer in excel format
You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period...
You borrow $149000 to buy a house. The mortgage rate is 7.5% and the loan period is 30 years. Payments are made monthly. What is the monthly mortgage payment.
The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for...
The Johnsons will buy a house for $348,000.00. They will get a 30 year loan for 4.63% annual interest rate compounded monthly. Calculate the payment needed for this loan and put your answer in F6. Then fill out the amortization schedule for the first year. After the table is done find the total interest paid in the first year and the total paid to principle for the first year. ON EXCELL!!
You have decided to buy a house. You can get a mortgage rate of 5.75 percent,...
You have decided to buy a house. You can get a mortgage rate of 5.75 percent, and you want your payments to be $1,050 or less. How much can you borrow on a 15-year fixed-rate mortgage? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Mortgage Amount:_______
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in...
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047...
If I decide to take a second mortgage or home equity loan on my house to...
If I decide to take a second mortgage or home equity loan on my house to increase funds available for my children's tuition. I will need to understand the deductibility of the interest and any limitations that exist.
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047 amortization...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047 amortization...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT