Borrowing cost of adjustable rate mortgage assuming

Assignment Help Financial Management

Reference no: EM131457846

In this problem, 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 under the following two (2) scenarios:

1. Interestrates(index)rise1/2%everyyear 2. Interestrates(index)rise2%everyyear

I suggest you put each scenario on a separate sheet.

A description of the 1-year ARM with monthly payments is as follows: Amount: $300,000

Maturity: 10 years

Initial Contract Rate (teaser rate): 3.00% Margin: 125bp (1basis point = 0.01%)

Current Index Yield: 2%

Caps and Floors: Annually: 1.5%, Lifetime: 5%

Create a table showing opening balance, interest payment, principal payment, debt service, ending balance, and inflation rate for each year.

Calculate effective cost of this loan.

Create a graph, showing the time-series dynamics of Balance

Create graph(s), showing the time-series dynamics of Interest payment and Principal payment together

Reference no: EM131457846

Questions Cloud

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

Define a forward contract : Define a forward contract. If a forward contract on gold is negotiated at a forward price of $1,487 per ounce, what would be the payoff on the maturity date.

Create a strategy with policies in alignment : Disaster recovery powerpoint- Based on the graphic, create a strategy with policies in alignment with current national policies to combat the challenges.

Discuss the benefits of standardization of futures contract : Discuss the benefits of standardization of a futures contract. What are the two roles that a clearinghouse plays in the case of a futures contract?

Identify all lazy dollars in your financial life : Identify all the lazy dollars in your financial life. What savings strategies will you use to improve your financial situation?

User Account

All Pages