Annualized irr for mortgage in spreadsheet

Assignment Help Financial Management

Reference no: EM131911938

Ann would like to buy a house. It costs $800,000. Her down payment will be $40,000. She will take out a mortgage for $760,000. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.00%. She must pay 2.5% in fees at the time of the loan. Note: the home is bought and the loan is taken in month 0, the first payment is due in month 1. In the spreadsheet where it says “cash inflow”, “outflow” and “net cash flow” you should only take into account cash flow related to the mortgage.

1. Fill in the spreadsheet for Ann. (It is called an amortization schedule.)

2. Compute Ann’s annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.) (a) What is the annualized IRR for the mortgage? (b) Is it higher or lower than the mortgage contract rate? (c) Why?

Reference no: EM131911938

Questions Cloud

How do you think strategic management would help : Why and how do you think strategic management would help address the issue or problems in the company

Advantages and disadvantages of the global matrix structure : What are the advantages and disadvantages of the global matrix structure?

What is the forward exchange rate premium : What is the forward exchange rate premium (in terms of dollars per peso) for one year ahead?

Differences between domestic and international hr practices : Discuss at least two of the variables that moderate differences between domestic and international HR practices

Annualized irr for mortgage in spreadsheet : Compute Ann’s annualized IRR for the mortgage in the spreadsheet.

What are the reasons for trump administration : (a). What are the reasons for Trump Administration to re-negotiate the NAFTA?

Define the concepts of free trade area : (a). Define the concepts of Free Trade Area, Customs Union & Common Market?

What must risk-free rate be : A stock has an expected return of 13.7 percent and a beta of 1.18. What must the risk-free rate be?

Describe how a nerve impulse is transmitted along its axon : Describe how a nerve impulse is transmitted along its axon. What are two advantages of fat over carbohydrate for fuel storage in the body?

User Account

All Pages