Finance Memo / Excel assignment

Conde_Nast
FinancialAnalysisApplication-Data.xlsx
Home>Business & Finance homework help>Management homework help>Finance Memo / Excel assignment

Sheet1

Date Risk-free AEP IDA PNY S&P500
7/25/16 0.0005 69.30 80.85 59.80 217.12
7/18/16 0.0004 70.06 81.59 59.86 217.24
7/11/16 0.0004 69.64 80.49 59.88 215.83
7/5/16 0.0004 70.71 81.31 59.91 212.65
6/27/16 0.0004 70.14 81.44 60.05 209.92
6/20/16 0.0004 67.26 75.61 59.55 203.24
6/13/16 0.0004 67.21 75.00 59.64 206.52
6/6/16 0.0004 66.85 75.38 59.99 208.98
5/31/16 0.0004 65.81 74.23 59.75 209.19
5/23/16 0.0004 64.31 72.89 59.62 209.15
5/16/16 0.0004 63.80 70.93 59.52 204.43
5/9/16 0.0004 65.61 73.91 59.61 203.70
5/2/16 0.0004 64.56 72.97 59.57 204.66
4/25/16 0.0004 62.95 72.22 59.46 205.26
4/18/16 0.0004 62.20 70.59 59.36 207.89
4/11/16 0.0004 65.48 73.49 59.46 206.71
4/4/16 0.0004 65.44 72.58 59.52 203.44
3/28/16 0.0004 66.43 74.27 59.56 205.85
3/21/16 0.0004 64.50 73.60 59.21 202.07
3/14/16 0.0004 64.23 72.78 59.22 203.32
3/7/16 0.0004 63.68 73.48 59.10 200.68
2/29/16 0.0004 61.89 71.64 58.81 198.37
2/22/16 0.0004 60.94 70.79 58.82 193.08
2/16/16 0.0004 61.38 71.28 58.78 190.03
2/8/16 0.0004 60.08 69.11 58.52 184.71
2/1/16 0.0004 61.74 68.87 58.42 186.02
1/25/16 0.0004 59.91 68.60 58.57 191.73
1/19/16 0.0004 57.51 66.51 57.31 188.56
1/11/16 0.0004 57.67 65.55 57.34 185.88
1/4/16 0.0004 57.24 66.32 57.08 189.95
12/28/15 0.0004 57.25 67.03 56.38 201.77
12/21/15 0.0004 57.38 67.83 56.30 203.57
12/14/15 0.0004 55.30 67.48 55.76 197.96
12/7/15 0.0004 53.61 65.21 56.04 198.62
11/30/15 0.0004 54.87 67.36 57.24 206.24
11/23/15 0.0004 54.96 66.43 57.14 206.18
11/16/15 0.0004 55.55 66.43 56.79 205.93
11/9/15 0.0004 54.10 64.16 56.57 199.27
11/2/15 0.0004 53.02 64.18 56.67 206.65
10/26/15 0.0004 55.11 65.40 56.33 204.58
10/19/15 0.0004 55.92 67.43 41.50 204.16
10/12/15 0.0003 56.95 66.81 41.36 199.99
10/5/15 0.0003 55.20 64.68 40.23 198.08
9/28/15 0.0003 54.79 63.23 39.94 191.85
9/21/15 0.0003 54.47 62.25 38.61 189.76
9/14/15 0.0003 53.97 60.02 37.07 192.30
9/8/15 0.0003 52.32 57.43 36.04 192.56
8/31/15 0.0003 51.11 56.35 35.42 188.50
8/24/15 0.0003 53.41 58.88 37.68 195.05
8/17/15 0.0003 55.73 61.80 38.28 193.63
8/10/15 0.0003 56.62 62.31 38.86 204.98
8/3/15 0.0003 55.23 60.56 37.44 203.54
7/27/15 0.0003 54.52 60.30 37.04 206.03
7/20/15 0.0003 52.62 56.39 35.30 203.59
7/13/15 0.0003 53.70 56.80 36.17 207.96
7/6/15 0.0003 53.54 56.38 35.99 203.08
6/29/15 0.0003 52.26 55.67 34.87 202.92
6/22/15 0.0003 50.99 55.13 34.82 205.37
6/15/15 0.0003 52.49 55.78 35.85 206.34
6/8/15 0.0003 51.97 54.41 35.10 204.56
6/1/15 0.0003 51.50 54.86 34.81 204.32
5/26/15 0.0003 54.25 57.74 36.02 205.66
5/18/15 0.0003 53.63 57.86 35.75 207.46
5/11/15 0.0003 53.58 57.58 35.87 206.93
5/4/15 0.0003 53.78 57.40 35.25 206.13
4/27/15 0.0003 54.44 58.12 35.68 205.25
4/20/15 0.0003 55.25 60.39 36.81 206.16
4/13/15 0.0003 53.20 59.62 35.00 202.55
4/6/15 0.0003 53.83 60.50 36.03 204.59
3/30/15 0.0003 53.90 60.84 36.10 201.08
3/23/15 0.0003 53.36 59.02 35.32 200.40
3/16/15 0.0003 55.08 60.55 35.79 204.95
3/9/15 0.0003 52.80 57.94 34.45 199.60
3/2/15 0.0003 52.51 57.76 33.69 201.22
2/23/15 0.0004 54.97 60.32 35.71 204.28
2/17/15 0.0004 56.05 61.23 36.22 204.84
2/9/15 0.0004 55.20 59.29 36.11 203.43
2/2/15 0.0004 56.46 62.27 37.15 199.32
1/26/15 0.0004 59.45 64.97 38.19 193.41
1/20/15 0.0004 61.07 66.54 38.95 198.76
1/12/15 0.0004 60.17 65.17 38.72 195.52
1/5/15 0.0004 58.34 63.01 37.92 198.06
12/29/14 0.0004 57.88 63.44 37.76 199.21
12/22/14 0.0004 58.67 64.70 37.89 202.13
12/15/14 0.0004 56.69 62.82 36.60 200.26
12/8/14 0.0004 55.55 59.74 35.97 193.74
12/1/14 0.0004 54.67 59.98 36.07 200.59
11/24/14 0.0003 54.47 59.42 35.58 199.82
11/17/14 0.0003 54.35 59.10 35.61 199.32
11/10/14 0.0003 53.06 58.22 34.91 196.97
11/3/14 0.0003 55.20 59.84 35.82 196.10
10/27/14 0.0003 54.73 60.04 36.09 194.48
10/20/14 0.0004 52.97 56.91 34.70 189.43
10/13/14 0.0004 51.23 54.14 33.67 181.76
10/6/14 0.0004 50.55 52.47 32.94 183.75
9/29/14 0.0004 49.60 51.38 32.33 189.52
9/22/14 0.0004 49.02 51.18 32.12 190.85
9/15/14 0.0004 49.98 52.38 33.17 193.55
9/8/14 0.0004 49.23 52.35 33.38 191.15
9/2/14 0.0005 50.53 53.92 34.94 193.05
8/25/14 0.0005 50.38 53.86 35.19 192.66
8/18/14 0.0005 49.29 52.81 34.86 191.20
8/11/14 0.0005 48.24 51.87 34.38 187.87
8/4/14 0.0005 47.39 50.72 33.25 185.49
7/28/14 0.0005 48.59 51.04 32.54 184.78
7/21/14 0.0005 49.43 51.41 33.22 189.79
7/14/14 0.0005 50.52 52.05 34.05 189.78
7/7/14 0.0006 50.45 52.36 34.27 188.73
6/30/14 0.0005 49.94 52.97 34.51 190.25
6/23/14 0.0006 51.39 53.69 34.92 187.97
6/16/14 0.0006 50.60 54.10 34.58 188.08
6/9/14 0.0005 49.03 51.41 33.86 185.46
6/2/14 0.0005 50.22 52.38 34.03 186.65
5/27/14 0.0005 49.55 51.65 33.38 184.07
5/19/14 0.0005 47.75 50.86 32.81 181.85
5/12/14 0.0005 48.95 51.32 32.78 179.65
5/5/14 0.0005 48.60 51.70 32.31 179.56
4/28/14 0.0005 48.61 51.24 32.59 179.66
4/21/14 0.0005 49.11 52.26 33.43 177.97
4/14/14 0.0005 47.60 51.77 33.38 178.06
4/7/14 0.0005 46.83 50.92 32.95 173.40
3/31/14 0.0005 46.72 51.21 33.19 178.07
3/24/14 0.0005 46.00 51.33 32.50 177.20
3/17/14 0.0006 44.98 51.13 32.36 177.88
3/10/14 0.0006 46.11 51.78 32.30 175.63
3/3/14 0.0006 45.39 51.88 31.65 179.06
2/24/14 0.0006 46.19 52.52 31.26 177.19
2/18/14 0.0006 46.52 52.04 31.04 174.90
2/10/14 0.0006 46.11 50.69 30.82 175.03
2/3/14 0.0005 44.19 47.62 30.11 170.90
1/27/14 0.0005 44.44 48.89 30.52 169.47
1/21/14 0.0005 42.58 48.38 30.42 170.15
1/13/14 0.0005 42.58 48.29 30.01 174.66
1/6/14 0.0005 42.97 49.12 30.06 175.14
12/30/13 0.0005 41.98 47.30 29.93 173.95
12/23/13 0.0005 42.34 48.33 30.39 174.86
12/16/13 0.0005 42.54 48.87 30.82 172.69
12/9/13 0.0005 41.70 47.73 29.54 168.49
12/2/13 0.0005 42.88 49.04 29.99 171.17
11/25/13 0.0005 42.85 47.91 30.35 171.22
11/18/13 0.0005 43.43 47.60 30.52 171.04
11/11/13 0.0005 43.56 47.17 30.40 170.33
11/4/13 0.0005 42.11 46.86 30.46 167.71
10/28/13 0.0005 42.37 47.46 30.82 166.69
10/21/13 0.0005 42.59 48.20 31.51 166.45
10/14/13 0.0005 40.37 47.23 30.84 164.97
10/7/13 0.0005 39.87 46.08 30.01 161.06
9/30/13 0.0005 39.04 44.26 29.19 159.77
9/23/13 0.0005 39.13 44.48 29.90 159.79
9/16/13 0.0005 39.39 44.08 30.20 161.50
9/9/13 0.0005 38.39 43.02 29.66 159.41
9/3/13 0.0005 38.33 42.30 28.97 156.31
8/26/13 0.0005 38.55 44.01 29.26 154.06
8/19/13 0.0005 38.87 44.69 29.82 156.86
8/12/13 0.0005 39.01 45.70 29.46 156.11
8/5/13 0.0005 40.53 48.26 31.05 159.39
7/29/13 0.0005 41.51 48.54 31.46 160.93
7/22/13 0.0005 41.41 47.94 31.79 159.20
7/15/13 0.0005 42.01 47.99 31.84 159.26
7/8/13 0.0005 41.48 46.50 31.23 157.69
7/1/13 0.0005 39.46 44.11 30.28 153.47
6/24/13 0.0005 39.90 43.59 30.60 151.02
6/17/13 0.0005 39.01 42.85 29.96 149.75
6/10/13 0.0005 40.55 43.96 30.70 152.81
6/3/13 0.0005 41.12 44.29 30.47 154.33
5/28/13 0.0005 40.83 43.11 30.37 153.06
5/20/13 0.0005 42.51 44.24 30.63 154.80
5/13/13 0.0004 44.23 45.32 31.33 156.33
5/6/13 0.0004 43.50 43.82 30.46 153.02
4/29/13 0.0004 45.08 44.09 30.74 151.11
4/22/13 0.0005 44.60 43.56 30.41 148.18
4/15/13 0.0005 44.07 43.49 31.14 145.60
4/8/13 0.0004 44.11 43.93 30.89 148.71
4/1/13 0.0004 42.99 43.39 30.00 145.30
3/25/13 0.0004 42.92 43.71 29.55 146.71
3/18/13 0.0004 42.24 42.92 29.65 145.71
3/11/13 0.0004 42.27 43.25 29.90 145.93
3/4/13 0.0004 41.91 43.21 29.63 144.92
2/25/13 0.0004 41.22 42.32 29.08 141.81
2/19/13 0.0004 40.75 42.33 28.94 141.61
2/11/13 0.0004 39.83 42.31 28.52 141.81
2/4/13 0.0004 39.33 42.23 28.64 141.52
1/28/13 0.0003 39.51 41.99 28.54 141.00
1/22/13 0.0003 38.83 40.61 29.16 140.08
1/14/13 0.0004 38.00 39.28 29.12 138.29
1/7/13 0.0004 37.76 39.11 28.05 137.11
12/31/12 0.0004 38.03 39.18 28.71 136.46
12/24/12 0.0004 36.86 38.06 27.36 130.55
12/17/12 0.0004 37.94 39.73 28.87 133.12
12/10/12 0.0004 37.41 38.65 27.72 131.55
12/3/12 0.0004 37.79 38.67 27.68 131.83
11/26/12 0.0004 37.25 38.36 27.23 131.59
11/19/12 0.0004 35.83 36.94 26.18 130.85
11/12/12 0.0004 36.26 36.94 25.80 126.24
11/5/12 0.0004 36.50 38.17 26.33 127.90
10/31/12 0.0004 38.21 39.77 27.52 131.05
10/22/12 0.0004 37.96 39.62 27.85 130.85
10/15/12 0.0004 38.85 39.68 28.45 132.74
10/8/12 0.0004 38.11 38.96 27.60 132.28
10/1/12 0.0004 38.20 39.01 28.45 135.29
9/24/12 0.0004 37.96 38.53 28.65 133.28
9/17/12 0.0005 38.02 38.52 29.10 135.04
9/10/12 0.0004 37.71 37.70 28.44 135.58
9/4/12 0.0005 37.54 38.19 28.07 132.90
8/27/12 0.0005 37.13 36.91 27.30 129.98
8/20/12 0.0004 36.97 37.26 27.37 130.31
8/13/12 0.0005 37.20 37.91 28.04 130.92
8/6/12 0.0004 37.62 37.71 27.70 129.69
7/30/12 0.0004 36.16 38.00 27.82 128.32
7/23/12 0.0004 36.23 37.76 27.79 127.70
7/16/12 0.0004 35.81 38.00 28.24 125.66
7/9/12 0.0004 35.61 38.38 28.32 125.00
7/2/12 0.0004 34.99 37.43 28.45 124.76
6/25/12 0.0004 34.08 37.17 28.14 125.32
6/18/12 0.0004 33.53 35.86 28.09 122.89
6/11/12 0.0004 34.11 36.24 27.92 123.52
6/4/12 0.0004 33.93 35.85 27.50 121.93
5/29/12 0.0004 32.79 34.45 25.90 117.40
5/21/12 0.0004 32.65 34.57 25.62 121.01
5/14/12 0.0004 32.24 33.82 25.50 118.85
5/7/12 0.0004 32.84 34.62 25.88 124.23
4/30/12 0.0004 32.55 34.29 25.41 125.50
4/23/12 0.0004 32.65 35.80 26.22 128.61
4/16/12 0.0004 32.34 34.82 25.80 126.37
4/9/12 0.0004 31.48 34.50 25.43 125.63
4/2/12 0.0004 32.05 35.80 26.67 128.06
3/26/12 0.0004 32.55 36.03 26.91 128.99
3/19/12 0.0004 32.47 35.39 26.99 127.93
3/12/12 0.0004 32.68 35.74 27.05 128.52
3/5/12 0.0004 32.24 36.05 27.72 125.47
2/27/12 0.0004 32.03 35.24 27.21 125.24
2/21/12 0.0004 31.83 35.97 28.62 124.89
2/13/12 0.0004 33.52 36.67 28.86 124.42
2/6/12 0.0004 33.16 36.46 28.51 122.55
1/30/12 0.0004 33.00 36.90 29.02 122.71
1/23/12 0.0004 33.31 36.76 28.45 120.23
1/17/12 0.0003 34.19 35.99 28.06 120.35
1/9/12 0.0003 34.49 36.29 28.15 117.51
1/3/12 0.0003 34.01 35.82 28.62 116.48
12/27/11 0.0004 34.44 36.87 29.15 114.47
12/19/11 0.0004 34.66 36.73 29.18 115.28
12/12/11 0.0004 33.07 35.76 28.51 110.90
12/5/11 0.0004 33.13 35.46 28.03 114.24
11/28/11 0.0004 32.73 35.36 27.53 113.16
11/21/11 0.0003 31.02 33.27 25.45 105.44
11/14/11 0.0003 32.15 35.03 27.01 110.55
11/7/11 0.0004 32.95 35.93 27.24 114.80
10/31/11 0.0004 32.71 35.15 27.03 113.73
10/24/11 0.0003 32.48 35.59 28.31 116.55
10/17/11 0.0003 32.24 35.06 26.88 112.36
10/10/11 0.0004 31.85 34.52 26.00 111.09
10/3/11 0.0004 31.10 33.35 24.62 104.87
9/26/11 0.0003 31.33 32.60 24.57 102.55
9/19/11 0.0003 30.86 32.47 24.11 102.90
9/12/11 0.0003 30.91 33.70 25.50 110.14
9/6/11 0.0003 30.32 30.95 25.66 104.52
8/29/11 0.0003 31.29 31.39 25.65 106.26
8/22/11 0.0003 30.95 31.72 25.23 106.37
8/15/11 0.0003 30.53 30.92 23.59 101.56
8/8/11 0.0003 29.46 31.20 24.16 106.50
8/1/11 29.48 31.66 23.62 108.27

Sheet2

Sheet3