This is my answer, please check it. If wrong, please use excel and show formulas.

price	$200,000.00		outflows	$(238,300.00)	=-SUM(B1,B4:B11)
amount borrowed	$160,000.00		required sell price is:	$(285,960.00)	=E1*(1+B12)
interest	4.50%
inspection	$ 500.00
title search	$ 1,000.00		cash inflow	14400	=B13*12
renovation	$ 13,000.00		outflows	$(231,100.00)	=E1-B14+E5
landscaping	$ 800.00		required sell price is:	$(277,320.00)	=E6*(1+B12)
loan interest	$ 7,200.00
insurance	$ 1,800.00
property taxes	$ 6,000.00
selling expenses	$ 8,000.00
IRR	20%
cash flow	1200
additional interest	7200

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: 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 is now concerned that if the property does not sell, the investor 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