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))^-(3012))
=	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))^-(3012))
=	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 1 year ago

Next > < Previous

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

Subjects