Reference no: EM131052598
Coca-Cola Project Analysis
To show your work and to receive credit, please use Excel cell formulas,
financial functions or algebraic time value of money equations to answer these questions in your spreadsheet.
Coca-Cola is considering jumping on the pomegranate bandwagon by producing Poma-Cola and Pomegranate Sprite carbonated beverages in 2016 (t=1). New production equipment and facilities costing $30 million will be required in 2015 (t =0) and fall into the 5-year straight-line depreciation class. Additional net working capital of $5 million will also be needed in 2015. Here are sales projections for the proposed projects.
Year Expected New Pomegranate Sales
2016 $22 million
2017 $30 million
2018 $25 million
2019 $20 million
Projected operating costs (other than depreciation) are 73% of sales for the new beverages. However, Coca-cola estimates that projected sales for other carbonated beverages will fall $5 million in 2016, $9 million in 2017, $7 million in 2018, and $4 million in 2019 if they introduce the new beverages. Projected operating costs for these existing beverages are 68% of sales. At the end of 2019, the project will end and the production equipment and facilities could be sold for an estimated $10 million.
Coca-Cola’s marginal tax rate is 40% and this is an average risk project for the company giving the project a WACC of 9%. Answer the following.
1. What is the initial cost of the project? (I've answered this question)
2. What are the expected operating cash flows for 2016 thru 2019? (can't seem to get the TVM formula to work on excel)
3. What is the expected end of project termination cash flow at the end of 2019?
4. Calculate the NPV and IRR for the proposed project.
5. Should Coca-Cola go ahead with this project? Explain your answer.
|
What was the cash balance at the end of quarter
: Jupiter stores had a Quarter 2 beginning cash balance of $430. Sales for Quarters 1 through 3 are estimated at $600, $800, and $900, respectively. The cost of goods sold is equal to 70 percent of sales. Goods are purchased one quarter prior to the mo..
|
|
True regarding payment and the place for delivery
: Which of the following is true regarding payment and the place for delivery if those terms are left open under the UCC?
|
|
Bankruptcy protection during this recession
: A number of major retailers have been driven into bankruptcy protection during this recession, including Red Envelope and Eddie Bauer, or gone out of business altogether, like Circuit City. Blockbuster, Virgin Megastores, and many more have closed..
|
|
Compare the obtained value and the critical value
: Compare the obtained value and the critical value. Make a decision. With this information would you conclude that the results are significant? Why or why not? Report your findings the way we practiced in class.
|
|
Coca-cola project analysis
: Coca-Cola is considering jumping on the pomegranate bandwagon by producing Poma-Cola and Pomegranate Sprite carbonated beverages in 2016 (t=1). New production equipment and facilities costing $30 million will be required in 2015 (t =0) and fall into ..
|
|
Do you think the company can reduce costs
: In what other ways do you think Zappos can affordably enhance its customer service? Use credible sources and research to support and explain.
|
|
Write a method called alarm that prints the string alarm!
: The method should accept an integer parameter that specifies how many times the string is printed. Print an error message if the parameter is less than 1.
|
|
New business intelligence (bi) system
: Jim Honerkamp, CIO of Hillman Group, is proud of his new business intelligence (BI) system. Why not? It's much better than what came before. In the bad old days, executives looking for sales information, for example, had to ask one of Honerkamp's ..
|
|
Change in price the bond will experience in dollars
: A 6.20 percent coupon bond with ten years left to maturity is priced to offer a 7.4 percent yield to maturity. You believe that in one year, the yield to maturity will be 7.0 percent. What is the change in price the bond will experience in dollars?
|