Please answer all questions and provide working(with excel if possible). Thank you!

Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. What is the Potential Gross Income (PGI) for the first year? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58) QUESTION 2 Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. What is the Effective Gross Income (EGI) for the first year? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58) QUESTION 3 Common information for the first block of numerical questions in this HW. You want to purchase an office building in Brooklyn. The property contains 27,500 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $42.50/sq ft. The vacancy rate is 6.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. If operating expenses are expected to be 40% of EGI, what is the Net Operating Income (NOI) generated by the property in the 1 st year of ownership? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58)