stock data analysis, business & finance homework help

User Generated

1234zlu

Business Finance

Description

Following Word document to do some analysis of your picks. Each part has a link to a source that will guide you step by step to complete the analysis.

First excel show you 10 stocks which is I choose. Second one is 8 short tasks for analysis.

Unformatted Attachment Preview

Company Name Ticker Symbol Market Cap ICBC QUTA 5.17 HKD China Construction Bank Closing Price Volume HKD closing price 1/25/2017 4,72 127.937.513 1/26/2017 4,8 260.559.584 1/27/2017 4,78 96.015.895 1/28/2017 1/29/2017 1/30/2017 1/31/2017 2/1/2017 4,77 215.352.014 2/2/2017 4,73 119.673.983 2/3/2017 4,7 209.729.067 2/4/2017 2/5/2017 2/6/2017 4,74 160.744.445 2/7/2017 4,76 194.992.247 2/8/2017 4,82 360.241.535 2/9/2017 4,87 323.825.365 2/10/2017 4,86 278.870.354 2/11/2017 2/12/2017 2/13/2017 4,94 286.664.639 2/14/2017 4,96 280.366.727 2/15/2017 5,1 785.106.390 2/16/2017 5,13 660.035.916 6/1/2017 5,3 476,704,10 6/2/2017 5,4 545.534.228 6/5/2017 5,34 295279643 6/6/2017 5,34 269844842 6/7/2017 5,3 334374657 6/8/2017 5,3 215.904.147 6/9/2017 5,22 555.334.751 6/12/2017 5,17 215.772.045 6/13/2017 5,19 174.956.855 6/14/2017 5,21 231.064.828 6/15/2017 5,13 292.233.315 6/16/2017 5,19 458.462.103 6/19/2017 5,23 172.572.443 6/20/2017 5,18 198.594.460 6/21/2017 5,12 319.049.064 6.50 HKD volume 5,72 231.057.913 5,84 362.842.444 5,8 146.676.444 5,8 5,77 5,76 242.856.590 156.312.062 213.384.080 5,8 5,8 5,85 5,92 5,91 212.289.254 198.063.453 561.104.569 510.869.327 348.640.979 5,95 5,97 6,27 6,45 6,53 6,6 6,56 6,58 6,48 6,5 6,46 6,37 6,41 6,45 6,34 6,39 6,46 6,46 6,42 317.375.070 350.170.652 998.521.655 912.020.342 321374801 340108627 394526546 229478416 511011801 252068820 415067228 294575712 168213421 207290825 263939745 238707544 142526848 226103616 363739976 6/22/2017 6/23/2017 6/26/2017 6/27/2017 6/28/2017 6/29/2017 6/30/2017 7/3/2017 7/4/2017 7/5/2017 7/6/2017 7/7/2017 7/10/2017 7/11/2017 7/12/2017 7/13/2017 7/14/2017 7/17/2017 7/18/2017 7/19/2017 7/20/2017 7/21/2017 5,15 5,2 5,25 5,22 5,2 5,28 5,27 5,03 4,96 4,96 4,94 4,88 4,87 5,02 5,19 5,26 5,27 5,29 5,3 5,34 5,38 5,36 291.038.995 253.772.982 167.086.956 188.561.814 319.258.115 360.809.216 260.990.436 259.451.957 350.899.694 325.061.325 200.176.227 198.181.104 262.299.552 435.890.808 732.188.436 435.475.631 239.545.564 311.641.791 323.554.270 301.220.853 313.997.338 223.887.510 GOOGLE STOCKS 6,12 6,11 6,17 6,12 6,06 6,08 6,05 6,08 5,99 6,02 5,98 5,93 5,94 6,18 6,34 6,39 6,4 6,41 6,39 6,4 6,38 6,35 GOOGLE STOCKS 287789040 212524627 190909993 147736200 232131198 290204843 221226938 154829329 330917030 211448769 212664557 224446831 232136385 475332101 554022140 327782493 254820839 265247470 216666434 157128542 158.348.189 140.708.496 Berkshire Hathaway JPMorgan Chase 166.5 USD closing price volume Allianz 83.90 USD closing price volume closing price 164,25 164,92 164,4 4.500.000 3.132.400 2.520.300 86,03 86,75 86,93 17.551.000 15.962.800 12.535.400 162,5 163 162 164,8 164,14 163,61 163 163,94 3.194.400 3.099.600 2.906.900 3.041.200 3.352.700 86,03 84,63 84,95 84,59 87,18 13.661.900 15.655.100 15.430.900 11.081.400 17.885.200 159,25 156,8 157,9 157,15 158,3 163,42 162,93 162,87 164,04 164,01 2.798.300 2.446.800 2.247.100 2.878.300 3.066.200 86,77 86,72 85,96 87,2 87 11.828.400 9.392.800 13.970.900 13.749.100 10.992.500 156,35 156,25 155,25 156,6 156,85 165,85 166,95 167,28 167,74 2.958.400 3.057.900 4.349.600 3.152.200 3330897 3919875 2303426 2752253 2987775 4387420 3781306 4662747 3145426 3344536 3275236 6505945 2869040 2470055 2365080 88,15 89,56 90,59 90,53 83,06 82,64 82,79 82,96 83,91 84,95 86,96 86,98 87,27 87,09 86,57 86,18 88,07 87,52 87,12 18.739.100 17.932.100 17.381.800 17.672.700 17123490 14998489 9080165 12196816 13711071 17950964 19120172 16053405 12557225 16175654 12509682 16936572 15972336 11197809 10005941 158,5 159,15 158,75 158,35 171,45 173,35 HOLIDAY 171,1 170,55 172,05 173,85 173,6 173,25 173,95 173 174,45 176,2 175,85 175,05 166,66 166,29 166,52 166,13 166,5 166,94 170 170,5 171,47 171,45 170,55 170,48 171,55 170,55 169,62 168,32 167,22 167,49 167,35 169,89 169,3 169,37 171,8 171,85 170,2 171,14 170,25 169,24 169,92 169,69 169,47 170,16 170,31 171,2 171,33 171,2 GOOGLE STOCKS 2673903 4046778 2542983 2995631 3210877 3545467 3627845 2493428 HOLIDAY 2558551 3182046 2967228 2504544 3525601 3018227 3170520 2941549 3044423 2599866 1923235 2.137.923 1.923.235 87,02 86,86 87,24 88,05 89,82 91,15 91,4 92,75 12180579 18812029 10082422 15415152 17466177 27697818 16892700 13208087 93,68 93,38 93,85 93,19 92,83 92,51 93,1 92,25 91,39 91,07 91,2 91,2 90,89 17535404 16596123 12817808 13987191 13262282 13540107 12820084 22235168 14374219 14719404 11651245 11.561.740 10.971.292 GOOGLE STOCKS 174,9 173,9 174,55 174,35 174,35 173,1 172,4 175,9 176,65 176,7 177,15 178,75 180 179,9 182,5 183,85 182,8 181,95 179,7 179,7 178,95 176,85 GOOGLE STOCKS Alphabet Total 172 EUR volume Daimler 981USD 60.89 USD closing price volume closing price volume closing price 2.458.748 858,45 1.655.400 57,48 1.341.400 72,35 1.539.238 856,98 3.493.300 50,79 1.724.100 71,56 1.193.485 845,03 3.752.500 50,4 1.422.900 70,72 1.342.261 1.710.878 1.291.977 951.510 1.034.327 823,83 820,19 815,24 818,26 820,13 3.516.900 2.020.200 2.251.000 1.689.200 1.528.100 49,82 50,56 50,36 50,28 50,81 1.293.800 2.472.300 811.700 1.414.900 1.590.500 70,45 69,35 70,02 68,1 67,65 1.675.926 1.181.084 1.293.333 1.394.096 1.029.765 821,62 829,23 829,88 830,06 834,85 1.350.900 1.666.600 1.302.200 1.194.200 1.415.100 50,38 49,63 49,99 50,51 50,9 668.800 1.800.100 2.878.100 1.953.800 1.480.300 67,21 66,76 66,66 67,29 67,12 1.061.521 926.973 1.123.805 1.421.054 847191 1340157 838,96 840,03 837,32 842,17 988,29 996,12 1003,88 996,68 1001,59 1004,28 970,12 961,81 970,5 967,93 960,18 958,62 975,22 968,99 978,59 1.295.700 1.393.300 1.357.200 1.005.100 1306384 1735469 1378916 1552114 1374097 1687925 3647857 4202109 2005356 1505486 2427639 2559207 1468837 1297287 1161607 50,92 50,71 50,93 50,89 52,1 52,21 51,76 51,93 51,17 51,12 51,37 51,14 51,41 50,41 49,55 50,28 50,27 49,74 49,46 2.502.400 1.758.000 2.580.200 1.441.900 859504 1438946 2950798 2466425 1373444 659493 1252186 1543217 2157841 2047791 1915320 934716 716853 1279402 2200006 67,89 68,11 68,06 67,79 65,07 65,84 HOLIDAY 1470483 1036479 1041731 1154287 1031009 1267959 1904903 1907340 3400340 1334345 1127481 1091554 HOLID 65,53 65,17 65,16 65,46 65,64 65,9 65,71 65,25 65,2 65,71 65,57 65,45 972327 973214 968030 932858 1069731 1668309 1506882 1429532 1170238 1239877 1524722 1429073 1293752 1240084 1545991 1453052 1088505 721377 1415805 862746 1.260.068 2.012.004 GOOGLE STOCKS 976,62 986,09 972,09 948,09 961,01 937,82 929,68 919,46 932,26 927,69 940,81 951 953,53 967,66 968,85 976,91 975,96 986,95 992,77 992,19 993,84 1009476 1563985 1517912 2443602 2745568 3206674 2287662 1694811 HOLIDAY 2094055 2014855 1663302 1451460 1461247 1602115 1524571 1079608 1660464 1413335 1412148 1.418.385 1.463.322 GOOGLE STOCKS 49,33 49,2 49,16 50,06 50,38 49,86 49,59 50,1 3262112 1694523 874121 1107493 990596 1576356 1607056 746874 48,93 48,88 48,45 48,66 49,02 49,06 49,23 49,66 49,49 49,68 50,13 50,35 49,62 1738974 850373 2878289 795599 1064794 1911941 823978 916591 1109817 783755 639965 2.142.403 1.935.361 GOOGLE STOCKS 65,49 65,34 65,37 65,08 64,9 64,31 63,37 64,08 64,1 63,74 63,36 63,48 63,36 64,15 65,46 65,15 64,87 64,68 64,17 64,14 63,9 62,58 GOOGLE STOCKS Volkswagen 64.98 EUR Microsoft 137.75 EUR 71.91 USD volume closing price volume 4.232.038 153,9 3.407.985 152,5 3.436.066 149,9 closing price volume 1.751.077 63,68 23.672.700 1.112.311 64,27 43.554.600 1.310.558 65,78 44.818.000 3.009.514 4.160.165 4,O15,812 9.187.905 4.319.994 145,5 143,9 145,7 144,3 144,9 1.364.761 1.615.633 1.078.447 998.554 765.096 65,13 64,65 63,58 63,17 63,68 31.651.400 25.270.500 39.671.500 45.827.000 30.301.800 4.074.818 3.767.313 3.714.044 3.982.671 3.303.073 141,9 141,85 139,9 140 142,15 1.243.901 741.277 1.049.799 1.286.343 995.836 63,64 63,43 63,34 64,06 64 19.796.400 20.277.200 18.096.400 22.644.400 18.096.400 3.130.096 2.865.966 3.341.348 2.687.252 4025852 4152509 145,25 146,85 143,6 140,25 135,75 137,55 1.006.323 1.012.475 966.444 1.903.272 1039993 1350796 134,95 133,2 132,25 132,6 134,85 135,25 132,4 131,35 131,2 131,2 131,95 132,25 1091464 1294759 1284305 981308 1640335 765695 1647486 1846860 1761910 1026211 813556 757524 64,72 64,57 64,53 64,52 70,1 71,76 72,28 72,52 72,39 71,95 70,32 69,78 70,65 70,27 69,9 70 70,87 69,91 70,27 22.920.100 23.108.400 17.005.200 20.546.300 21603601 34770261 33316760 31511065 22301765 24588270 49187396 47761743 25258614 25510685 26068709 48345085 23798268 21512231 19891051 HOLIDAY 3453813 2586092 2561811 2641147 4544238 2270434 3678420 4207551 9209382 2475263 2326684 2467010 2884562 2603281 2548809 3509086 3139016 4196610 5067499 3007027 2047146 3714665 4217803 2300559 2502879 3748374 4161260 5940234 4637093 2051645 4030644 2649587 3.587.833 8.756.451 GOOGLE STOCKS 134,65 133,65 134,3 134,1 134,35 133 133,35 135,8 136,2 135,65 138,1 138,75 138,65 140,15 142,55 143,35 145,45 144,55 142,7 143,5 142,95 137,75 GOOGLE STOCKS 1076284 874211 709548 824120 666867 899824 956389 1045597 618703 799354 1867231 896069 835096 1211541 1363074 1414285 1395155 1116164 1319561 843473 1.380.181 3.260.127 70,26 22965738 71,21 27617291 70,53 19606974 69,21 25215128 69,8 25806200 68,49 28918715 68,93 24161068 68,17 16165538 HOLIDAY 69,08 21176272 68,57 21117572 69,46 16878317 69,98 15014503 69,99 17460022 71,15 17750925 71,77 20269816 72,78 25868086 73,35 21803907 73,3 26435296 73,86 22416222 74,22 42.361.025 73,79 46.717.082 GOOGLE STOCKS Final Project Using Stock Data Collected During the Semester 1. Be sure your data is listed so that each column is a different stock and the rows contain the prices for each day of your collection. Stock 1 Stock 2 Stock 3… Stock 10 HPR1 Volatility1 $10,000 HPR2 Volatility2 $10,000 HPR3 Volatility3 $10,000 HPR1 Volatility10 $10,000 1/1/17 1/2/17 1/32/174 Investment 2. Compute the holding period return for each. Here is a website that will help: http://financetrain.com/how-to-calculate-the-holding-period-returns/ 3. Compute the annualized volatility for each of your stocks: https://www.fool.com/knowledge-center/how-to-calculate-annualized-volatility.aspx 4. Compute the return on an equally weighted portfolio of your ten stock. https://www.boundless.com/finance/textbooks/boundless-finance-textbook/introduction-torisk-and-return-8/implications-across-portfolios-80/calculating-expected-portfolio-returns-3493894/ 5. Construct a correlation matrix for the ten stocks in your spreadsheet. www.ruf.rice.edu/~admn543/Correlation%20matrix%20steps.doc 6. Using the correlation matrix, construct 6 portfolios of two stocks each. Find 2 portfolios of positively correlated stocks, 2 portfolios of negatively correlated stocks and 2 portfolios of stocks that have correlations that are as close to zero as you have. 7. Compare the portfolio returns you get to the individual returns of the stock that comprise them. 8. Lastly, create portfolio of 5 stocks of your own choosing and weight. Compute the daily value of that portfolio, then use this column to determine the holding period return and volatility of your self-constructed portfolio.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please look at. Thanks

