As always, I would recommend solving this problem in Excel. This will help you avoid any rounding errors when you do correct referencing to the cells with intermediate results.

A regional office of McGraw Hill is expanding and is currently in the process of relocating to a new building. It is looking for 6,000 square feet of usable office space for its 25 employees. A leasing broker shows McGraw Hill space in a 20-story multi-tenanted office building. This building contains 1,100,000 square feet of gross building area. A total of 30,000 square feet is interior space and is non-rentable. The non-rentable space includes areas in the basement, elevator core, and other mechanical and structural components. There are 90,000 square feet of common area is the lobby area that can be used by all tenants and, of course, their business clients. The square footage that is exactly what McGraw Hill is looking for is on the lucky thirteenth floor. The thirteenth floor contains 40,000 square feet of rentable area. There are other tenants on that floor already, and they occupy a combined total of 27,000 square feet of usable space. The leasing broker indicated to McGraw Hill that base rents will be $15 per square foot per year of rentable area.

 

(a) Fill out the table below for McGraw Hill. (Round all load factors to 4 decimal places, and everything else to 2 decimal places. Use commas to separate thousands and millions: e.g., put 1,000,000 rather than 1 000 000 or 1000000. Do not use "$" signs.) If not considering any common areas If considering only common areas on the 13th floor if considering only common areas in the rest of the building If considering common areas on the 13th floor and the rest of the building Load Factor Sq.ft. of rentable area Total annual rent due $ $ $ Rent per sq.ft. per year effectively paid for the usable area