PLEASE DO THIS ON EXCEL AND SHOW FORMULA

As CFO for Everything.Com, you are shopping for 5,000 square feet of usable office space for 25 of your employees in Center City, USA. A leasing broker shows you space in Apex Atrium, a 10-story multi tenant office building. This building contains 300,000 square feet of gross building area. A total of 45,000 square feet is interior space and is non-rentable. The non-rentable space consists of areas contained in the basement, elevator core, and other mechanical and structural components. An additional 30,000 square feet of common areas the lobby area usable by all tenants. The leasing broker indicated that base rents will be $30 per square foot of rentable area.

1.Calculate total rentable area in the building as though it would be rented to one tenant.

2.Calculate the load factor for the building.

3.Calculate the rentable area for Everything.Com.

4.Calculate total rent annually and monthly for Everyting.com.