Description
A. Using the two stocks you selected from Homework #1, identify the Beta for each stock. what conclusion can you draw from the stocks' current and historical beta? If the stock market went up 10% today, what would be the impact on each of your stocks?
Beta for Apple and Beta for General motors
B. Using the 2014 financial statements from your stocks above and the equations from your textbook, prepare the Historical Average and Standard Deviation for each stock.
For Apple and For General Motors
Explanation & Answer
Attached.
Date
12/31/2013
1/2/2014
1/3/2014
1/6/2014
1/7/2014
1/8/2014
1/9/2014
1/10/2014
1/13/2014
1/14/2014
1/15/2014
1/16/2014
1/17/2014
1/21/2014
1/22/2014
1/23/2014
1/24/2014
1/27/2014
1/28/2014
1/29/2014
1/30/2014
1/31/2014
2/3/2014
2/4/2014
2/5/2014
2/6/2014
2/7/2014
2/10/2014
2/11/2014
2/12/2014
2/13/2014
2/14/2014
2/18/2014
2/19/2014
2/20/2014
2/21/2014
2/24/2014
2/25/2014
2/26/2014
2/27/2014
2/28/2014
3/3/2014
3/4/2014
3/5/2014
3/6/2014
3/7/2014
Adj Close % return deviation dev. Sq.
74,30417
73,25917
-1,41%
-1,56%
0,02%
71,64998
-2,20%
-2,35%
0,06%
72,04067
0,55%
0,39%
0,00%
71,52548
-0,72%
-0,87%
0,01%
71,97844
0,63%
0,48%
0,00%
71,05928
-1,28%
-1,43%
0,02%
70,58514
-0,67%
-0,82%
0,01%
70,95464
0,52%
0,37%
0,00%
72,36651
1,99%
1,84%
0,03%
73,81943
2,01%
1,85%
0,03%
73,4075
-0,56%
-0,71%
0,01%
71,60893
-2,45%
-2,60%
0,07%
72,72145
1,55%
1,40%
0,02%
73,04462
0,44%
0,29%
0,00%
73,66314
0,85%
0,69%
0,00%
72,32413
-1,82%
-1,97%
0,04%
72,91084
0,81%
0,66%
0,00%
67,08328
-7,99%
-8,15%
0,66%
66,32172
-1,14%
-1,29%
0,02%
66,19326
-0,19%
-0,35%
0,00%
66,30185
0,16%
0,01%
0,00%
66,42502
0,19%
0,03%
0,00%
67,38658
1,45%
1,29%
0,02%
67,88988
0,75%
0,59%
0,00%
68,28558
0,58%
0,43%
0,00%
69,24089
1,40%
1,25%
0,02%
70,48132
1,79%
1,64%
0,03%
71,41
1,32%
1,16%
0,01%
71,40467
-0,01%
-0,16%
0,00%
72,53851
1,59%
1,44%
0,02%
72,4799
-0,08%
-0,23%
0,00%
72,74639
0,37%
0,21%
0,00%
71,59788
-1,58%
-1,73%
0,03%
70,76911
-1,16%
-1,31%
0,02%
69,98302
-1,11%
-1,26%
0,02%
70,28947
0,44%
0,29%
0,00%
69,55801
-1,04%
-1,19%
0,01%
68,93045
-0,90%
-1,06%
0,01%
70,30547
1,99%
1,84%
0,03%
70,11493
-0,27%
-0,42%
0,00%
70,31745
0,29%
0,14%
0,00%
70,78112
0,66%
0,51%
0,00%
70,93035
0,21%
0,06%
0,00%
70,71584
-0,30%
-0,46%
0,00%
70,67454
-0,06%
-0,21%
0,00%
3/10/2014
3/11/2014
3/12/2014
3/13/2014
3/14/2014
3/17/2014
3/18/2014
3/19/2014
3/20/2014
3/21/2014
3/24/2014
3/25/2014
3/26/2014
3/27/2014
3/28/2014
3/31/2014
4/1/2014
4/2/2014
4/3/2014
4/4/2014
4/7/2014
4/8/2014
4/9/2014
4/10/2014
4/11/2014
4/14/2014
4/15/2014
4/16/2014
4/17/2014
4/21/2014
4/22/2014
4/23/2014
4/24/2014
4/25/2014
4/28/2014
4/29/2014
4/30/2014
5/1/2014
5/2/2014
5/5/2014
5/6/2014
5/7/2014
5/8/2014
5/9/2014
5/12/2014
5/13/2014
5/14/2014
70,73848
71,42731
71,49661
70,70251
69,90842
70,18156
70,80242
70,78378
70,44269
70,99828
71,84036
72,61313
71,91898
71,60986
71,52992
71,51392
72,16811
72,28804
71,78706
70,85841
69,74589
69,74187
70,65855
69,74721
69,23158
69,50737
69,01173
69,15163
69,94173
70,77181
70,84242
69,91641
75,64829
76,20389
79,15508
78,92059
78,62214
78,80736
78,95391
80,07045
79,19775
78,92059
78,77992
78,45168
79,42838
79,55299
79,56773
0,09%
0,97%
0,10%
-1,11%
-1,12%
0,39%
0,88%
-0,03%
-0,48%
0,79%
1,19%
1,08%
-0,96%
-0,43%
-0,11%
-0,02%
0,91%
0,17%
-0,69%
-1,29%
-1,57%
-0,01%
1,31%
-1,29%
-0,74%
0,40%
-0,71%
0,20%
1,14%
1,19%
0,10%
-1,31%
8,20%
0,73%
3,87%
-0,30%
-0,38%
0,24%
0,19%
1,41%
-1,09%
-0,35%
-0,18%
-0,42%
1,25%
0,16%
0,02%
-0,06%
0,82%
-0,06%
-1,26%
-1,28%
0,24%
0,73%
-0,18%
-0,63%
0,64%
1,03%
0,92%
-1,11%
-0,58%
-0,26%
-0,18%
0,76%
0,01%
-0,85%
-1,45%
-1,72%
-0,16%
1,16%
-1,44%
-0,89%
0,25%
-0,87%
0,05%
0,99%
1,03%
-0,05%
-1,46%
8,05%
0,58%
3,72%
-0,45%
-0,53%
0,08%
0,03%
1,26%
-1,24%
-0,50%
-0,33%
-0,57%
1,09%
0,00%
-0,13%
0,00%
0,01%
0,00%
0,02%
0,02%
0,00%
0,01%
0,00%
0,00%
0,00%
0,01%
0,01%
0,01%
0,00%
0,00%
0,00%
0,01%
0,00%
0,01%
0,02%
0,03%
0,00%
0,01%
0,02%
0,01%
0,00%
0,01%
0,00%
0,01%
0,01%
0,00%
0,02%
0,65%
0,00%
0,14%
0,00%
0,00%
0,00%
0,00%
0,02%
0,02%
0,00%
0,00%
0,00%
0,01%
0,00%
0,00%
5/15/2014
5/16/2014
5/19/2014
5/20/2014
5/21/2014
5/22/2014
5/23/2014
5/27/2014
5/28/2014
5/29/2014
5/30/2014
6/2/2014
6/3/2014
6/4/2014
6/5/2014
6/6/2014
6/9/2014
6/10/2014
6/11/2014
6/12/2014
6/13/2014
6/16/2014
6/17/2014
6/18/2014
6/19/2014
6/20/2014
6/23/2014
6/24/2014
6/25/2014
6/26/2014
6/27/2014
6/30/2014
7/1/2014
7/2/2014
7/3/2014
7/7/2014
7/8/2014
7/9/2014
7/10/2014
7/11/2014
7/14/2014
7/15/2014
7/16/2014
7/17/2014
7/18/2014
7/21/2014
7/22/2014
78,89111
80,05544
81,00402
81,0201
81,23446
81,36309
82,28221
83,82299
83,60594
85,12932
84,81045
84,22762
85,41872
86,3941
86,73306
86,49459
87,87862
88,394...
Review
Review
