FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Calculate the weights on the stocks that minimize risk using Excel's SOLVER. 2) Compute the optimal risky portfolio (e.g. maximize Sharpe ratio) 3) Use

1) Calculate the weights on the stocks that minimize risk using Excel's SOLVER.

2) Compute the optimal risky portfolio (e.g. maximize Sharpe ratio)

3) Use 5 points to draw the efficient frontier using these portfolios

Date AMZNRtrn QQQRtrn SPYRtrn VZRtrn MSFTRtrn WMTRtrn IBMRtrn
2012-01-04 -0.0085 0.0042 0.0016 -0.0131 0.0235 -0.0103 -0.0041
2012-01-05 0.0006 0.0082 0.0027 -0.0069 0.0102 -0.0049 -0.0047
2012-01-06 0.0282 0.0035 -0.0026 -0.0157 0.0155 -0.0071 -0.0115
2012-01-09 -0.0222 -0.0033 0.0024 0.0010 -0.0132 0.0031 -0.0052
2012-01-10 0.0044 0.0073 0.0087 0.0052 0.0036 -0.0024 -0.0015
2012-01-11 -0.0025 0.0021 0.0005 0.0086 -0.0043 0.0061 0.0056
2012-01-12 -0.0166 0.0040 0.0024 0.0005 0.0101 0.0017 -0.0097
2012-01-13 0.0142 -0.0036 -0.0052 0.0000 0.0089 0.0007 -0.0077
2012-01-17 0.0182 0.0091 0.0039 0.0026 0.0004 0.0052 0.0047
2012-01-18 0.0428 0.0133 0.0111 -0.0003 -0.0011 0.0027 0.0059
2012-01-19 0.0264 0.0062 0.0053 -0.0003 -0.0039 0.0100 -0.0030
2012-01-20 -0.0181 -0.0015 0.0006 -0.0008 0.0565 0.0066 0.0443
2012-01-23 -0.0253 0.0003 0.0005 -0.0146 0.0007 -0.0016 0.0077
2012-01-24 0.0049 -0.0018 -0.0011 -0.0159 -0.0131 0.0079 0.0103
2012-01-25 0.0043 0.0126 0.0084 -0.0026 0.0075 0.0013 -0.0010
2012-01-26 0.0294 -0.0035 -0.0051 -0.0093 -0.0020 -0.0081 -0.0039
2012-01-27 0.0106 0.0030 -0.0005 -0.0035 -0.0092 -0.0043 -0.0027
2012-01-30 -0.0165 0.0008 -0.0034 0.0107 0.0130 0.0097 0.0107
2012-01-31 0.0119 0.0013 -0.0004 0.0013 -0.0027 0.0010 0.0005
2012-02-01 -0.0770 0.0081 0.0088 0.0037 0.0122 0.0134 0.0001
2012-02-02 0.0126 0.0031 0.0016 -0.0063 0.0020 -0.0039 -0.0057
2012-02-03 0.0328 0.0137 0.0140 0.0075 0.0097 0.0015 0.0110
2012-02-06 -0.0242 -0.0008 -0.0007 0.0079 -0.0013 -0.0024 -0.0042
2012-02-07 0.0057 0.0021 0.0025 -0.0058 0.0050 -0.0031 0.0027
2012-02-08 0.0070 0.0053 0.0030 0.0000 0.0102 -0.0011 -0.0021
2012-02-09 -0.0027 0.0072 0.0013 0.0000 0.0036 0.0055 0.0009
2012-02-10 0.0030 -0.0070 -0.0074 -0.0061 -0.0088 -0.0010 -0.0037
2012-02-13 0.0326 0.0093 0.0074 0.0117 0.0026 -0.0018 0.0010
2012-02-14 -0.0015 0.0025 -0.0013 -0.0024 -0.0108 0.0070 -0.0021
2012-02-15 -0.0357 -0.0070 -0.0047 -0.0055 -0.0066 -0.0074 0.0002
2012-02-16 -0.0246 0.0137 0.0111 0.0058 0.0413 0.0045 0.0040
2012-02-17 0.0143 -0.0031 0.0026 0.0108 -0.0013 0.0071 0.0021
2012-02-21 -0.0013 0.0028 0.0004 0.0008 0.0061 -0.0386 -0.0002
2012-02-22 -0.0092 -0.0046 -0.0032 -0.0073 -0.0054 -0.0245 0.0025
2012-02-23 -0.0094 0.0066 0.0044 -0.0021 0.0032 -0.0010 0.0193
2012-02-24 0.0013 0.0035 0.0022 0.0003 0.0035 0.0043 0.0008
2012-02-27 -0.0033 0.0014 0.0017 -0.0003 -0.0041 -0.0056 -0.0012
2012-02-28 0.0295 0.0101 0.0029 0.0005 0.0166 0.0080 0.0023
2012-02-29 -0.0224 -0.0045 -0.0039 -0.0010 -0.0041 0.0025 -0.0063
2012-03-01 0.0019 0.0079 0.0052 0.0084 0.0173 -0.0044 0.0041
2012-03-02 -0.0041 -0.0008 -0.0030 0.0062 -0.0065 0.0032 0.0065
2012-03-05 0.0054 -0.0103 -0.0041 0.0085 -0.0087 0.0066 0.0093
2012-03-06 0.0046 -0.0098 -0.0146 -0.0079 -0.0075 -0.0072 -0.0169
2012-03-07 0.0148 0.0077 0.0070 0.0047 0.0089 0.0151 0.0026
2012-03-08 0.0211 0.0108 0.0099 0.0090 0.0053 -0.0015 0.0103
2012-03-09 -0.0177 0.0042 0.0039 -0.0031 -0.0006 0.0052 0.0041
2012-03-12 -0.0050 0.0005 0.0001 0.0056 0.0016 0.0100 0.0019
2012-03-13 0.0065 0.0186 0.0180 0.0041 0.0197 0.0053 0.0138
2012-03-14 -0.0126 0.0035 -0.0011 -0.0003 0.0031 0.0013 0.0046
2012-03-15 0.0119 0.0029 0.0058 0.0018 0.0024 0.0025 0.0063
2012-03-16 0.0034 -0.0024 -0.0030 0.0008 -0.0076 -0.0064 0.0000
2012-03-19 0.0025 0.0071 0.0039 0.0020 -0.0123 -0.0016 -0.0014
2012-03-20 0.0367 0.0018 -0.0029 -0.0005 -0.0065 -0.0023 -0.0071
2012-03-21 -0.0031 0.0001 -0.0016 0.0038 -0.0025 -0.0007 0.0022
2012-03-22 0.0035 -0.0021 -0.0072 -0.0030 0.0028 0.0015 0.0039
2012-03-23 0.0137 -0.0006 0.0032 -0.0061 0.0003 0.0016 0.0000
2012-03-26 0.0401 0.0175 0.0140 -0.0023 0.0181 0.0074 0.0111
2012-03-27 0.0127 0.0015 -0.0031 -0.0170 -0.0021 -0.0018 -0.0028
2012-03-28 -0.0208 -0.0040 -0.0050 -0.0103 -0.0101 0.0016 0.0005
2012-03-29 0.0172 -0.0038 -0.0017 -0.0050 -0.0022 -0.0060 0.0047
2012-03-30 -0.0103 -0.0019 0.0041 0.0042 0.0044 0.0062 0.0018
2012-04-02 -0.0220 0.0104 0.0073 0.0076 0.0009 0.0026 0.0039
2012-04-03 0.0081 -0.0003 -0.0041 -0.0016 -0.0108 -0.0116 0.0001
2012-04-04 -0.0284 -0.0136 -0.0099 -0.0018 -0.0229 -0.0064 -0.0165
2012-04-05 0.0021 0.0062 -0.0005 -0.0190 0.0099 0.0068 -0.0028
2012-04-09 -0.0130 -0.0075 -0.0112 -0.0053 -0.0133 -0.0089 -0.0026
2012-04-10 -0.0255 -0.0161 -0.0168 -0.0176 -0.0203 -0.0033 -0.0127
2012-04-11 0.0053 0.0048 0.0081 0.0158 -0.0039 -0.0022 0.0012
2012-04-12 0.0145 0.0114 0.0131 0.0045 0.0208 0.0057 0.0135
2012-04-13 -0.0117 -0.0152 -0.0119 -0.0077 -0.0055 -0.0062 -0.0123
2012-04-16 -0.0157 -0.0112 -0.0007 0.0046 0.0088 0.0136 -0.0004
2012-04-17 0.0156 0.0203 0.0148 0.0083 0.0116 0.0213 0.0233
2012-04-18 0.0142 -0.0025 -0.0034 -0.0021 -0.0095 0.0031 -0.0353
2012-04-19 0.0002 -0.0113 -0.0064 0.0130 -0.0042 -0.0050 -0.0031
2012-04-20 -0.0059 -0.0027 0.0017 0.0152 0.0455 0.0113 0.0005
2012-04-23 -0.0092 -0.0091 -0.0084 -0.0041 -0.0093 -0.0466 -0.0049
2012-04-24 0.0111 -0.0054 0.0038 0.0241 -0.0062 -0.0297 0.0069
2012-04-25 0.0215 0.0266 0.0137 -0.0005 0.0088 -0.0071 0.0178
2012-04-26 0.0081 0.0059 0.0070 0.0167 -0.0028 0.0277 0.0099
2012-04-27 0.1575 0.0060 0.0016 0.0022 -0.0040 0.0014 0.0060
2012-04-30 0.0223 -0.0071 -0.0037 0.0037 0.0013 -0.0020 0.0013
2012-05-01 -0.0080 0.0016 0.0062 0.0045 -0.0003 0.0027 0.0044
2012-05-02 0.0009 0.0028 -0.0030 0.0010 -0.0066 -0.0010 0.0003
2012-05-03 -0.0035 -0.0106 -0.0076 0.0010 -0.0013 -0.0003 -0.0039
2012-05-04 -0.0238 -0.0249 -0.0162 -0.0094 -0.0246 -0.0049 -0.0109
2012-05-07 0.0052 0.0009 0.0007 0.0067 -0.0107 0.0083 -0.0060
2012-05-08 -0.0056 -0.0037 -0.0040 0.0005 -0.0049 -0.0024 -0.0111
2012-05-09 -0.0041 -0.0031 -0.0059 -0.0074 0.0085 -0.0003 -0.0012
2012-05-10 0.0166 -0.0020 0.0021 0.0075 -0.0007 0.0027 -0.0031
2012-05-11 0.0044 -0.0002 -0.0030 0.0150 0.0137 0.0039 0.0028
2012-05-14 -0.0209 -0.0093 -0.0111 -0.0066 -0.0154 -0.0059 -0.0086
2012-05-15 0.0065 -0.0033 -0.0057 0.0039 -0.0153 0.0047 -0.0020
2012-05-16 -0.0015 -0.0068 -0.0038 -0.0041 -0.0103 -0.0027 0.0035
2012-05-17 -0.0254 -0.0211 -0.0148 0.0120 -0.0060 0.0421 -0.0092
2012-05-18 -0.0207 -0.0130 -0.0086 0.0039 -0.0151 0.0122 -0.0102
2012-05-21 0.0199 0.0280 0.0172 -0.0046 0.0164 0.0098 0.0096
2012-05-22 -0.0127 -0.0011 0.0017 0.0012 0.0003 0.0109 -0.0048
2012-05-23 0.0091 0.0019 0.0005 0.0000 -0.0218 0.0000 0.0000
2012-05-24 -0.0094 -0.0066 0.0020 0.0000 -0.0014 0.0210 -0.0037
2012-05-25 -0.0109 -0.0013 -0.0032 0.0014 -0.0003 0.0037 -0.0091
2012-05-29 0.0087 0.0127 0.0121 0.0072 0.0172 0.0057 0.0111
2012-05-30 -0.0257 -0.0084 -0.0145 -0.0079 -0.0074 -0.0037 -0.0098
2012-05-31 0.0176 -0.0043 -0.0022 0.0053 -0.0051 0.0058 -0.0084
2012-06-01 -0.0220 -0.0266 -0.0252 -0.0146 -0.0254 -0.0041 -0.0198
2012-06-04 0.0305 0.0076 -0.0005 0.0076 0.0035 0.0067 -0.0029
2012-06-05 -0.0063 0.0041 0.0076 -0.0034 -0.0014 -0.0074 0.0035
2012-06-06 0.0208 0.0229 0.0225 0.0138 0.0295 0.0066 0.0253
2012-06-07 0.0053 -0.0040 0.0006 -0.0031 -0.0041 -0.0009 0.0023
2012-06-08 -0.0015 0.0096 0.0080 0.0192 0.0144 0.0357 0.0036
2012-06-11 -0.0091 -0.0169 -0.0127 0.0028 -0.0253 -0.0101 -0.0135
2012-06-12 -0.0004 0.0121 0.0115 0.0089 0.0135 0.0028 0.0106
2012-06-13 -0.0078 -0.0069 -0.0064 0.0012 -0.0055 -0.0096 -0.0075
2012-06-14 -0.0013 0.0037 0.0106 0.0177 0.0072 0.0083 0.0104
2012-06-15 0.0182 0.0101 0.0050 -0.0046 0.0232 0.0018 0.0205
2012-06-18 0.0197 0.0094 0.0019 0.0062 -0.0060 0.0055 -0.0041
2012-06-19 0.0062 0.0104 0.0097 -0.0021 0.0288 -0.0046 0.0032
2012-06-20 -0.0045 0.0008 -0.0016 -0.0098 0.0075 0.0105 -0.0008
2012-06-21 -0.0109 -0.0249 -0.0224 0.0007 -0.0255 -0.0120 -0.0271
2012-06-22 0.0072 0.0105 0.0077 0.0143 0.0186 -0.0059 0.0016
2012-06-25 -0.0094 -0.0193 -0.0160 -0.0068 -0.0270 0.0131 -0.0043
2012-06-26 0.0252 0.0063 0.0050 0.0044 0.0050 0.0059 -0.0047
2012-06-27 0.0000 0.0061 0.0090 -0.0014 0.0050 0.0001 0.0055
2012-06-28 -0.0191 -0.0111 -0.0029 0.0043 -0.0086 -0.0042 -0.0083
2012-06-29 0.0318 0.0315 0.0249 0.0107 0.0227 0.0208 0.0218
2012-07-02 0.0042 0.0030 0.0030 0.0110 -0.0010 -0.0053 0.0013
2012-07-03 0.0009 0.0084 0.0066 0.0004 0.0065 0.0202 0.0005
2012-07-05 -0.0108 0.0006 -0.0045 -0.0013 -0.0020 0.0047 -0.0033
2012-07-06 -0.0089 -0.0125 -0.0095 -0.0105 -0.0166 0.0039 -0.0199
2012-07-09 0.0000 -0.0019 -0.0013 0.0072 -0.0063 0.0056 -0.0091
2012-07-10 -0.0247 -0.0098 -0.0087 -0.0009 -0.0087 0.0049 -0.0180
2012-07-11 -0.0051 -0.0055 0.0001 0.0045 -0.0148 0.0021 -0.0054
2012-07-12 -0.0138 -0.0094 -0.0048 -0.0051 -0.0229 0.0007 -0.0117
2012-07-13 0.0141 0.0152 0.0168 0.0121 0.0265 0.0120 0.0159
2012-07-16 -0.0109 -0.0028 -0.0024 0.0013 0.0017 -0.0027 -0.0066
2012-07-17 0.0043 0.0052 0.0069 0.0086 0.0075 0.0016 -0.0062
2012-07-18 0.0025 0.0135 0.0074 0.0050 0.0266 -0.0034 0.0250
2012-07-19 0.0400 0.0110 0.0026 -0.0294 0.0072 -0.0181 0.0377
2012-07-20 0.0094 -0.0132 -0.0091 -0.0011 -0.0179 0.0101 -0.0148
2012-07-23 -0.0100 -0.0121 -0.0101 -0.0031 -0.0279 -0.0055 -0.0084
2012-07-24 -0.0131 -0.0079 -0.0086 -0.0131 -0.0044 0.0040 -0.0026
2012-07-25 -0.0269 -0.0067 0.0002 -0.0011 -0.0110 -0.0008 0.0039
2012-07-26 0.0136 0.0133 0.0165 0.0169 0.0114 0.0221 0.0150
2012-07-27 0.0787 0.0237 0.0184 0.0099 0.0206 0.0115 0.0126
2012-07-30 -0.0052 -0.0008 0.0000 0.0011 -0.0040 0.0062 0.0015
2012-07-31 -0.0118 -0.0003 -0.0070 0.0042 -0.0057 -0.0073 -0.0036
2012-08-01 -0.0052 -0.0029 -0.0009 0.0016 -0.0020 -0.0109 -0.0041
2012-08-02 -0.0055 -0.0036 -0.0069 -0.0131 -0.0075 0.0058 -0.0037
2012-08-03 0.0180 0.0189 0.0198 -0.0036 0.0192 0.0068 0.0209
2012-08-06 -0.0042 0.0076 0.0019 0.0052 0.0067 -0.0036 0.0012
2012-08-07 0.0110 0.0083 0.0050 -0.0049 0.0104 -0.0039 0.0059
2012-08-08 -0.0092 -0.0005 0.0012 -0.0065 0.0023 0.0043 -0.0045
2012-08-09 -0.0014 0.0030 0.0009 0.0036 0.0056 -0.0062 -0.0031
2012-08-10 -0.0056 0.0006 0.0016 0.0059 -0.0026 -0.0023 0.0044
2012-08-13 -0.0013 0.0024 -0.0005 -0.0074 -0.0010 -0.0038 -0.0014
2012-08-14 0.0032 0.0004 0.0001 0.0014 -0.0086 0.0083 -0.0036
2012-08-15 0.0181 0.0025 0.0011 -0.0032 0.0023 0.0059 0.0006
2012-08-16 0.0174 0.0119 0.0074 -0.0016 0.0192 -0.0309 0.0123
2012-08-17 -0.0016 0.0044 0.0013 -0.0014 0.0039 -0.0022 0.0019
2012-08-20 -0.0034 0.0015 0.0001 -0.0082 -0.0052 0.0043 -0.0036
2012-08-21 -0.0037 -0.0039 -0.0030 -0.0185 0.0020 -0.0120 -0.0092
2012-08-22 0.0152 0.0041 0.0004 -0.0063 -0.0084 0.0048 -0.0070
2012-08-23 -0.0078 -0.0082 -0.0082 -0.0087 -0.0092 -0.0029 -0.0079
2012-08-24 0.0188 0.0062 0.0060 0.0218 0.0099 0.0077 0.0106
2012-08-27 -0.0074 0.0016 0.0002 -0.0095 0.0043 0.0054 -0.0105
2012-08-28 0.0090 0.0000 -0.0010 -0.0021 -0.0020 -0.0012 -0.0042
2012-08-29 0.0041 0.0000 0.0008 0.0098 0.0007 0.0050 0.0011
2012-08-30 -0.0036 -0.0101 -0.0072 -0.0074 -0.0108 -0.0071 -0.0088
2012-08-31 0.0083 0.0066 0.0048 0.0040 0.0165 0.0048 0.0077
2012-09-04 -0.0016 -0.0010 -0.0009 0.0177 -0.0140 0.0125 -0.0016
2012-09-05 -0.0067 -0.0010 -0.0009 0.0023 0.0000 0.0005 0.0026
2012-09-06 0.0210 0.0222 0.0203 0.0080 0.0316 0.0171 0.0208
2012-09-07 0.0309 -0.0014 0.0039 -0.0097 -0.0128 -0.0132 0.0020
2012-09-10 -0.0079 -0.0128 -0.0057 0.0078 -0.0074 -0.0042 0.0073
2012-09-11 -0.0055 -0.0016 0.0028 0.0041 0.0023 0.0075 0.0115
2012-09-12 -0.0002 0.0029 0.0033 0.0147 -0.0003 0.0001 0.0025
2012-09-13 0.0180 0.0136 0.0152 0.0154 0.0052 0.0144 0.0127
2012-09-14 0.0040 0.0089 0.0044 -0.0230 0.0087 -0.0085 0.0022
2012-09-17 -0.0125 0.0004 -0.0034 0.0011 0.0000 -0.0068 0.0016
2012-09-18 0.0029 0.0009 -0.0008 0.0074 -0.0010 -0.0005 -0.0004
2012-09-19 0.0113 0.0019 0.0005 0.0080 -0.0042 0.0057 -0.0031
2012-09-20 -0.0033 -0.0010 0.0001 0.0049 0.0129 0.0051 -0.0012
2012-09-21 -0.0128 -0.0026 -0.0057 0.0033 -0.0083 -0.0040 -0.0010
2012-09-24 -0.0104 -0.0058 -0.0015 0.0009 -0.0131 0.0039 -0.0033
2012-09-25 -0.0092 -0.0141 -0.0106 -0.0013 -0.0127 -0.0064 -0.0015
2012-09-26 -0.0111 -0.0081 -0.0056 -0.0007 -0.0072 -0.0009 -0.0048
2012-09-27 0.0277 0.0138 0.0094 0.0037 -0.0003 -0.0028 0.0094
2012-09-28 -0.0088 -0.0082 -0.0046 -0.0042 -0.0133 -0.0024 0.0075
2012-10-01 -0.0091 -0.0015 0.0026 0.0053 -0.0091 0.0034 0.0146
2012-10-02 -0.0056 0.0029 0.0010 0.0011 0.0058 -0.0041 -0.0030
2012-10-03 0.0212 0.0064 0.0041 0.0092 0.0067 0.0061 0.0032
2012-10-04 0.0178 0.0035 0.0072 0.0212 0.0057 0.0070 -0.0006
2012-10-05 -0.0075 -0.0053 0.0001 -0.0044 -0.0060 0.0055 0.0010
2012-10-08 0.0021 -0.0091 -0.0034 -0.0102 -0.0023 0.0016 -0.0037
2012-10-09 -0.0313 -0.0159 -0.0099 -0.0099 -0.0168 -0.0148 -0.0087
2012-10-10 -0.0238 -0.0051 -0.0064 -0.0072 -0.0102 0.0173 -0.0104
2012-10-11 -0.0031 -0.0031 0.0006 -0.0127 -0.0010 -0.0054 -0.0003
2012-10-12 -0.0076 -0.0004 -0.0033 -0.0128 0.0086 0.0107 0.0099
2012-10-15 0.0075 0.0073 0.0083 -0.0027 0.0106 0.0177 0.0054
2012-10-16 -0.0010 0.0141 0.0101 -0.0094 -0.0007 -0.0031 0.0099
2012-10-17 0.0146 -0.0006 0.0045 0.0145 0.0034 0.0016 -0.0491
2012-10-18 -0.0107 -0.0116 -0.0026 0.0237 -0.0030 -0.0061 -0.0283
2012-10-19 -0.0198 -0.0239 -0.0167 -0.0135 -0.0292 -0.0123 -0.0082
2012-10-22 -0.0259 0.0052 0.0001 -0.0086 -0.0223 0.0004 0.0054
2012-10-23 0.0023 -0.0095 -0.0139 -0.0156 0.0018 -0.0118 -0.0162
2012-10-24 -0.0248 -0.0035 -0.0028 0.0036 -0.0053 0.0008 -0.0028
2012-10-25 -0.0244 0.0000 0.0029 0.0005 -0.0007 0.0067 0.0046
2012-10-26 0.0687 0.0029 -0.0006 0.0108 0.0118 -0.0028 0.0087
2012-10-31 -0.0225 -0.0061 0.0000 -0.0020 0.0117 -0.0012 0.0065
2012-11-01 -0.0032 0.0142 0.0105 0.0112 0.0343 -0.0209 0.0135
2012-11-02 0.0012 -0.0106 -0.0089 -0.0137 -0.0007 -0.0093 -0.0189
2012-11-05 0.0082 0.0066 0.0020 -0.0072 0.0044 0.0051 0.0037
2012-11-06 0.0138 0.0018 0.0078 0.0023 0.0078 0.0085 0.0048
2012-11-07 -0.0232 -0.0236 -0.0227 -0.0251 -0.0261 -0.0088 -0.0200
2012-11-08 -0.0203 -0.0157 -0.0120 -0.0134 -0.0093 -0.0086 -0.0055
2012-11-09 -0.0046 0.0043 0.0009 0.0007 0.0007 -0.0023 -0.0024
2012-11-12 0.0007 -0.0002 0.0007 -0.0019 -0.0212 0.0024 -0.0021
2012-11-13 0.0006 -0.0069 -0.0034 -0.0005 -0.0400 -0.0092 -0.0049
2012-11-14 -0.0161 -0.0117 -0.0135 -0.0071 -0.0092 -0.0070 -0.0149
2012-11-15 -0.0105 -0.0034 -0.0017 -0.0128 -0.0067 -0.0363 0.0018
2012-11-16 0.0210 0.0044 0.0049 -0.0072 -0.0053 -0.0100 0.0059
2012-11-19 0.0199 0.0238 0.0202 0.0341 0.0079 0.0146 0.0182
2012-11-20 0.0177 0.0003 0.0004 0.0002 -0.0007 -0.0003 -0.0060
2012-11-21 0.0182 0.0020 0.0019 0.0079 0.0090 -0.0016 0.0058
2012-11-23 0.0078 0.0152 0.0136 0.0139 0.0278 0.0190 0.0168
2012-11-26 0.0156 0.0043 -0.0021 -0.0105 -0.0112 -0.0041 -0.0032
2012-11-27 -0.0009 -0.0034 -0.0051 -0.0074 -0.0113 -0.0059 -0.0086
2012-11-28 0.0152 0.0086 0.0081 0.0135 0.0103 0.0153 0.0039
2012-11-29 0.0168 0.0060 0.0047 0.0103 -0.0150 0.0038 -0.0023
2012-11-30 0.0031 -0.0017 0.0003 0.0025 -0.0122 0.0168 -0.0076
2012-12-03 -0.0068 -0.0020 -0.0050 -0.0005 -0.0071 -0.0094 -0.0031
2012-12-04 0.0086 -0.0006 -0.0014 -0.0098 -0.0023 0.0109 -0.0006
2012-12-05 0.0058 -0.0111 0.0018 0.0098 0.0114 -0.0065 -0.0037
2012-12-06 -0.0023 0.0065 0.0034 0.0079 0.0022 -0.0008 0.0056
2012-12-07 -0.0004 -0.0060 0.0030 -0.0009 -0.0101 0.0098 0.0119
2012-12-10 -0.0217 0.0029 0.0004 -0.0086 0.0181 -0.0019 0.0035
2012-12-11 0.0118 0.0131 0.0068 0.0093 0.0141 -0.0175 0.0082
2012-12-12 0.0043 -0.0021 0.0005 0.0079 -0.0029 -0.0275 -0.0064
2012-12-13 -0.0020 -0.0079 -0.0061 -0.0060 -0.0048 0.0015 -0.0050
2012-12-14 -0.0082 -0.0095 -0.0036 -0.0070 -0.0111 -0.0042 -0.0012
2012-12-17 0.0187 0.0133 0.0117 -0.0020 0.0108 0.0065 0.0097
2012-12-18 0.0258 0.0153 0.0111 -0.0057 0.0170 0.0043 0.0107
2012-12-19 -0.0093 -0.0044 -0.0074 -0.0112 -0.0091 -0.0141 -0.0031
2012-12-20 0.0136 0.0000 0.0058 0.0099 0.0135 0.0070 -0.0016
2012-12-21 -0.0175 -0.0160 -0.0161 -0.0055 -0.0083 -0.0051 -0.0069
2012-12-24 0.0066 -0.0020 -0.0031 -0.0007 -0.0142 -0.0012 -0.0053
2012-12-26 -0.0386 -0.0088 -0.0042 -0.0021 -0.0074 -0.0085 -0.0023
2012-12-27 -0.0013 -0.0016 -0.0013 0.0007 0.0037 0.0029 0.0040
2012-12-28 -0.0126 -0.0096 -0.0108 -0.0133 -0.0152 -0.0085 -0.0149
2012-12-31 0.0232 0.0212 0.0170 0.0086 0.0060 0.0092 0.0091



