Question

In: Finance

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).

Expert Solution

Information provided:

Cost of the house = $305,469

Down payment = 10%*$305,469 = $30,546.90

Mortgage = Present value= $305,469 - $30,546.90 = $274,922.10

Time= 30 years*12 = 360 months

Interest rate= 4%/12= 0.3333% per month

The monthly payment is calculated by entering the below in a financial calculator:

PV= -274,922.10

N= 360

I/Y= 0.3333

Press the CPT key and PMT to compute the monthly payment.

The value obtained is 1,312.52.

Therefore, the amount of monthly payment is $1,312.52.

Therefore, the total monthly payment is = $1,312.52*360

= $472,507.26.

jeff jeffy answered 2 years ago

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?

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...

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 are buying a house and trying to decide how to structure a the loan.

You are buying a house and trying to decide how to structure a the loan. You can borrow $120,000 at a 4.5 percent rate for 30 years with monthly payments, or you can borrow $120,000 at a 3.75 rate for 20 years with monthly payments. what should you consider when making this decision?

Suppose you are buying an $80,000 car , you decide to buy it and get it...

Suppose you are buying an $80,000 car , you decide to buy it and get it financed and make monthly payments.Your budget is $3,000 for monthly payments, and you can get financing at 11% APR. With the help of an amortization table, show approximately how long will it take you to pay the loan back? Remember the monthly payment must be around your budget. Work with Excel. Copy and paste the first four months and last two months of the...

You are buying a house and trying to decide how to structure the loan. You can...

You are buying a house and trying to decide how to structure the loan. You can borrow $120,000 at a 4.5% rate for 30 years with monthly payments, or you can borrow $120,000 at a 3.75% rate for 20 years with monthly payments. What should you consider when making this decision?

1. You decide to buy a new car. You negotiate with the dealer and get the...

1. You decide to buy a new car. You negotiate with the dealer and get the car for $40,000. What will be your monthly payment if you finance the purchase through your bank with a 6-year, 11% auto loan (assume no down payment). a. What if you made a down payment of $4,000? What would be the monthly payment for the car?

Suppose you want to buy a house which is valued at $100,000. You decide to borrow...

Suppose you want to buy a house which is valued at $100,000. You decide to borrow the money from the bank at an interest rate of 12.5 percent and agree to make equal annual end of year payments over the next 5 years to fully repay the loan. Also assume you work as a financial manager at the bank and you want to prepare a loan amortization schedule yourself. So, prepare the loan amortization schedule showing separate columns for the...

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.