MBA FPX 5008 Assessment 3 Presenting Data Analysis Results Effectively

MBA FPX 5008 Assessment 3 Presenting Data Analysis Results Effectively Student name Capella University MBA-FPX5008 Applied Business Analytics Professor Name Submission Date Presenting Data Analysis Results Effectively Slide 1: Good morning, my name is _______, and I am here to provide you with an in-depth look at The Coca-Cola Company’s stock for the past decade. Slide 2: Effective communication of results of analysis is required to communicate results of data analysis successfully; providing multiple audiences with clear insights to be acted upon from complex findings will require a variety of methods of communicating through the use of visual tools (charts, graphs, and tables) that help clearly show patterns and/or these trends. When presenting analytical results, the presentation of data (both descriptive and narrative) increases the effectiveness of communicating the impact that decisions made will have on others. The effective sharing of results from analyses greatly increases both the value added from and the impact of any business analysis. Company Context Slide 3: When you get insight into a company’s history, you should have background information on the financial results that they have delivered, and how well they have done as a company in the market. Grouped together in 1892, in Atlanta, Georgia, The Coca-Cola Company is one of the world’s leading beverage companies (The Coca-Cola Company, 2025). The Coca-Cola Company has more than 200 different products, including Coke, Sprite, and Dasani, and sells products in more than 200 countries (Hong & Luo, 2024). By having a background knowledge of the company, analysts will be able to make successful recommendations on whether to invest in the company or not. The stock performance data are influenced by the nature of the business environment, which is competitive. As well, Coca-Cola faces competition from the other two giant non-alcoholic beverages companies, PepsiCo and Keurig Dr. Pepper, in the global market (Huse et al., 2022), and the sales of PepsiCo surpass those of Coca-Cola; it still manages to stay the top player in the market thanks to the specialization of its brands and efficiency (Hong & Luo, 2024). So it’s crucial to consider what the competition is like when making appropriate inferences on the stock performance analysis. Graphical Interpretations Slide 4: High Stock Price Trend Figure 1 High Stock Price Trend Having the stock price change over a large time frame gives an idea of the extent to which the firm’s stock still enjoys the trust of the market and how the firm has performed financially. The share price of Coca-Cola has been steadily rising for the past decade (2016-2026), with its highest price ever recorded at Nasdaq, 2026a. There is still an upward trend in the number of the highest daily stock prices in the 60-day moving average, which shows that there is still strong positive momentum despite the fact that the fluctuation caused by the ups and downs of the short-term market does not seem to be significant (Song et al., 2023). Like the other day’s best stocks, Coca-Cola has demonstrated that its best daily trades share a common characteristic: they’re strong stocks, suggesting that they are popular with investors and have strong growth prospects. This consistent upward trajectory reflects sustained investor confidence and reinforces Coca-Cola’s position as a resilient long-term investment. Slide 5: Competitor & Industry Stock Graph (KO vs PEP vs KDP) Figure 2 Competitor & Industry Stock Graph (KO vs PEP vs KDP) Analyzing the different companies’ relative stock price trends over time in a graphical format will show the different behaviours of the relative stock price trend of the different companies and how it relates to the individual company’s stock price. As PepsiCo has traditionally enjoyed high prices with minimal fluctuations over the past decade, it has multiple income streams (Liu, 2023). In the case of Coca-Cola’s business, it has shown a trend of steady revenue/income growth in its operation, which may be attributed to its strong customer loyalty and the operation of the business being efficient (Hong & Luo, 2023). A comparison of the companies’ stock prices at an industry level will give the investors the time to analyze which of the companies have provided them with steady value over time. Slide 6: Competitor Comparison Table (KO vs PEP vs KDP) Table 1 Competitor Comparison Table (KO vs PEP vs KDP) Metric Coca-Cola PepsiCo Keurig Dr Pepper Industry Nonalcoholic Beverages Food & Beverages Nonalcoholic Beverages Estimated Global Beverage Market Share 43% 25% 7% Total Sales (2025) $47 Billion $92 Billion $15 Billion Number of Employees 79,000 318,000 29,000 Total Assets (2025) $106 Billion $103 Billion $53 Billion Primary Business Model Beverage Manufacturing & Distribution Food and Beverage Manufacturing Beverage Manufacturing & Distribution You’ll get an idea of the market positioning of your Company relative to the competition, as well as their financial strength, by analyzing competitors. In the global beverage market, about 43% of beverage sales were generated via Coca-Cola products, while Keurig Dr Pepper (trading on Nasdaq, 2026b) generated sales of just about 7%. For the total global sales, for the full line of beverages and food, PepsiCo accounted for US$ 92 billion in total sales for FY2025, while Coca-Cola’s total revenue for all beverages and Food for the same period (trading on Nasdaq, 2025) came to about US$ 47 billion. The competitor comparative analysis is delivered through tables, allowing the shareholders of each Company to perform a relative analysis of each Company based on the different variable types through a relative strength/weakness analysis. Slide 7: Descriptive Statistics: Daily Closing Prices Table 2 Descriptive Statistics: Daily Closing Prices Statistic Value Mean 58.73 Median 58.11 Mode 43.12 Standard Deviation 8.64 Variance 74.65 Range 35.72 Minimum 38.45 Maximum 74.17 Count 2,500+ The past ten years have seen relatively stable performance of Coca-Cola’s stock. The day’s average price of the Coca-Cola stock was $58.73, and the middle price value in the price series (median) was $58.11 (Nasdaq, 2026a). From the last decade of yearly observations, Coca-Cola’s stock has exhibited outstanding consistency in its yearly performance, which has a low level […]