1- Consider an old 1920s brick building in the central business district of Al Qatif city. Business and residents moved away from the area, and its current use as retail space may no longer be the highest and best use of the property. It is a 15,000 square foot building, and its estimated value as vacant land is $10/sqft, or $150,000.

In its current use as retail space, the property generates rent of $12/sqft. Vacancy rates are around 11% since foot traffic generally doesnt support retail business in the area. Operating costs are $34,000 per year. Since conditions are fairly stable, capitalizing next years income at a rate of 9%

2- Another alternative would be to renovate the property and convert it into office space. Market research indicates this is a desirable area for professional office such as attorneys, accountants, architects, and designers. Market rent for offices in this area is $21 per square foot and has been increasing by 2% annually. Operating costs average $5/sqft and increase by $0.25 per year. Converting the property into office space will cost $850,000 in the first year, and average vacancy during the year will be 75% due to the time of the renovations. Vacancy is 20% in year 2 and then settles into a constant 5% thereafter. The net present value of cash flow discounted at a rate of 10%

please can you find rent income, vacancy cost , operating cost capital investment and net income for year 1,2,3 and 4 . please explain the formula used