Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PRICE DATA: 10 STOCKS AND SP500, 2015-2020 SP500 represented by Vanguard's Index 500 fund (includes dividends) 1 2 4 5 3 6 Apple Google
PRICE DATA: 10 STOCKS AND SP500, 2015-2020 SP500 represented by Vanguard's Index 500 fund (includes dividends) 1 2 4 5 3 6 Apple Google Amazon Seagate Comcast 7 8 Johnson- General Merck Johnson Electric 9 Hewlett Packard 10 Goldman Sachs 11 SP500 Date 1-Jan-20 AAPL GOOG AMZN 308.78 1,434.23 2,008.72 1-Dec-19 292.95 1,337.02 1,847.84 STX CMCSA MRK JNJ GE HPQ GS GSPC 56.08 42.99 84.74 147.93 12.44 21.12 236.31 3,225.52 57.92 44.76 89.59 144.95 11.14 20.18 228.53 3,230.78 1-Nov-19 265.82 1-Oct-19 247.43 1,260.11 1,776.66 1,304.96 1,800.80 58.10 43.94 85.88 135.68 11.25 19.72 218.77 3,140.98 56.49 44.40 85.36 130.30 9.96 17.06 210.89 3,037.56 1-Sep-19 222.77 1,219.00 1,735.91 51.74 44.66 82.37 127.68 8.91 18.43 204.82 2,976.74 1-Aug-19 206.84 1,188.10 1,776.29 48.29 43.85 84.62 125.73 8.23 17.81 200.28 2,926.46 1-Jul-19 211.10 1,216.68 1,866.78 44.54 42.56 81.21 127.55 10.42 20.49 216.21 2,980.38 1-Jun-19 196.12 1,080.91 1,893.63 44.68 41.68 81.51 136.42 10.46 20.08 193.50 2,941.76 1-May-19 1-Apr-19 198.08 1,188.48 1-Mar-19 187.50 1,173.31 172.81 1,103.63 1,775.07 39.68 40.42 77.00 127.59 9.40 18.05 178.43 2,752.06 1,926.52 45.82 42.69 76.51 137.36 10.13 19.27 201.34 2,945.83 1,780.75 44.81 39.21 80.30 135.99 9.94 18.61 187.72 2,834.40 1-Feb-19 170.18 1,119.92 1,639.83 43.57 37.92 78.49 132.05 10.34 18.90 191.56 2,784.49 1-Jan-19 163.59 1,116.37 1,718.73 41.44 35.86 71.86 128.61 9.72 21.10 192.83 2,704.10 1-Dec-18 155.04 1,035.61 1,501.97 35.50 33.21 73.26 124.72 7.23 19.46 162.68 2,506.85 1-Nov-18 174.91 1,094.43 1,690.17 39.64 38.04 76.07 141.07 7.17 21.88 184.95 2,760.17 1-Oct-18 214.36 1,076.77 1,598.01 37.01 37.00 70.58 134.43 9.65 22.96 218.59 2,711.74 1-Sep-18 221.10 1,193.47 2,003.00 42.99 34.35 67.56 132.69 10.68 24.37 217.49 2,913.98 1-Aug-18 222.17 1,218.19 2,012.71 48.61 35.88 65.32 128.49 12.24 23.31 229.90 2,901.52 1-Jul-18 185.73 1,217.26 1,777.44 47.78 34.51 62.73 126.42 12.89 21.83 229.53 2,816.29 1-Jun-18 180.67 1,115.65 1,699.80 50.72 31.64 57.36 115.75 12.76 21.33 213.23 2,718.37 1-May-18 181.69 1,084.99 1,629.62 50.62 30.07 56.25 113.27 13.20 20.71 217.59 2,705.27 1-Apr-18 160.68 1,017.33 1,566.13 52.00 30.10 55.63 119.78 13.19 20.21 229.59 2,648.05 1-Mar-18 163.13 1,031.79 1,447.34 52.02 32.77 51.03 121.35 12.64 20.49 242.62 2,640.87 1-Feb-18 172.48 1,104.73 1,512.45 47.47 34.72 50.79 122.20 13.11 21.86 252.57 2,713.83 1-Jan-18 162.13 1,169.94 1,450.89 49.07 40.62 55.50 130.02 15.03 21.80 257.34 2,823.81 1-Dec-17 163.87 1,046.40 1,169.47 36.65 38.25 52.27 131.46 15.99 19.51 244.73 2,673.61 1-Nov-17 165.81 1,021.41 1,176.75 34.26 35.86 51.34 130.30 16.76 19.92 237.14 2,584.84 1-Oct-17 163.10 1,016.64 1,105.28 32.38 34.27 51.17 130.37 18.47 20.01 232.20 2,575.26 1-Sep-17 148.70 959.11 961.35 28.51 36.60 59.05 121.58 21.93 18.41 227.13 2,519.36 1-Aug-17 1-Jul-17 1-Jun-17 1-May-17 146.21 157.62 142.94 138.42 908.73 939.33 980.60 27.10 38.63 58.89 123.01 22.26 17.60 213.53 2,471.65 930.50 987.78 28.33 38.47 58.91 123.33 23.22 17.62 215.04 2,470.30 968.00 32.80 36.87 58.67 122.93 24.07 16.00 211.77 2,423.41 964.86 994.62 36.88 39.49 59.61 118.39 24.40 17.17 200.94 2,411.80 1-Apr-17 137.49 905.96 924.99 35.66 36.97 57.06 113.98 25.83 17.23 212.87 2,384.20 1-Mar-17 137.50 829.56 886.54 38.36 35.46 57.75 114.98 26.56 16.24 218.50 2,362.72 1-Feb-17 130.55 823.21 845.04 40.24 35.30 59.87 112.08 26.35 15.78 235.33 2,363.64 1-Jan-17 115.65 796.79 823.48 37.71 35.57 56.34 103.86 26.25 13.67 217.55 2,278.87 1-Dec-16 110.38 771.82 768.66 31.36 32.44 53.10 105.66 27.71 13.37 227.16 2,238.83 1-Nov-16 104.79 758.04 750.57 32.95 32.66 55.19 101.37 26.98 13.87 207.39 2,198.81 1-Oct-16 107.65 784.54 789.82 28.19 28.92 52.97 105.64 25.52 13.05 168.57 2,126.15 1-Sep-16 107.19 777.29 837.31 31.13 31.04 55.88 107.59 25.77 13.87 152.52 2,168.27 1-Aug-16 100.06 767.05 769.16 27.24 30.53 56.22 107.97 27.18 12.83 159.64 2,170.95 1-Jul-16 1-Jun-16 1-May-16 98.27 768.79 758.81 25.86 31.33 52.53 113.30 27.09 12.51 149.61 2,173.60 735.72 90.15 692.10 715.62 93.60 19.67 30.37 51.17 109.75 27.17 11.00 139.97 2,098.86 722.79 17.64 29.49 49.97 101.23 26.09 11.73 149.62 2,096.95
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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