Company Name
Ticker Symbol
Market Cap

ICBC
QUTA
5.17 HKD
Closing Price

6/1/2017
6/2/2017
6/5/2017
6/6/2017
6/7/2017
6/8/2017
6/9/2017
6/12/2017
6/13/2017
6/14/2017
6/15/2017
6/16/2017
6/19/2017
6/20/2017
6/21/2017
6/22/2017
6/23/2017
6/26/2017
6/27/2017
6/28/2017
6/29/2017
6/30/2017
7/3/2017
7/5/2017
7/6/2017
7/7/2017
7/10/2017
7/11/2017
7/12/2017
7/13/2017
7/14/2017
7/17/2017
7/18/2017
7/19/2017
7/20/2017
7/21/2017

5,3
5,4
5,34
5,34
5,3
5,3
5,22
5,17
5,19
5,21
5,13
5,19
5,23
5,18
5,12
5,15
5,2
5,25
5,22
5,2
5,28
5,27
5,03
4,96
4,94
4,88
4,87
5,02
5,19
5,26
5,27
5,29
5,3
5,34
5,38
5,36

Volume
476,704,10
545.534.228
295279643
269844842
334374657
215.904.147
555.334.751
215.772.045
174.956.855
231.064.828
292.233.315
458.462.103
172.572.443
198.594.460
319.049.064
291.038.995
253.772.982
167.086.956
188.561.814
319.258.115
360.809.216
260.990.436
259.451.957
325.061.325
200.176.227
198.181.104
262.299.552
435.890.808
732.188.436
435.475.631
239.545.564
311.641.791
323.554.270
301.220.853
313.997.338
223.887.510

