Question

In: Finance

Greetings, I worked through part A and assuming I got it all correct so far. I'm...

Greetings,

I worked through part A and assuming I got it all correct so far. I'm not sure where to go or how to find the breakeven point from the information found & given in order to complete B and C.

1. You are currently in the 7th year of a 25-year fixed rate, fully amortized mortgage with monthly payments. You originally borrowed $150,000 with a 9.50% annual interest rate. Interest rates are expected to be lower, so you are considering the feasibility of refinancing the loan. To refinance, closing costs are expected to be 3.25% of the new loan amount. You will also have to pay 1 point. Assume no prepayment penalties both with the original and new loans.

A) Using a spreadsheet, calculate the new loan payments for every eighth of a percent from a revised interest rate of 7.5% to 8.5%. Assume you will refinance at the end of the 7th year of the mortgage with points and closing costs included in the new loan and you do not wish to extend the length of the mortgage beyond its current length (i.e. the maturity of the new loan is 18 years from now).

B) How low must interest rates go in order for you to breakeven?

C) Draw a graph to plot the new interest rate versus the new mortgage payment and show the breakeven point.

A.
Original Loan $150,000.00
Monthly Interest Rate= 9.5% / 12 months 0.79%
N= 25 * 12 300
Monthly Payments $1,310.54
Balance end of Year 7 $149,117.99
Closing Costs = 135114.55 * 3.25% $4,846.33
New Loan Balance $153,964.32
New Loan Present Value $153,964.32
Annual Rate 7.50%
Monthly Interest Rate= 7.5% / 12 months 0.63%
N= 18 * 12 216
Monthly Payments $1,292.88
FV 0
Present Value Annual Rate Monthly Rate N FV PMT
-$153,964.32 7.50% 0.63% 216 $0.00 $1,292.88
-$153,964.32 7.63% 0.64% 216 $0.00 $1,304.59
-$153,964.32 7.76% 0.65% 216 $0.00 $1,316.36
-$153,964.32 7.89% 0.66% 216 $0.00 $1,328.17
-$153,964.32 8.02% 0.67% 216 $0.00 $1,340.04
-$153,964.32 8.15% 0.68% 216 $0.00 $1,351.95
-$153,964.32 8.28% 0.69% 216 $0.00 $1,363.92
-$153,964.32 8.41% 0.70% 216 $0.00 $1,375.93
-$153,964.32 8.54% 0.71% 216 $0.00 $1,387.99
-$153,964.32 8.67% 0.72% 216 $0.00 $1,400.10
-$153,964.32 8.80% 0.73% 216 $0.00 $1,412.26
-$153,964.32 8.93% 0.74% 216 $0.00 $1,424.47
-$153,964.32 9.06% 0.76% 216 $0.00 $1,436.72
-$153,964.32 9.19% 0.77% 216 $0.00 $1,449.02
-$153,964.32 9.32% 0.78% 216 $0.00 $1,461.36
-$153,964.32 9.45% 0.79% 216 $0.00 $1,473.76
-$153,964.32 9.58% 0.80% 216 $0.00 $1,486.19
-$153,964.32 9.71% 0.81% 216 $0.00 $1,498.67
-$153,964.32 9.84% 0.82% 216 $0.00 $1,511.20
-$153,964.32 9.97% 0.83% 216 $0.00 $1,523.77
-$153,964.32 10.10% 0.84% 216 $0.00 $1,536.39

Solutions

Expert Solution


Related Solutions

