### Construction of new stadium for major league baseball team

Assignment Help Financial Management
##### Reference no: EM131849228

Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may buy the boxes for \$100,000 each. The fixed construction cost for the upper deck area is estimated to be \$1,500,000 with a variable cost of \$50,000 for each box constructed.

1. Use the data table tool in Excel (Data > What-If-Analysis > Data Table) to calculate the profit realized when s = 40 and Qvaries from 0 to 60 in increments of 5, i.e. Q = 0, 5, 10, 15, etc. and then use the graph wizard to graph the profit line as a function of Q. (you can cope your excel table to answer this question.)

A reliable sales forecast has been obtained indicating that City officials would be able to sell 40 boxes. However, the City officials are concerned that this conclusion might change if more accurate estimates were available for the fixed cost of construction, the marginal construction cost, and the unit revenue for each box. Therefore, before a final decision is made, management wants sensitivity analysis done on these cost/revenue estimates. Use the spreadsheet you developed in part c and use the goal seek command and/or data table features in Excel to perform the following sensitivity analysis. Note: Parts (e), (f), and (g) are independent of each other and each part refers to the original data.

2. How large can the fixed cost of construction before this project ceases to be profitable?

3. How large can the marginal construction cost be before this project ceases to be profitable?

4. How small can the unit revenue for each box be before this project ceases to be profitable?

#### Questions Cloud

 What is the lowest score someone can get : Everyone who scores in the top 30% of the distribution gets a certificate. What is the lowest score someone can get and still earn a certificate? What did you observe about how social the person is : The purpose of this assignment is to recognize the concepts we have studied, at work in real life, in your observations of an adult or elderly person's daily. What is the probability that the fisher chosen : What is the probability that the fisher chosen from Clearwater had a license and the fisher chosen from Mountain View did not have a license? Define overextension and describe running commentaries : What can give a teacher insight into children's language behavior? How many new words might a preschooler acquire each day? Construction of new stadium for major league baseball team : Preliminary plans are under way for the construction of a new stadium for a major league baseball team. How many ways can allan arrange : In how many ways can Allan arrange the 9 songs on the? CD?Allan can burn the 9 songs on the CD in ____ different ways. Summarize the characteristics of culturally relevant teacher : Describe the problem from Jeff Bliss's perspective as well as from Ms. Phung's perspective. Explain what probably caused it. What is the probability that a randomly selected worker : What is the probability that a randomly selected worker primarily drives a van or takes public transportation to? work? How would you defend your argument : Select an argument FOR or AGAINST either euthanasia or physician-assisted suicide. How would you defend your argument? and give example of which one is the most

### Write a Review

#### Assuming the stock returns follow normal distribution

what is the probability that this stock will earn at least 20% in any one given year assuming the stock returns follow normal distribution?

#### Describe the role of the firms tax rate in cost of capital

How is the fun's weighted cost of capital influenced by the firm's capital structure and describe the role of the firm's tax rate in cost of capital calculations?

#### Interest payments will be tax deductible

You want a new automobile for personal use. Neither depreciation nor interest payments will be tax deductible. What is the indifference point?

#### The after-tax cost of debt is generally

The after-tax cost of debt is generally:

#### An operating lease generally

An operating lease generally:

#### What is the probability that european call option on stock

A stock price follows a geometric Brownian motion with an expected return of 15% and a volatility of 30%. The current price is \$39. What is the probability that a European call option on the stock with an exercise price of \$40 and a maturity date in ..

#### Define the shareholder cash flow

FCOJ, Inc., a prominent consumer products firm, is debating whether or not to convert its all-equity capital structure to one that is 35 percent debt.

#### Your investment horizon is three years

What is the value of \$1 invested in each share class if your investment horizon is 3 years? What if your investment horizon is 20 years?

#### What is the nov for the project

What is the NOV for the project? Should we accept or reject this project?

#### Calculate the required return for each stock

calculate the beta for stock a and stock b. calculate the required return for each stock

#### What is balance of mortgage loan after two year of payments

You just found the house of your dreams. How much are your monthly payments for the loan? What is the balance of the mortgage loan after 2 year(s) of payments

#### What is required rate of return on the investors portfolio

An investor is forming a portfolio by investing \$50,000 in stock A which has a beta of 1.50, and \$25,000 in Stock B which has a beta of .90. The return on the market is equal to 6% and treasury bonds have a yield of 4%. What is the required rate of r..