China Construction Bank
6.50 HKD
Closing Price
6,53
6,6
6,56
6,58
6,48
6,5
6,46
6,37
6,41
6,45
6,34
6,39
6,46
6,46
6,42
6,12
6,11
6,17
6,12
6,06
6,08
6,05
6,08
6,02
5,98
5,93
5,94
6,18
6,34
6,39
6,4
6,41
6,39
6,4
6,38
6,35

Volume
321374801
340108627
394526546
229478416
511011801
252068820
415067228
294575712
168213421
207290825
263939745
238707544
142526848
226103616
363739976
287789040
212524627
190909993
147736200
232131198
290204843
221226938
154829329
211448769
212664557
224446831
232136385
475332101
554022140
327782493
254820839
265247470
216666434
157128542
158.348.189
140.708.496

Berkshire Hathaway
166.5 USD
Closing Price

166,66
166,29
166,52
166,13
166,5
166,94
170
170,5
171,47
171,45
170,55
170,48
171,55
170,55
169,62
168,32
167,22
167,49
167,35
169,89
169,3
169,37
171,8
171,85
170,2
171,14
170,25
169,24
169,92
169,69
169,47
170,16
170,31
171,2
171,33
171,2

GOOGLE STOCKS

GOOGLE STOCKS

GOOGLE STOCKS

