PRICE DATA: 10 STOCKS AND SP500, 2015-2020 SP500 represented by Vanguard's Index 500 fund (includes dividends)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
1.The purpose of using a balanced scorecard is for: Multiple Choice A.companies to make sure their business activities align with strategy. B.companies to compare themselves with their competitors....
-
Office Pro, Inc., does software development. One important activity in software development is writing software code. The manager of the WordPro Development Team determined that the average software...
-
The comparative financial statements of Bien Taco Restaurants for 2010, 2009, and 2008 include the following selected data: Requirements 1. Compute these ratios for 2010 and 2009: a. Quick ratio. b....
-
When an investor views the times interest earned ratio of a company, a. it is a measure of the companys liquidity. b. a high value is generally viewed favorably. c. a low value is generally viewed...
-
Pedrick, Inc. reports the following liabilities (in thousands) on its January 31, 2012, balance sheet and notes to the financial statements. Instructions(a) Identify which of the above liabilities...
-
Time Line Price(dollars 1970 $0.20 1980 $0.50 2003 $2.00 2009 $2.25 2013 $2.50 2015 $2.75 I Identify your independent and dependent variables using appropriate symbols to state them. Let the...
-
A licensee who represents a seller whose property is in an area or of a type where the licensee has no experience is acting: Group of answer choices within the scope of a California Real Estate licens
-
K 1/3 The function f(x)=24x models the number of plant species, f(x), on an island in terms of the area, x, in square miles. What is the area of an island that has 120 species of plants? square miles
-
QUESTION 2 Excellent Sdn Bhd manufactures a single product called Magenta. The budgeted costs of the company for the first half year of 2021 based on budgeted productions and sales of 15,000 units of...
-
4) ABC Corporation makes electrical watches. The lifetime (period during which a watch does not need major repair) of an electronic watch manufactured by this corporation has a normal distribution...
-
Problem Statement: This submission requires you to develop, verify and validate a numerical model against both analytical and experimental data. This task will require you to demonstrate that a...
-
The Botswana government through the Ministry of Entrepreneurship has launched a programme to assist the out of school youth to start businesses in Palapye village. You have been hired by the Ministry...
-
Using Spss answer the following questions: Question 1 Construct the 92% confidence interval for the true mean MILEAGE of all cars. Question 2 Is there evidence that the population mean PRICE for...
-
Match the following. Answers may be used more than once: Measurement Method A. Amortized cost B. Equity method C. Acquisition method and consolidation D. Fair value method Reporting Method 1. Less...
-
Assume that you have been asked to place a value on the ownership position in Briarwood Hospital. Its projected profit and loss statements and equity reinvestment (asset) requirements are shown below...
-
Assume that you have been asked to place a value on the fund capital (equity) of BestHealth, a not-for-profit HMO. Its projected profit and loss statements and equity reinvestment (asset)...
-
Where would you be able to bring about cost savings as a program manager for a company? Discuss these using the standard project constraints. (Lo 2)
Study smarter with the SolutionInn App