Question
In: Finance
You want to buy a house. You have found the house you like and have agreed...
You want to buy a house. You have found the house you like and have agreed to purchase the house for $300,000. You go to the bank to get a loan and have decided that a 30 year mortgage loan is the best loan duration. What do you think the interst rate will be on your loan given the following data?
"Real" interest rate given current macro econmomic conditions = 2.0%
The inflation rate forecasted for the future is = 1.5%
Unfortunately, your credit score sucks and you represent a bigger risk to the bank.
The added "risk" rate is = 6.0% (only 2% added risk rate if good credit rating)
Estimated bank mortgage rate =
Given the 30 year rate above, calculate your monthly house payment (assume monthly compounding).
Calculate your monthly house payment if you had a good credit score
What is the total difference in payments over the life of the loan btween a "good" rate and a "bad" rate?
Would the rate be higher or lower on a 15 year mortgage? Why?
Show excel formula for each and please explain each answer
Solutions
Expert Solution
| Interest Rate | ||||
| Real Interest Rate (A) | 2.00% | |||
| Inflation Risk Premium (B) | 1.50% | |||
| Default Premium risk ('C) | 6.00% | |||
| Estimated bank Mortgage Rate (r=A+B+C) | 9.50% | |||
| Principal Amount (P) | 300,000.00 | |||
| Number of Years (n) | 30 | |||
| Compunding (m) | Monthly | |||
| Monthly Payment = | (r/m(P))/(1-(1+r/m)^-n*m) | |||
| = | ((0.095/12)*300000)/(1-(1+(0.095/12))^-(30*12)) | |||
| = | 2,522.56 | |||
| Interest Rate | ||||
| Real Interest Rate (A) | 2.00% | |||
| Inflation Risk Premium (B) | 1.50% | |||
| Default Premium risk ('C) | 2.00% | |||
| Estimated bank Mortgage Rate (r=A+B+C) | 5.50% | |||
| Principal Amount (P) | 300,000.00 | |||
| Number of Years (n) | 30 | |||
| Compunding (m) | Monthly | |||
| Monthly Payment = | (r/m(P))/(1-(1+r/m)^-n*m) | |||
| = | ((0.055/12)*300000)/(1-(1+(0.055/12))^-(30*12)) | |||
| = | 1,703.37 | |||
| Total payment with 9.5% interest= | 2522.56*360= | 908,121.60 | ||
| Total payment with 5.5% interest= | 1703.37*360= | 613,213.20 | ||
| Difference due bad rate | 294,908.40 | |||
The rate of interest will be lower on a 15 year mortgage as this will reduce he risk . Shorter mortgages carry less risk as compared to long term mortgages.
jeff jeffy answered 2 years agoRelated Solutions
Suppose that you decided to buy a new house. The house you want to buy costs...
Suppose that you decided to buy a new house. The house you want
to buy costs $520,000 and the interest rate is 7%. You currently
have $130,000 and are required to put a 20% down payment plus an
additional 3% of the loan amount as closing costs.
1) When will you have enough money for the down payment and
closing costs, assuming that the $80,000 is the only investment
that you make?
2) Suppose that you plan to buy the...
You would like to buy a house that costs $ 350,000. You have $ 50,000 in...
You would like to buy a house that costs $ 350,000. You have $
50,000 in cash that you can put down on the house, but you need to
borrow the rest of the purchase price. The bank is offering you a
30-year mortgage that requires annual payments and has an interest
rate of 7 % per year. You can afford to pay only $ 23,500 per year.
The bank agrees to allow you to pay this amount each year,...
You would like to buy a house that costs $ 350,000. You have $ 50,000 in...
You would like to buy a house that costs $ 350,000. You have $
50,000 in cash that you can put down on the house, but you need to
borrow the rest of the purchase price. The bank is offering a
30-year mortgage that requires annual payments and has an interest
rate of 7 % per year. You can afford to pay only $ 22,970 per year.
The bank agrees to allow you to pay this amount each year, yet...
You would like to buy a house that costs $ 350,000 . You have $ 50,000...
You would like to buy a house that costs
$ 350,000
.
You have
$ 50,000
in cash that you can put down on the house, but you need to
borrow the rest of the purchase price. The bank is offering a
30-year mortgage that requires annual payments and has an interest
rate of
7 %
per year. You can afford to pay only
$ 23,500
per year. The bank agrees to allow you to pay this amount each
year,...
You would like to buy a house that costs $ 350,000. You have $ 50,000 in...
You would like to buy a house that costs
$ 350,000. You have $ 50,000 in cash that you can put down on
the house, but you need to borrow the rest of the purchase price.
The bank is offering you a 30-year mortgage that requires annual
payments and has an interest rate of 8 % per year. You can afford
to pay only $ 25,580 per year. The bank agrees to allow you to pay
this amount each year,...
You want to buy a house that costs $210,000. You have $21,000 for a down payment,...
You want to buy a house that costs $210,000. You have $21,000
for a down payment, but your credit is such that mortgage companies
will not lend you the required $189,000. However, the realtor
persuades the seller to take a $189,000 mortgage (called a seller
take-back mortgage) at a rate of 5%, provided the loan is paid off
in full in 3 years. You expect to inherit $210,000 in 3 years, but
right now all you have is $21,000, and...
You want to buy a house that costs $180,000. You have $18,000 for a down payment,...
You want to buy a house that costs $180,000. You have $18,000
for a down payment, but your credit is such that mortage companies
will not lend you the required $160,000. However, the realtor
persuades the seller to take a $160,000 mortage (called a seller
take-back mortage) at a rate of 7%, provided the loan is paid off
in full in 3 years. You expected to inherit $180,000 in 3 years;
but right now all you have is $18,000, and...
You want to buy a house that costs $100,000. You have $10,000 for a down payment,...
You want to buy a house that costs $100,000. You have $10,000
for a down payment, but your credit is such that mortgage companies
will not lend you the required $90,000. However, the realtor
persuades the seller to take a $90,000 mortgage (called a seller
take-back mortgage) at a rate of 9%, provided the loan is paid off
in full in 3 years. You expect to inherit $100,000 in 3 years; but
right now all you have is $10,000, and...
You want to buy a house that costs $230,000. You have $23,000 for a down payment,...
You want to buy a house that costs $230,000. You have $23,000
for a down payment, but your credit is such that mortgage companies
will not lend you the required $207,000. However, the realtor
persuades the seller to take a $207,000 mortgage (called a seller
take-back mortgage) at a rate of 8%, provided the loan is paid off
in full in 3 years. You expect to inherit $230,000 in 3 years, but
right now all you have is $23,000, and...
You want to buy a house that costs $100,000. You have $10,000 for a down payment,...
You want to buy a house that costs $100,000. You have $10,000
for a down payment, but your credit is such that mortgage companies
will not lend you the required $90,000. However, the realtor
persuades the seller to take a $90,000 mortgage (called a seller
take-back mortgage) at a rate of 10%, provided the loan is paid off
in full in 3 years. You expect to inherit $100,000 in 3 years, but
right now all you have is $10,000, and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 3) You are rolling a 12 sided die 8 times. a) What is the size for...
- explain the difference between quantitative and qualitative research strategies. Provide an example of a crime based...
- use postorder and inorder tree traversals to make preorder traversal. #!/usr/bin/env python3 # encoding: UTF-8 """Turning...
- 1. Write an if-else statement to describe an object. Print "Balloon" if isBalloon is true and...
- An investor is considering purchasing a Treasury bond with a 20 year maturity, an 8% coupon...
- Write a program that copies the contents of one file to a destination file. This program...
- how to conduct a marketing mix for 3d crest white strips
ADVERTISEMENT