Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Group Project 3 Problem 2 (50 Points) Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2022. Follow

Group Project 3 Problem 2 (50 Points) Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2022. Follow the instructions below to access each companys information and perform a financial analysis based on the financial measures we have learned in this course. 1. Select www.yahoo.com and then select Finance. In the Search section at the top of the screen select KO for Coca-Cola and PEP for Pepsi 2. Select Financials and select Income Statement when accessing the Income Statement 3. Select Financials and select Balance Sheet when accessing the Balance Sheet 4. Do the following for KO and PEP for the year ended 12/31/22 only A. Perform a vertical analysis of the Income Statement for KO and PEP for the year ended 12/31/22 Include in your vertical analysis all of following as a % of total revenue: o Cost of Revenue as a % of Total Revenue o Gross Profit as a % of Total Revenue o Selling, gen and administrative expenses as a % of Total Revenue o Operating Income as a % of Total Revenue o Net Income as a % of Total Revenue B. Current Ratio C. Quick Ratio (Acid-Test) D. Accounts Receivable turnover ratio. Assume the total revenue on the Income Statement represents all of the sales on account E. Days Sales in Receivables. F. Inventory turnover. Assume the Cost of Revenue on the Income statement represents the Cost of Goods Sold G. Times Interest Earned Ratio H. Rate of Return on Common Stockholders Equity I. Rate of Return on Total Assets J. Debt to Equity Ratio K. Debt Ratio L. Asset Turnover Ratio M. Price Earnings Ratio on basic earnings per share as of 12/31/2022. The closing market price can be determined by following these procedures: i. Select Http://www.yahoo.com/ and select Finance at the top. ii. Go to Yahoo! Finance and enter Symbol key KO for Coca-Cola and PEP for Pepsi. iii. Select Historical data and scroll down to the closing price for 12/31/2022. Do this for both KO and PEP You will also need the Basis Earnings per Share from the income statement for Coke and Pepsi. A little more research will be needed for for this part, since Coke and Pepsis Basic Earnings Per share is not given on the Yahoo statement. To find the Basis Earnings Per share you will need to do the following: 1. To access SEC filings go to U.S. Securities and Exchange Commission Edgar Company Filings . 2. Select KO under search and select coca cola (K) for Pepsi select Pepsi in the search section and select Pepsico Inc (Pep) 3. Under Select Filings select Form 10-K filed on 2/21/2023 for Coke and 2/9/2023 for Pepsi. 4. You will then need to find Financial Statements and Supplementary Data and then look up the Basic EPS on the Consolidated statements of Income. You will need to do a little more searching for Pepsi. In preparing the vertical analysis and other financial analysis above; define each measure and identify the strengths and weaknesses of KO and PEP as related to each other. Below is an example how of you should set it up a long with the definition and strength or weakness from the 2020 year: Working Capital KO PEP Current Assets $ 22,591,000 $ 21,539,000 - Current Liabilities $ 19,724,000 $ 26,785,000 Net Working Capital = $ 2,867,000 $ (5,246,000) Strength or Weakness Working Capital measures the ability of a company to meet its short-term obligations with current assets. Coke is performing better since it has current assets substantially above working capital and Pepsi has a negative working capital. Requirements for Each Group 1. The vertical analysis prepared in 4A above. 2. All of your computations for the financial analysis. (4B through 4M) 3. Identification of strengths and weaknesses. (Include a definition of each financial measure, a description of which company is doing better in each financial measure including the vertical analysis and explain why) 4. All group members must submit the Report Project Team Assessment If the requirements above are not met, points will be deducted. I NEED HELP WITH PART H THROUGH M !!!!

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

The Process Auditing And Techniques Guide

Authors: J.P. Russell

2nd Edition

087389782X, 978-0873897822

More Books

Students also viewed these Accounting questions

Question

can some one help me write a business proposal (mock)

Answered: 1 week ago

Question

Develop skills for building positive relationships.

Answered: 1 week ago

Question

Describe techniques for resolving conflicts.

Answered: 1 week ago

Question

Give feedback effectively and receive it appropriately.

Answered: 1 week ago