In: Finance
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 |