In: Accounting
The following excerpt is from Coca-Cola Company’s 2014 annual
report filed with the SEC:
Management evaluates the performance of our operating segments
separately to individually monitor the different factors affecting
financial performance. Our Company manages income taxes and certain
treasury-related items, such as interest income and expense, on a
global basis within the Corporate operating segment. We evaluate
segment performance based on income or loss before income
taxes.
Below are selected segment data for Coca-Cola Company for the 2014
and 2013 fiscal years. Dollar amounts are in millions.
Eurasia | Latin | North | |||||||||||||||||||
& Africa | Europe | America | America | Pacific | |||||||||||||||||
2014 Fiscal Year | |||||||||||||||||||||
Net operating revenues | $ | 2,730 | $ | 5,536 | $ | 4,657 | $ | 21,479 | $ | 5,746 | |||||||||||
Income before taxes | 1,084 | 2,852 | 2,316 | 2,447 | 2,448 | ||||||||||||||||
Identifiable operating assets | 1,298 | 3,358 | 2,426 | 33,066 | 1,793 | ||||||||||||||||
2013 Fiscal Year | |||||||||||||||||||||
Net operating revenues | 2,763 | 5,334 | 4,939 | 21,590 | 5,869 | ||||||||||||||||
Income before taxes | 1,087 | 2,859 | 2,908 | 2,432 | 2,478 | ||||||||||||||||
Identifiable operating assets | 1,273 | 3,731 | 2,918 | 33,964 | 1,922 | ||||||||||||||||
Required
a. Compute the ROI for each of Coke’s geographical segments for each fiscal year. Which segment appears to have the best performance during 2014 based their ROIs?
b. Assuming Coke’s management expects a minimum return of 30 percent, calculate the residual income for each segment for each fiscal year. Which segment appears to have the best performance based on residual income from 2013 to 2014? (Enter your answers in millions. Negative amounts should be indicated by minus sign. Round your percentage answers to 1 decimal place and other answers to nearest dollar amount.)
a). ROI is Return on Investment is the ration of wealth
generated to the amount invested to generate the wealth.
ROI = Operating Income / Operating Assets
EURASIA AND AFRICA (in millions)
2014 = ROI = 1084/1298 = 0.835 or 83.51%
2013 = ROI = 1087/1273 = 0.8538 or 85.38%
EUROPE
2014 = ROI = 2852/3358 = 0.8493 or 84.93%
2013 = ROI = 2859/3731 = 0.7662 or 76.62%
LATIN AMERICA
2014 = ROI = 2316/2426 = 0.9546 or 95.46%
2013 = ROI = 2908/2918 = 0.9965 or 99.65%
NORTH AMERICA
2014 = ROI = 2447/33066 = 0.074 or 7.40%
2013 = ROI = 2432/33964 = 0.0716 or 7.16%
PACIFIC
2014 = ROI = 2448/1793 = 1.365 or 136.53%
2013 = ROI = 2478/1922 = 1.289 or 128.92%