Plot the new interest rates versus the new mortgage payments

Assignment Help Financial Management

Reference no: EM131457850

You are currently in the 7th year of a 25-year fixed rate, fully amortized mortgage with monthly payments, with the lock-in period of 10 years (prepayment penalty is 2% of the remaining balance). Assume that rate doesn’t change over the life of the loan. 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. Assume no prepayment penalty with new loans.

A) Using a spreadsheet, calculate the new loan payments for every eighth of a percent from a revised interest rate of 6.5% to 9.0%. Assume you will refinance at the end of the 7th year of the mortgage with prepayment penalty 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) Using the spreadsheet graphics, plot the new interest rates versus the new mortgage payments and show the breakeven point.

Reference no: EM131457850

Questions Cloud

What will be the loans ear : You want to buy a car, and a local bank will lend you $20,000. The loan will be fully amortized over 5 years (60 months), What will be the loan's EAR?

Three elements of cost : What is the ratio that exists between the three elements of cost? Reduce to lowest terms

At what stock price will you receive a margin call : Consider the following data: YBM's stock price is $100. The initial margin is 50 percent, and the maintenance margin is 25 percent.

Sequence of transformations : Let f(x) = Find a formula for a function g whose graph is obtained from f by the given sequence of transformations.

Plot the new interest rates versus the new mortgage payments : Using the spreadsheet graphics, plot the new interest rates versus the new mortgage payments and show the breakeven point.

Discuss the use of internet technologies : The Dojima Rice Market and the Origins of Futures Trading (Harvard Business School Case 709044-PDF-ENG). The case blends business history with policy issues.

Debt aspirations with your debt reality : What specific behavioral steps do you personally need to take to match your debt aspirations with your debt reality?

Do you think everyone should get together : Do you think everyone should get together and talk about these things? Do you think they also have the right to get involved in discussion and voting?

Borrowing cost of adjustable rate mortgage assuming : you are being asked to calculate the effective borrowing cost (rate) of an adjustable rate mortgage assuming you live in the house till the loan matures

User Account

All Pages