Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Evaluate the financial performance of Coca-Cola; ( KO ) and Pepsi ( PEP ) for the year ended December 31, 2018. Follow the instructions below

Evaluate the financial performance of Coca-Cola; (KO) and Pepsi (PEP) for the year ended December 31, 2018. 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. Go to 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

  1. Do the following for KO and PEP for the year ended 12/31/18 only: Perform a vertical analysis of the Income Statement for KO and PEP for the year ended 12/31/18. Include in your vertical analysis all of following as a % of total revenue:
    1. Cost of Revenue as a % of Total Revenue
    2. Gross Profit as a % of Total Revenue
    3. Selling, gen and administrative expenses as a % of Total Revenue
    4. Operating Income as a % of Total Revenue
    5. 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

$ 30,634,000

$ 21,893,000

- Current Liabilities

$ 29,223,000

$ 22,138,000

Net Working Capital =

$ 1,411,000

$ (245,000)

Strength or Weakness

Working Capital measures the ability of a company to meet its short-term obligations with current assets. Coke is performing a little better since they have a positive net working capital contrasted with Pepsis negative working capital.

image text in transcribed

image text in transcribed

PART 4 VERTICAL ANALYSIS COKE Computations PEPSI Stengths and Weaknesses PART 4 CURRENT RATIO COKE Computations PEPSI Stengths and Weaknesses PART 4 Accounts Receivable Turnover COKE Computations PEPSI Stengths and Weaknesses 6 PART 4 7Average Collection Period COKE Computations PEPSI Stengths and Weaknesses 4 PART 4 5 Inventory Turnover COKE Computations PEPSI Stengths and Weaknesses 3 PART 4 Debt To Asset Ratio COKE Computa ations PEPSI Stengths and Weaknesses 0 PART 4 COKE Computations PEPS Return on Assets Ratio Stengths and Weaknesses 8 PART 4 Asset Turnover COKE Computations PEPSI Stengths and Weaknesses

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

Survey of Accounting

Authors: Carl S Warren

5th Edition

9780538489737, 538749091, 538489731, 978-0538749091

More Books

Students also viewed these Accounting questions