Amazonia Co. wants to buy a 505,000-square-foot distribution facility in the outskirts of the city of Cool, CA. The subject facility is presently renting for $5.50 per square foot per year. Based on recent market activity, two properties have sold within a several-mile distance from the subject facility. They are comparable in size, design, and age. One facility is 470,000 square feet and is presently being leased for $5.30 per square foot annually . The second facility contains 530,000 square feet and is being leased for $5.70 per square foot annually. It sold just a few days ago and is in very close proximity the subject, which makes it three times important in determining the subject's value as the first facility. Market data indicate that current vacancies and operating expenses combined should run approximately 68 percent and 78 percent of gross income for the two respective facilities, and it is 75 percent for the subject. The first facility sold for $10.9 million, and the second sold for $11.4 million. If you can do the math in Excel with correct referencing to cells with intermediate results. This will allow you to avoid rounding errors. Otherwise, increase decimal places - the more the better! Say, 6 or even higher. (a) First, fill out the table below. Round $$$ to whole dollars. Don't use any units (e.g., "$"). Facility #2 Subject facility Facility #1 Potential gross income $ $ $ Net operating income $ $ $ (b) Use the gross income multiplier approach to calculate the subject facility's estimated current value. Fill out the table below. Round $$$ to whole dollar, and multipliers to 2 decimal places. Don't use any units (e.g., $"). Facility #1 Facility #2 Subject facility Gross income multiplier Estimated current value $ (c) Using the direct capitalization approach to calculate the subject facility's estimated current value. Fill out the table below. Round $$$ to whole dollar, and the rates to 2 decimal places (e.g., put 1.23 for "1.23%"). Don't use any units (e.g., "%" or "$"). Facility #1 Facility #2 Subject facility Capitalization rate % % Estimated current value $ (put "b" for the gross income multiplier approach, or "c" for the direct capitalization approach) is more (d) Between these two approaches, accurate is estimating the value of the subject property. Amazonia Co. wants to buy a 505,000-square-foot distribution facility in the outskirts of the city of Cool, CA. The subject facility is presently renting for $5.50 per square foot per year. Based on recent market activity, two properties have sold within a several-mile distance from the subject facility. They are comparable in size, design, and age. One facility is 470,000 square feet and is presently being leased for $5.30 per square foot annually . The second facility contains 530,000 square feet and is being leased for $5.70 per square foot annually. It sold just a few days ago and is in very close proximity the subject, which makes it three times important in determining the subject's value as the first facility. Market data indicate that current vacancies and operating expenses combined should run approximately 68 percent and 78 percent of gross income for the two respective facilities, and it is 75 percent for the subject. The first facility sold for $10.9 million, and the second sold for $11.4 million. If you can do the math in Excel with correct referencing to cells with intermediate results. This will allow you to avoid rounding errors. Otherwise, increase decimal places - the more the better! Say, 6 or even higher. (a) First, fill out the table below. Round $$$ to whole dollars. Don't use any units (e.g., "$"). Facility #2 Subject facility Facility #1 Potential gross income $ $ $ Net operating income $ $ $ (b) Use the gross income multiplier approach to calculate the subject facility's estimated current value. Fill out the table below. Round $$$ to whole dollar, and multipliers to 2 decimal places. Don't use any units (e.g., $"). Facility #1 Facility #2 Subject facility Gross income multiplier Estimated current value $ (c) Using the direct capitalization approach to calculate the subject facility's estimated current value. Fill out the table below. Round $$$ to whole dollar, and the rates to 2 decimal places (e.g., put 1.23 for "1.23%"). Don't use any units (e.g., "%" or "$"). Facility #1 Facility #2 Subject facility Capitalization rate % % Estimated current value $ (put "b" for the gross income multiplier approach, or "c" for the direct capitalization approach) is more (d) Between these two approaches, accurate is estimating the value of the subject property