Answered You can hire a professional tutor to get the answer.
quot;REQUIREMENTS Reference financial statement information for Coca-Cola and PepsiCo through the following links: Coca-Cola:...
"REQUIREMENTSReference financial statement information for Coca-Cola and PepsiCo through the following links:Coca-Cola: http://www.thecoca-colacompany.com/investors/annual_other_reports.htmlPepsiCo: http://phx.corporate-ir.net/phoenix.zhtml?c=78265&p=irol-reportsannualFor the years 2009 and 2010:• Construct common-size income statements and balance sheets for each company;• Compute financial ratios indicated below for each company;• Perform computations within the same EXCEL spreadsheet file (you may use separate tabs within the same workbook if you choose, but submit only one file).• Provide a written summary and conclusions about comparative financial performance or position.I. Financial Statement ComputationsA. Comparative financial ratio analysis -1. Current ratio2. Acid-test ratio3. Current cash debt coverage ratio4. Receivable turnover5. Inventory turnover6. Asset turnover7. Profit margin on sales8. Rate of return on assets9. Rate of return on common stock equity10. Earnings per share11. Price-earnings ratio12. Dividend payout ratio13. Debt to total assets14. Times interest earned15. Cash debt coverage ratio16. Book value per shareB. Common-size analysis (vertical percentage) financial statements -Income statement and balance sheet onlyII. Summary and ConclusionsBriefly evaluate the relative financial strengths and weaknesses of each company with respect to the ratio and commons-size analysis. Your summary should not exceed 2 pages
