Question

PLEASE SOLVE IN EXCEL WITH CALCULATIONS.
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 8 percent interest and that the property will require the following total expenditures during the next year
Inspection      $500
Title search   $1,000
Renovation.   $13,000
Landscaping $ 800
Loan Interest $12,800
Insurance.     $ 1800
Property Taxes $ 6000
Selling Expenses $8000

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. What other issues must he consider?
b. The lender now is 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 and realize net cash flow before debt service of 1200 per month. However, he would have to make an additional $12,800 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?

Answer 1

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

renovation payments amount = $28,400

Interest rate = 20%

present value of equity amount = 47,500

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

sale value = Net cash flows for sale + loan amount + selling expense

= 85,400 + 160,000 + 8,000

= $253,400

b)

renovation payments amount = $41,200

Interest rate = 20%, n = 2

present value of equity amount = 61,900

sale value = Net cash flows needed in 2 years for sale + loan amount + selling expense

= 179,776 + 160,000 + 8,000

= $347,776

the price have to be at the end of year 2 in order to earn a 20 percent IRR on equity =$347,776