FIN 425 - Course Project CougFresh Inc. DCF Project and Company Analysis Instructions: Your final report should include a complete set of tables, numerical and written answers to each part of the...

Attached


FIN 425 - Course Project CougFresh Inc. DCF Project and Company Analysis Instructions: Your final report should include a complete set of tables, numerical and written answers to each part of the assigned questions. Show your computation steps. Your written report for this project should not exceed 8 pages. There is no minimum page requirement as long as you answer all questions properly. If necessary, you can choose to provide additional evidence such as supporting excel calculations, regressions, additional tables or data. Note that additional evidence is not required. Additional Requirements In conducting the analysis and preparing your report, you may use any sources you find helpful: textbook, public documents, data from various websites, and etc. However, the work you submit must be your own in the sense that it represents your own synthesis and analysis of information gathered from multiple sources and is written in your own words. Be sure to carefully document all your sources, calculations, and assumptions. Moreover, you should perform your own data analysis and estimations, rather than copying from other available analyst's report (such as beta, cost of capital, etc). Failure to follow any of the above requirements can result in serious consequence and even a fail of the project or the course. Additional important project Policies and Template will be posted on canvas. It is your responsibility to read and comply with these policies. CougFresh is an American retailer located in Pullman, WA. The company president is John Smith, who inherited the company. When the company was founded over 30 years ago, it originally focuses on retailing beverage and organic food to more than 30 states in the US. Over the years, the company still maintains its original retail business, accounting for about 50 percent of its total revenue. Faced with stiff competition, the company also expanded into the business of manufacturing its own soft drinks. You, as a Carson College business majored, are hired by the company's finance department to evaluate a new project for the company. As of now, CougFresh's only soft drink is named the IcyBlast (IB), and sales have been excellent. CougFresh's main competitor in the soft drink market is Coca-Cola, Inc (KO). CougFresh's IB is similar to the Coca-Cola’s Zero Sugar but with richer flavor. However, CougFresh wants to introduce a new energy version of the soft drink, the BurnZero (BZ), into their lineup. CougFresh spent $600,000 to develop the new BZ, which features more environmentally friendly ingredients, and is healthier than the existing IB soft drink. The company has spent a further $150,000 on a marketing study to determine the new drinks expected sales figures. CougFresh can manufacture the new drink for $1.5 per bottle in variable costs. Fixed costs for the operation are estimated to run $250,000 per year. The estimated sales volume is 500,000, 600,000, and 350,000 drinks per year for the next three years, respectively. The unit price of the new drink will be $3.5. The necessary equipment can be purchased for $350,000 and will be depreciated on a five-year MACRS schedule. It is believed the value of the equipment in three years will be $200,000. As previously stated, CougFresh currently manufactures the IB. Production of the existing product is expecting to be terminated in two years. If CougFresh does not introduce the new BZ product, sales of the existing product will be $1,000,000, and $800,500 per year for the next two years, respectively. The price of the existing soft drink, IB is $2.5 per bottle, with variable costs of $1 each and fixed costs of $3 million per year. If CougFresh does introduce the new drink, sales of the existing one will fall by 100,000 bottles per year, and the price of the existing soft drink will have to be lowered to $2 per bottle. Net working capital for the project will be 20 percent of sales and will occur with the timing of the cash flows for the year; for example, there is no initial outlay for NWC, but changes in NWC will first occur in Year 1 with the first year's sales. CougFresh has a 20 percent corporate tax rate. The company has a target debt to equity ratio of 0.5 and is currently BBB- rated (according to S&P 500 ratings). The overall cost of capital of CougFresh is 10 percent. The finance department of the company has asked you to prepare a report to John, the company’s CEO, and the report should answer the following questions. QUESTIONS Required Part (questions1-4) 1. Can you prepare the income statement and the total cash flow (CFFA) table for this new project? 1. Please use these tables to help explain to John the relevant and irrelevant cash flows of this project? 1. The company’s CEO, John, wants to understand the risk of the soft drink industry better. Since CougFresh’s main competitor, Coca-Cola, Inc (KO), is a leading company in this industry, John asks you to perform the following analysis on KO. 1. Using the past N years of data (ending at December 2020) to estimate your own beta and alpha of KO based on a regression analysis. Document data sources used. Also explain how long a time period (from which year to which year) that you decide to use to perform your estimation, and explain why? 1. Provide your beta and alpha estimates, as well as the statistical significance (e.g. t ratio, p-value). Comment briefly. 1. Plot the security characteristic line for this company. Clearly show alpha and beta on the diagram. Is the company correctly priced, overpriced or underpriced? 1. From the above analysis, can you explain to John the risk characteristics of KO and the soft drink industry using the beta you estimated? Do you think your estimated beta makes sense given the nature of the company and the industry? 3. Given your understanding of CougFresh and your analyses so far, can you help John to make the project decision regarding the company’s new product BZ? That is, please compute the NPV and IRR of CougFresh’s new project? Please show your computation steps clearly (show your inputs if using financial calculator or excel sheet). Should John take the new project? Why or why not (Please explain using the NPV and IRR rules separately)? Bonus question* (*Note – Bonus question is not a required part for this course project. Please consider this question only after you finish the required part (first 4 questions). You have the opportunity to get up to 15 points for answering the bonus question.) John is also interested in understanding the cost of capital of the soft drink industry. Therefore, he asks you to find the cost of equity, the cost of debt, and the WACC of KO. Please show your computational steps clearly and document data sources used and any assumptions you make. Briefly comment on how this analysis may help John in his capital investment decisions. ***** End *****