Interest rates versus the new mortgage payments

Assignment Help Financial Management

Reference no: EM131048616

(Round your calculation results to 2 decimal places, whenever necessary)

You are currently in the 9th year of a 30-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 $180,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.85% 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 7% to 9%. Assume you will refinance at the end of the 9th 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 21 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: EM131048616

Questions Cloud

A program that repeatedly asks the user to enter two money : To add the two amounts, you'll need to carry 1 shilling when the pence value is greater than 11, and carry 1 pound when there are more than 19 shillings.

Identify and explain the role of a specifc tourism : Identify what is actually occuring or being practised at a place, and relate this to the theoretical concepts introduced in this unit - identify and explain the role of a specifc tourism or hospitality industry in your TDR

What is your expected return on your investment : Suppose you have $10,000 in cash and you decide to borrow another $10,000 at a(n) 6% interest rate to invest in the stock market. You invest the entire $20,000 in an exchange-traded fund (ETF) with a 11% expected return and a 20% volatility. What is ..

Main issues facing this special population : What are the main issues facing this special population, particularly concerning access, quality, and cost-effective care? What are some public policies that would support the needs of this special population?

Interest rates versus the new mortgage payments : You are currently in the 9th year of a 30-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 l..

Conform to umuc academic policies : As for all work in this class, the final exam must be original work developed by the student solely for use in this class and must conform to UMUC's academic policies.

Calculate kfor these reactions at 25? and 500 : The reaction of CH4 and O2 to form C2H6 and H2O must be carried out carefully to avoid a competing reaction. What is the most likely competing reaction?

Weighted average implied by two outstanding debt issues : Filer Manufacturing has 7.4 million shares of common stock outstanding. The current share price is $44, and the book value per share is $5. Filer Manufacturing also has two bond issues outstanding. Assume that the overall cost of debt is the weighted..

More volatile than the annual rate of return : Over the period of 1926 through 2008, the annual rate of return on _____ has been more volatile than the annual rate of return on_____. .

User Account

All Pages