Index Numbers

$$ Please submit your work in an excel document through the Blackboard link. Make sure to show ALL your work in the process of completing the assignment.

$$ The required a template that can be found under course documents.

$$ Written portion can be included in a textbox in excel.

$1.$ In$-$class last week we introduced how the S&P $500$ and the Dow Jones Industrial Average Indices were calculated. I would like you to do the same to start this assignment, but instead of using $5$ companies. We are going to use all $30$ from the Dow Jones $($use the same $30$ for the S&P Calculation. Calculate index value for each index using their respective methods.

$2.$ What is the NASDAQ exchange? Explain how it is calculated and calculate the index value using the $30$ companies above. Do this on a separate spreadsheet on your document $$ you can copy the template from the first question. $($If a divisor is needed, use $0\mathrm{.}08)$

$3.$ What are each of the three indexes called in regard to their statistical terminology? Which do you believe is the fairest representation of the underlying stocks?

$4.$ Lookup the value of the Dow Jones Industrial Average for today, are they the same value? What is the value of the real DJIA Index.

S&P $500$

Formula $=($sum of current market value $/$ sum of base market value$)*10$

Company Ticker Base Price Current Price Outstanding Shares Market Value Base Market Value Current

American Express AXP $97\mathrm{.}66162\mathrm{.}76$

Amgen AMGN $139\mathrm{.}86233\mathrm{.}1$

Apple AAPL $95\mathrm{.}36158\mathrm{.}93$

Boeing BA $118\mathrm{.}74197\mathrm{.}9$

Caterpillar CAT $131\mathrm{.}66219\mathrm{.}44$

Cisco CSCO $29\mathrm{.}8449\mathrm{.}73$

Chevron CVX $92\mathrm{.}71154\mathrm{.}52$

Goldman Sachs GS $188\mathrm{.}91314\mathrm{.}85$

Home Depot HD $170\mathrm{.}35283\mathrm{.}91$

Honeywell Int. HON $112\mathrm{.}15186\mathrm{.}92$

International Machine IBM $74\mathrm{.}02123\mathrm{.}37$

Intel INTC $17\mathrm{.}4229\mathrm{.}03$

Johnson & Johnson JNJ $90\mathrm{.}68151\mathrm{.}13$

Coca Cola KO $35\mathrm{.}9559\mathrm{.}92$

JP Morgan JPM $76\mathrm{.}10126\mathrm{.}84$

McDonalds MCD $161\mathrm{.}77269\mathrm{.}62$

$3$M Corp MMM $60\mathrm{.}60101$

Merck & CO MRK $62\mathrm{.}54104\mathrm{.}23$

Microsoft MSFT $166\mathrm{.}60277\mathrm{.}66$

Nike NKE $72\mathrm{.}58120\mathrm{.}97$

Procter and Gamble PG $86\mathrm{.}27143\mathrm{.}79$

Travelers TRV $98\mathrm{.}32163\mathrm{.}86$

United Health UNH $281\mathrm{.}95469\mathrm{.}91$

Salesforce CRM $112\mathrm{.}46187\mathrm{.}44$

Verizon VZ $22\mathrm{.}4237\mathrm{.}37$

Visa V $133\mathrm{.}55222\mathrm{.}59$

Walgreens WBA $19\mathrm{.}4032\mathrm{.}33$

Walmart WMT $84\mathrm{.}39140\mathrm{.}65$

Walt Disney DIS $57\mathrm{.}5095\mathrm{.}83$

Dow Inc. DOW $30\mathrm{.}9951\mathrm{.}65$