Step by Step Solution

★★★★★

3.43 Rating (166 Votes )

There are 3 Steps involved in it

Step: 1

I can guide you on how to approach these finance questions step by step First lets tackle the task o... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Service Systems Engineering And Management

Service Systems Engineering And Management

Authors: A. Ravi Ravindran ,Paul M. Griffin ,Vittaldas V. Prabhu

1st Edition

0367781328, 978-0367781323

More Books

Students also viewed these Finance questions

Question

3. ) Figure shows a a If it has an extra positive charge of spherical nonconducting sphere. 1uC, at which Location the electric potential is the maximum - A, G or C? A Why?

Answered: 1 week ago

Question

★★★★★
Estimate the maximum completely reversed bending moment that can be applied to the ends of the plate shown in Figure 4.40 if the plate is machined from AISI 4320 steel having S_u = 140 ksi and S_y =...

Answered: 1 week ago

Question

★★★★★
A 6.0kg block, starting from rest, slides down a frictionless incline of length 2.0m. when it arrives at the bottom of the incline it's speed vf. At what distance from the top of the incline is the...

Answered: 1 week ago

Question

★★★★★
Why is an investment portfolio containing a mix of stocks and bonds less risky than one containing a single asset class? Because the markets for stocks and bonds tend to move in the same direction at...

