• Using the website recommended in the explanatory video, find the closing prices for the last twenty (20) trading sessions for the following stocks:
  1. APPLE - (APPL)
  2. McDonalds Corporation - (MCD)
  3. Walmart- (WMT)
  4. The Coca Cola Company (KO)
  5. Goldman Sachs - (GS)
  6. Merck & Company- (MRK)
• Search for closing prices for the last twenty (20) trading sessions for the Dow Jones Industrials Index (DJI).
• Within the "Beta Calculator" spreadsheet located in Blackboard do the following:
• 1. Perform Copy/Paste from each of the 20 sessions of the activity for each of the six (6) actions.
  2. Make Copy/Paste from each of the 20 Dow Jones Industrials (DJI) sessions.
  3. The Beta factor will be calculated automatically. Perform the same exercise for the five (5) actions presented.
  4. The data presented in the Excel sheet will feed a graph that will serve as a tool for data analysis.
  5. Interpret what the beta of each action tells us.

Transcribed Image Text:

Chrome File Edit View History Bookmarks Profiles Tab Window Help in | agmu.instructure.com/courses/26558/assignments/540826 C Sun Mar 17 4:39 PM + New Chrome available : T Beta Calcuator.xlsx INA706 2024SPR-72.. Tareas Mdulo 2: Asignacin: :: Departamento d... Xerx ASC Website ASC | V 2.... Gmail YouTube Maps Microsoft Office H... Inter * La filiacin y la pat... | All Bookmarks Descargar Informacin Cerrar ctor in Page < 1 > of 6 ZOOM + If APPL DJIA Fecha Closing Change 3/5/2024 171.36 3/14/2024 173 3/13/2024 171.13 3/12/2024 173.23 3/11/2024 172.75 3/8/2024 170.73 3/7/2024 169 3/6/2024 169.12 3/5/2024 170.12 3/4/2024 175.1 3/1/2024 179.66 2/29/2024 180.75 2/28/2024 181.42 2/27/2024 182.63 2/26/2024 181.16 2/23/2024 182.52 2/22/2024 184.37 2/21/2024 182.32 2/20/2024 181.56 2/16/2024 182.31 Closing Change APPL vs DJI Beta 0 38,766.58 0 0.96% 38,905.66 0.36% -1.08% 39,043.32 0.35% 1.23% 39,005.49 -0.10% -0.28% 38,769.66 -0.60% -1.17% 38,722.69 -0.12% -1.01% 38,791.35 0.18% 0.07% 38,661.05 -0.34% 0.59% 38,585.19 -0.20% 2.93% 38,989.83 2.60% 39,087.38 0.61% 38,996.39 0.37% 38,949.02 0.67% 38,972.41 -0.80% 39,069.23 0.25% 0.75% 39,131.53 0.16% 1.01% 39,069.11 -0.16% -1.11% 38,612.24 -1.17% -0.42% 38,563.80 -0.13% 0.41% 38,627.99 0.17% 1.3132 APPL vs DJIA (Beta) 0.035 0.03 0.025 0.02 0.015 1.05% 0.01 0.25% 0.005 -0.23% -0.12% 0 -0.005 2 A 4 6 7 8 9 10 11 12 13 14 15 16 17 18 20 0.06% -0.01 -0.015 -Change Change 294 MAR 17 tv A W HEIC Chrome File Edit View History Bookmarks Profiles Tab Window Help in | agmu.instructure.com/courses/26558/assignments/540826 C Sun Mar 17 4:39 PM + New Chrome available : T Beta Calcuator.xlsx INA706 2024SPR-72.. Tareas Mdulo 2: Asignacin: :: Departamento d... Xerx ASC Website ASC | V 2.... Gmail YouTube Maps Microsoft Office H... Inter * La filiacin y la pat... | All Bookmarks Descargar Informacin Cerrar ctor in Page < 1 > of 6 ZOOM + If APPL DJIA Fecha Closing Change 3/5/2024 171.36 3/14/2024 173 3/13/2024 171.13 3/12/2024 173.23 3/11/2024 172.75 3/8/2024 170.73 3/7/2024 169 3/6/2024 169.12 3/5/2024 170.12 3/4/2024 175.1 3/1/2024 179.66 2/29/2024 180.75 2/28/2024 181.42 2/27/2024 182.63 2/26/2024 181.16 2/23/2024 182.52 2/22/2024 184.37 2/21/2024 182.32 2/20/2024 181.56 2/16/2024 182.31 Closing Change APPL vs DJI Beta 0 38,766.58 0 0.96% 38,905.66 0.36% -1.08% 39,043.32 0.35% 1.23% 39,005.49 -0.10% -0.28% 38,769.66 -0.60% -1.17% 38,722.69 -0.12% -1.01% 38,791.35 0.18% 0.07% 38,661.05 -0.34% 0.59% 38,585.19 -0.20% 2.93% 38,989.83 2.60% 39,087.38 0.61% 38,996.39 0.37% 38,949.02 0.67% 38,972.41 -0.80% 39,069.23 0.25% 0.75% 39,131.53 0.16% 1.01% 39,069.11 -0.16% -1.11% 38,612.24 -1.17% -0.42% 38,563.80 -0.13% 0.41% 38,627.99 0.17% 1.3132 APPL vs DJIA (Beta) 0.035 0.03 0.025 0.02 0.015 1.05% 0.01 0.25% 0.005 -0.23% -0.12% 0 -0.005 2 A 4 6 7 8 9 10 11 12 13 14 15 16 17 18 20 0.06% -0.01 -0.015 -Change Change 294 MAR 17 tv A W HEIC