Berkshire Hathaway

JP Morgan Chase

Allianz

Alphabet

166.5 USD

83.90 USD

172 EUR

981USD

Volume
3330897
3919875
2303426
2752253
2987775
4387420
3781306
4662747
3145426
3344536
3275236
6505945
2869040
2470055
2365080
2673903
4046778
2542983
2995631
3210877
3545467
3627845
2493428
2558551
3182046
2967228
2504544
3525601
3018227
3170520
2941549
3044423
2599866
1923235
2.137.923
1.923.235

Closing Price
83,06
82,64
82,79
82,96
83,91
84,95
86,96
86,98
87,27
87,09
86,57
86,18
88,07
87,52
87,12
87,02
86,86
87,24
88,05
89,82
91,15
91,4
92,75
93,68
93,38
93,85
93,19
92,83
92,51
93,1
92,25
91,39
91,07
91,2
91,2
90,89

Volume
17123490
14998489
9080165
12196816
13711071
17950964
19120172
16053405
12557225
16175654
12509682
16936572
15972336
11197809
10005941
12180579
18812029
10082422
15415152
17466177
27697818
16892700
13208087
17535404
16596123
12817808
13987191
13262282
13540107
12820084
22235168
14374219
14719404
11651245
11.561.740
10.971.292

Cosing Price
171,45
173,35
176,09
171,1
170,55
172,05
173,85
173,6
173,25
173,95
173
174,45
176,2
175,85
175,05
174,9
173,9
174,55
174,35
174,35
173,1
172,4
175,9
176,7
177,15
178,75
180
179,9
182,5
183,85
182,8
181,95
179,7
179,7
178,95
176,85

