Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December...
80.2K
Verified Solution
Link Copied!
Question
Accounting
Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2016. 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.
Select Http://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
Select Financials and select Income Statement when accessing the Income Statement
Select Financials and select Balance Sheet when accessing the Balance Sheet
Do the following for KO and PEP for the year ended 12/31/16 only
Perform a vertical analysis of the Income Statement for KO and PEP for the year ended 12/31/16.
Include in your vertical analysis all of following as a % of total revenue:
Cost of Revenue as a % of Total Revenue
Gross Profit as a % of Total Revenue
Selling, gen and administrative expenses as a % of Total Revenue
Operating Income as a % of Total Revenue
Net Income as a % of Total Revenue
Current Ratio
Accounts Receivable turnover. Assume the total revenue on the income statement represents all sales on account for the year
Average collection period
Merchandise Inventory turnover. Assume the Cost of Revenue on the Income Statement is the same as the Cost of Goods Sold
Debt to Asset Ratio
Return on Assets Ratio
Asset Turnover
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 of you should set it up.
Working Capital
KO
PEP
Current Assets
$ 34,010,000
$ 27,089,000
- Current Liabilities
$ 26,532,000
$ 21,135,000
Net Working Capital =
$ 7,478,000
$ 5,954,000
Strength or Weakness
Working Capital measures the ability of a company to meet its short-term obligations with current assets. Pepsi is and Coke are performing at about the same level. Cokes working capital is a little higher because they have higher current assets and current liabilities.
1.The vertical analysis prepared in 4 A above.
2.All of your computations for the financial analysis. (4 B through 4 H)
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)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!