Question: PLEASE ANSWER AS SOON AS POSSIBLE. URGENT. Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will

PLEASE ANSWER AS SOON AS POSSIBLE. URGENT.

Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.50%. She will pay $5,000 in closing costs at origination. She will also pay 1.75% of the balance in buy-down points at origination. 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.

The Annualized IRR for the mortgage is 4.67%. It is higher than the mortgage contract rate.

QUESTION: WHY is the annualized IRR for the mortgage higher than the mortgage contract rate?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please show work via excel shown below!! Ann would like to buy a house. It costs $600,000. Her down payment will be $100,000. She will take out a mortgage for the remainder. It will be a 30 year,...

Use the following information for the remaining questions. Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It...

PLEASE ENTER ANSWERS IN BLUE BOLD INK! Use the following information for all the questions. Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a...

Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It will be a 30 year, fully amortizing, FRM, with constant...

URGENT: NEED THIS ASAP PLEASE Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It will be a 30 year, fully...

Can you help me with the IRR and the excel? TI 2 200.000 59000 Peo.c00.00 11 000 Green represent inputs Purple represent outputs Marger MEE JOS al ser 11 547700 90 WS 5 + dan Balance Mermerest...

{ 6 points} Leverage and limited liability 1 . {1 point} You pay $1000 for a property with 9% cap rate, keep it for 5 years, and sell at the end of year 5 at the same cap rate. The selling costs are...

PLEASE show what is put into the cell. Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remainder. It will be a 30 year,...

CAN SOMEONE PLEASE PLEASE HELP ME WITH THIS 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...

(a) In Problem 6, using energy techniques rather than the techniques find the speed of the snowball as it reaches the ground below the cliff. What is that speed (b) If the launch angle is changed to...

31. Which of thefollowing is not a unit-level activity? A) Drilling B) Cutting C) Sanding D) Inspecting

2 Multiple Choice 1 . 2 5 points C Corporation must file a Federal Tax Return using Form whether it has taxable income or not, before the 1 5 t h day of the fourth month follow the close of a...

Global expansion allows firms to achieve all of the following, except Group of answer choices Realize cost economies from experience effects generated by serving a larger market from a central...

=+1. What does Klingner observe about changes in societal and governmental values, and how might these lead to changes in how HRM is implemented in either public or nonprofit organizations?

=+3. Based on your reading of this textbook, what areas within social media would you like to specialize in? This can be a designated role or a particular industry. Outline five steps you will take...

=+ Outline three tips while listing three things you will do as the students mentor to pay it forward to the future generation of social media professionals.