I have solved most of question and the answers I have so far are correct, I...
I have solved most of question and the answers I have so far are correct, I just need help finding out the lower bound and upper bound (All answers were generated using 1,000 trials and native Excel functionality.) Galaxy Co. distributes wireless routers to Internet service providers. Galaxy procures each router for $75 from its supplier and sells each router for $125. Monthly demand for the router is a normal random variable with a mean of 100 units and a...
I'm a stock trader. I entered and exited the market so far 3 times this year....
I'm a stock trader. I entered and exited the market so far 3 times this year. 1) entered on 12/31/19 at 86.5 and exited on 1/27/20 at 92.72 for a gain of 7.1%. 2) re-entered on 2/5/20 at 105.82 and exited on 2/20/20 at 114.66 for a gain of 8.4%. 3) re-entered on 4/15/20 at 61.55 and exited on 4/30/20 at 69.77 for a gain of 13.4%. What is the total return to date (should be around 40% to 50%)...
Hello, I'm really struggling with this problem. So far I have calculated 48,000 for preferred and...
Hello, I'm really struggling with this problem. So far I have calculated 48,000 for preferred and 38,000 for common, which I know to be incorrect per my professor.  I also calculated 64,703 as the preferred and 41,697 as the common but I know these to be incorrect as well. I'm just not sure how to calculate this. Please see the below. The outstanding capital stock of Skysong Corporation consists of 2,000 shares of $100 par value, 8% preferred, and 5,100 shares...
One part of this question I am getting wrong. I'm assuming it's the test statistic? I...
One part of this question I am getting wrong. I'm assuming it's the test statistic? I got 1 for Question C, and I got 5.432 for question b, and I got B for question C. An undergraduate student performed a survey on the perceived physical and mental health of UBC students for her term project. She collected information by asking students whether they are satisfied with their physical and mental health status. 129 male and 157 female UBC students were...
It is important to note that we are assuming that so far there has been NO...
It is important to note that we are assuming that so far there has been NO governmental action regarding the virus. So, there has been no quarantining, there have been no “Stay-at-Home” orders, there have been no orders closing businesses, and, generally, there have been no decisions by a governmental entity regarding the virus.Draw a graph to explain your answer. First, explain (in words) what an “efficient” outcome is in the present context. Then, present an economic argument, using a...
Assuming, I'm correct that sex and yes/no questions are nominal data, then the best source of...
Assuming, I'm correct that sex and yes/no questions are nominal data, then the best source of testing from my reading and research is mode. However in my question/answers, the only options are mean, SD, range, or median. My reading and research says you can't use median, SD, or median. But range wouldn't really be relavent data either? The question does say "relative data". So my best guess is range; but I'm a bit confused by this? Can you shed any...
Is my writing for the email correct? I mean grammatically and academy. Dear Dr. Muller, Greetings!...
Is my writing for the email correct? I mean grammatically and academy. Dear Dr. Muller, Greetings! I would like to thank you for your assistance. I looked at the offer from University of Manchester and I found that there were two conditions are master's degree with GPA of 3.2 or higher and Two satisfactory references issued on official headed paper, signed and dated by referees I think I provided official transcript with GPA of 3.667 and two references to Dr.George...
Black-Scholes This problem is a bit of work but I'm curious to see if I got...
Black-Scholes This problem is a bit of work but I'm curious to see if I got it right. I think i did XYZ stock is being traded at $115 today. Consider European put and call options with an exercise price of $110. The option expires in 91 days and the volatility is 0.50. The risk-free rate (continuously compounded) is 2.5%. Use actual/365 day count method. A) Calculate the values of the put and call options. Assume there will be no...
Need solution for 3rd question I solved first part below is my answers so far. Really...
Need solution for 3rd question I solved first part below is my answers so far. Really need help on second question. Below is the Background, What I need to do, and the price data to start with. Any help with getting me started is appreciated.    Background The Book Emporium wants to price books to optimize profits. The spreadsheet for this homework has sales data on Harry Potter book 7. For each week, the Book Emporium varied prices on Harry...
So, if Henry's constant is greater then the solubility increases (correct me if I'm wrong), then...
So, if Henry's constant is greater then the solubility increases (correct me if I'm wrong), then why is it that oxygen gas is less soluble in water than carbon dioxide even though the concentration of oxygen is less than carbon dioxide? Given that pressure is the same and using the formula Kh = P/C.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT