Comparative financial ratio analysis? Reference financial statement information for Coca-Cola and PepsiCo through the following links: Coca-Cola: http://www.thecoca-colacompany.com/investors/annual_other_reports.html PepsiCo: http://phx.corporate-ir.net/phoenix.zhtml?c=78265&p=irol-reportsannual For 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 I. Financial Statement Computations A. Comparative financial ratio analysis 1. Current ratio 2. Acid-test ratio 3. Current cash debt coverage ratio 4. Receivable turnover 5. Inventory turnover 6. Asset turnover 7. Profit margin on sales 8. Rate of return on assets 9. Rate of return on common stock equity 10. Earnings per share 11. Price-earnings ratio 12. Dividend payout ratio 13. Debt to total assets 14. Times interest earned 15. Cash debt coverage ratio 16. Book value per share B. Common-size analysis (vertical percentage) financial statements Income statement and balance sheet only