Reference no: EM131051324
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?
2. What are the expected operating cash flows for 2016 thru 2019?
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.
|
Improper disclosure of health information
: A cause of action for improper disclosure of health information may result from either a negligent or intentional act. Complete an Internet search and find news stories related to breach of patient confidentiality.
|
|
What actions and behaviors or principles should you consider
: You have been thinking about working with children as a Certified Child Life Specialist in a pediatric hospital setting. What actions, behaviors, or principles should you consider in preparing to work with this special population?
|
|
Prepare a flexible budget and a performance report
: Prepare a flexible budget. Prepare a performance report. Prepare a master budget. During December, the salesmen made a special deal with the airlines which dropped the quarterly sales price from $4.00 per meal to an average of $3.80 each.
|
|
What is the expected end of project termination cash flow
: 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 ..
|
|
List problems associated with project management
: Analysis of Problems in Case Study - List problems associated with Project Management Practices and Analysis of Problems in Case Study
|
|
Outgoing traffic to the same address
: A device that can look at all protocol headers up to the transport layer is called layer-4 firewall. Which one of the following statement is true layer-4 firewall?
|
|
Wifi labs sells wireless routers
: 2. WiFi Labs sells wireless routers that are very popular in the market with a weekly demand that is normally distributed with a mean of 20,000 and a standard deviation of 6,000. WiFi outsources manufacture of these routers to a local contract man..
|
|
Securities and exchange commission
: Refer to the search you performed in the Learning Activities on the U.S. Securities and Exchange Commission's (SEC) website. This search should have produced a variety of financial documents for the publically traded companies you searched. Identify ..
|