Answered: 1 week ago

Question

★★★★★
In planning the audit of a client's inventory, an auditor identified the following issues that need audit attention. 1. Inventories are properly stated at the lower of cost or market. 2. Inventories...

Answered: 1 week ago

Question

★★★★★
The fluorescence emitted in XRF is also in the X-ray range of the spectrum, but is always at lower energies than the X-rays used to initiate the process. Explain why this must be true.

Answered: 1 week ago

Question

★★★★★
When a salesman visits a certain town, he stays in one of three available hotels, H1, H2, H3. Let Ai be the event that he stays in Hotel Hi, for i = 1, 2, 3. If it is known that find the probability...

Answered: 1 week ago

Question

★★★★★
Many of a banks customers use its automatic teller machine to transact business after normal banking hours. During the early evening hours in the summer months, customers arrive at a certain location...

Answered: 1 week ago

Question

★★★★★
Using the information listed in the table Below, Record the Vendors invoices to the Purchases Journal, General Ledgers and Accounts payable subsidiary ledger, do not forget to label each of the...

Answered: 1 week ago

Question

★★★★★
Bruin Corporation has been authorized to issue 5,000 shares of 12 percent noncumulative, nonparticipating preferred stock with a par value of $100 per share and 200,000 shares of common stock with a...

Answered: 1 week ago

