Module 4 Mini-Case Assignment Instructions The Owens Chocolatier Company is a midsized company operating in Virginia Beach, VA. The company specializes in making specialty chocolates and candies and sells its products in physical stores throughout the southeast. In recent years, the company has been successful at reaching customers throughout the US thanks to its revamped website and online marketing efforts. The company's president Ryan Owens is considering purchasing new equipment and machinery to be able to meet the increased demand. The new machinery and equipment costs $450,000 and is expected to be used for 5 years. Mr. Owens expects to sell the equipment's parts for $50,000 in year 6 and expects to use straight line depreciation. Since you are a recent MBA graduate, Mr. Owens asked you to evaluate whether such investment is likely to add value to the company. Working with the marketing and accounting departments, he gave you a report that shows expected revenues in the next 5 years and expected expenses. He also supplied you with expected investments in working capital. The tax rate=21% and the required return = 15%. Year 1 Year 2 Year 3 Year 4 Year 5 Revenues 500000 550000 450000 380000 250000 Cost of Goods Sold 225000 247500 202500 171000 112500 Other Costs 30000 30000 30000 30000 30000 Year 1 Year 2 Year 3 Year 4 Year 5 10800 26000 34000 28500 21600 Working Capital Using what you have learned in your Managerial Finance course. Estimate the project's cash flows, calculate the NPV and provide an investment recommendation. Attach your spreadsheet showing your calculations. 4) What is the cash flow from investment in working capital in year 2? A. -$10800 B. $13,000 C. -$15,200 D. -$20,200 5) What is the cash flow from investment in working capital in year 6? A. $21,600 B. $5500 C. $4,200 D. $19,200 6) What is the project's cash flow in year 0? A. -$500,000 B. -$450,000 C. -$400,000 D. $-250,000