finance 2 homework

profilesadzizali
fina_3383-2.xlsx

Sheet1

Dow Jones Industrial Average
S.No# Company Name SYMBOL Closing Share Price
1 Procter and Gamble and Co. PG 86.56
2 Travelers Cos. Inc. TRV 116.95
3 VISA Inc. V 78.16
4 Coca Cola Co. KO 43.4
5 Exxon Mobil Co. XOM 85.74
6 Microsoft Corp. MSFT 56.44
7 3M Co. MMM 177.82
8 JPMorgan Chase and Co. JPM 63.64
9 General Electric and Co. GE 31.04
10 McDonald's Corp. MCD 117.55
11 International Business Machines Corp. IBM 160.89
12 Merck and Co. Inc. MRK 58.38
13 Johnson & Johnson JNJ 124.69
14 UnitedHealth Group Inc. UNH 142.65
15 Nike Inc. NKE 55
16 United Technologies Corp. UTX 106.02
17 Walt Disney Co. DIS 94.62
18 Chevron Corp. CVX 98.09
19 Caterpillar Inc. CAT 81.1
20 Cisco Systems Inc. CSCO 30.41
21 Verizon Communication Inc. VZ 53.9
22 Boeing Co. BA 131.6
23 Home Depot Inc. HD 137.04
24 American Express Co. AXP 63.23
25 Intel Corp. INTC 34.36
26 Goldman Sachs Group Inc. GS 155.82
27 Wal-Mart Stores Inc. WMT 72.73
28 E.I Dupont de Nemours and Co. DD 68.16
29 Apple Inc. AAPL 104.12
30 Pfizer Inc. PFE 36.23
DIJA Computation
The divisor is 0.14602128057775
DIJA = Summation P = Sum of all the Stock Prices/ Divisor
DIJA = 18,259.94
The date selected for the Compuutation is the August 02, 2016.
Comparison of the Computed DIJA with the Reported DIJA
Reported DIJA 18,264.39
Computed DIJA 18,259.94
Difference 4.45

Sheet2

Sheet3