The questions are at the beginning of the pdf file. The financial statements for Pepsi are followed after the questions and the Coke finances start on page 27. You can use excel if that makes it easier. I do need the work shown like in the example. Thank-you in advance.

PepsiCo's financial statements are presented in Appendix A. Financial statements of The Coca-Cola Company are presented in Appendix B. Instructions; (a) Based on the information contained in these financial statements, determine each of the following For each company. Show all numerical equations including numerator and denominator, not just a Final number. Present your work in a comparative format using a table as illustrated below (show The work within the table). Leave the numbers rounded as they appear in the financials, and round Results to one decimal place when necessary: Use Ratio Analysis to answer the following questions Below. Use as example: Financial Measure Profit Margin Pepsi Co. xxxx/xxxx = xx% Coca-Cola xxxx/xxxx = xx% Net income/Net Sales 1) Current ratio at the end of 2008. 2) Acid-Test Ratio at the end of 2008. 3) Accounts receivable turnover for 2008. 4) Average Collection Period (aka days sales in receivable) for 2008. 5) Inventory turnover for 2008. 6) Days inventory on hand for 2008. 7) Profit margin expressed as a % of net sales for 2008. 8) Asset turnover ratio at the end of 2008. 9) Return on assets for 2008. 10) Return on common stockholders' equity at the end of 2008. 11) Using information from your analysis (state which parts of the analysis are being used), would you recommend purchasing the stock of PepsiCo or Coca-Cola? FINANCIAL STATEMENTS AND ACCOMPANYING NOTES The standard set of financial statements consists of: (1) a comparative income statement for three years, (2) a comparative statement of cash flows for three years, (3) a comparative balance sheet for two years, (4) a statement of stockholders' equity for three years, and (5) a set of accompanying notes that are considered an integral part of the financial statements. The auditor's report, unless stated otherwise, covers the financial statements and the accompanying notes. PepsiCo's financial statements and accompanying notes plus supplementary data and analyses follow. B Specimen Financial Statements: The Coca-Cola Company