Annualized irr for mortgage in spreadsheet

Assignment Help Financial Management

Reference no: EM131904139

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.

1. Compute Ann’s annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.)

(1.a) What is the annualized IRR for the mortgage?

(1.b) Is it higher or lower than the mortgage contract rate?

(1.c) Why?

Reference no: EM131904139

Questions Cloud

What can you learn about venture capital on the web : Funding your venture goes hand in hand with the merit and validity of your opportunity as well as with your skills and knowledge to execute your idea.

Using the strategy of rolling down the yield curve : How much return was made using the strategy of rolling down the yield curve?

Explain the role of the hr functions : Explain the role of the HR and L&D functions in your organisation in supporting individuals during organisation change.

Merton medical clinic are analyzing proposed project : The managers of Merton Medical Clinic are analyzing proposed project. What are the project’s expected NPV and standard deviation of NPV?

Annualized irr for mortgage in spreadsheet : Ann would like to buy a house. It costs $800,000. What is the annualized IRR for the mortgage? Compute Ann’s annualized IRR for the mortgage in the spreadsheet.

Why dr van calls the recognition challenge can be helpful : Briefly explain, as best you can, why what Dr. van calls the recognition challenge can be helpful for understanding the important relationship.

Calculate each equipment discounted payback period : Calculate each equipment’s payback period. Calculate each equipment’s discounted payback period. Calculate each equipment’s Net Present Value (NPV).

What are the implications of that lawsuit for the sale : Locate information on the Tiffany versus eBay lawsuit and identify each side's arguments and who prevailed.

Two one-period forward rates that must hold for these bonds : Bond B has a 10% coupon and sells for sh1,055.12. Find the two one-period forward rates that must hold for these bonds.

User Account

All Pages