Asiignment 2

profilesajhal-1
Assignment2-AppleStockPrice.xlsx
Home>Business & Finance homework help>Asiignment 2

Monthly

Date Apple Closing Price Monthly Return
Jan-15 26.64 6.14
Feb-15 29.21 9.64
Mar-15 28.41 -2.75
Apr-15 28.57 0.58
May-15 29.74 4.10
Jun-15 28.75 -3.32
Jul-15 27.81 -3.29
Aug-15 25.85 -7.04
Sep-15 25.40 -1.74
Oct-15 27.52 8.34
Nov-15 27.24 -1.00
Dec-15 24.34 -10.64
Jan-16 22.51 -7.52
Feb-16 22.36 -0.67
Mar-16 25.34 13.33
Apr-16 21.80 -13.99
May-16 23.22 6.53
Jun-16 22.36 -3.68
Jul-16 24.38 9.01
Aug-16 24.82 1.81
Sep-16 26.59 7.13
Oct-16 26.71 0.43
Nov-16 26.00 -2.66
Dec-16 27.38 5.33
Jan-17 28.69 4.77
Feb-17 32.39 12.89
Mar-17 34.11 5.32
Apr-17 34.11 -0.01
May-17 36.27 6.34
Jun-17 34.34 -5.33
Jul-17 35.46 3.27
Aug-17 39.10 10.27
Sep-17 36.89 -5.66
Oct-17 40.46 9.68
Nov-17 41.13 1.66
Dec-17 40.65 -1.17
Jan-18 40.22 -1.06
Feb-18 42.79 6.38
Mar-18 40.47 -5.42
Apr-18 39.86 -1.50
May-18 45.07 13.08
Jun-18 44.82 -0.56
Jul-18 46.07 2.80
Aug-18 55.12 19.62
Sep-18 54.85 -0.48
Oct-18 53.18 -3.05
Nov-18 43.39 -18.40
Dec-18 38.46 -11.36
Jan-19 40.58 5.52
Feb-19 42.22 4.03
Mar-19 46.51 10.17
Apr-19 49.14 5.64
May-19 42.87 -12.76
Jun-19 48.65 13.49
Jul-19 52.37 7.64
Aug-19 51.31 -2.02
Sep-19 55.26 7.70
Oct-19 61.38 11.07
Nov-19 65.94 7.43
Dec-19 72.68 10.21
Jan-20 76.60 5.40
Feb-20 67.65 -11.68
Mar-20 63.08 -6.76
Apr-20 72.89 15.54
May-20 78.87 8.22
Jun-20 90.74 15.05
Jul-20 105.73 16.51
Aug-20 128.39 21.44
Sep-20 115.44 -10.09
Oct-20 108.51 -6.00
Nov-20 118.67 9.36
Dec-20 132.49 11.65

Weekly

