Assignment
1) A homeowner can obtain on property valued at $250,000, a 30-year fixed-rate mortgage, LTV=90%, at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. If she will keep the mortgage for 30 years, what is the net present value of paying the points (to the nearest dollar)
2) Given the following information, calculate the going-out cap rate: estimated holding period: five years; NOI for year 1: $120,000; NOI for year 5: $150,000; NOI for year 6: $155,250; expected sale price at end of year 5: $1,530,000.
3) A client has requested advice on a potential investment opportunity involving an income-producing property. She would like you to determine the internal rate of return of the investment opportunity based on the following information: expected holding period: years; end of first year NOI estimate: $110,000; NOI estimates in subsequent years will grow by 6 % per year; price at which the property is expected to be sold at the end of year 5: $1,615,205.22; current market price of the property: $1,475,667.71.
4) Given the following information regarding an income producing property, determine the NPV using levered cash flows in your analysis: required equity investment: $350,000; expected NOI for each of the next five years: $250,000; debt service for each of the next five years: $175,000; expected holding period: five years; required yield on levered cash flows: 15%; expected sale price at end of year 5: $2,500,000; expected cost of sale: $250,000; expected mortgage balance at time of sale: $1,750,000.
5) Given the following information regarding an income producing property, determine the unlevered internal rate of return (IRR): expected holding period: five years; 1st year expected NOI: $89,100; 2nd year expected NOI: $91,773; 3rd year expected NOI: $94,526; 4th year expected NOI: $97,362; 5th year expected NOI: $100,283; debt service in each of the next five years: $58,444; current market value: $858,000; required equity investment: $221,250; net sale proceeds of property at end of year 5: $947,700; remaining mortgage balance at end of year 5: $631,026.