CHIP AHOY Co. CHIP AHOY Co. has been very successful developing cookies for retail purchase and bringing them to market. The company has historically focused on packaged cookies for home consumption. The retail snack food industry is competitive, and the CEO has recently become interested in expanding into other types of snack foods and has identified a project that looks promising. Engineers have identified expansion equipment that is for sale for $3,000,000 along with acquisition costs (R&D, Labor, Maintenance, etc.) are valued at $180,000 (total project cost of $3,180,000). After breakeven calculations of the new snack food, it is forecasted that this equipment will bring $340,000 in sales per year for 10 years. The equipment has a $500,000 salvage value 10 years from now (assume a sale 10 years from now). The current investments at CHIP AHOY are yielding a 109t return. You have been asked to use this rate of return as your WACC in your analysis of this project. At the asking price, does an NPV analysis of this project indicate that it would be a good deal? What is the IRR of this project? The CEO is considering making an offer of $2,1go,oo0 (inclusive of the $180,000 acquisition costs). At what price range will the project generate an IRR sufficient to meet CHIP AHOY'S return expectations? Prepare an Excel spreadsheet comparing the two cash flow streams. Identify and show the present values of the benefits and the present values of the costs. You will present and explain your calculations comparing the $2,180,000 offer and the $3,180,000 asking, and your plan to the CEO. The CEO has also asked that you include the answers to the following questions in your analysis: 

1. Without changing any of the cash flows, understanding this investment may be negotiated, what is the maximum amount Mr. Ahoy should offer for this to remain beneficial? (Compare this third amount in your Excel sheet.) 

2. Do NPV and IRR analysis always agree on whether a proposed investment creates value for the firm? What evidence do you have? 

3. Are there other capital budgeting techniques that we might use to evaluate this project? What are the Pros and Cons of each? Calculate at least two others as examples. 

4. What other considerations should Mr. Ahoy be concerned with regarding TVM and Capital Budgeting? 

5. What other recommendations do you have for Mr. Ahoy regarding the long-term success of Chip Ahoy Co.? You should be submitting your prepared Excel sheet along with your written memo (minimum of three paragraphs — Intro, Body, Conclusion, and 500-word count). The CEO will evaluate your explanation and recommendations based on the attached rubric.

Answer rating: 100% (QA)

While I cant create Excel spreadsheets directly I can guide you through the financial analysis of the project and provide answers to the CEOs question... View the full answer