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.
Suppose that Bob withdraws $100 of cash from his checking account at Security Bank and uses it to buy a camera from Joe, who deposits the $100 in his checking account in ...May 27 2020
Today, virtually all managers endorse social responsibility of corporations. It is, instead, a matter of what types of responsibility and the degree of responsibility. Th...Jul 22 2021
In the following reactions, identify which element is oxidized and which is reduced by assigning oxidation states.Jul 27 2021
A company has a deferred tax liability of $20,000 at the beginning of the fiscal year relating to a taxable temporary difference of $80,000. The current year tax rate is...Dec 12 2019
Now, you believe the dealer knows more about the cars than you. How much are you willing to pay? Why? How can this be resolved in a competitive market?Mar 28 2020
Based on their respective van der Waals constants (Table 10.3), is Ar or CO2 expected to behave more nearly like an ideal gas at high pressures? Explain.Aug 21 2021
1. Specify and explain the typical shapes of marginal-benefit and marginal-cost curves. How are these curves used to determine the optimal allocation of resources to a pa...Apr 27 2020
Insert commas, semicolons, and colons to punctuate the following sentences correctly. For each sentence indicate the number of additions you made.We are looking for many ...Jul 14 2021
Job costing The Gonzalez Company uses a job order costing system at its plant in Green Bay, Wisconsin. The plant has a machining department and a finishing department. Th...Jul 01 2020
If S is a sphere and F satisfies the hypotheses of Stokes'Theorem, show thatJun 22 2021