For the calculations in this problem increase decimal places for an intermediate calculations to say, 6 or her. The more the better if you can do the math in Excel with correct referencing to cells with intermediate results even better because Excel by default doesn't round anything. In fact, I highly recommend to solve this problem in Excel because it's save you a lot of time in partio Simon Property Group www.simon.com) is a real estate investment company that owns premier shopping dining entertainment and mixed-use properties in North America, as well as Europe and Asia. It generates bilions in annual sales, and is therefore the company's priority to maintain the night mix of tenants in its properties that pay the rental prices that just right The Maple Mall is a newly opened mall(this is a fictitious mall, by the way consists of a total area of 21 million square feet. Macy's, Nordstrom, Sears, and JC Penney are its anchors, and they altogether occupy 5.5 million square feet of space. The mall owner is planning that eachinine tenant in the mall would be paying $2.75 per year per usable square foot in common area maintenance (CAM) charges. In-line tenants will occupy 9.5 million square feet The remainder is common area ovovovovovo square feet (use "o" for any blank values which the landlord believes will require 56 per square foot to maintain and operate each year. tall the shopping malls owner would like to recover at CM expenses from all tenants in the mall, the anchors would need to pay for any blank values) every year per square foot of their usable space for the CAM charges (round to 2 decimal places and use "o The landlord has run some numbers and figured out a couple additional figures Fre, can charge the anchors additional 50.50 in CAM charges per square foot per year, without risking them towing for other locations. In this case, the in line tenants would need to pays per square foot per year use" for "more" or "2" for less than they pay in part (a) of this problem c) Second, if needed, the landlord has some flexibility in reallocating the space in the mal between the common areas and in-line tenants, as well as in adding extra common areas to the existing square footage of the mal. Assume that anchor stores annual per square foot contribution to the CAM charges can never exceed the annual per square foot contribution by the in-line tenants. How can the square footage of common areas in the shopping malle.. parking structures, food court areas, hallways, etc.) be altered in order for the anchors annual CAM contribution per square foot to also equal $2.757 Your answer the square footage of common areas would need to use "1" for increase" or "" for "decrease") by (round and use "0" for any blank values) square feet. (HINT: "Goal seek in Excel might be the easiest way to figure this out For the calculations in this problem increase decimal places for an intermediate calculations to say, 6 or her. The more the better if you can do the math in Excel with correct referencing to cells with intermediate results even better because Excel by default doesn't round anything. In fact, I highly recommend to solve this problem in Excel because it's save you a lot of time in partio Simon Property Group www.simon.com) is a real estate investment company that owns premier shopping dining entertainment and mixed-use properties in North America, as well as Europe and Asia. It generates bilions in annual sales, and is therefore the company's priority to maintain the night mix of tenants in its properties that pay the rental prices that just right The Maple Mall is a newly opened mall(this is a fictitious mall, by the way consists of a total area of 21 million square feet. Macy's, Nordstrom, Sears, and JC Penney are its anchors, and they altogether occupy 5.5 million square feet of space. The mall owner is planning that eachinine tenant in the mall would be paying $2.75 per year per usable square foot in common area maintenance (CAM) charges. In-line tenants will occupy 9.5 million square feet The remainder is common area ovovovovovo square feet (use "o" for any blank values which the landlord believes will require 56 per square foot to maintain and operate each year. tall the shopping malls owner would like to recover at CM expenses from all tenants in the mall, the anchors would need to pay for any blank values) every year per square foot of their usable space for the CAM charges (round to 2 decimal places and use "o The landlord has run some numbers and figured out a couple additional figures Fre, can charge the anchors additional 50.50 in CAM charges per square foot per year, without risking them towing for other locations. In this case, the in line tenants would need to pays per square foot per year use" for "more" or "2" for less than they pay in part (a) of this problem c) Second, if needed, the landlord has some flexibility in reallocating the space in the mal between the common areas and in-line tenants, as well as in adding extra common areas to the existing square footage of the mal. Assume that anchor stores annual per square foot contribution to the CAM charges can never exceed the annual per square foot contribution by the in-line tenants. How can the square footage of common areas in the shopping malle.. parking structures, food court areas, hallways, etc.) be altered in order for the anchors annual CAM contribution per square foot to also equal $2.757 Your answer the square footage of common areas would need to use "1" for increase" or "" for "decrease") by (round and use "0" for any blank values) square feet. (HINT: "Goal seek in Excel might be the easiest way to figure this out