Reference no: EM13742436
Final Case Project
Suppose that the Cott Corporation (Symbol COT) is considering adding a new product line. Currently, Cott sells apple juice and they are considering selling a new fruit drink. The fruit drink will have a selling price of $1.64 per container. The plant has excess capacity in a fully depreciated building to process the fruit drink product line. The new fruit drink will be discontinued in four years. The new equipment falls under the 3-year MACRS depreciation schedule. The new fruit drink requires an increase in inventory of $275,000, an increase in accounts receivable of $135,000, and an increase in accounts payable of $110,000. Projected sales are 4,000,000 containers in the first year, with a 9% growth rate for each subsequent year. Variable costs are 60% of total revenues and fixed costs are $1,250,000 each year. The new equipment costs $2,500,000 and has a salvage value of $500,000. The corporate tax rate for Cott is 35%.
Cott currently has 1,100,000 bonds outstanding with a 5.38% coupon rate (paid semi-annually) and 8 years left until maturity. They are selling at 98% of par.
You will gather current market data (price, beta, & shares outstanding) on Cott's common stock from Yahoo! Finance.
Remember from project #3, beta and shares outstanding are under 'Key Statistics' in Yahoo! Finance.
The monthly expected return on the S&P 500 (SPY) that we calculated from project #3 was 1.19%.
Multiplying this by 12 will give you a reliable estimate of the expected return on the market.
The risk-free rate is 1.2%.
Required
*Unless the value is given above (or pulled straight from Yahoo! Finance), all cells highlighted in yellow require a calculation done using formulas.
*Do not forget the correct sign convention
*Double-check your calculations using your calculator
1. Calculate the WACC for the company using the 'WACC' tab below.
2. Create pro-forma income statements for the incremental cash flows from this project using the
Enter formulas to calculate the PV of each year's cash flows in row 36.
(You can either use the EXCEL formula PV() or use mathmatical formula for PV of a lump sum.)
The NPV is simply the sum of the PVs of all years' cash flows
3. Create a NPV profile using the 'NPV Profile'.
|
Accurate forecast of the demand for soft shag carpet
: The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet ..
|
|
Describe how the two countries are different
: Develop a two-page, APA-formatted paper that addresses the following: Describe how the two countries are similar in terms of Hofstede's five cultural dimensions.
|
|
Primary project management organizational structures
: Write a 1,050- to 1,400-word paper in which you compare and contrast the three primary project management organizational structures: functional, matrix, and pure project. In your paper, discuss the situation in which each structure would be the be..
|
|
Explain the morphology-structure
: In the following table, list the major anatomical features used for keying insects. Explain the morphology-structure and form-and function of the anatomical features
|
|
Case project-cott corporation
: Suppose that the Cott Corporation (Symbol COT) is considering adding a new product line. Currently, Cott sells apple juice and they are considering selling a new fruit drink.
|
|
Technology has impacted organizational communication
: In a 250-300 word response, analyze how the use of technology has impacted organizational communication both positively and negatively. How has technology impacted the verbal and nonverbal cues used in interpreting messages?
|
|
Decision making across the organization
: Martinez Company has decided to introduce a new product. The new product can be manufactured by either a capital-intensive method or a labor-intensive method. The manufacturing method will not affect the quality of the product. The estimated manuf..
|
|
Certain level of intercultural communication competence
: In a 250-300 word response, critically examine your personal level of intercultural communication competence. Is it important for you to achieve a certain level of intercultural communication competence. Would enhanced intercultural communication ..
|
|
Define would a visual presentation enhance its effectiveness
: How would you present the information related to this report in a visual manner. Would a visual presentation enhance its effectiveness. Why or why not. Use at least one resource to support your key points. Respond to at least two of your fellow st..
|