Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Score: 0 The Blue Chips: The Dow Jones Industrial Average (DJIA) The Dow Jones is a list of 30 of the largest companies in the

image text in transcribedimage text in transcribed

Score: 0 The Blue Chips: The Dow Jones Industrial Average (DJIA) The Dow Jones is a list of 30 of the largest companies in the United States. Because of the sizes of the changes in these companies is so significant, they are reported on a daily basis, and used to judge the overall strength of the US economy. NUM-TICKER 1 MMM | 2 AXP 3 AAPL COMPANY 3M American Express Apple INDUSTRY Conglomerate Financial Services Information Technology START HERE There are 10 questions below the datatable. To assist in answering the questions, FILTER the data. If this has not already been done... Select the data from A13 to J43. Click on the menu item Data, at the top of the screen. Then click FILTER. Each column will have a down arrow, allowing you to select ONLY the data you are looking for. For example, if you want only those companies in the Financial Services industry, you can select that data item from the dropdown. OR, you could tiptoe using your fingers! See questions beneath the table. P/E RATIC 22 13 14 27 13 15 196 170 13 83 NUMTICKER 1 MMM 2 AXP 2 3 AAPL 4 BA 5 CAT 6 CVX 7 CSCO 8 KO 9 DIS 10 DWDP 11 XM 12 GS 13 HD 14 IBM 15 INTC 16 JNJ 17 JPM 18 MCD 19 MRK 20 MSFT 21 NKE 22 PFE 23 PG 24 TRV 25 UTX 26 UNH 27 VZ 19 COMPANY 3M American Express Apple Boeing Caterpillar Chevron Cisco Coca-Cola - Disney DowDupont Inc. Exxon Mobil Goldman Sachs Home Depot IBM Intel Johnson & Johnson JP Morgan Chase McDonald's Merck Microsoft Nike 15 8 INDUSTRY Conglomerate Financial Services Information Technology Aerospace & Defense Construction & Mining Equipment Oil & Gas & Information Technology Food Broadcasting & Entertainment Chemicals Oil & Gas & Financial Services Retail Information Technology Information Technology Pharmaceuticals Financial Services Food Pharmaceuticals Information Technology Apparel Pharmaceuticals Consumer Goods Insurance Conglomerate Health Care Telecommunications MILLIONS SALES $32,765 $36,986 $265,595 $94,005 $ $54,772 $ 158,902 $49,330 $35,410 $59,434 $62,484 $290,212 $35,942 $100,904 $79,591 $70,848 $81,581 $104,158 $22,820 $42,294 $110,360 $36,397 $53,647 $66,832 $30,282 $66,501 $226,247 $130,863 MILLIONS INCOME $5,363 $6,921 $59,531 $8,458 $6,147 $14,824 $110 $1,248 $12,598 $1,460 $20,840 $9,841 $8,630 $8,278 $21,053 $15,297 $32,474 $5,192 $6,220 $33,540 $1,933 $11,153 $9,750 $2,523 $5,269 $11,986 $15,528 10 201 MILLIONS SHARES 576.57 847 4720 565 590 1,910 450 4260 1490 2270 4240 381 1130 909 4500 2680 3320 771 2600 7670 1260 5780 2500 263.6 861.75 962.03 4130 17 EPS $9.30 $8.17 $12.61 $14.97 $10.42 $ 7.76 $0.24 $0.29 $8.46 $0.64 $4.92 $ $25.83 $7.64 $9.11 $4.68 $5.71 $9.78 $6.73 $2.39 $4.37 $1.53 $1.93 $3.90 $9.57 $6.11 $12.46 $3.76 Con SHARE PRICE $206.57 $107.00 $170.89 $410.72 $132.67 $118.72 $47.89 $49.66 $109.20 $53.36 $75.40 $194.49 $185.52 $136.05 $50.01 $134.16 $102.60 $173.97 $78.52 $106.89 $84.71 $41.87 $99.26 $127.26 $123.98 $263.50 $54.42 24 15 11 24 10 26 33 Pfizer Procter & Gamble Travelers Companies Inc. United Technologies United Health Verizon YA 24 55 22 25 13 20 21 14 Saco 141 10 861.75 20 21 14 25 UTX 26 UNH 27 VZ 28 V 29 WMT 30 WBA United Technologies United Health Verizon VISA Wal-Mart Walgreens Boots Alliance Conglomerate Health Care Telecommunications Financial Services Retail Retail $66,501 $226,247 $130,863 $20,609 $500,343 $131,587 $5,269 $11,986 $15,528 $10,301 $9,862 $5,024 $ 962.03 4130 1750 2910 943.44 $6.11 $12.46 $3.76 $5.89 $3.39 $5.33 $123.98 $263.50 $54.42 $141.99 $96.97 $1.56 24 29 0 0 Answers go In this column core 0 0 QUESTIONS 1 The Dow Jones list contains 4 companies in the financial services category. Which one of those had the highest sales level in 2018? Hint: Click on the down-arry symbol for Industry. : Click the Select All to turn it off. . Click on Financial Services and hit the OK button. Look at the data and choose the correct company. Click on the answer column to choose your answer. Each correct answer scores a l in the Score column. To return to the full list, click on the filter symbol , Y and choose Select All. 2 Which company in the Financial Services industry had the highest Earnings Per Share (EPS)? 3 Which company in the 30 had the highest share price? 4 Which company in the Dow Jones 30 had the highest level of revenue? & Sort & Filter 5 Which company in the Information Technology Industry had the highest Earnings Per Share (EPS)? | | | | | | 6 Which company in the Information Technology Industry had the highest share price? 7 Which of the two companies in the Oil and Gas Industry has the highest sales? 8 In the Pharmaceuticals Industry, which company has the highest Earnings Per Share (EPS)? 9 Which company in the list has the most shares outstanding? Hint: it is in the Information Technology Industry. 0 10 Which company has the highest Price to Earnings Ratio (PE or P/E), making it (theoretically) the most expensive stock

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta

11th Canadian Edition

1259024970, 978-1259265921

More Books

Students also viewed these Finance questions