Date Apple Closing Price Weekly Return
1/5/15 25.47 2.46
1/12/15 24.10 -5.37
1/19/15 25.69 6.59
1/26/15 26.64 3.70
2/2/15 27.04 1.51
2/9/15 29.01 7.27
2/16/15 29.56 1.90
2/23/15 29.33 -0.80
3/2/15 28.90 -1.45
3/9/15 28.22 -2.38
3/16/15 28.74 1.87
3/23/15 28.14 -2.10
3/30/15 28.61 1.68
4/6/15 29.02 1.42
4/13/15 28.48 -1.85
4/20/15 29.74 4.43
4/27/15 29.44 -1.02
5/4/15 29.14 -1.03
5/11/15 29.52 1.32
5/18/15 30.38 2.93
5/25/15 29.87 -1.71
6/1/15 29.49 -1.25
6/8/15 29.15 -1.15
6/15/15 29.02 -0.45
6/22/15 29.06 0.12
6/29/15 28.99 -0.24
7/6/15 28.26 -2.50
7/13/15 29.72 5.14
7/20/15 28.54 -3.95
7/27/15 27.81 -2.57
8/3/15 26.48 -4.77
8/10/15 26.70 0.84
8/17/15 24.36 -8.80
8/24/15 26.09 7.12
8/31/15 25.16 -3.55
9/7/15 26.30 4.52
9/14/15 26.13 -0.67
9/21/15 26.42 1.11
9/28/15 25.42 -3.77
10/5/15 25.82 1.58
10/12/15 25.57 -0.96
10/19/15 27.42 7.24
10/26/15 27.52 0.35
11/2/15 27.88 1.31
11/9/15 25.98 -6.81
11/16/15 27.59 6.20
11/23/15 27.25 -1.25
11/30/15 27.53 1.04
12/7/15 26.18 -4.91
12/14/15 24.52 -6.32
12/21/15 24.98 1.89
12/28/15 24.34 -2.56
1/4/16 22.42 -7.89
1/11/16 22.46 0.18
1/18/16 23.46 4.42
1/25/16 22.51 -4.02
2/1/16 21.74 -3.41
2/8/16 21.86 0.51
2/15/16 22.33 2.18
2/22/16 22.53 0.91
2/29/16 23.95 6.29
3/7/16 23.78 -0.73
3/14/16 24.63 3.58
3/21/16 24.57 -0.24
3/28/16 25.58 4.09
4/4/16 25.27 -1.21
4/11/16 25.54 1.10
4/18/16 24.57 -3.80
4/25/16 21.80 -11.30
5/2/16 21.56 -1.09
5/9/16 21.18 -1.78
5/16/16 22.28 5.19
5/23/16 23.48 5.39
5/30/16 22.91 -2.42
6/6/16 23.12 0.93
6/13/16 22.30 -3.54
6/20/16 21.85 -2.02
6/27/16 22.43 2.67
7/4/16 22.62 0.82
7/11/16 23.11 2.17
7/18/16 23.08 -0.12
7/25/16 24.38 5.63
8/1/16 25.14 3.14
8/8/16 25.45 1.20
8/15/16 25.72 1.09
8/22/16 25.15 -2.21
8/29/16 25.34 0.74
9/5/16 24.26 -4.27
9/12/16 27.03 11.43
9/19/16 26.51 -1.92
9/26/16 26.59 0.30
10/3/16 26.83 0.89
10/10/16 27.67 3.13
10/17/16 27.43 -0.88
10/24/16 26.75 -2.47
10/31/16 25.60 -4.29
11/7/16 25.63 0.13
11/14/16 26.02 1.50
11/21/16 26.43 1.57
11/28/16 25.98 -1.69
12/5/16 26.94 3.69
12/12/16 27.42 1.77
12/19/16 27.55 0.47
12/26/16 27.38 -0.60
1/2/17 27.88 1.80
1/9/17 28.14 0.96
1/16/17 28.37 0.81
1/23/17 28.83 1.62
1/30/17 30.52 5.85
2/6/17 31.24 2.36
2/13/17 32.23 3.17
2/20/17 32.45 0.69
2/27/17 33.19 2.28
3/6/17 33.04 -0.46
3/13/17 33.24 0.61
3/20/17 33.39 0.46
3/27/17 34.11 2.15
4/3/17 34.04 -0.22
4/10/17 33.49 -1.60
4/17/17 33.78 0.86
4/24/17 34.11 0.97
5/1/17 35.37 3.70
5/8/17 37.06 4.79
5/15/17 36.49 -1.54
5/22/17 36.62 0.36
5/29/17 37.06 1.20
6/5/17 35.52 -4.16
6/12/17 33.92 -4.50
6/19/17 34.88 2.82
6/26/17 34.34 -1.54
7/3/17 34.38 0.11
7/10/17 35.53 3.37
7/17/17 35.83 0.83
7/24/17 35.64 -0.51
7/31/17 37.29 4.61
8/7/17 37.55 0.70
8/14/17 37.70 0.41
8/21/17 38.26 1.50
8/28/17 39.27 2.62
9/4/17 37.97 -3.30
9/11/17 38.27 0.79
9/18/17 36.36 -5.00
9/25/17 36.89 1.47
10/2/17 37.17 0.77
10/9/17 37.58 1.09
10/16/17 37.40 -0.47
10/23/17 39.03 4.35
10/30/17 41.29 5.80
11/6/17 41.81 1.26
11/13/17 40.87 -2.24
11/20/17 42.03 2.83
11/27/17 41.09 -2.24
12/4/17 40.69 -0.98
12/11/17 41.79 2.72
12/18/17 42.04 0.60
12/25/17 40.65 -3.30
1/1/18 42.04 3.41
1/8/18 42.54 1.19
1/15/18 42.87 0.77
1/22/18 41.20 -3.89
1/29/18 38.56 -6.42
2/5/18 37.57 -2.55
2/12/18 41.59 10.69
2/19/18 42.33 1.78
2/26/18 42.50 0.40
3/5/18 43.41 2.14
3/12/18 42.94 -1.09
3/19/18 39.78 -7.35
3/26/18 40.47 1.72
4/2/18 40.61 0.36
4/9/18 42.14 3.77
4/16/18 39.97 -5.16
4/23/18 39.15 -2.05
4/30/18 44.34 13.25
5/7/18 45.49 2.59
5/14/18 45.11 -0.83
5/21/18 45.66 1.22
5/28/18 46.06 0.88
6/4/18 46.42 0.77
6/11/18 45.72 -1.49
6/18/18 44.77 -2.08
6/25/18 44.82 0.10
7/2/18 45.51 1.55
7/9/18 46.33 1.79
7/16/18 46.35 0.06
7/23/18 46.24 -0.24
7/30/18 50.36 8.91
8/6/18 50.25 -0.22
8/13/18 52.87 5.21
8/20/18 52.52 -0.65
8/27/18 55.31 5.31
9/3/18 53.77 -2.78
9/10/18 54.39 1.15
9/17/18 52.89 -2.76
9/24/18 54.85 3.71
10/1/18 54.50 -0.64
10/8/18 53.97 -0.97
10/15/18 53.29 -1.26
10/22/18 52.56 -1.37
10/29/18 50.41 -4.08
11/5/18 49.68 -1.45
11/12/18 47.19 -5.02
11/19/18 42.01 -10.98
11/26/18 43.54 3.65
12/3/18 41.08 -5.65
12/10/18 40.35 -1.79
12/17/18 36.75 -8.91
12/24/18 38.09 3.65
12/31/18 36.15 -5.10
1/7/19 37.13 2.72
1/14/19 38.24 2.97
1/21/19 38.47 0.60
1/28/19 40.60 5.55
2/4/19 41.55 2.34
2/11/19 41.73 0.43
2/18/19 42.36 1.50
2/25/19 42.85 1.16
3/4/19 42.34 -1.18
3/11/19 45.58 7.64
3/18/19 46.78 2.65
3/25/19 46.51 -0.58
4/1/19 48.24 3.71
4/8/19 48.70 0.95
4/15/19 49.92 2.51
4/22/19 50.03 0.22
4/29/19 51.85 3.65
5/6/19 48.28 -6.88
5/13/19 46.46 -3.78
5/20/19 43.99 -5.31
5/27/19 43.03 -2.18
6/3/19 46.74 8.61
6/10/19 47.38 1.36
6/17/19 48.86 3.13
6/24/19 48.65 -0.43
7/1/19 50.20 3.19
7/8/19 49.97 -0.46
7/15/19 49.80 -0.35
7/22/19 51.07 2.54
7/29/19 50.15 -1.79
8/5/19 49.41 -1.49
8/12/19 50.95 3.13
8/19/19 50.00 -1.87
8/26/19 51.51 3.01
9/2/19 52.62 2.17
9/9/19 53.98 2.57
9/16/19 53.72 -0.47
9/23/19 53.99 0.50
9/30/19 56.01 3.74
10/7/19 58.28 4.05
10/14/19 58.33 0.08
10/21/19 60.84 4.30
10/28/19 63.12 3.75
11/4/19 64.19 1.69
11/11/19 65.77 2.47
11/18/19 64.79 -1.50
11/25/19 66.14 2.09
12/2/19 67.00 1.29
12/9/19 68.10 1.64
12/16/19 69.16 1.56
12/23/19 71.72 3.71
12/30/19 73.61 2.63
1/6/20 76.80 4.34
1/13/20 78.88 2.71
1/20/20 78.78 -0.13
1/27/20 76.60 -2.76
2/3/20 79.20 3.40
2/10/20 80.61 1.78
2/17/20 77.66 -3.66
2/24/20 67.81 -12.68
3/2/20 71.70 5.73
3/9/20 68.96 -3.83
3/16/20 56.87 -17.53
3/23/20 61.46 8.07
3/30/20 59.89 -2.56
4/6/20 66.48 11.01
4/13/20 70.16 5.53
4/20/20 70.20 0.06
4/27/20 71.71 2.16
5/4/20 76.94 7.29
5/11/20 76.54 -0.51
5/18/20 79.32 3.63
5/25/20 79.09 -0.30
6/1/20 82.46 4.26
6/8/20 84.28 2.20
6/15/20 86.99 3.22
6/22/20 87.96 1.12
6/29/20 90.57 2.96
7/6/20 95.44 5.37
7/13/20 95.85 0.42
7/20/20 92.15 -3.85
7/27/20 105.73 14.73
8/3/20 110.56 4.57
8/10/20 114.54 3.60
8/17/20 123.97 8.23
8/24/20 124.41 0.35
8/31/20 120.57 -3.08
9/7/20 111.64 -7.41
9/14/20 106.50 -4.61
9/21/20 111.92 5.09
9/28/20 112.66 0.66
10/5/20 116.59 3.49
10/12/20 118.64 1.75
10/19/20 114.67 -3.34
10/26/20 108.51 -5.37
11/2/20 118.31 9.03
11/9/20 119.08 0.65
11/16/20 117.16 -1.61
11/23/20 116.42 -0.64
11/30/20 122.07 4.85
12/7/20 122.23 0.13
12/14/20 126.47 3.47
12/21/20 131.77 4.19
12/28/20 132.49 0.55