Please show all work and submit an excel file.

Use the information provided below to estimate the market value of the office building that has been described Type of Property: Leasable Space: Average Rent: Expected Rent Growth: Vacancy and Collection Losses Other Income: Expected Growth in Other Income: Operating Expenses Capital Expenditures: Going-In Cap Rate: Going-Out Cap Rate: Selling Expenses: Discount Rate: Office Building 75,000 square feet S20 per square foot per year 3% per year 10% of potential gross income S1.25 per square foot per year 3% per year 45% of effective gross income 3% of effective gross income 7% 7.25% 5% of future selling price What is the market value of this property according to the direct capitalization approach? What is the market value of this property according to the discounted cash flow approach? Assume that you are going to sell the property at the end of the 5th year of ownership a. b. Use the information provided below to estimate the market value of the office building that has been described Type of Property: Leasable Space: Average Rent: Expected Rent Growth: Vacancy and Collection Losses Other Income: Expected Growth in Other Income: Operating Expenses Capital Expenditures: Going-In Cap Rate: Going-Out Cap Rate: Selling Expenses: Discount Rate: Office Building 75,000 square feet S20 per square foot per year 3% per year 10% of potential gross income S1.25 per square foot per year 3% per year 45% of effective gross income 3% of effective gross income 7% 7.25% 5% of future selling price What is the market value of this property according to the direct capitalization approach? What is the market value of this property according to the discounted cash flow approach? Assume that you are going to sell the property at the end of the 5th year of ownership a. b