On a spreadsheet enter the income statement data and the balance sheet data for Pepsi and Coca-Cola for the past three years (2007 through 2009). Ignore Minority Interest for this exercise. Compare the two companies using common size statements for each of the three years. Assume the total current assets are correct. Then calculate the financial ratios for Pepsi and Coca-Cola for the years 2007 through 2009 and complete the key ratios for the next three years, 2007 through 2009. For Coca-Cola use 2,310,000 common shares outstanding for all three years. For Pepsi use 1,610,000 common shares outstanding for all three years. Which ratios have changed the most over the years? For the Income Statement and Balance Sheet, use