Question

★★★★★
Gibson Guitars in Nashville TN has been evaluating new automated paint processes, to implement in a new facility quality-improvement project. Your supervisor has tasked you with negotiating with all...

Answered: 1 week ago

Question

★★★★★
Ratino is working on how to process criticism at work so he can influence the conversation to a solution. What is the last step in this process? Select an answer: He should assume positive intent. He...

Answered: 1 week ago

Question

★★★★★
Brad Gokool is reviewing the results of the subsequent events audit procedures. Brad is writing a report for his audit partner based on these results and will be attending a meeting tomorrow with the...

Answered: 1 week ago

Question

★★★★★
Which techniques are recommended when communicating data-informed decisions? Select all that apply. a. Defining the problem. b. Assigning blame for the problem. c. Supporting the solution with data....

Answered: 1 week ago

Question

★★★★★
To which QoS policy action is the RADIUS attribute format "bw-rpct" equivalent? bandwidth bandwidth percentage bandwidth remaining percent bandwidth allowed

Answered: 1 week ago

Question

★★★★★
Heidi has been a client for some years, operating a traditional retail business. She has now made the decision to operate online as well and seeks your advice as to undertaking online transactions....

Answered: 1 week ago

Question

★★★★★
ELN Waste Management has a subsidiary that disposes of hazardous waste and a subsidiary that collects and disposes of residential garbage. information related to the two subsidiaries follows:...

