Question: I had done this using excel but apparently its wrong Problem 7.4 An Investor is considering the acquisition of a distressed property which is on
I had done this using excel but apparently its wrong 
Problem 7.4 An Investor is considering the acquisition of a distressed property" which is on Northlake Bank's REO list. The property is available for $200.000 and the investor estimates that he can borrow $160,000 at 4.5 percent interest and that the property will require the following total expenditures during the next year. Inspection $ 580 Title search 1.000 Renovation 13,860 Landscaping 880 Loan interest 7.200 Insurance Property taxes 6,080 Selling expenses 8,000 Required: a. The investor is wondering what such a property must sell for after one year in order to earn a 20 percent return (IRR on equity. b. The lender is now concerned that if the property does not sell, he may have to carry the property for one additional year. He believes that he could rent it starting in year 2) and realize a net cash flow before debt service of $1.200 per month. However, he would have to make an additional $7.200 in Interest payments on his loan during that time, and then sell. What would the price have to be at the end of year 2 in order to earn a 20 percent IRR on equity? 1.800 Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required A Required B The investor is wondering what such a property must sell for after one year in order to earn a 20 percent return (IRR) on equity. (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.) Sale value of property S 237,500
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
