Single Spreadsheet Entries Analyzed
Not what you're looking for?
NOTE: In your explanation, show that you understand the major concepts.
1. Using ratio analysis, compare two major competitors selling soft drinks: the Coca Cola Co. and Pepsico, Inc. Create a single spreadsheet with appropriate entries for all questions. There are 3 separate financial statements to analyze:
a. the income statement,
b. the balance sheet, and
c. the cash flow statement.
To answer these questions you may obtain information from the web directly from:
• the companies using their annual report;
• from financial information from Yahoo, MSN or other service; or
• from the Securities and Exchange Commission at their EDGAR web site, www.sec.gov.
2. Look for the 10-K, annual reports or link to the SEC documents from one of the financial sites. Calculate these ratios for the last 3 fiscal years.
Note: Whenever you use balance sheet items to calculate ratios, be sure to average the beginning-of-year and end-of-year amounts.
3. What can you tell from your analysis? What are the strengths and weaknesses of each company? If you had $10,000 to invest, would you rather purchase the common stock of the Coca Cola Co. or Pepsico, Inc.? Give your reasons.
Purchase this Solution
Solution Summary
The expert examines single spreadsheet entries.
Solution Preview
I'm a little confused on what you are asking for.
<br>
<br>I believe your attachment2 gives a detailed explanation of financial ratios and how to calculate them with valid examples. I don't see anything that needs to be done with attachment2.
<br>
<br>Also on attachment1 - I don't see what questions you are trying to answer unless they are the questions ...
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.