This paper concentrates on the primary theme of Single Spreadsheet Entries Analyzed in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 79. For more details and full access to the paper, please refer to the site.
Single Spreadsheet Entries Analyzed
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.