Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need Help in understanding the attached Practice Question. Step by step instructions to help me grasp the theory will be most helpful, many Thanks! look6

Need Help in understanding the attached Practice Question. Step by step instructions to help me grasp the theory will be most helpful, many Thanks!

image text in transcribed
look6 - Excel Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do do Cut EB Copy 2b Wrap Text General Bad Format Painter Merge & Center - $ - % Conditional Format as Check Cell Formatting - Table Explanatory .. Clipboard Alignment Number It is the end of 2018 and you recently started working for the Coca-cola Company as a senior project analyst. Senior management has been discussing a limited production run of Crystal Clear Coke as a novelty drink to boost sales temporarily. Crystal Coke would be marketed and sold for 3 years starting in 2019. However, there is some concern that producing and marketing Crystal Clear Coke will canibalize sales from regular Coke. You've been tasked with completing an anlysis to determine if going forward with Crystal Clear Coke makes sense financially. You've been given the information below. New equipment will have to be purchased immediately, totalling $1,250,000. The new equipment will be depreciated on a straightline basis over 10 years, but will NOT be sold or disposed at the end of the project. Instead, it will be repurposed and used for other products. Additionally, inventory will increase by $20,000; accounts payable will increase by $5,000; and accounts receivable will increase by $7,000 for the life of the Crystal Coke project. Any changes in net working capital (NWC) will be recovered or reversed at the end of the project. There will be a one time expense of $500,000 for an advertising campaign. This will be paid at the end of 2019. SG&A expenses will increase by $250,000 for the life of the Capital expenditure required: 1,250,000.00 Increase in inventory: 20,000.00 Increase in accounts payable: 5,000.00 Increase in accounts receivable 7,000.00 Revenue per unit, regular coke: 80.5 Revenue per unit, crystal coke: 10 Cost per unit, regular coke: 80.50 55.35 12 1 Cost per unit, crystal coke: 13 201 2020 14 Unit sales, crystal coke: 2021 700,000 650,000 450,000 15 Unit sales lost, regular coke: 500,000 490,000 195,000 16 17 Advertising campaign: 500,000.00 (One time, at end of 2019) 18 Increase in SG&A: 250,000.00 (each year) 19 20 NPV: 21 (put your final answer here) 22 SHOW YOUR WORK BELOW THIS ROW 24 26

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Economics, Principles, Applications, And Tools

Authors: Arthur O'Sullivan, Steven M. Sheffrin, Stephen J. Perez

5th Edition

0132556073, 978-0132556071

More Books

Students also viewed these Finance questions

Question

Briefly describe Hartleys contributions to associationism.

Answered: 1 week ago

Question

What is one of the skills required for independent learning?Explain

Answered: 1 week ago