1.Use an electronic spreadsheet to calculate the following measures for each of Coca-Cola's operating segments (excluding Bottling Investments and Corporate):

Percentage of total net revenues, 2009 and 2010.

Percentage change in total net revenues, 2008 to 2009 and 2009 to 2010.

Operating income as a percentage of total net revenues (profit margin), 2009 and 2010.

2. Determine whether you believe Coca-Cola should attempt to expand its operations in a particular region of the world to increase operating revenues and operating income.

3. List any additional information you would like to have to conduct your analysis

Information about our Company's operations by operating segment for the years ended December 31, 2011, 2010, and 2009, is as follows Gn milions) & Africa Europe Amerka America Pacific Investments Corporate Elminations Corsolidated Net operating revenues Third party Thied party... $2689 s4777 s4403 $20,559 ss,454 501 $159 $ - 1,622 8415,4744,69020,571 5,838 1,0913,0902,8152,318 2,151 Total net reveies... Interest income.. Interest expense Depreciation and amortization 1,089 3,134 2832 2.325 2,154 home Oss) before income taxes dentifiable operating assets ....245 3204 2,44633,422 2,085 Captal expenditures. ' Net operating revenues: 2,426$4424$3,880 $11,140 $4,941 $8,216 92 35,119 Intersegment. Total net revenues 2,556 5,249 412111,2055,27 980 2976 2,405 520 2.048 Interest income.... Depreciation and amonization Equity income loss) net Income Goss) before income taxes... 1,5232,049 4243 65,336 1,000 3,020 2,426 Investments...w. Capital expenditures... Net operating revenues Third paty $1,977 308 $3.700 $8,191 $4533 sa 193 $ 88 $ 1,846 2,1975,2033,8828,271 4875 1,699 1,887 Total net reven 810 2,9462,042 8231 Deprecation and amortization. . Income Os) before income taes identifiable operating assets .... 810 2,97620390 1,866 1553,0472410941 1,929 Capital expenditures