Answered: 1 week ago

Question

★★★★★
Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1

Answered: 1 week ago

Question

★★★★★
Discuss various factors a consumer would consider in selecting a payment mode.

Answered: 1 week ago

Question

★★★★★
Consider the data given in Table 1.8 (Example 1.3) again. Draw the histograms for the following problem areas: a. No-shows b. Overtime days c. Medical errors What can you conclude based on the above...

Answered: 1 week ago

Question

★★★★★
Solve for the optimal inputs for Example 4.9. Example 4.9: Consider the CobbDouglas production function considered in Example 4.5. Suppose that a unit of x1 is $10 and a unit of x2 is $20. Further,...

Answered: 1 week ago

Question

★★★★★
Suppose that the weight W of male patients registered at a diet clinic has the normal distribution with mean 190 and variance 100. a. For a random sample of patients of size n = 25, the expression P(...

Answered: 1 week ago

Question

★★★★★
Chao et al. (2001) report data on an outbreak of Hepatitis A virus among students of a college. Investigators want to estimate N, the total number of students with Hepatitis A. Cases were reported...

Answered: 1 week ago

Question

★★★★★
A university wishes to estimate the proportion of its students who have used cocaine. Students were classified into one of three groups: undergraduate, graduate, or professional school (medical or...

Answered: 1 week ago

Previous Question Next Question