Question

In: Finance

Value of the house 200,000. You are using a 30-year mortgage. Also, you are putting down...

Value of the house 200,000. You are using a 30-year mortgage. Also, you are putting down 20%.

You have two options:

a. Mortgage rate of 4.5% with no points.

b. Mortgage rate of 4.35% and 1.5 points.

Which option should you choose?

Solutions

Expert Solution

a

Effective cost of loan is 4.5%

b

Loan amount = 160000 but amount received is = 160,000 - 160,000 * 1.5% = 157,600

Monthly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          160,000
Rate of interest per period:
Annual rate of interest 4.350%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.0435 /12 = 0.3625%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                  30.00
Total number of payments N 30 × 12 = 360
Period payment using the formula = [ 160000 × 0.00363 × (1+0.00363)^360] / [(1+0.00363 ^360 -1]
Monthly payment = $                                                            796.50
Calculator
Inputs:
PV 157,600.000
PMT             (796.5)
FV                      -  
N                  360
Output:
I/Y = YTM 0.3732%
Annual rate 4.48%

Take option 2 as effective cost of loan is lower at 4.48%


Related Solutions

Value of the house 300,000. You are using a 30-year mortgage. Also, you are putting down...
Value of the house 300,000. You are using a 30-year mortgage. Also, you are putting down 20%. You have two options: a. Mortgage rate of 3.5% with no points. b. Mortgage rate of 3.35% and 1.5 points. Which option should you choose?
Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage...
Amortize a 30-year mortgage for a $200,000 house cost with a 20% down payment. The mortgage interest rate is 4.125%. How much is the monthly payment? How much will the borrower pay in total interest?
You plan to purchase a house for $200,000 using a 30-year mortgage obtained from your local...
You plan to purchase a house for $200,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 5.60 percent and...
You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit...
You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.50 percent. You will make a down payment of 20 percent of the purchase price. (LG 7-4) a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. please show in excel
Consider a 30-year, traditional mortgage on a $200,000 property. With 30% down payment and a 4%...
Consider a 30-year, traditional mortgage on a $200,000 property. With 30% down payment and a 4% APR. Mortgage payments are made monthly. What is the 214th payment?
You take out a 30-year mortgage to buy a house worth $449,000. The down payment is...
You take out a 30-year mortgage to buy a house worth $449,000. The down payment is 7% and the annual interest rate is 4.9%. What are the monthly payments? Round to the nearest cent.
You take out a 30-year mortgage to buy a house worth $312,000. The down payment is...
You take out a 30-year mortgage to buy a house worth $312,000. The down payment is 21% and the annual interest rate is 4.4%. What are the monthly payments? Round to the nearest cent.
You take out a 30-year mortgage to buy a house worth $396,000. The down payment is...
You take out a 30-year mortgage to buy a house worth $396,000. The down payment is 19% and the annual interest rate is 4.9%. What are the monthly payments? Round to the nearest cent.
Jackie bought a $200,000 house and has a 30 year mortgage at anominal interest rate...
Jackie bought a $200,000 house and has a 30 year mortgage at a nominal interest rate of 4.8% convertible monthly. Jackie must pay level payments at the end of each month. Find the amount of her monthly mortgage payment. After 200 payments have been made, what is the ratio of total interest paid to total principal repaid?
You plan to purchase a house for $200,000 using a 15-year mortgage obtained from your local...
You plan to purchase a house for $200,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 10 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 6.25 percent and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT