Question: Solve it using Excel and show the formulas you use to solve it. Assume a tenant is leasing 8,000 sf in a regional mall of

Solve it using Excel and show the formulas you use to

Solve it using Excel and show the formulas you use to solve it.

Assume a tenant is leasing 8,000 sf in a regional mall of 2.0mm sf. at a minimum rent of $25 psf. Also, the tenant has a percentage rent clause with a natural breakpoint of based upon 5% of sales. The rentable areas in the mall are 900,000sf for the anchors and 500,000 for the in line tenants. Total CAM expenses are $2.0mm which the anchors have agreed to contribute 50%. If sales of our tenant totaled $4.5mm, what is the total rent charges for the tenant (\$'s or psf)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Formulas to use to solve the questions below. And use exactly the same formulas as they are in the images below. Same letters and variables in the formulas should be used to solve the problems...

Q:

Formulas to use to solve the questions below. And use exactly the same formulas as they are in the images below. Same letters and variables in the formulas should be used to solve the problems...

Q:

Formulas to use to solve the questions below. And use exactly the same formulas as they are in the images below. Same letters and variables in the formulas should be used to solve the problems...

Q:

The subject property is a three-tenant retail center, 50,000SF total, with a grocery store anchor. All rents and expenses are expressed on an annual basis. Grocery: 40,000SF Tenant A: 6,000SF Tenant...

Q:

The subject property is a three-tenant retail center, 50,000SF total, with a grocery store anchor. All rents and expenses are expressed on an annual basis. Grocery: 40,000SF Tenant A: 6,000SF Tenant...

Q:

The subject property is a three-tenant retail center, 50,000SF total, with a grocery store anchor. All rents and expenses are expressed on an annual basis. Grocery: 40,000SF Tenant A: 6,000SF Tenant...

Q:

Suppose Generic has to select one of two products, A or B, to introduce into a certain market. Because of their different characteristics, A and B are expected to perform differently in the market....

Q:

need this quick. Thanks 1. Which of the following is an example of a positive statement? O A. If this good is bad for you, you should not consume it. O B. If you consume this good, you will get sick....

Q:

please answer a,b,c,d and e please fill in the excel document as listed below and provide each step to solve and answer each question. there is two excel pages, part (b) and part (d) please show both...

Q:

Instructions: electronically submit your answers to Canvas by the due date. For Parts (b) & (d) use the Excel template file that is posted along with this assignment on Canvas and attach your...

Q:

Find an ad for a job related to your field of study - something entry level that you could realistically apply for after graduation. Prepare a Professional Resume and Cover Letter for that specific...

Q:

A 1.00-kg beaker containing 2.00 kg of oil (density = 916.0 kg/m3) rests on a scale. A 2.00-kg block of iron is suspended from a spring scale and completely submerged in the oil as in Figure P14.63....

Q:

The outcomes for consumers are expected to be quite different if a market is purely competitive rather than purely monopolistic. List some of the differences you would expect and explain your choices.

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

10-8 The mobile platform may not make desktop PCs obsolete, but corporations will have to change their business models to adjust to this shift. Do you agree? Why or why not?

Q:

10-12 Pick one e-commerce company on the Internetfor example, Ashford, Buy.com, Yahoo, or Priceline. Study the Web pages that describe the company and explain its purpose and structure. Use the Web...

Q:

4. What role does Orbitz for Business play in the companys business strategy? When it comes to mobile apps and gauging their impact on consumers and business, the online travel industry and its...