Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Company Compensation ($millions) Return in 2012 (%) Berkshire Hathaway 15.4 -36 Whole Foods Market 7.2 -35 Cincinnati Financial 5.3 -29 M&T Bank 6.6 -28 Kimco
Company Compensation ($millions) Return in 2012 (%) Berkshire Hathaway 15.4 -36 Whole Foods Market 7.2 -35 Cincinnati Financial 5.3 -29 M&T Bank 6.6 -28 Kimco Realty 9 -25 People's United Financial 8.4 -20 Fastenal 9.5 -19 O'Reilly Automotive 20.5 -16 TECO Energy 6.9 -15 AGL Resources 9.7 -12 MeadWestvaco 9.2 -11 Sigma-Aldrich 4.7 -10 FLIR Systems 8.1 -10 Apartment Investment and Management 10 -10 Genuine Parts 8.6 -9 C.H. Robinson Worldwide 4.2 -8 Intuitive Surgical 6 -8 Total System Services 5 -7 Helmerich & Payne 7 -7 F5 Networks 10 -6 Newfield Exploration 10 -6 CenterPoint Energy 5.3 -4 Ryder System 5.5 -4 Gannett 16 -4 Kellogg 8.4 -3 Bemis 13.4 -3 First Horizon National 5.8 -2 Ameren 10.1 -2 Eastman Chemical 3.7 -1 International Game Technology 4.3 -1 McCormick & Company 11.5 0 PNC Financial Services Group 8.3 1 Carnival 8.2 2 Weyerhaeuser 11.7 2 Joy Global 12.7 2 St. Jude Medical 7.1 3 Huntington Bancshares 7.4 3 Sempra Energy 15 3 Moody's 6.3 4 Baker Hughes 10.7 4 Spectra Energy 12 4 MetroPCS Communications 7.1 5 American Electric Power 20.4 5 AmerisourceBergen 21.1 5 PACCAR 5 6 Allegheny Technologies 8.7 6 Comerica 12.6 6 Northern Trust 15.4 6 Rowan 4.9 7 NRG Energy 13 7 FMC 18 7 DTE Energy 21.6 7 Avery Dennison 6.7 8 Cabot Oil & Gas 13.2 8 Snap-on 3.8 9 Beam 8.7 9 C.R. Bard 8.7 9 Tenet Healthcare 9.1 9 Dominion Resources 13.1 9 International Flavors & Fragrances 4.5 10 Duke Energy 8.5 10 Humana 9.7 10 Public Service Enterprise Group 12.7 10 T. Rowe Price Group 11.6 11 W.W. Grainger 3.8 12 Hershey 5 12 United States Steel 10.7 12 BB&T 11.8 12 SunTrust Banks 13.8 13 Reynolds American 5.7 14 Edison International 11.8 14 EQT 5.7 15 Ecolab 7 15 Fifth Third Bancorp 7.8 15 Newmont Mining 9.5 15 Wisconsin Energy 11.6 15 McGraw-Hill 17.1 15 Ball 21.8 15 Applied Materials 8.4 17 Fluor 16.6 17 XL Group 17.9 17 Peabody Energy 21 17 Noble 5.1 18 Norfolk Southern 9.3 18 Progressive 11.3 18 TE Connectivity 4.6 19 PerkinElmer 6.3 19 Discover Financial Services 6.7 19 AES 8.5 19 CareFusion 8.6 19 Hess 10.6 19 Agilent Technologies 23.8 19 VF 25 19 U.S. Bancorp 7.2 20 Coca-Cola Enterprises 16.3 20 Motorola Solutions 18.5 20 Life Technologies 8 21 Harley-Davidson 10.1 21 Teradata 10.2 21 Covidien 20.5 21 Kimberly-Clark 4.7 22 United Parcel Service 8.9 22 Stanley Black & Decker 10.3 22 Sherwin-Williams 28 22 Tesoro 7.1 23 L-3 Communications Holdings 3.3 24 Textron 5.7 24 Corning 8.8 24 Chubb 9.1 24 Dover 9.8 24 Alcoa 9.1 25 Equifax 12 25 BorgWarner 7.9 26 HCP 10.2 26 Praxair 10.3 26 NYSE Euronext 12 26 Adobe Systems 12.3 26 Delphi Automotive 0.5 27 Aflac 7.6 27 Franklin Resources 10.3 27 Apple 12.8 27 Marathon Petroleum 19.3 27 Valero Energy 10.3 28 PepsiCo 18.5 28 E.I. du Pont de Nemours 3 29 Analog Devices 6.7 29 Cigna 7.2 29 Bank of New York Mellon 8.2 29 Whirlpool 9.4 29 Marathon Oil 16.1 29 Lennar 20.7 30 Texas Instruments 7.9 31 MetLife 12.3 32 Goodyear Tire & Rubber 12.8 32 PPG Industries 25 32 Verizon Communications 2.1 34 Pentair 6.1 35 Schlumberger 11.3 35 Gilead Sciences 7.6 37 Hewlett-Packard 10.3 37 IBM 22.6 37 Bristol-Myers Squibb 16 38 Baxter International 23.9 39 Ameriprise Financial 5.5 41 Honeywell International 35 41 EMC 11.7 42 Deere 5.2 47 DirecTV 38.9 48 General Dynamics 45 48 Pfizer 1.3 50 Eaton 14.7 50 Wells Fargo 6.8 51 Allergan 6.4 52 Occidental Petroleum 8.1 58 General Electric 7.9 59 Qualcomm 9.8 60 AT&T 8.6 61 Boeing 12.5 65 Coca-Cola 13.5 65 United Technologies 12.4 73 Capital One Financial 39 73 Lockheed Martin 11 74 Tyco International 9.9 76 Abbott Laboratories 12.3 76 Prologis 5.9 77 American Express 12.2 78 Viacom 15.3 79 Starbucks 11.2 90 Walt Disney 12.9 95 eBay 13 100
Company | Compensation ($millions) | Return in 2012 (%) |
Berkshire Hathaway | 15.4 | -36 |
Whole Foods Market | 7.2 | -35 |
Cincinnati Financial | 5.3 | -29 |
M&T Bank | 6.6 | -28 |
Kimco Realty | 9 | -25 |
People's United Financial | 8.4 | -20 |
Fastenal | 9.5 | -19 |
O'Reilly Automotive | 20.5 | -16 |
TECO Energy | 6.9 | -15 |
AGL Resources | 9.7 | -12 |
MeadWestvaco | 9.2 | -11 |
Sigma-Aldrich | 4.7 | -10 |
FLIR Systems | 8.1 | -10 |
Apartment Investment and Management | 10 | -10 |
Genuine Parts | 8.6 | -9 |
C.H. Robinson Worldwide | 4.2 | -8 |
Intuitive Surgical | 6 | -8 |
Total System Services | 5 | -7 |
Helmerich & Payne | 7 | -7 |
F5 Networks | 10 | -6 |
Newfield Exploration | 10 | -6 |
CenterPoint Energy | 5.3 | -4 |
Ryder System | 5.5 | -4 |
Gannett | 16 | -4 |
Kellogg | 8.4 | -3 |
Bemis | 13.4 | -3 |
First Horizon National | 5.8 | -2 |
Ameren | 10.1 | -2 |
Eastman Chemical | 3.7 | -1 |
International Game Technology | 4.3 | -1 |
McCormick & Company | 11.5 | 0 |
PNC Financial Services Group | 8.3 | 1 |
Carnival | 8.2 | 2 |
Weyerhaeuser | 11.7 | 2 |
Joy Global | 12.7 | 2 |
St. Jude Medical | 7.1 | 3 |
Huntington Bancshares | 7.4 | 3 |
Sempra Energy | 15 | 3 |
Moody's | 6.3 | 4 |
Baker Hughes | 10.7 | 4 |
Spectra Energy | 12 | 4 |
MetroPCS Communications | 7.1 | 5 |
American Electric Power | 20.4 | 5 |
AmerisourceBergen | 21.1 | 5 |
PACCAR | 5 | 6 |
Allegheny Technologies | 8.7 | 6 |
Comerica | 12.6 | 6 |
Northern Trust | 15.4 | 6 |
Rowan | 4.9 | 7 |
NRG Energy | 13 | 7 |
FMC | 18 | 7 |
DTE Energy | 21.6 | 7 |
Avery Dennison | 6.7 | 8 |
Cabot Oil & Gas | 13.2 | 8 |
Snap-on | 3.8 | 9 |
Beam | 8.7 | 9 |
C.R. Bard | 8.7 | 9 |
Tenet Healthcare | 9.1 | 9 |
Dominion Resources | 13.1 | 9 |
International Flavors & Fragrances | 4.5 | 10 |
Duke Energy | 8.5 | 10 |
Humana | 9.7 | 10 |
Public Service Enterprise Group | 12.7 | 10 |
T. Rowe Price Group | 11.6 | 11 |
W.W. Grainger | 3.8 | 12 |
Hershey | 5 | 12 |
United States Steel | 10.7 | 12 |
BB&T | 11.8 | 12 |
SunTrust Banks | 13.8 | 13 |
Reynolds American | 5.7 | 14 |
Edison International | 11.8 | 14 |
EQT | 5.7 | 15 |
Ecolab | 7 | 15 |
Fifth Third Bancorp | 7.8 | 15 |
Newmont Mining | 9.5 | 15 |
Wisconsin Energy | 11.6 | 15 |
McGraw-Hill | 17.1 | 15 |
Ball | 21.8 | 15 |
Applied Materials | 8.4 | 17 |
Fluor | 16.6 | 17 |
XL Group | 17.9 | 17 |
Peabody Energy | 21 | 17 |
Noble | 5.1 | 18 |
Norfolk Southern | 9.3 | 18 |
Progressive | 11.3 | 18 |
TE Connectivity | 4.6 | 19 |
PerkinElmer | 6.3 | 19 |
Discover Financial Services | 6.7 | 19 |
AES | 8.5 | 19 |
CareFusion | 8.6 | 19 |
Hess | 10.6 | 19 |
Agilent Technologies | 23.8 | 19 |
VF | 25 | 19 |
U.S. Bancorp | 7.2 | 20 |
Coca-Cola Enterprises | 16.3 | 20 |
Motorola Solutions | 18.5 | 20 |
Life Technologies | 8 | 21 |
Harley-Davidson | 10.1 | 21 |
Teradata | 10.2 | 21 |
Covidien | 20.5 | 21 |
Kimberly-Clark | 4.7 | 22 |
United Parcel Service | 8.9 | 22 |
Stanley Black & Decker | 10.3 | 22 |
Sherwin-Williams | 28 | 22 |
Tesoro | 7.1 | 23 |
L-3 Communications Holdings | 3.3 | 24 |
Textron | 5.7 | 24 |
Corning | 8.8 | 24 |
Chubb | 9.1 | 24 |
Dover | 9.8 | 24 |
Alcoa | 9.1 | 25 |
Equifax | 12 | 25 |
BorgWarner | 7.9 | 26 |
HCP | 10.2 | 26 |
Praxair | 10.3 | 26 |
NYSE Euronext | 12 | 26 |
Adobe Systems | 12.3 | 26 |
Delphi Automotive | 0.5 | 27 |
Aflac | 7.6 | 27 |
Franklin Resources | 10.3 | 27 |
Apple | 12.8 | 27 |
Marathon Petroleum | 19.3 | 27 |
Valero Energy | 10.3 | 28 |
PepsiCo | 18.5 | 28 |
E.I. du Pont de Nemours | 3 | 29 |
Analog Devices | 6.7 | 29 |
Cigna | 7.2 | 29 |
Bank of New York Mellon | 8.2 | 29 |
Whirlpool | 9.4 | 29 |
Marathon Oil | 16.1 | 29 |
Lennar | 20.7 | 30 |
Texas Instruments | 7.9 | 31 |
MetLife | 12.3 | 32 |
Goodyear Tire & Rubber | 12.8 | 32 |
PPG Industries | 25 | 32 |
Verizon Communications | 2.1 | 34 |
Pentair | 6.1 | 35 |
Schlumberger | 11.3 | 35 |
Gilead Sciences | 7.6 | 37 |
Hewlett-Packard | 10.3 | 37 |
IBM | 22.6 | 37 |
Bristol-Myers Squibb | 16 | 38 |
Baxter International | 23.9 | 39 |
Ameriprise Financial | 5.5 | 41 |
Honeywell International | 35 | 41 |
EMC | 11.7 | 42 |
Deere | 5.2 | 47 |
DirecTV | 38.9 | 48 |
General Dynamics | 45 | 48 |
Pfizer | 1.3 | 50 |
Eaton | 14.7 | 50 |
Wells Fargo | 6.8 | 51 |
Allergan | 6.4 | 52 |
Occidental Petroleum | 8.1 | 58 |
General Electric | 7.9 | 59 |
Qualcomm | 9.8 | 60 |
AT&T | 8.6 | 61 |
Boeing | 12.5 | 65 |
Coca-Cola | 13.5 | 65 |
United Technologies | 12.4 | 73 |
Capital One Financial | 39 | 73 |
Lockheed Martin | 11 | 74 |
Tyco International | 9.9 | 76 |
Abbott Laboratories | 12.3 | 76 |
Prologis | 5.9 | 77 |
American Express | 12.2 | 78 |
Viacom | 15.3 | 79 |
Starbucks | 11.2 | 90 |
Walt Disney | 12.9 | 95 |
eBay | 13 | 100 |
Sort the data set based on Compensation and return separately (2 sorts) and identify top 5 corporations with highest return and highest compensations.
Show step by step how to solve and input on excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started