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 (). New production equipment and facilities costing $30 million will be required in 2015 (t ) 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.
Gentle rest slumber case study, llc: what are the positive aspectsthe employees could glean from the financial data ? AttachedMay 03 2020
Suppose you’re given a data set that classifies each sample unit into one of four categories: A, B, C, or D. You plan to create a computer database consisting of these da...Aug 07 2020
Coal has about 5% sulfur. How many pounds of sulphur would be emitted from coal-fired power plants in the united states in 3 years? (each year. U.S electricityproduction ...Jul 04 2020
EXERCISE 12–9 Utilization of a Constrained Resource [LO5]Shelby Company produces three products: product X, product Y, and product Z. Data concerning the three products f...Jun 27 2020
Inbound and outbound logistics are the primary value generators in a service-oriented company.70) How does competitive strategy determine value chain structure?71) Distin...Dec 23 2019
To fund its wars against Napoleon, the British government sold consol bonds. They were referred to as “perpetuities” because they would pay £3 every year in perpetuity (f...Dec 05 2019
a. What two technical requirements have the highest impact on the customer requirement that the paper not tear?b. The following table presents technical requirements and ...Aug 06 2020
All of the following is one of the guidelines for management by walking around except: (A) Be open and don't argue. The goal is to provide an open environment of trust....Mar 23 2018
For each of the following transactions for Bartlett Co., indicate whether it is a:a.Financing Activityb.Investing Activityc.Operating Activity19.Borrowed $45,000 from a b...Dec 25 2019
The U.S. Army Corps of Engineers is considering the feasibility of constructing a small flood control dam in an existing arroyo. The initial cost of the project will be ...May 22 2018
Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.