Volume
847191
1340157
1239877
1470483
1036479
1041731
1154287
1031009
1267959
1904903
1907340
3400340
1334345
1127481
1091554
972327
973214
968030
932858
1069731
1668309
1506882
1429532
1239877
1524722
1429073
1293752
1240084
1545991
1453052
1088505
721377
1415805
862746
1.260.068
2.012.004

Closing Price
988,29
996,12
1003,88
996,68
1001,59
1004,28
970,12
961,81
970,5
967,93
960,18
958,62
975,22
968,99
978,59
976,62
986,09
972,09
948,09
961,01
937,82
929,68
919,46
932,26
927,69
940,81
951
953,53
967,66
968,85
976,91
975,96
986,95
992,77
992,19
993,84

GOOGLE STOCKS

GOOGLE STOCKS

GOOGLE STOCKS

GOOGLE STOCKS

Alphabet

Total

Daimler

Volkswagen

981USD

60.89 USD

64.98 EUR

137.75 EUR

Volume
1306384
1735469
1378916
1552114
1374097
1687925
3647857
4202109
2005356
1505486
2427639
2559207
1468837
1297287
1161607
1009476
1563985
1517912
2443602
2745568
3206674
2287662
1694811
2094055
2014855
1663302
1451460
1461247
1602115
1524571
1079608
1660464
1413335
1412148
1.418.385
1.463.322

Closing Price
52,1
52,21
51,76
51,93
51,17
51,12
51,37
51,14
51,41
50,41
49,55
50,28
50,27
49,74
49,46
49,33
49,2
49,16
50,06
50,38
49,86
49,59
50,1
48,93
48,88
48,45
48,66
49,02
49,06
49,23
49,66
49,49
49,68
50,13
50,35
49,62

Volume
859504
1438946
2950798
2466425
1373444
659493
1252186
1543217
2157841
2047791
1915320
934716
716853
1279402
2200006
3262112
1694523
874121
1107493
990596
1576356
1607056
746874
1738974
850373
2878289
795599
1064794
1911941
823978
916591
1109817
783755
639965
2.142.403
1.935.361

Closing Price
65,07
65,84
63,74
65,53
65,17
65,16
65,46
65,64
65,9
65,71
65,25
65,2
65,71
65,57
65,45
65,49
65,34
65,37
65,08
64,9
64,31
63,37
64,08
63,74
63,36
63,48
63,36
64,15
65,46
65,15
64,87
64,68
64,17
64,14
63,9
62,58

Volume
4025852
4152509
3714665
3453813
2586092
2561811
2641147
4544238
2270434
3678420
4207551
9209382
2475263
2326684
2467010
2884562
2603281
2548809
3509086
3139016
4196610
5067499
3007027
3714665
4217803
2300559
2502879
3748374
4161260
5940234
4637093
2051645
4030644
2649587
3.587.833
8.756.451...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags