Reference no: EM13951598
You are Sam Vestering, manager of North American Distribution for Worldwide Enterprises. You are preparing a projected distribution revenue schedule for Marquee Productions' latest films Two by Two, to be released February 14, 2003. Create a new workbook that will estimate Worldwide's projected revenue using the following information (see Figure E1-5):
A. Preview cities receive the film on the Friday before the general release date and pay Worldwide Enterprises 1.25% of projected box office revenues.
B. General release cities pay Worldwide Enterprises 1% of projected box office revenues.
C. All projections are paid in U.S. dollars.
D. Include a total of the projected revenue for Worldwide Enterprises. (Hint: You may want to create this workbook by grouping the preview cities and the general release cities separately.
Figure E1.5
City Release Category Projected Box Office Sales in Millions
New York Preview 22.5
Phoenix General 12.3
Los Angeles Preview 31.8
Denver Preview 18.3
Miami General 22.5
Des Moines General 11.2
Wichita Preview 10.6
Boston General 19.4
Philadelphia General 21.6
Fort Worth General 19.4
Milwaukee General 17.8
Vancouver General 12.4
Winnipeg General 10.1
Toronto Preview 17.5
Montreal Preview 15.8
2. Make any formatting changes you think would improve the appearance of the workbook.
Attachment:- Excel S1-P3.zip
|
Forward versus money market hedge on payables
: Forward versus Money Market Hedge on Payables. Assume that the Mississippi Airlines in the United States will need 450,000 ringgit in 90 days. It wishes to hedge this payables position. Would it be better off using a forward hedge or a money market h..
|
|
What might account for the improvement in performance
: What might account for the improvement in performance related to time per call and the poor rating of customer support?
|
|
Should the company accept or reject the project
: Calculate the NPV of a project given the following - and should the company accept or reject the project: It is estimated that the project will deliver $25,000 operating profit each year for 12 years. They can sell stock at $20.00 with a flotation co..
|
|
Demand estimation-sample analytical problem
: Please review the following files posted in Week 2 Instructor Insights. Demand Estimation - Sample Analytical Problem
|
|
Include a total of the projected revenue for worldwide
: Include a total of the projected revenue for Worldwide Enterprises. (Hint: You may want to create this workbook by grouping the preview cities and the general release cities separately.
|
|
Using the DCF valuation method used in class
: You’re a financial advisor and one of your clients comes to you for advice. He wants to invest in company XYZ. What would be your first steps in order to help your client? Using the DCF valuation method used in class, what would you recommend to your..
|
|
Firms required return using both CAPM-constant growth model
: A firm's upcoming dividend is expected to be 2.25 and its stock is selling at $65. The firm has a beta of .8 and is expected to grow at 10% in the foreseeable future. Compute the firms required return using both CAPM and the constant growth model. As..
|
|
Assume that the interest rate
: If you assume that the interest rate is 10% (which means that after you get the money, it will be invested and you will get 10% interest from it), how much money will you have in 4 years.
|
|
Debt financing to fund this project
: If an investment project has a negative net project value, when discounted at a cost of capital equal to 9%, the internal rate of return might be, 12% and an acceptable level for taking on the project, 7% and justifiable only if the payback period is..
|