Question: See the table to solve Question 1 10 pts Consider that on January 2, 2014 (Wednesday) you decide to invest in a portfolio consisting of

 See the table to solve Question 1 10 pts Consider that

on January 2, 2014 (Wednesday) you decide to invest in a portfolio

See the table to solve

consisting of these 10 stocks. You want to find the optimal portfolio

to invest in, so you analyze the performance of these 10 stocks

over time (using past historical data from January 3, 2011 to December31, 2013). Please construct the optimal portfolio if short selling is allowed.Use the 3-month T-bill rate as a proxy for the risk-free rate.Assume that riskless borrowing/lending is possible (Hint: Use the borrowing/lending rate onJanuary 2, 2014 - use the specific value provided in the Excelfile for this assignment). Please solve this part using Excel Solver (GRGNonlinear Method). What is the proportion of your funds invested in Tesla?

Please report the full number (not the %), rounded to three decimals.

Question 2 10 pts Please construct the optimal portfolio if short selling

is not allowed. Solve this part using Excel Solver (GRG Nonlinear Method).

What is the proportion of your funds invested in Accenture PLC Ireland?Please report the full number (not the %), rounded to three decimals.

0.3439 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM

Returns ACN Returns_XRX Returns_BRK _3monthTbill 16-Feb-11 2.6979 8.275 -0.6723 0.1853 0.8678 0.76372.7313 2.71 -0.0235 0.12 17-Feb-11 0.5141 -0.5599 -4.5693 -1.4382 0.5382 0.227 -0.2455

Question 1 10 pts Consider that on January 2, 2014 (Wednesday) you decide to invest in a portfolio consisting of these 10 stocks. You want to find the optimal portfolio to invest in, so you analyze the performance of these 10 stocks over time (using past historical data from January 3, 2011 to December 31, 2013). Please construct the optimal portfolio if short selling is allowed. Use the 3-month T-bill rate as a proxy for the risk-free rate. Assume that riskless borrowing/lending is possible (Hint: Use the borrowing/lending rate on January 2, 2014 - use the specific value provided in the Excel file for this assignment). Please solve this part using Excel Solver (GRG Nonlinear Method). What is the proportion of your funds invested in Tesla? Please report the full number (not the %), rounded to three decimals. Question 2 10 pts Please construct the optimal portfolio if short selling is not allowed. Solve this part using Excel Solver (GRG Nonlinear Method). What is the proportion of your funds invested in Accenture PLC Ireland? Please report the full number (not the %), rounded to three decimals. 0.3439 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM Returns ACN Returns_XRX Returns_BRK _3monthTbill 16-Feb-11 2.6979 8.275 -0.6723 0.1853 0.8678 0.7637 2.7313 2.71 -0.0235 0.12 17-Feb-11 0.5141 -0.5599 -4.5693 -1.4382 0.5382 0.227 -0.2455 1.1796 0 -0.0353 0.09 18-Feb-11 0.3653 0.0433 -1.7797 - 1.2876 1.907 0.7392 -0.2675 -0.7957 -0.4398 0.1413 0.1 22-Feb-11 -1.7532 0.4329 -5.6514 -6.6087 -0.6402 1.1124 -2.6931 -2.313 -3.9753 -2.2105 0.12 23-Feb-11 - 1.0929 -0.3879 -0.1829 2.6071 -0.1817 1.9078 -0.5734 -2.1195 -1.7479 -0.3727 0.12 24-Feb-11 0.3683 -0.6058 3.2066 0.9982 -1.804 -1.2633 -0.0776 0.9559 -0.6554 0.6034 0.13 25-Feb-11 0.9392 -0.4789 4.7936 -0.0898 0.4551 -0.7328 1.8313 0.8309 1.0368 1.8114 0.13 28-Feb-11 -0.2465 0.175 1.1859 1.0791 0.5537 0.2226 1.6894 - 1.3415 0.2798 2.8396 0.15 1-Mar-11 - 1.1799 -0.7424 0.2093 -5.605 - 1.1847 -0.8535 -0.493 -0.6216 - 1.2093 -2.3258 0.14 2-Mar-11 0.1188 -0.9239 0.3342 -4.3355 -0.6923 0.3302 -1.411 -0.0195 -0.7533 -0.2698 0.13 3-Mar-11 2.0729 2.2202 1.4155 1.0837 0.4081 0.8698 0.7211 3.6755 1.2334 1.976 0.13 4-Mar-11 - 1.0093 2.5195 2.422 -3.4113 0.2202 -0.8623 -1.3017 -0.7166 -1.687 - 1.3841 0.12 7-Mar-11 - 1.1741 0.1695 -0.0401 1.8164 -0.3717 -0.4231 -2.1651 -0.4938 -0.9533 -0.538 0.11 8-Mar-11 1.4694 0.2961 - 1.1227 9.7126 0.7802 -0.1416 1.0896 -0.2481 1.6843 1.5404 0.11 9-Mar-11 2.2061 0.0844 0.2433 -1.7163 0.5757 -0.26 -0.5001 -0.421 -0.8045 -0.3822 0.1 10-Mar-11 -2.3152 0.885 -2.8722 2.7574 -1.4815 -3.5553 -2.256 - 1.249 -1.4313 - 1.209 0.08 11-Mar-11 0.253 -0.1253 0.2499 0.4472 0.6152 0.9093 -2.1366 0.3697 0.6776 0.3766 0.08 14-Mar-11 -0.6403 -0.2091 -3.4067 -2.3152 -0.034 0.3166 -4.5768 -0.252 -0.6731 - 1.2778 0.09 15-Mar-11 - 1.4685 - 1.2903 -2.5524 -0.5776 -1.2017 -0.416 -2.7794 -1.4521 -2.0069 0.1 16-Mar-11 -3.7857 - 2 -0.5665 -4.5837 -0.8031 -2.5556 - 1.2041 -2.0792 -3.0452 -1.9026 0.1 17-Mar-11 0.7712 0.8929 -0.0438 -3.3333 1.0853 2.3326 2.052 0.0817 2.7356 2.1989 0.08 18-Mar-11 1.1091 0.5478 0.6576 3.854 - 1.0566 -0.382 -0.6093 2.5092 -0.1972 0.9066 0.07 21-Mar-11 1.1482 -0.9221 -1.0017 -0.6836 1.5329 2.4613 2.6851 0.199 1.2846 2.0244 0.1 22-Mar-11 0.2029 0.0423 -2.3757 -1.6716 -1.1366 -0.338 -0.8955 0 - 1.0732 -0.2231 0.1 23-Mar-11 0.9684 -0.6342 0.0901 -0.9 0.2574 0.0485 - 1.0361 0.6356 0.8876 -0.2824 0.09 24-Mar-11 0.3197 1.5745 0.5403 1.0091 0.6846 0.1574 -1.1566 2.5459 0.2933 0.4956 0.09 25-Mar-11 1.3372 -0.7122 1.8809 -2.0979 0.255 1.0758 -0.5296 4.4842 3.9961 0.0939 0.09 28-Mar-11 -0.4994 -0.0844 2.1978 1.1224 -0.1187 -0.1794 0.6649 - 1.3078 -0.2812 - 1.0206 0.11 29-Mar-11 0.9357 2.1537 2.8817 -1.2109 0.5941 -0.2636 - 1.0428 1.2878 0.4934 0.403 0.1 30-Mar-11 0.442 0.4134 -0.8779 1.5322 0.2194 1.4895 1.5682 0.9582 0.0939 0.8854 0.1 31-Mar-11 -0.324 - 1.3174 17.0392 -1.4084 0.1515 -0.4261 -0.877 0.3285 -0.0938 -2.1414 0.09 0.5868 -0.5006 0.1627 DATE Returns IBM Returns_KR Returns_TSLA Returns_DAL Returns_TRV Returns XOM ReturnsTM Returns ACN Returns XRX Returns_BRK 1-Apr-11 0.7359 -0.9178 -3.9279 0.2041 0.3867 0.6538 0.324 -0.1819 2.1596 0.0598 4-Apr-11 -0.0122 0.5474 -3.1133 0.1018 -0.134 0.2244 - 1.2793 0.3645 -0.3676 -0.6931 5-Apr-11 -0.1583 -0.3769 3.3682 -1.3225 -0.8385 0.648 -2.3276 -0.2542 0 - 1.2756 6-Apr-11 0.0305 0.7566 -0.7865 -1.134 1.3699 -0.281 -0.3607 -0.4551 0.0923 -0.0609 7-Apr-11 0.2073 0.5841 2.8313 -1.877 -0.2502 0.6809 -0.181 0.2926 0 -0.0732 8-Apr-11 -0.2008 -0.4562 -2.7533 -3.932 -0.3512 0.2215 0.8678 0.4741 - 1.3825 -0.1587 11-Apr-11 -0.061 0.9583 -4.6055 4.3142 1.4099 -0.9191 -1.772 1.6334 0.8411 0.5623 12-Apr-11 -0.427 -0.4952 -2.4535 4.9841 - 1.2082 -2.325 0.915 -0.2857 -0.278 -0.7051 13-Apr-11 0.4288 0.3733 1.1359 -3.2323 0.4021 -0.024 1.0104 2.0774 -0.2788 - 1.1263 14-Apr-11 0.6221 2.0661 0.8424 -2.4008 0.3367 -0.1282 - 1.7507 0.1864 -0.0248 15-Apr-11 0.7517 -0.6478 1.7502 - 1.0695 0.2851 1.0187 -0.3082 -1.6019 -0.1861 0.1858 18-Apr-11 -0.1624 0.163 -2.1501 - 1.1892 -1.3211 -1.4118 -0.5023 -0.3292 -0.5592 -0.7294 19-Apr-11 -0.3254 0.5194 -0.1094 -1.4065 0.8424 - 1.4628 1.67 - 1.1246 0.2491 20-Apr-11 -0.393 -1.5435 2.345 -0.6572 1.6329 2.2076 1.4976 1.1733 2.8436 1.5155 21-Apr-11 2.1426 1.1139 3.8447 -0.2205 3.7037 0.829 0.6989 1.3559 -5.8065 0.7832 25-Apr-11 -0.3625 -0.9792 - 1.3089 -0.5525 0.7502 -0.1621 2.1979 -0.4753 -1.8591 0.0243 26-Apr-11 0.4891 0.0824 2.0462 11 -0.6313 1.3918 - 1.069 0.283 0.4985 0.6555 27-Apr-11 1.1158 1.2351 0.557 0.6006 1.4009 0.4118 -0.4704 0.2998 0.2976 0.0844 28-Apr-11 0.2407 -2.074 2.1418 0.199 1.3012 -0.5013 1.5455 0.211 0.1978 0.3374 29-Apr-11 -0.1171 0.9551 -0.2169 3.0785 0.3489 0.7328 0.2264 0.2457 -0.3949 0.036 2-May-11 0.9204 -0.905 -0.5435 0.7707 0.3793 -1.148 0.6024 1.6279 0.1982 -1.6567 3-May-11 0.4182 0 -2.1129 0.5736 0.8344 - 1.5523 -0.5863 -3.6342 0.7913 0.4883 4-May-11 - 1.3016 0.2906 -0.6699 -0.4753 -0.7963 -0.946 0.0878 -0.0715 -0.6869 -0.8989 5-May-11 - 1.266 0.5795 -0.9367 7.1633 -0.8499 -2.5822 -0.2508 -1.7528 0.2964 -2.3535 6-May-11 0.7005 -0.2881 2.5719 -0.0891 0.6825 0.0847 -0.5782 0.4005 0.9852 0.6904 9-May-11 0.1243 0.2476 2.913 -3.5682 -0.0631 0.5926 0.3287 1.0698 -0.6829 0.6483 10-May-11 0.7569 1.2762 1.5048 -0.0925 0.7414 0.1923 2.0917 2.1887 2.7505 0.6193 11-May-11 -0.5165 -0.122 -4.4476 2.4074 -0.9552 -2.0998 0.5431 - 1.1938 - 1.8164 -1.3911 12-May-11 1.6165 2.3403 2.2165 - 1.7179 0.9486 -0.0863 2.6639 0.5686 0.2921 0.7491 13-May-11 -1.347 -0.0399 -0.4337 -2.0239 -2.3806 -0.2221 -0.2989 - 1.5194 -0.8738 - 1.3011 16-May-11 -0.6238 -0.1998 -3.4483 3.2864 0.9787 -0.779 -1.4032 0.7356 -0.3918 -0.2134 3month Tbill 0.07 0.06 0.07 0.06 0.04 0.04 0.05 0.05 0.06 0.07 0.07 0.07 0.06 0.06 0.06 0.07 0.07 0.06 0.04 0.04 0.05 0.03 0.03 0.02 0.02 0.03 0.03 0.03 0.02 0.03 0.04 3month Tbill 0.04 0.05 0.05 0.05 0.06 0.06 0.06 0.05 0.05 0.06 0.05 0.04 -0.0327 0.04 DATE Returns IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns_XOM Returns TM Returns_ACN Returns XRX Returns_BRK 17-May-11 0.9712 1.3211 -2.406 0.0909 -0.5879 0.2119 - 1.0218 1.0508 -0.9833 -0.692 18-May-11 -0.0352 0.1976 1.5023 -0.7266 0.6872 1.654 0.0246 0.3172 1.8868 0.8742 19-May-11 0.088 0.4732 7.0209 4.1171 -0.3016 0.7218 -0.8478 0.0351 0 -0.427 20-May-11 -0.2521 -2.0016 -0.8156 1.1424 -0.8916 -0.9231 -0.917 0.843 -1.462 -0.7064 23-May-11 - 1.1166 -1.5619 - 4.1115 -2.4327 -1.3012 -1.1033 -0.5253 -1.8809 - 1.3848 - 1.0544 24-May-11 -0.1605 -0.4475 -0.3729 - 1.2467 -0.6836 0.7686 0.44 0.0887 - 1.2036 -0.2825 25-May-11 -0.1429 -1.0625 8.4581 -5.4103 0.7211 0.8242 2.3532 0.3547 -0.2031 0.6309 26-May-11 -0.3398 0.537 1.7253 -2.9552 -0.4068 0.5246 0.5381 0.7775 1.5259 0.1919 27-May-11 0.1914 1.5612 0.2374 -1.7682 0.5065 0.2913 0.0608 -0.2104 0.2004 -0.3448 31-May-11 0.8537 0.4045 1.9966 0.8 0.9103 1.0166 1.2521 0.8434 2.1 1.3198 1-Jun-11 - 1.4029 -3.7067 -5.3849 -3.9683 -1.4175 -1.7252 -2.1491 -0.7144 -2.0568 -2.5168 2-Jun-11 -0.2822 -0.5858 0.8521 -0.6198 -0.8533 -0.7239 -0.2983 0.5 0.1038 3-Jun-11 -0.6262 -0.7997 4.7636 0 0 -0.1844 -0.4944 -1.7427 -0.4975 - 1.1794 6-Jun-11 -0.1818 - 1.7395 -4.7461 -3.0146 -0.1961 - 1.0963 -0.7328 -0.0717 -2.4 -1.1934 7-Jun-11 -0.6434 0.6045 -1.1498 -0.7503 0.2784 -0.3612 2.0646 0.8785 -1.6393 -0.6371 8-Jun-11 0.3971 1.3734 -4.4061 -1.2959 -0.2123 0.95 0.2207 -0.9419 -1.4583 -0.708 9-Jun-11 0.3042 0.7621 1.8437 0.4376 0.6426 0.5201 0.2079 1.0944 1.0571 0.9148 10-Jun-11 - 1.007 -2.1849 0.8689 0.4357 -3.0616 -1.7246 -1.5259 -1.4374 -1.6736 -1.2665 13-Jun-11 -0.0061 0.5584 2.0459 0.4338 -0.76 -0.6894 - 1.1776 0.7022 2.6596 0.3106 14-Jun-11 0.5822 -0.8116 0.598 2.5918 -0.1872 1.4515 0.9032 2.1277 1.8653 1.1038 15-Jun-11 - 1.0907 -1.1628 -4.4755 -1.7895 -1.8926 -2.1398 -1.1934 -2.9937 -1.9329 -1.7042 16-Jun-11 0.2094 4.5316 -3.0015 0.7503 0.3823 0.7119 -0.0126 -2.5808 0.8299 1.5983 17-Jun-11 1.0881 0.0417 0 1.9149 0.277 -0.2525 0.0503 -0.0556 1.3374 0.6666 20-Jun-11 0.3527 0.1667 - 1.8491 1.1482 -0.6043 0.8732 0.7798 0.0185 0.203 0.7813 21-Jun-11 0.7272 2.4126 5.8439 1.2384 0.8859 1.0789 0.7862 1.5382 1.1145 0.5125 22-Jun-11 -0.3249 -0.4874 - 1.1624 -2.2426 - 1.3085 -0.9309 -0.0743 0.8396 0.1002 -0.6798 23-Jun-11 0.2656 0.9796 1.8376 3.6496 -0.2791 - 1.7289 0.1487 0.7964 0.8008 -0.4739 24-Jun-11 -0.6321 -0.9701 -0.5233 -5.1308 -0.8397 -2.1163 0.5815 2.3882 -1.7875 0.0132 27-Jun-11 1.5448 -0.898 -0.3809 2.439 0.9527 1.4848 -1.9068 1.3504 0.2022 0.0132 28-Jun-11 1.4258 0.5354 2.3671 -2.795 0.5767 2.1946 0.4264 3.2186 2.2452 1.0446 29-Jun-11 0.3117 0.7374 0.6403 -2.0234 1.7724 0.7786 1.8107 0.4359 1.5857 0.7982 0.05 0.05 0.04 0.05 0.05 0.05 0.05 0.05 0.05 0.04 0.03 0.03 0.02 0.01 0.02 0.02 0.03 0.02 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM 30-Jun-11 0.5922 0.854 2.9692 -0.3261 -0.3244 1.4081 1.0916 1-Jul-11 1.7429 1.129 -0.3776 1.3086 1.2504 0.7742 1.2497 5-Jul-11 0.5099 -0.1595 0.4135 -1.8299 -0.9812 -0.4999 0.1798 6-Jul-11 1.2997 0.3594 -0.6177 0.1097 0.1367 -0.0368 0.8014 7-Jul-11 -0.6921 1.3132 2.6588 3.0668 0.4948 0.9685 0.4391 8-Jul-11 0.0057 -0.5499 -3.0945 -0.6376 -0.4075 0.0728 -0.2836 11-Jul-11 -0.8499 -1.3428 -1.5967 -3.7433 -0.6989 -0.6309 -0.8294 12-Jul-11 -0.5372 0.6005 -0.6349 -4.3333 0.1373 -0.0122 -0.0717 13-Jul-11 0.1551 0.5173 1.6684 1.0453 0.24 0.7205 1.2434 14-Jul-11 -0.0516 0.3563 -3.5964 -2.1839 - 1.2656 -0.291 -0.4724 15-Jul-11 0.7519 0.5128 -0.1087 - 1.1751 0.2945 0.9241 -0.5102 18-Jul-11 -0.1481 -0.2747 - 1.269 -4.1617 -2.3834 -0.4217 -0.5844 19-Jul-11 5.6652 1.6529 2.4238 2.4814 0.9023 1.1857 1.0557 20-Jul-11 -0.8423 -0.271 2.8684 -1.4528 0.0526 -0.3946 0.1068 21-Jul-11 0.6806 -2.368 0.0349 0.3685 1.1041 2.0648 1.3518 22-Jul-11 0.1514 0.6362 2.0557 -0.8568 -0.1907 0.2352 -0.5382 25-Jul-11 -0.7992 -1.936 -2.7313 -2.963 -1.6151 -0.7627 -1.0352 26-Jul-11 -0.4192 0.4432 - 1.7199 2.0356 0.2648 -0.2365 -0.0357 27-Jul-11 -0.8637 0.2006 -1.2857 -5.1122 -0.9331 -1.2564 -2.2949 28-Jul-11 0.2481 -0.5604 1.9175 0.2628 -1.3684 -2.2206 -0.9006 29-Jul-11 0.0275 0.1208 0 3.4076 -0.6667 -2.0501 0.6017 1-Aug-11 -0.6049 -0.7238 2.1299 -1.1407 -0.9432 -0.2381 -0.1831 2-Aug-11 -1.4938 -2.7542 -4.9705 -4.7436 -0.824 -2.2111 -0.587 3-Aug-11 0.4381 1.0829 -0.5121 1.6151 0.1108 -0.1542 -0.0369 4-Aug-11 -4.1101 -2.2662 -9.0074 -7.0199 -1.6783 -4.9923 -4.7379 5-Aug-11 0.8747 -0.7167 -2.0606 -0.7123 - 1.3881 1.3272 0.0258 8-Aug-11 -3.4744 -5.2654 -2.4752 -5.0215 -7.5899 -6.1882 -4.7914 9-Aug-11 2.6411 1.1206 6.0068 6.9486 6.4018 2.0658 4.7341 10-Aug-11 -4.7301 -2.7925 -4.9481 -5.6497 -5.1267 -4.383 -4.8957 11-Aug-11 2.5778 3.5796 6.2133 4.3413 4.792 5.2183 2.3287 12-Aug-11 0.8817 0.5307 3.9921 0 -0.5059 0.5868 -0.9848 Returns_ACN 0.8513 0.7448 1.4457 0.5668 2.1578 -0.0158 -3.0585 -0.7156 -0.6224 0.2637 -0.2137 - 1.1862 2.7009 -0.3409 0.5701 -0.7451 -0.1632 0.2615 -2.5921 -0.1004 -0.9214 -0.3044 -1.6113 2.7409 -4.396 0.4036 -7.0792 3.2543 -5.6477 4.2672 1.1296 Returns_XRX Returns_BRK 1.561 0.4674 2.8818 0.9045 - 1.3072 -0.9988 0 - 1.0219 1.0407 1.6336 -0.1873 - 1.1187 -3.8462 -2.1196 -0.4878 0.6776 0.1961 0.7126 - 1.4677 -0.2883 -0.5958 -0.9724 -0.8991 -0.3317 2.7218 1.571 - 1.2758 -0.1966 2.3857 1.576 -2.1359 -0.375 -1.7857 -1.4796 -1.1111 -0.5269 -2.145 - 1.0859 -1.6701 0.2142 -0.9554 -0.9085 -2.1436 1.0247 -3.3954 -2.0819 0.907 0.8723 -3.7079 -4.0805 -0.4667 0.3663 -9.7304 -6.4561 6.1039 9.4224 -5.6304 - 7.3084 3.6316 6.1243 0.2503 -0.3067 3month Tbill 0.03 0.02 0.02 0.01 0.03 0.03 0.03 0.03 0.01 0.01 0.02 0.02 0.03 0.02 0.05 0.05 0.05 0.07 0.08 0.07 0.1 0.1 0.06 0.02 0.02 0.01 0.05 0.03 0.02 0.03 0.02 3monthTbili 0.02 0.03 0.01 0.01 0.02 0.01 0.01 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM Returns_ACN Returns XRX Returns_BRK 15-Aug-11 2.8478 0.6159 -0.3041 5.0215 2.2296 3.1806 2.3118 1.4832 3.2459 1.4262 16-Aug-11 - 1.0116 0.9182 -0.4956 4.6448 -0.5548 - 1.0634 -0.9196 -1.0826 -0.6046 - 1.0477 17-Aug-11 0.1401 1.2998 -1.0345 1.8277 0.4232 0.898 -0.9812 -0.5472 0.9732 0.8359 18-Aug-11 -4.4612 -1.9247 -6.0782 -5.2564 -4.6169 -4.342 -4.1644 - 10.3815 -7.5904 -3.8961 19-Aug-11 -3.8394 -0.9594 -8.0791 -2.4357 -0.6628 -1.607 - 1.2156 -2.9063 -4.5632 -1.7683 22-Aug-11 0.9141 0.044 -1.5695 0.1387 -0.6874 0.5444 -0.2263 2.2344 1.2295 -0.7756 23-Aug-11 3.3589 0.5722 4.6014 0.554 0.4682 4.9587 3.3173 4.0619 2.969 2.6401 24-Aug-11 1.4849 -1.5317 3.9634 -0.1377 0.3242 -0.1629 - 1.0977 1.0105 2.7523 1.6669 25-Aug-11 -0.7076 0 -3.1839 -5.7931 -3.0701 -2.4069 - 1.1238 -0.4512 -3.9541 -2.4876 26-Aug-11 2.15 0.8 2.6828 4.246 0.646 1.2122 0.5332 1.6749 2.5232 1.2321 29-Aug-11 2.0575 2.9541 4.1298 5.3371 5.0725 2.0374 0.628 2.6357 4.4042 3.9519 30-Aug-11 -0.0637 -1.242 -0.3238 1.4667 - 1.064 -0.2833 -1.6089 2.0204 0.1241 -0.4683 31-Aug-11 -0.3478 2.1683 0.4466 -1.0512 0.4979 0.1488 1.2687 -0.8144 2.8501 1.0241 1-Sep-11 -0.9191 -1.0611 -2.9911 - 1.4608 -0.4954 -0.716 -0.9326 - 1.2876 -2.2892 -2.2329 2-Sep-11 - 1.9668 -0.9867 -3.875 -2.0216 -2.6688 -1.837 -2.5713 -2.7032 -2.4661 -2.8023 6-Sep-11 - 1.1199 - 1.3865 -0.5635 - 1.9257 -0.6957 -1.3723 - 1.5431 -1.4572 -1.2642 - 1.4415 7-Sep-11 1.3324 3.2513 3.9233 4.7686 4.3272 3.5137 2.3143 2.918 2.8169 3.4079 8-Sep-11 - 1.2312 -0.6383 -0.9648 -2.1419 -1.7523 - 1.127 -0.6872 -0.0575 -2.3661 -1.8246 9-Sep-11 -2.348 -5.6959 -2.7107 -1.7784 -2.4321 -2.4856 -2.2632 -4.5045 -5.4847 -2.3628 12-Sep-11 0.6507 -0.9083 -0.3918 2.7855 1.7034 1.1688 0.5457 0.4014 1.4845 2.1691 13-Sep-11 0.6218 0.7333 5.2448 8.2656 -0.0409 -0.2645 1.2909 1.6793 2.1277 -0.5633 14-Sep-11 2.3313 0.546 1.0797 5.0063 0 1.3817 0.7531 0.8061 1.8229 0.8134 15-Sep-11 1.7041 2.3077 1.9721 0.8343 1.839 1.886 2.3573 3.4133 1.1509 2.0458 16-Sep-11 1.705 -0.973 3.9484 -0.7092 1.5449 0.7296 -0.5617 3.7722 1.3907 1.0165 19-Sep-11 0.0809 -0.0447 -0.1163 -1.0714 -1.4029 -1.1402 0.0424 -0.7634 -1.3716 -2.6415 20-Sep-11 0.9184 0.1341 0.9313 0.722 1.0421 0.4206 -0.5788 -0.3297 -1.8963 0.0861 21-Sep-11 -0.973 -2.9005 -0.6151 -4.4205 - 4.4228 -2.7564 -3.0243 -1.8927 -3.4794 -3.5858 22-Sep-11 -2.5431 -0.1379 -0.8511 -5.25 - 1.6808 -3.7933 -1.9473 -5.6752 -5.0734 - 1.8149 23-Sep-11 0.427 0.2301 2.9263 7.7836 -0.5488 0.1011 1.314 0.0993 -0.1407 0.5606 26-Sep-11 3.053 1.1938 -3.26 1.5912 2.5891 3.4771 1.3559 2.9954 4.2254 8.6183 27-Sep-11 1.8337 -0.4537 2.6254 -1.9277 1.8618 1.6592 0.7881 3.3321 2.2973 -0.0277 0.02 0.01 0.01 0.02 0.01 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0 0.01 0.02 0.01 3month Tbill 0.02 0.02 0.02 0.02 0.01 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM ReturnsTM Returns_ACN Returns XRX Returns_BRK 28-Sep-11 -0.09 0.0456 -6.1092 -0.3686 - 2.173 - 1.1521 0.4942 0.3355 -2.8732 -1.7899 29-Sep-11 0.9124 1.2301 -1.9113 -1.9729 3.1555 2.5114 1.5476 1.1332 0.4104 2.7268 30-Sep-11 -2.4 - 1.1701 1.1194 -5.6604 -1.932 -1.6919 -2.7774 -3.2329 -5.0409 -2.2968 3-Oct-11 -0.9035 -1.0018 -2.706 - 11.3333 -3.9606 -2.0377 -1.8898 -2.0122 -3.5868 - 1.3795 4-Oct-11 0.8368 1.242 -0.295 9.6241 2.735 2.3612 0.3584 5.1143 4.3155 4.4391 5-Oct-11 1.2075 0.5906 7.2274 1.9204 3.099 1.5378 -0.7737 1.0874 1.7118 0.082 6-Oct-11 2.7368 2.8907 6.2672 4.7106 1.2508 -0.0811 0.7647 0.8204 0.9818 0.5462 7-Oct-11 0.3853 - 1.0975 0.1113 0.2571 -2.371 -0.4466 - 1.5923 1.1212 -0.4167 -2.6212 11-Oct-11 -0.8681 -0.5242 -0.9684 1.9876 - 1.3307 -0.0131 - 1.0147 -0.6447 -0.6685 -0.9445 12-Oct-11 0.6054 -0.3074 0.6882 2.5579 2.023 1.1669 0.728 1.8853 0.673 1.7709 13-Oct-11 0.3761 -0.7489 0.5036 3.0879 -1.9246 - 1.0238 -0.1475 -0.418 0.8021 -0.8834 14-Oct-11 1.9859 0.3551 0.3937 - 1.2673 1.6254 2.2784 -0.3545 2.8332 2.5199 0.9453 17-Oct-11 -2.0679 -1.1057 -2.246 -1.9837 -3.2963 -0.8194 -0.2075 -1.8027 -3.3635 -2.4883 18-Oct-11 -4.1213 1.6995 3.3552 3.6905 3.7918 1.833 1.1884 -0.4676 2.9451 2.9908 19-Oct-11 -0.844 -0.1759 -2.717 -2.411 5.6937 -0.5831 -1.145 -0.2262 -0.7802 - 1.2788 20-Oct-11 -0.0789 0.0881 -0.8342 2.3529 0.2574 0.357 -0.8167 -0.436 -0.2621 2.3749 21-Oct-11 2.4711 1.6285 2.5238 -0.4598 5.1715 1.8041 1.2277 1.7341 2.8909 2.0825 24-Oct-11 0.3414 0.7362 1.8552 2.7714 0.4708 0.0499 0.6212 0.4993 2.1711 -0.2711 25-Oct-11 -1.037 -1.4617 - 1.0508 -5.1685 -2.2214 -0.9106 -2.5136 -0.3426 0.25 -1.942 26-Oct-11 0.8927 0.4363 -0.9558 1.4218 2.0589 2.0519 0.8595 0.0688 2.2444 3.0103 27-Oct-11 2.1487 2.0417 2.7877 0.9346 3.3044 0.9991 3.5431 5.0507 4.5122 3.1659 28-Oct-11 0.8446 -0.1703 3.8595 -1.5046 0.1347 -0.4885 0.5775 0.9975 -0.4667 -0.6585 31-Oct-11 -1.5044 -1.1514 -1.6739 0.1175 -1.8998 -4.1605 -4.2349 -2.4288 -4.1032 -2.6263 1-Nov-11 - 1.7765 -2.9767 -1.6684 - 2.2301 -3.2905 -2.7532 -2.1736 -4.6465 -2.934 -3.0054 2-Nov-11 1.4171 0.667 -0.5886 -0.9604 2.2683 1.8831 -0.6436 1.7751 1.8892 2.6086 3-Nov-11 1.8378 0 13.0617 0.6061 1.5075 1.9258 0.8482 1.2654 3.2138 1.7164 4-Nov-11 -0.4912 0.7509 -0.4621 0.6024 -0.7511 -0.4311 -0.3211 -1.6548 1.3174 -2.0046 7-Nov-11 0.5043 1.1837 -3.2188 -0.479 0.8256 1.0571 0.4603 -0.4121 -0.1182 -0.1813 8-Nov-11 0.363 0.7366 1.8228 -1.3237 0.6994 1.109 - 1.3287 1.5345 1.0651 1.3748 9-Nov-11 -2.6756 -2.1505 -3.0151 -2.439 -3.5745 -2.9714 -0.9286 -3.7018 -5.2693 -3.5312 10-Nov-11 0.6091 1.2527 1.4573 -4.75 0.8433 1.6927 0.6874 0.5114 0.4944 0.7825 0 0.01 0.01 0.02 0.02 0.02 0.02 0.04 0.04 0.03 0.03 0.02 0.02 0.01 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns TRV Returns_XOM Returns TM Returns ACN Returns XRX Returns_BRK 14-Nov-11 -0.016 -1.2377 - 1.2485 1.3837 -1.5403 -0.9533 0.2963 -2.4589 -0.7308 -1.4421 15-Nov-11 0.7473 -0.1296 2.1373 -0.7444 -0.4172 0.1646 -0.5753 0.7128 0 0.0923 16-Nov-11 - 1.1285 -2.7261 2.9767 -5.25 -1.6582 -1.0621 -0.6256 - 1.7262 -1.5951 -1.6594 17-Nov-11 -0.4769 - 1.6459 -3.6062 -3.9578 -1.0827 -0.4984 1.2433 -2.1605 - 1.2469 -0.4955 18-Nov-11 -0.2638 0.995 -3.2067 1.0989 0.8792 0.0514 - 1.197 - 1.0772 -0.5051 1.4401 21-Nov-11 -2.0298 -0.9852 -2.5767 -2.038 - 2.5969 - 1.2709 -3.7288 -0.0726 - 1.269 -1.3931 22-Nov-11 -0.0937 - 1.0855 0.9761 0.9709 -1.4974 - 1.1442 1.2257 -0.4177 -1.4139 0.0538 23-Nov-11 - 1.8532 -0.2286 -1.9333 -2.1978 -2.1876 -1.9071 -2.5024 -2.1886 -1.5645 -2.1651 25-Nov-11 -0.5001 1.5582 0.6677 0 1.232 -0.9118 2.8482 0.1305 0.2649 0.1924 28-Nov-11 2.9086 2.3466 2.8427 4.3539 1.5166 2.6252 3.3167 2.9609 1.4531 3.5533 29-Nov-11 -0.697 -1.455 -2.4877 4.9798 -0.2767 1.4372 0.3428 0.5064 -0.9115 -0.4637 30-Nov-11 3.9018 3.7136 3.1181 4.1026 4.0318 4.5626 2.3606 4.2469 7.0959 4.8316 1-Dec-11 0.7713 0.8197 -0.4276 4.9261 -2.1511 -0.8081 -0.2883 0.0691 0.4908 - 1.2062 2-Dec-11 0.1109 -0.0428 2.1472 - 1.2911 - 1.4535 0 0.7608 0.7073 0.3663 -0.4755 5-Dec-11 0.6222 1.3699 3.3634 2.3781 0.7928 0.8272 2.7635 1.6101 1.7032 0.8652 6-Dec-11 1.1004 0.1689 1.3074 -1.626 1.2438 0.4599 - 1.3813 -0.2529 -0.3588 0.0512 7-Dec-11 0.5753 -0.1265 - 1.9501 1.0626 1.7344 0.3217 1.9967 -1.0647 0.3601 0.7294 8-Dec-11 -1.2729 -0.7176 -9.6519 -4.4393 -0.6619 -1.4924 -1.9284 -3.1944 -3.9474 -2.2612 9-Dec-11 1.5555 1.7857 0.4856 3.912 0.8824 1.8405 1.5939 3.5998 1.6189 0.8708 12-Dec-11 - 1.2233 -0.0835 -2.0296 0 -0.3392 - 1.5859 -2.5073 -0.8346 -2.0833 -1.7266 13-Dec-11 -0.536 -0.4599 -3.1569 -6 0.1791 0.5996 - 1.2784 -0.4981 -0.8761 -0.5376 14-Dec-11 - 1.2712 - 1.092 -3.1239 2.0025 0.0715 -1.3535 -0.6399 -3.2798 - 1.6414 -0.4482 15-Dec-11 -0.6571 1.104 0.3155 5.3988 1.5008 0.7427 0.23 0.1785 1.6688 -0.821 16-Dec-11 -2.0855 -0.42 -2.1663 5.0058 0.8273 0.1624 -2.5547 -3.5275 0.6313 0.3071 19-Dec-11 -0.3704 -0.8857 -0.8929 -5.6541 -0.9951 -0.7859 -0.6122 - 1.2004 -3.1368 -1.4508 20-Dec-11 2.3785 2.0426 0.5405 1.4101 2.5392 3.1057 1.8638 1.3832 3.886 2.7823 21-Dec-11 -3.0816 2.0851 - 1.1828 -1.854 1.6165 1.3659 -0.3721 -4.0376 0.4988 0.1577 22-Dec-11 0.3141 - 1.3072 0.7254 - 1.2987 0.1692 1.4076 0.3891 1.0183 1.6129 0.879 23-Dec-11 1.4887 1.3245 0.4681 -0.3588 0.2703 1.1033 0.6977 0.5896 1.221 1.1055 27-Dec-11 0.1083 -0.0409 2.4014 -1.8007 0.3033 0.0704 -0.9084 0.0756 -1.5682 -0.656 28-Dec-11 -0.5191 -0.5721 -0.21 -0.7335 - 1.1255 - 1.2899 -0.1709 -0.1322 -2.6654 -0.9193 3month Tbill 0.01 0.01 0.01 0.02 0.01 0.02 0.02 0.02 0.02 0.03 0.02 0.01 0.01 0.02 0.01 0.01 0.02 0.01 0.01 0.01 0.01 0.01 0 0 0.01 0.01 0.01 0.01 0.01 0.02 0.01 -0.1669 0.539 0.6846 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns_TM Returns_ACN Returns_XRX Returns_BRK 29-Dec-11 1.1903 0.4932 0.7717 -0.3695 1.3931 1.2948 1.572 1.854 0.8861 0.4966 30-Dec-11 - 1.2354 -0.9407 -0.5917 0 -0.8546 -0.5981 1.3331 - 1.133 -0.1255 -0.7802 3-Jan-12 1.3161 1.2387 -1.6807 -0.618 -0.3042 1.463 2.4951 -0.526 3.0151 1.8086 4-Jan-12 -0.4079 -1.0196 -1.3177 -0.3731 -0.4069 0.0233 0.959 -0.0378 -0.6098 - 1.1328 5-Jan-12 -0.4743 0.0824 -2.1292 3.995 0.9872 -0.3022 0.2777 -1.9082 -0.6135 0.1693 6-Jan-12 -1.1481 -0.4117 -0.7743 -0.1201 0.0337 -0.7463 -0.1603 -0.1733 0 -0.7019 9-Jan-12 -0.5204 0.2894 1.2635 -0.4808 0.5729 0.4464 -0.1314 -0.1736 -0.1235 -0.1309 10-Jan-12 -0.1542 0.2473 1.3578 -0.1208 0.6869 0.2573 0.3654 1.7201 0.2472 1.4812 11-Jan-12 0.5571 -0.9457 2.2085 4.1112 -0.3328 -0.7466 -0.1019 1.9761 0.9864 0.7492 12-Jan-12 -0.9708 -0.4566 0.0708 3,0197 -0.3996 -0.6706 0.5031 -0.7326 0.641 13-Jan-12 -0.7699 0.6255 -19.3274 -0.2255 -0.7191 0.1652 0.1761 - 1.2792 -0.615 -0.9299 17-Jan-12 0.4689 0.746 16.7179 - 1.3559 0.9543 -0.9083 0.4507 0 0.2572 18-Jan-12 0.5944 -0.7816 0.7895 2.1764 0.3351 0.8869 0.3105 2.7295 4.9505 1.2184 19-Jan-12 -0.3038 -0.2488 -0.1865 4.5964 0.6709 1.8276 -0.273 2.7123 0.849 20-Jan-12 4.4316 -0.6234 -0.5979 0.8574 2.1393 0.5286 3.3435 1.8431 0.5741 0.4021 23-Jan-12 0.7744 0.9201 0.6391 - 1.2752 -2.1107 -0.0229 -0.3501 1.2005 -0.3425 -0.9511 24-Jan-12 1.0264 0.8703 2.4281 0.9688 -3.7983 -0.3315 1.6585 0.2656 -0.6873 -0.8465 25-Jan-12 -0.1042 1.2736 2.0058 6.1834 1.9828 0.0459 2.613 0.9889 -9.9193 1.7457 26-Jan-12 -0.3912 -0.3245 3.468 2.1084 -0.7608 -0.5159 0.4985 -0.4721 0.5122 -0.2379 27-Jan-12 -0.2723 - 1.0989 1.3476 2.1632 -1.1073 - 1.0833 - 1.3675 -0.8784 0.3822 -0.3013 30-Jan-12 1.0711 -0.8642 0.8183 3.6574 0.1034 -0.3961 -0.6253 1.1344 -1.9036 -0.9192 31-Jan-12 0.052 -1.3699 -1.6909 -2.0427 0.327 -2.047 0.5061 0.4907 0.2587 -0.4067 1-Feb-12 0.0104 0.2946 1.7544 3.3175 1.6638 0.2747 2.3408 1.8835 0.3871 0.37 2-Feb-12 -0.5659 0.5875 2.265 1.8349 0.2025 -0.524 1.3697 - 1.1126 0.1285 0.089 3-Feb-12 1.1017 -0.2086 2.9752 1.8018 1.2292 1.6641 0.3148 0.9347 2.1823 1.6131 6-Feb-12 -0.4235 0.5853 2.0867 -2.7434 -1.314 0.9774 1.6215 -1.1147 -0.2513 -0.1875 7-Feb-12 0.2749 -1.4963 -0.6289 -0.182 0.691 0.688 2.445 0.5203 0.3778 0.0376 8-Feb-12 0.181 -0.2532 1.0443 0.1823 0.1841 -0.637 1.8088 -1.5355 0.5019 -0.2754 9-Feb-12 0.0933 -0.2538 2.0357 1.1829 0.0668 -0.5157 -0.2098 0.5958 0.1248 -0.5775 10-Feb-12 -0.3676 0.212 -4.5427 -2.0683 -0.8516 -1.2724 -3.0786 -0.7838 - 1.2469 -0.5177 13-Feb-12 0.1039 0.1058 1.254 2.3875 -0.6568 0.7399 0.6634 1.2626 0.825 3month Tbill 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.02 0.02 0.03 0.03 0.03 0.03 0.05 0.05 0.04 0.04 0.04 0.05 0.06 0.05 0.06 0.06 0.08 0.08 0.08 0.08 0.09 0.09 0.09 0.11 0.79 1.124 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns TRV Returns XOM ReturnsTM Returns ACN Returns_XRX Returns_BRK _3month Tbili 14-Feb-12 -0.2077 1.4019 5.335 - 1.8834 0.2882 0.2961 1.3813 0.0871 4.3641 -0.6546 0.12 15-Feb-12 0.0156 -0.5027 1.2964 - 1.0055 0.2197 -0.6496 3.2 0.7309 -0.4779 - 1.077 0.11 16-Feb-12 0.4005 0.5474 1.7262 0.9234 0.253 1.5335 1.3203 0.9848 0.6002 1.076 0.1 17-Feb-12 0.2072 0.1675 2.3113 -0.9149 0.6898 0.2459 -0.3467 -0.0342 -0.9547 0.6463 0.09 21-Feb-12 -0.0155 -0.4181 - 1.344 -7.2022 -0.9691 1.1096 -0.1679 -0.4963 -1.5663 0.2644 0.08 22-Feb-12 0.2482 -0.7557 -0.8116 - 1.194 -0.5568 0.4043 1.3098 0.6708 -0.2448 -0.8791 0.09 23-Feb-12 1.9291 -2.7919 0.9059 -2.4169 0.0339 0.115 -0.2847 1.5035 2.3313 0.5575 0.09 24-Feb-12 0.0759 2.4369 -2.2589 -1.6512 -0.6106 0.3677 0.5591 0.404 0.2398 0.8441 0.1 27-Feb-12 -0.1163 1.4443 -0.3852 1.3641 0 -0.1259 - 1.1119 0.0168 0.1196 0.2624 0.12 28-Feb-12 0.2278 -0.4188 0.5651 2.4845 -0.3413 -0.1032 1.256 0.1676 -0.8363 -1.0093 0.1 29-Feb-12 -0.6314 0.0421 - 1.1831 -0.9091 -0.7363 -0.7344 -2.2918 -0.3681 -0.8434 - 1.2462 0.08 1-Mar-12 0.4067 2.7322 2.9931 - 1.7329 0.7763 0.3815 0.4353 0.2351 2.0656 0.4207 0.08 2-Mar-12 0.648 -1.473 - 1.0753 1.3485 -0.7018 -0.5758 -1.8057 -0.1341 -1.5476 -0.622 0.07 5-Mar-12 0.9305 0.4983 -0.7932 - 1.0235 0.8447 0.7877 -0.4046 2.1477 0.8464 0.08 6-Mar-12 -1.6944 -0.6198 -1.9544 -3.2058 -2.5812 -1.3217 - 1.3417 -2.3325 -3.3573 -0.8842 0.08 7-Mar-12 0.2585 0.0832 0.0302 0.1068 0.5089 -0.0349 0.7112 0.2523 0.3722 0.446 0.08 8-Mar-12 1.0315 1.1217 -0.151 1.0672 0.4044 - 1.1651 2.2299 1.1072 1.9777 0.0634 0.08 9-Mar-12 0.4054 -0.0822 5.0499 - 1.056 0.8932 -0.6248 1.5633 0.9789 0 0.6847 0.09 12-Mar-12 0.1894 0.2467 3.6557 -1.921 0 1.4828 - 1.229 0.4765 0.3636 0.1637 0.09 13-Mar-12 1.3831 -0.6563 0.2222 1.3058 1.3886 1.5313 1.4375 2.0605 1.6908 1.5338 0.08 14-Mar-12 0.4613 0.4955 -2.2167 -0.1074 0.9245 -0.9671 -0.5121 0.3205 0.4751 -0.0619 0.09 15-Mar-12 0.6252 0.2876 -0.8218 3.5484 0.2205 0.0814 2.1547 1.6291 -0.2364 0.7806 0.08 16-Mar-12 0.0049 -0.1639 0.9143 -4.3614 0.2031 0.4066 0.0703 -0.0157 -1.4218 -0.3319 0.09 19-Mar-12 -0.1408 -0.9848 -0.9626 1.0858 -0.1351 0.6363 -0.1874 -0.3301 0.1202 0.5057 0.1 20-Mar-12 -0.7146 -0.1243 -0.0572 2.363 0.0677 -0.4483 -0.6804 -0.5204 -0.9604 -0.0368 0.1 21-Mar-12 0.2154 0.5435 2.2036 - 1.0987 -0.6813 -0.8268 1.0621 0.1212 -0.2947 0.09 22-Mar-12 0.3908 -1.1532 -2.1337 -2.1561 -0.9229 -0.7906 0.5598 -0.3608 -0.6053 -0.3448 0.08 23-Mar-12 -0.0049 1.8333 -0.9302 0.9444 0.3968 0.2578 -0.7936 2.1411 0.1218 0.556 0.08 26-Mar-12 1.1145 -0.9411 9.7418 2.7027 1.1168 1.73 0.7044 1.5567 1.9465 1.1796 0.09 27-Mar-12 -0.284 0.3304 1.4438 -0.7085 -0.6287 -0.4711 2.4198 -0.6526 -0.1193 -0.7044 0.09 28-Mar-12 0.0531 -0.4117 -0.2372 1.9368 0.4959 -0.8774 1.2377 -1.4665 -0.9259 0.0245 0.09 0.7469 0.392 3month Tbill 0.07 0.07 0.08 0.08 0.08 0.08 0.09 0.09 0.09 0.09 DATE Returns_IBM Returns_KR Returns_TSLA Returns_DAL Returns TRV Returns_XOM Returns_TM Returns_ACN Returns_XRX Returns_BRK 29-Mar-12 0.4728 0.124 - 1.3738 0.7 -0.2042 0.2562 -0.7382 0 -1.4545 -0.5258 30-Mar-12 0.1825 0.0413 -0.2411 -1.5392 0.9378 0.7551 0.8831 0 -0.6765 -0.2458 2-Apr-12 0.393 0.6603 -1.7723 0.9581 0.2196 -0.1497 1.5349 0.9288 0.8503 3-Apr-12 0.0143 -2.706 3.9092 3.0969 -0.0843 -1.4241 -0.5422 -0.8246 - 1.1043 -0.3666 4-Apr-12 - 1.6468 -0.8007 -7.919 1.5504 -0.1012 -0.9903 -3.0387 -0.7852 -1.9851 -0.6009 5-Apr-12 -0.2815 1.2744 -1.4857 - 1.0496 -0.5741 -0.1883 0.311 0.5431 -0.3797 -0.1727 9-Apr-12 -0.2579 -1.4262 -3.8573 -0.7715 - 1.4096 - 1.1082 -2.5757 - 1.6206 -0.8894 - 1.4213 10-Apr-12 - 1.2735 -0.9787 -2.0815 -4.6647 -0.5168 -2.0386 -0.9302 -0.9256 -0.8974 -1.329 11-Apr-12 0.1236 0.8165 1.9409 1.0194 0.7273 0.645 1.9397 1.8131 1.5524 0.4447 12-Apr-12 1.3526 0.682 1.0577 3.5318 1.5988 1.0883 0.606 0.8016 1.4013 1.2777 13-Apr-12 -1.2274 -0.4657 0.4486 - 1.2671 -1.6582 -0.7775 -1.9154 -2.4637 -1.5075 -1.5488 16-Apr-12 -0.0394 0.2552 -3.9893 1.1846 1.7894 1.2779 -0.2211 - 1.0711 0.6378 1.0784 17-Apr-12 2.3333 0.5091 -0.031 1.8537 1.403 1.7141 0.2462 3.7169 1.3942 1.3681 18-Apr-12 -3.5286 -0.8442 1.3027 0.8621 -0.8668 0.3511 0.1351 -0.966 -0.5 - 1.263 19-Apr-12 -0.3098 - 1.192 1.5309 2.754 3.7498 -0.5481 0.2943 -0.8024 -0.6281 -0.5769 20-Apr-12 0.0451 0.1723 0 -0.6469 1.7018 0.0235 -1.5283 0.5551 -0.5057 -0.4793 23-Apr-12 -0.491 0 -3.6791 -3.3488 0.255 0.4572 -1.3782 -0.5836 0.1271 -0.1267 24-Apr-12 0.6948 0.2581 -0.3757 0.8662 0.7312 0.7235 1.6367 -0.3332 0.5076 1.2563 25-Apr-12 1.785 -0.5148 3.4255 0 0.647 0.6257 0.7804 1.9739 0.5051 0.188 26-Apr-12 0.9874 0.4312 1.7624 -0.7634 1.5522 -0.8981 0.5777 0.4371 -0.6281 0.5754 27-Apr-12 0.5983 0.2576 -0.4479 4.0385 -1.1734 0.0116 0.5621 1.0569 - 1.0114 0.199 30-Apr-12 0.1306 -0.3426 -0.6299 1.2939 0.4843 0.302 -0.6198 -0.1077 -0.6386 -0.1365 1-May-12 0.4443 0.6446 1.962 0.8212 0.4353 0.8108 -1.9931 1.928 1.2554 2-May-12 0.0288 -0.3416 0.4737 - 1.629 0.2167 -0.9651 -0.3743 0.2 -0.4051 3-May-12 -0.3941 -0.3856 -4.3606 0.828 0.0154 -0.638 -0.789 -1.4126 -1.5326 0.1602 4-May-12 - 1.0857 -0.5591 -1.9408 0.365 -0.3861 - 1.2609 -0.7448 -2.4918 - 1.1673 -0.3938 7-May-12 -0.6049 -0.4758 2.0107 1.5455 0.1395 -0.1064 0.0763 -3.8173 1.4436 1.8903 8-May-12 -0.6969 -0.4346 -7.0219 0 -0.3096 -0.5445 -0.6608 - 1.4613 -0.6468 -0.3031 9-May-12 -0.1241 -0.4801 -0.4306 -2.3277 -0.7299 -0.845 3.0447 -0.2022 -0.5208 -0.9608 10-May-12 -0.3131 1.2281 9.6474 1.0999 1.1264 0.12 - 1.018 -0.8781 0 0.4298 11-May-12 0.2841 0.0217 -2.1541 3.0825 -0.0309 0.3139 1.2291 -0.1533 -0.1309 -0.2201 0.09 0.08 0.08 0.07 0.07 0.08 0.08 0.09 0.09 0.09 0.077 - 1.261 0.09 0.1 0.09 0.08 0.09 0.07 0.1 0.09 0.09 0.1 0.1 3month Tbill 0.1 0.09 0.1 0.1 0.08 0.09 0.09 0.09 0.1 0.09 0.09 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns_TM Returns_ACN Returns XRX Returns BRK 14-May-12 -0.86 -1.9591 -6.7907 0.5277 -0.2167 - 1.1793 -1.2514 0.3412 0.7864 -1.3113 15-May-12 -0.2006 -1.5986 -2.0958 -2.2747 -0.5118 -0.4019 -1.7566 0.204 -3.7711 -0.3974 16-May-12 0.3467 0.2708 -0.8495 1.9696 -0.8418 0.4646 -2.0179 0.3224 -2.8378 0.4738 17-May-12 -0.9212 - 1.3051 -2.0905 -8.604 -1.4306 -0.3164 0.6387 - 1.2348 1.1127 -0.8934 18-May-12 - 1.0157 -0.5472 -3.5352 -2.5937 -0.8293 -0.5372 -1.4894 -1.2673 - 1.6506 - 1.202 21-May-12 0.9598 1.2838 4.3904 4.3392 0.8363 0.6996 0.8414 2.4631 0.6993 1.1279 22-May-12 -0.4753 1.0412 7.0212 -0.3781 0.1914 -0.1097 0.678 -0.237 -0.1389 -0.188 23-May-12 -0.3557 -0.7168 0.747 1.8975 0.4776 0.1098 0.0388 -0.0339 0 0.1255 24-May-12 -0.0153 -0.0451 -2.2566 4.9348 0.1109 0.6948 -0.0647 -1.5617 -3.4771 0.0627 25-May-12 -0.9128 1.1738 -1.6821 0.8873 -0.9337 -0.6416 -0.5181 -0.9484 1.8732 -0.6892 29-May-12 1.1117 0.6247 6.3066 3.7819 0.4473 -0.1828 0.3255 1.6887 3.3946 0.7192 30-May-12 -0.9824 -0.8869 -4.0391 -0.4237 - 1.5744 -2.612 -0.9215 - 1.1813 -0.9576 - 1.2403 31-May-12 -0.8379 -1.5213 -2.9924 2.9787 0.9695 -1.4538 0.7205 - 1.0742 -0.2762 0.6723 1-Jun-12 -1.9803 -1.6811 -4.5763 -4.876 -3.0565 -0.903 -2.7052 -3.1874 -1.385 -0.4284 4-Jun-12 -0.2856 1.2477 -0.9591 -11.5552 -0.3301 -0.1155 -0.254 1.5195 -0.4213 0.0253 5-Jun-12 0.3501 -0.2282 0.1076 3.9293 0.6956 -0.2955 0.5226 1.1048 1.3399 0.1012 6-Jun-12 2.5317 0.4117 4.6937 0.2836 2.1382 3.3247 2.4797 2.9609 3.5491 1.9717 7-Jun-12 0.232 -0.9567 -0.9925 -3.1103 0.438 0.6361 -0.052 0.7532 0.8065 -0.0248 8-Jun-12 0.36 -0.782 3.9751 0.9728 0.3715 0.1859 -0.4165 -0.5607 2.8 0.8678 11-Jun-12 - 1.3478 -1.0199 -3.1915 -2.0231 -0.9334 -0.7051 - 1.2025 -2.2211 -2.4643 - 1.3274 12-Jun-12 1.0597 0.7026 1.8544 - 1.2783 0.6173 1.2333 1.1906 0.2097 0.6649 1.2207 13-Jun-12 -0.7453 -0.9767 0.3709 2.49 -0.4682 -0.7753 -0.4576 -0.7323 0.7926 -0.8245 14-Jun-12 1.0357 6.0592 - 1.2765 1.5549 2.3844 1.8603 -0.1445 1.5985 -0.1311 1.4022 15-Jun-12 2.0502 1.0186 1.7693 -1.8182 0.4594 1.3272 0.6182 2.1438 2.231 1.0401 18-Jun-12 -0.4068 0 6.4527 3.6062 -0.5362 -0.1322 0.4575 -0.3385 -1.027 -0.5087 19-Jun-12 0.3228 -0.4384 0.7852 2.6341 0.6025 1.6484 0.0521 1.6135 1.297 1.0103 20-Jun-12 -0.0754 1.4091 5.2664 2.7498 0.6304 0.58 0.6373 -0.4011 0 -0.6267 21-Jun-12 -2.7115 0.0434 -4.7069 0.1784 - 1.989 -3.3659 -1.4474 -4.9169 -2.4328 -1.5401 22-Jun-12 0.1603 -0.651 4.955 -1.6919 1.2304 0 0.7081 1.5884 2.4934 0.8375 25-Jun-12 -0.4337 -0.8737 -1.9979 -4.7101 -1.8942 -1.0596 -0.9245 -1.9284 -3.5851 -1.71 26-Jun-12 -0.4718 -0.6611 -4.5304 5.8935 0 1.4279 0.276 0 0.7968 1.0687 0.07 0.07 0.07 0.08 0.08 0.09 0.09 0.09 0.09 0.1 0.1 0.11 0.09 0.1 0.09 0.09 0.09 0.09 0.1 0.1 DATE Returns IBM Returns_KR Returns_TSLA Returns_DAL Returns TRV 27-Jun-12 0.547 1.1091 1.1072 -0.6284 1.0941 28-Jun-12 -0.829 0.5704 -1.7209 0.813 0.0318 29-Jun-12 2.1839 1.178 -0.382 -1.8817 1.5752 2-Jul-12 0.1278 -1.6386 -2.8444 1.5525 0.1253 3-Jul-12 0.0511 0.4384 0.8553 -3.2374 0.3285 5-Jul-12 -0.3266 -1.2658 1.8591 - 1.2082 -0.2651 6-Jul-12 - 1.9868 0.7957 -0.7685 3.4807 - 1.0944 9-Jul-12 -0.909 -1.5351 1.6134 -0.8182 -0.3003 10-Jul-12 -1.7979 0.5791 -0.6986 -1.7415 0.222 11-Jul-12 -0.5422 1.0186 0.7675 3.4515 - 1.0758 12-Jul-12 - 1.166 -3.7264 3.7766 -3.0658 -0.4638 13-Jul-12 1.5948 0.7286 4.7401 0.6512 1.4299 16-Jul-12 -0.6559 -0.9042 4.9927 1.3863 -0.9187 17-Jul-12 -0.6169 0.1825 -7.2581 - 1.5497 1.215 18-Jul-12 2.5048 0.0911 -3.5982 -5.2778 1.0899 19-Jul-12 3.7663 - 1.7743 0.3732 -2.2483 -0.4844 20-Jul-12 -1.4795 -0.5558 -1.4874 -0.6 -1.5387 23-Jul-12 -0.8418 -0.9315 -3.5546 -2.8169 -1.5468 24-Jul-12 -0.2568 -0.7522 -2.6745 -3.4161 -1.3767 25-Jul-12 0.3888 0.6632 -2.9826 1.5005 0.1478 26-Jul-12 1.502 1.3177 -2.8325 -0.6336 1.0331 27-Jul-12 1.2581 1.5792 4.9058 0.1063 1.8017 30-Jul-12 0.1477 0.2743 -7.3196 0.5308 0.7812 31-Jul-12 -0.3559 1.0944 0.2559 1.9007 -0.8859 1-Aug-12 -0.4082 0.1353 -4.267 -1.7617 1.1173 2-Aug-12 -0.374 -1.4414 -0.5714 -2.6371 -0.7577 3-Aug-12 2.0931 1.4625 4.4828 0.6501 1.3361 6-Aug-12 0.1209 1.1712 3.667 0.8611 -0.2982 7-Aug-12 0.5886 0.089 7.0039 -0.5336 -0.2361 8-Aug-12 -0.025 1.0231 -3.8347 0.7511 0.6943 9-Aug-12 -0.3065 -0.8807 1.1 -3.4079 0.1254 Returns XOM Returns TM Returns ACN Returns_XRX Returns_BRK 0.9709 -0.0262 - 1.0275 1.3505 0.7992 -0.1202 2.3073 1.3603 1.0458 0.4391 2.9723 3.1266 6.1098 1.8111 1.2023 -0.2688 -0.3728 0.6657 0 0.384 1.1015 0.873 0.9919 0.8895 0.1554 -0.8229 -0.3215 -1.3423 -1.2594 -0.6684 -0.8998 -0.5954 -3.0363 -0.6378 -0.8171 -1.3561 -0.9983 - 1.078 -1.5404 1.0298 -0.6455 -2.2057 -1.4357 -1.3038 -0.4077 1.5281 -0.2964 0.2633 0.6605 1.2522 -0.3081 -1.8743 0.2451 -2.8871 -0.6541 1.6048 0.8431 1.3794 - 1.7568 1.1252 -0.4914 -0.418 -0.0172 -0.1375 -0.5919 0.7995 -0.4591 0.4307 -0.2755 1.4408 0.5599 0.7907 1.0978 -0.6906 -0.2465 0 0.353 0.6956 0 -0.4119 -0.3016 -2.1108 -0.5897 -6.815 -0.9453 -0.861 - 1.1979 -2.1186 0.4478 -0.2863 -0.7393 -1.684 -0.8312 -3.5661 0.1316 0.7803 -0.644 0.6984 -1.6949 0.4062 1.5016 2.2066 2.6704 4.0752 0.7496 1.0749 2.6717 2.0605 3.0121 0.626 0.1258 -0.8148 -0.0827 1.0234 0.0352 -0.8109 1.378 -0.1325 0.2894 -0.4576 0.0691 0.2614 -0.1658 -2.0202 -0.2593 - 1.1851 0.4172 -1.9435 -2.0619 -0.6381 1.9446 5.2317 2.2362 4.2105 1.784 -0.1142 -0.3824 0.464 0.7215 -0.5025 0.5375 1.1641 0.5278 1.7192 -0.5637 0.4095 -0.9181 1.3946 0.4225 -0.0236 0.5551 0.766 -0.4045 0.561 -0.1299 3month Tbill 0.09 0.09 0.09 0.1 0.09 0.08 0.08 0.09 0.09 0.1 0.1 0.1 0.1 0.1 0.09 0.09 0.09 0.1 0.1 0.1 0.11 0.11 0.11 0.11 0.1 0.09 0.09 0.1 0.11 0.11 0.11 0.3305 3month Tbill 0.1 0.11 0.11 0.09 0.09 0.09 0.11 0.11 0.11 0.11 0.1 0.11 0.1 0.12 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM 10-Aug-12 0.4385 -0.0444 1.8021 -0.1102 0.1409 0.2721 13-Aug-12 -0.1405 0.2444 4.1082 2.2075 -0.3907 -0.3392 14-Aug-12 -0.3618 -0.4011 -5.6144 0.216 -0.2981 0.0681 15-Aug-12 0.0555 - 1.1633 -0.068 -0.2155 -0.2268 16-Aug-12 1.2298 0.1811 3.0612 -2.4838 0.4392 0.7614 17-Aug-12 0.1892 -0.4519 -0.9571 1.1074 1.7179 -0.3045 20-Aug-12 -0.3578 0.4539 -1.6661 3.6145 0.7831 -0.5091 21-Aug-12 -0.9227 -0.5422 -1.3555 2.6427 -0.6246 -0.5571 22-Aug-12 -0.7048 -0.2272 2.8856 -1.8538 0.3373 0.3087 23-Aug-12 -0.7858 - 1.2295 2.6043 -3.9874 -0.9931 -0.4787 24-Aug-12 1.0577 0.5532 -4.0026 -0.4372 0.9259 0.8476 27-Aug-12 - 1.0517 0.8712 -4 -0.5488 -0.3364 -0.3521 28-Aug-12 -0.419 0.9091 1.3065 -3.9735 -0.5216 0.4103 29-Aug-12 0.1078 -0.2252 -0.976 -1.0345 -0.0617 -0.227 30-Aug-12 -0.8766 0.2257 0 -0.6969 -0.4784 -0.7964 31-Aug-12 0.7654 0.3604 0.3872 1.1696 0.3877 0.1147 4-Sep-12 -0.1591 0.2693 -1.3324 -1.0405 -0.1545 -0.2062 5-Sep-12 0.257 0.9848 -0.7107 3.7383 -0.1702 0.241 6-Sep-12 2.0816 2.3936 2.1832 3.6036 1.9681 1.9008 7-Sep-12 0.2009 -1.6017 2.8021 0.8696 -0.199 1.0451 10-Sep-12 0.7268 1.4078 -6.7462 1.0776 0.1533 -0.4893 11-Sep-12 1.1545 1.5184 1.5711 - 1.0661 2.5111 0.1565 12-Sep-12 0.246 2.2222 1.7266 2.3707 0.8813 -0.0781 13-Sep-12 1.271 -0.1672 4.2433 -0.5263 1.3473 1.876 14-Sep-12 0.2181 -0.335 3.0868 -1.9048 0.1899 1.1729 17-Sep-12 0.1644 0.042 7.0747 -0.4315 -0.1458 -0.4225 18-Sep-12 -0.0386 -0.756 -3.6878 -2.9252 -0.0292 -0.2829 19-Sep-12 -0.3091 1.5235 -0.9253 4.5759 -0.336 - 1.1784 20-Sep-12 -0.1211 -0.3752 -0.4831 -2.3479 0.3224 1.0489 21-Sep-12 -0.097 -0.9205 -2.8479 -0.929 0.2338 0.4371 24-Sep-12 -0.335 0 2.1319 0.717 -0.2769 -0.0435 Returns_TM -0.0858 -0.6136 -0.8026 -0.1618 2.6181 0.3159 -1.09 0.2816 0.6838 -0.4851 0.5118 - 1.0791 -0.8579 0.136 -0.9506 -0.7603 - 1.1178 -0.3683 2.3967 1.6808 0.0245 -0.4774 0.9471 1.0601 0.2894 -2.1279 0.0123 0.9334 -0.292 -0.537 -1.227 Returns_ACN Returns_XRX Returns_BRK 0.13 0.1395 0.2721 -0.2109 0.1393 0.2595 -0.3902 -0.1391 -0.0588 -0.7182 0.8357 -0.2708 0.5426 1.3812 0.6021 -0.1145 0.9537 0.7627 -0.4748 0.135 -0.1397 0.3125 0 -0.6181 0.9347 -1.752 0.5515 - 1.1698 0.1372 -0.6302 1.1507 1.0959 0.2819 -0.4551 - 1.084 0.0234 -0.6531 1.0959 -0.5737 0.2794 0.1355 -0.4357 0.213 -0.8119 -0.6387 0.7359 0.5457 0.3928 -0.8766 -1.4925 -0.1067 0.4749 2.2039 1.1157 4.1076 3.504 1.5025 0.8924 0 0.1966 -0.6518 -2.8646 -0.0346 1.3433 0.4021 0.1732 0.447 2.2697 -0.0346 0.9667 1.0444 2.11 0.1368 1.5504 0.1581 -0.4401 -2.0356 -0.2029 -0.4726 -1.2987 0.1017 0.2297 2.5 0.3837 -0.382 0.1284 0.4272 0.092 0 0.2351 0.8123 - 1.0256 -0.9828 0.1 0.09 0.1 0.11 0.11 0.11 0.1 0.1 0.1 0.1 0.11 0.11 0.1 0.11 0.11 0.11 0.11 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM Returns_ACN Returns XRX Returns BRK 13-Nov-12 -0.4914 0.0401 1.7519 -0.8738 -0.2923 -0.9734 0.2188 -0.5402 1.4218 0.7037 14-Nov-12 -1.4921 - 1.2111 -0.7411 -6.3663 -0.2345 -0.4626 -1.8749 -1.8558 -2.0249 - 1.1529 15-Nov-12 0.1833 -0.3678 - 1.7846 -0.7322 0.3673 0.0813 5.0386 -0.7072 -0.159 0.4948 16-Nov-12 0.5865 0.5742 3.3092 -1.686 0.483 0.3599 2.2801 2.4772 -0.7962 0.7151 19-Nov-12 1.8241 0.4486 3.3923 2.358 1.2964 1.4112 1.4862 1.3144 3.0498 0.9894 20-Nov-12 -0.6042 -0.3654 0.243 1.3613 0.1438 -0.1939 -0.5281 -0.6412 0 0.0346 21-Nov-12 0.5761 0.4482 -1.6061 0.4132 0.8329 0.5829 1.8825 1.3958 0.6231 0.9102 23-Nov-12 1.6817 1.3387 -1.0471 1.2346 1.4953 1.2271 1.3976 0.9177 3.096 1.0505 26-Nov-12 -0.3153 -1.4812 0.4357 -0.4065 -0.5753 -0.5275 1.3083 -0.748 -1.2012 -0.2373 27-Nov-12 -0.8555 1.0158 -0.3719 0.2041 -0.0423 -1.4331 - 1.718 -0.4729 -0.7599 -0.2379 28-Nov-12 0.3922 0.8045 3.3592 1.833 0.1835 0.8586 -0.1525 0.9948 2.1439 0.2157 29-Nov-12 -0.2344 4.7486 1.3843 0.5 0.31 0.0227 1.6449 0.4852 1.7991 -0.3399 30-Nov-12 -0.7623 -0.0381 0.3859 -0.4975 -0.5058 0.0227 -0.4971 -0.6291 0.2946 0.125 3-Dec-12 -0.3104 2.0579 2.3655 0.1836 -0.6013 -0.4879 -0.1325 -0.2937 -0.3747 4-Dec-12 -0.0633 0.3361 -2.0797 1.1434 -0.592 -0.4794 -0.1634 1.1499 2.7982 -0.547 5-Dec-12 -0.375 -0.5955 -0.5605 -0.2055 4.9199 0.6193 -0.2923 1.4429 -0.1433 0.4011 6-Dec-12 0.5566 0.7113 0.5636 3.1926 -0.527 0.3078 0.4574 0.2874 0.7174 -0.1484 7-Dec-12 1.1861 -0.3346 0.7965 0.8982 0.3281 0.6818 0.5137 -0.4585 0.9972 -0.1829 10-Dec-12 0.349 -0.5968 1.1706 0.2967 -0.0681 -0.2144 -0.2091 0.0432 -0.8463 -0.2634 11-Dec-12 0.8203 -0.1876 2.0538 5.1282 0.1227 0.656 0.1513 1.899 1.2802 0.1952 12-Dec-12 -0.6437 -0.0376 -0.0567 0.5629 -0.1634 0.5169 0.8483 -0.4518 -0.5618 2.349 13-Dec-12 -0.4975 -0.9026 -4.6795 5.3172 -0.1091 -0.9726 -1.0371 - 1.3473 -0.565 0.1344 14-Dec-12 -0.1198 -0.2277 0.5951 -0.62 0.1912 -0.5645 0.0466 0.9344 -0.9943 -0.3242 17-Dec-12 0.97 1.065 1.745 0.0891 1.1176 0.8969 0.7798 1.5952 -0.4304 0.931 18-Dec-12 1.0691 0.6775 0.5523 2.6714 0.7764 3.072 -0.2944 2.5937 0.4334 19-Dec-12 -0.3117 -0.9346 0.0578 2.6019 -1.2108 -1.2546 1.6807 - 1.0124 -0.8427 -0.2988 20-Dec-12 -0.1589 0.4906 -0.5201 0.9298 0.5311 0.5129 2.0716 - 1.9602 0.9915 0.6548 21-Dec-12 -0.6931 -1.2392 - 1.2489 -0.67 -1.3546 -1.8675 -2.008 -2.3182 - 1.122 -0.9483 24-Dec-12 -0.5274 0.1521 0.8235 -0.6745 -0.6317 -0.3554 0.4517 -0.7119 -0.9929 0 26-Dec-12 -0.2339 -0.9112 -2.0128 -1.1036 -0.1244 0.1726 -0.8993 -0.971 -1.1461 -0.6345 27-Dec-12 0.3959 -0.5364 0.2977 -0.6867 -0.6227 -0.2412 2.4126 -0.1056 -0.9783 -0.0448 3month Tbill 0.11 0.1 0.08 0.06 0.09 0.08 0.1 0.1 0.1 0.1 0.1 0.09 0.08 0.1 0.1 0.1 0.1 0.09 0.09 0.08 0.07 0.06 0.04 0.05 0.06 -3.8 0.1887 0.05 0.06 0.06 0.06 0.09 0.08 DATE Returns IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns_XOM Returns_TM Returns ACN Returns XRX Returns BRK 28-Dec-12 - 1.4945 - 1.0786 -1.3951 -0.605 -0.8076 -2.0263 -0.5079 -0.8457 -1.4728 -0.751 31-Dec-12 0.9061 1.324 1.9566 3.2174 0.8142 1.7039 1.2816 1.2793 1.9432 1.2987 2-Jan-13 2.5059 1.3451 4.3992 3.0329 1.4481 2.4957 2.9383 3.8496 5.4252 3.9019 3-Jan-13 -0.55 0.0758 -1.6686 2.8618 0.7686 -0.1804 -0.6459 -0.362 0 0.4518 4-Jan-13 -0.6555 0.2653 - 1.0641 3.1796 0.8717 0.463 2.0656 0.5523 - 1.1127 0.2445 7-Jan-13 -0.4382 -2.4187 -0.1744 0.077 -1.3503 - 1.1578 -1.8595 -0.4336 1.6878 -0.4262 8-Jan-13 -0.1398 -2.0914 -1.922 -0.077 0.1779 0.6255 - 1.6749 0.5806 -0.1383 0.3852 9-Jan-13 -0.2852 1.068 -0.1188 1.0015 1.0247 -0.3843 1.8418 0.7072 0 -0.5223 10-Jan-13 0.2912 0 -0.327 1.4493 0.6897 1.0892 1.2544 -0.8742 0.9695 1.4252 11-Jan-13 0.814 0.5871 - 1.8491 0.3759 0.5373 0.5724 -0.7743 1.0265 -0.4115 -0.2747 14-Jan-13 -0.9411 0.6226 1.0635 0.6742 0.1336 -0.0335 0.7179 -0.0286 1.9284 1.0277 15-Jan-13 -0.0623 0.9667 1.9242 1.4137 0.8139 -0.0558 -0.3822 0.5583 0.2703 0 16-Jan-13 0.0468 0.6894 0.59 2.1277 -0.0132 -0.067 - 1.8563 -0.5125 2.1563 -0.3461 17-Jan-13 0.5504 1.5215 0.8211 -0.6466 0.4633 0.8159 2.2612 0 0.2841 18-Jan-13 0.4234 1.4612 0.4072 -1.5907 0.5402 0.6652 -0.9196 0.3148 0.7916 -0.1469 22-Jan-13 0.8279 1.2925 1.9409 2.939 2.1491 0.1322 - 1.1054 0.4992 -1.4398 0.7881 23-Jan-13 4.4064 0.8385 2.3018 -1.6417 -0.3977 -0.242 -0.4007 1.1212 0.664 0.5943 24-Jan-13 -0.1465 0.3615 2.75 1.0885 0.5796 0.7167 1.3658 0.1263 2.2427 0.8603 25-Jan-13 0.2691 0.2882 -0.027 1.7229 0.333 0.416 0.376 1.2195 2.3226 0.0822 28-Jan-13 -0.0195 -0.1437 2.8394 -1.6232 - 1.2763 -0.6759 - 1.3736 -0.1523 3.7831 -0.2772 29-Jan-13 -0.5026 -0.3237 -0.2104 -1.8651 0.5947 0.7134 0.8652 -0.5548 - 1.0936 0.1236 30-Jan-13 -0.1864 0.1804 - 1.1331 1.1696 -0.2956 -1.1879 0 0.8926 0.2457 -0.3702 31-Jan-13 -0.2211 -0.2161 -0.0267 0.3613 1.1343 -0.772 -0.2406 -0.6221 -1.8382 0.0516 1-Feb-13 1.039 0.6859 2.1061 -0.504 1.8226 0.0778 2.894 2.6568 0.1248 1.1039 4-Feb-13 -0.6775 -0.7888 -1.4621 0.2894 -2.3658 -0.9884 -0.3057 - 1.3279 -0.9975 -1.5204 5-Feb-13 -0.4907 0.7951 1.0334 0.5051 0.8333 0.6618 1.0528 0.7416 1.0076 1.4506 6-Feb-13 -0.4537 -0.1076 2.7275 3.8765 0.3941 0.0557 3.9854 - 1.2814 -0.3741 -0.0817 7-Feb-13 -0.6368 0.5743 0.7914 2.6952 0.2026 - 1.0803 0 0.7318 0 -0.736 8-Feb-13 0.9713 0.6424 -0.6079 -1.6151 -0.3286 0.4079 1.6051 0.4935 -0.3755 0.1442 11-Feb-13 -0.7537 0.6738 -2.0897 0.4788 0.4438 -0.3724 1.4169 -0.3274 0.3769 -0.1234 12-Feb-13 -0.06 0.5284 -1.3795 - 1.2934 0.8711 0.2039 -1.0384 0.4106 -0.3755 0.5868 3month Tbill 0.01 0.05 0.08 0.08 0.07 0.07 0.07 0.06 0.06 0.07 0.08 0.09 0.08 0.07 0.08 0.08 0.08 0.08 0.08 0.07 0.07 0.07 0.07 0.06 0.07 0.07 0.07 0.07 0.07 0.09 0.09 3monthTbill 0.01 0.05 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns TRV Returns XOM ReturnsTM Returns ACN Returns XRX Returns BRK 28-Dec-12 -1.4945 - 1.0786 -1.3951 -0.605 -0.8076 -2.0263 -0.5079 -0.8457 -1.4728 -0.751 31-Dec-12 0.9061 1.324 1.9566 3.2174 0.8142 1.7039 1.2816 1.2793 1.9432 1.2987 2-Jan-13 2.5059 1.3451 4.3992 3.0329 1.4481 2.4957 2.9383 3.8496 5.4252 3.9019 3-Jan-13 -0.55 0.0758 -1.6686 2.8618 0.7686 -0.1804 -0.6459 -0.362 0 0.4518 4-Jan-13 -0.6555 0.2653 - 1.0641 3.1796 0.8717 0.463 2.0656 0.5523 - 1.1127 0.2445 7-Jan-13 -0.4382 -2.4187 -0.1744 0.077 - 1.3503 - 1.1578 -1.8595 -0.4336 1.6878 -0.4262 8-Jan-13 -0.1398 -2.0914 - 1.922 -0.077 0.1779 0.6255 -1.6749 0.5806 -0.1383 0.3852 9-Jan-13 -0.2852 1.068 -0.1188 1.0015 1.0247 -0.3843 1.8418 0.7072 0 -0.5223 10-Jan-13 0.2912 0 -0.327 1.4493 0.6897 1.0892 1.2544 -0.8742 0.9695 1.4252 11-Jan-13 0.814 0.5871 - 1.8491 0.3759 0.5373 0.5724 -0.7743 1.0265 -0.4115 -0.2747 14-Jan-13 -0.9411 0.6226 1.0635 0.6742 0.1336 -0.0335 0.7179 -0.0286 1.9284 1.0277 15-Jan-13 -0.0623 0.9667 1.9242 1.4137 0.8139 -0.0558 -0.3822 0.5583 0.2703 0 16-Jan-13 0.0468 0.6894 0.59 2.1277 -0.0132 -0.067 -1.8563 -0.5125 2.1563 -0.3461 17-Jan-13 0.5504 1.5215 0.8211 -0.6466 0.4633 0.8159 2.2612 0 0 0.2841 18-Jan-13 0.4234 1.4612 0.4072 - 1.5907 0.5402 0.6652 -0.9196 0.3148 0.7916 -0.1469 22-Jan-13 0.8279 1.2925 1.9409 2.939 2.1491 0.1322 -1.1054 0.4992 -1.4398 0.7881 23-Jan-13 4.4064 0.8385 2.3018 -1.6417 -0.3977 -0.242 -0.4007 1.1212 0.664 0.5943 24-Jan-13 -0.1465 0.3615 2.75 1.0885 0.5796 0.7167 1.3658 0.1263 2.2427 0.8603 25-Jan-13 0.2691 0.2882 -0.027 1.7229 0.333 0.416 0.376 1.2195 2.3226 0.0822 28-Jan-13 -0.0195 -0.1437 2.8394 -1.6232 - 1.2763 -0.6759 - 1.3736 -0.1523 3.7831 -0.2772 29-Jan-13 -0.5026 -0.3237 -0.2104 -1.8651 0.5947 0.7134 0.8652 -0.5548 - 1.0936 0.1236 30-Jan-13 -0.1864 0.1804 - 1.1331 1.1696 -0.2956 -1.1879 0 0.8926 0.2457 -0.3702 31-Jan-13 -0.2211 -0.2161 -0.0267 0.3613 1.1343 -0.772 -0.2406 -0.6221 -1.8382 0.0516 0.08 0.08 0.07 0.07 0.07 0.06 0.06 0.07 0.08 0.09 0.08 0.07 0.08 0.08 0.08 0.08 0.08 0.07 0.07 0.07 0.07 Question 1 10 pts Consider that on January 2, 2014 (Wednesday) you decide to invest in a portfolio consisting of these 10 stocks. You want to find the optimal portfolio to invest in, so you analyze the performance of these 10 stocks over time (using past historical data from January 3, 2011 to December 31, 2013). Please construct the optimal portfolio if short selling is allowed. Use the 3-month T-bill rate as a proxy for the risk-free rate. Assume that riskless borrowing/lending is possible (Hint: Use the borrowing/lending rate on January 2, 2014 - use the specific value provided in the Excel file for this assignment). Please solve this part using Excel Solver (GRG Nonlinear Method). What is the proportion of your funds invested in Tesla? Please report the full number (not the %), rounded to three decimals. Question 2 10 pts Please construct the optimal portfolio if short selling is not allowed. Solve this part using Excel Solver (GRG Nonlinear Method). What is the proportion of your funds invested in Accenture PLC Ireland? Please report the full number (not the %), rounded to three decimals. 0.3439 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM Returns ACN Returns_XRX Returns_BRK _3monthTbill 16-Feb-11 2.6979 8.275 -0.6723 0.1853 0.8678 0.7637 2.7313 2.71 -0.0235 0.12 17-Feb-11 0.5141 -0.5599 -4.5693 -1.4382 0.5382 0.227 -0.2455 1.1796 0 -0.0353 0.09 18-Feb-11 0.3653 0.0433 -1.7797 - 1.2876 1.907 0.7392 -0.2675 -0.7957 -0.4398 0.1413 0.1 22-Feb-11 -1.7532 0.4329 -5.6514 -6.6087 -0.6402 1.1124 -2.6931 -2.313 -3.9753 -2.2105 0.12 23-Feb-11 - 1.0929 -0.3879 -0.1829 2.6071 -0.1817 1.9078 -0.5734 -2.1195 -1.7479 -0.3727 0.12 24-Feb-11 0.3683 -0.6058 3.2066 0.9982 -1.804 -1.2633 -0.0776 0.9559 -0.6554 0.6034 0.13 25-Feb-11 0.9392 -0.4789 4.7936 -0.0898 0.4551 -0.7328 1.8313 0.8309 1.0368 1.8114 0.13 28-Feb-11 -0.2465 0.175 1.1859 1.0791 0.5537 0.2226 1.6894 - 1.3415 0.2798 2.8396 0.15 1-Mar-11 - 1.1799 -0.7424 0.2093 -5.605 - 1.1847 -0.8535 -0.493 -0.6216 - 1.2093 -2.3258 0.14 2-Mar-11 0.1188 -0.9239 0.3342 -4.3355 -0.6923 0.3302 -1.411 -0.0195 -0.7533 -0.2698 0.13 3-Mar-11 2.0729 2.2202 1.4155 1.0837 0.4081 0.8698 0.7211 3.6755 1.2334 1.976 0.13 4-Mar-11 - 1.0093 2.5195 2.422 -3.4113 0.2202 -0.8623 -1.3017 -0.7166 -1.687 - 1.3841 0.12 7-Mar-11 - 1.1741 0.1695 -0.0401 1.8164 -0.3717 -0.4231 -2.1651 -0.4938 -0.9533 -0.538 0.11 8-Mar-11 1.4694 0.2961 - 1.1227 9.7126 0.7802 -0.1416 1.0896 -0.2481 1.6843 1.5404 0.11 9-Mar-11 2.2061 0.0844 0.2433 -1.7163 0.5757 -0.26 -0.5001 -0.421 -0.8045 -0.3822 0.1 10-Mar-11 -2.3152 0.885 -2.8722 2.7574 -1.4815 -3.5553 -2.256 - 1.249 -1.4313 - 1.209 0.08 11-Mar-11 0.253 -0.1253 0.2499 0.4472 0.6152 0.9093 -2.1366 0.3697 0.6776 0.3766 0.08 14-Mar-11 -0.6403 -0.2091 -3.4067 -2.3152 -0.034 0.3166 -4.5768 -0.252 -0.6731 - 1.2778 0.09 15-Mar-11 - 1.4685 - 1.2903 -2.5524 -0.5776 -1.2017 -0.416 -2.7794 -1.4521 -2.0069 0.1 16-Mar-11 -3.7857 - 2 -0.5665 -4.5837 -0.8031 -2.5556 - 1.2041 -2.0792 -3.0452 -1.9026 0.1 17-Mar-11 0.7712 0.8929 -0.0438 -3.3333 1.0853 2.3326 2.052 0.0817 2.7356 2.1989 0.08 18-Mar-11 1.1091 0.5478 0.6576 3.854 - 1.0566 -0.382 -0.6093 2.5092 -0.1972 0.9066 0.07 21-Mar-11 1.1482 -0.9221 -1.0017 -0.6836 1.5329 2.4613 2.6851 0.199 1.2846 2.0244 0.1 22-Mar-11 0.2029 0.0423 -2.3757 -1.6716 -1.1366 -0.338 -0.8955 0 - 1.0732 -0.2231 0.1 23-Mar-11 0.9684 -0.6342 0.0901 -0.9 0.2574 0.0485 - 1.0361 0.6356 0.8876 -0.2824 0.09 24-Mar-11 0.3197 1.5745 0.5403 1.0091 0.6846 0.1574 -1.1566 2.5459 0.2933 0.4956 0.09 25-Mar-11 1.3372 -0.7122 1.8809 -2.0979 0.255 1.0758 -0.5296 4.4842 3.9961 0.0939 0.09 28-Mar-11 -0.4994 -0.0844 2.1978 1.1224 -0.1187 -0.1794 0.6649 - 1.3078 -0.2812 - 1.0206 0.11 29-Mar-11 0.9357 2.1537 2.8817 -1.2109 0.5941 -0.2636 - 1.0428 1.2878 0.4934 0.403 0.1 30-Mar-11 0.442 0.4134 -0.8779 1.5322 0.2194 1.4895 1.5682 0.9582 0.0939 0.8854 0.1 31-Mar-11 -0.324 - 1.3174 17.0392 -1.4084 0.1515 -0.4261 -0.877 0.3285 -0.0938 -2.1414 0.09 0.5868 -0.5006 0.1627 DATE Returns IBM Returns_KR Returns_TSLA Returns_DAL Returns_TRV Returns XOM ReturnsTM Returns ACN Returns XRX Returns_BRK 1-Apr-11 0.7359 -0.9178 -3.9279 0.2041 0.3867 0.6538 0.324 -0.1819 2.1596 0.0598 4-Apr-11 -0.0122 0.5474 -3.1133 0.1018 -0.134 0.2244 - 1.2793 0.3645 -0.3676 -0.6931 5-Apr-11 -0.1583 -0.3769 3.3682 -1.3225 -0.8385 0.648 -2.3276 -0.2542 0 - 1.2756 6-Apr-11 0.0305 0.7566 -0.7865 -1.134 1.3699 -0.281 -0.3607 -0.4551 0.0923 -0.0609 7-Apr-11 0.2073 0.5841 2.8313 -1.877 -0.2502 0.6809 -0.181 0.2926 0 -0.0732 8-Apr-11 -0.2008 -0.4562 -2.7533 -3.932 -0.3512 0.2215 0.8678 0.4741 - 1.3825 -0.1587 11-Apr-11 -0.061 0.9583 -4.6055 4.3142 1.4099 -0.9191 -1.772 1.6334 0.8411 0.5623 12-Apr-11 -0.427 -0.4952 -2.4535 4.9841 - 1.2082 -2.325 0.915 -0.2857 -0.278 -0.7051 13-Apr-11 0.4288 0.3733 1.1359 -3.2323 0.4021 -0.024 1.0104 2.0774 -0.2788 - 1.1263 14-Apr-11 0.6221 2.0661 0.8424 -2.4008 0.3367 -0.1282 - 1.7507 0.1864 -0.0248 15-Apr-11 0.7517 -0.6478 1.7502 - 1.0695 0.2851 1.0187 -0.3082 -1.6019 -0.1861 0.1858 18-Apr-11 -0.1624 0.163 -2.1501 - 1.1892 -1.3211 -1.4118 -0.5023 -0.3292 -0.5592 -0.7294 19-Apr-11 -0.3254 0.5194 -0.1094 -1.4065 0.8424 - 1.4628 1.67 - 1.1246 0.2491 20-Apr-11 -0.393 -1.5435 2.345 -0.6572 1.6329 2.2076 1.4976 1.1733 2.8436 1.5155 21-Apr-11 2.1426 1.1139 3.8447 -0.2205 3.7037 0.829 0.6989 1.3559 -5.8065 0.7832 25-Apr-11 -0.3625 -0.9792 - 1.3089 -0.5525 0.7502 -0.1621 2.1979 -0.4753 -1.8591 0.0243 26-Apr-11 0.4891 0.0824 2.0462 11 -0.6313 1.3918 - 1.069 0.283 0.4985 0.6555 27-Apr-11 1.1158 1.2351 0.557 0.6006 1.4009 0.4118 -0.4704 0.2998 0.2976 0.0844 28-Apr-11 0.2407 -2.074 2.1418 0.199 1.3012 -0.5013 1.5455 0.211 0.1978 0.3374 29-Apr-11 -0.1171 0.9551 -0.2169 3.0785 0.3489 0.7328 0.2264 0.2457 -0.3949 0.036 2-May-11 0.9204 -0.905 -0.5435 0.7707 0.3793 -1.148 0.6024 1.6279 0.1982 -1.6567 3-May-11 0.4182 0 -2.1129 0.5736 0.8344 - 1.5523 -0.5863 -3.6342 0.7913 0.4883 4-May-11 - 1.3016 0.2906 -0.6699 -0.4753 -0.7963 -0.946 0.0878 -0.0715 -0.6869 -0.8989 5-May-11 - 1.266 0.5795 -0.9367 7.1633 -0.8499 -2.5822 -0.2508 -1.7528 0.2964 -2.3535 6-May-11 0.7005 -0.2881 2.5719 -0.0891 0.6825 0.0847 -0.5782 0.4005 0.9852 0.6904 9-May-11 0.1243 0.2476 2.913 -3.5682 -0.0631 0.5926 0.3287 1.0698 -0.6829 0.6483 10-May-11 0.7569 1.2762 1.5048 -0.0925 0.7414 0.1923 2.0917 2.1887 2.7505 0.6193 11-May-11 -0.5165 -0.122 -4.4476 2.4074 -0.9552 -2.0998 0.5431 - 1.1938 - 1.8164 -1.3911 12-May-11 1.6165 2.3403 2.2165 - 1.7179 0.9486 -0.0863 2.6639 0.5686 0.2921 0.7491 13-May-11 -1.347 -0.0399 -0.4337 -2.0239 -2.3806 -0.2221 -0.2989 - 1.5194 -0.8738 - 1.3011 16-May-11 -0.6238 -0.1998 -3.4483 3.2864 0.9787 -0.779 -1.4032 0.7356 -0.3918 -0.2134 3month Tbill 0.07 0.06 0.07 0.06 0.04 0.04 0.05 0.05 0.06 0.07 0.07 0.07 0.06 0.06 0.06 0.07 0.07 0.06 0.04 0.04 0.05 0.03 0.03 0.02 0.02 0.03 0.03 0.03 0.02 0.03 0.04 3month Tbill 0.04 0.05 0.05 0.05 0.06 0.06 0.06 0.05 0.05 0.06 0.05 0.04 -0.0327 0.04 DATE Returns IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns_XOM Returns TM Returns_ACN Returns XRX Returns_BRK 17-May-11 0.9712 1.3211 -2.406 0.0909 -0.5879 0.2119 - 1.0218 1.0508 -0.9833 -0.692 18-May-11 -0.0352 0.1976 1.5023 -0.7266 0.6872 1.654 0.0246 0.3172 1.8868 0.8742 19-May-11 0.088 0.4732 7.0209 4.1171 -0.3016 0.7218 -0.8478 0.0351 0 -0.427 20-May-11 -0.2521 -2.0016 -0.8156 1.1424 -0.8916 -0.9231 -0.917 0.843 -1.462 -0.7064 23-May-11 - 1.1166 -1.5619 - 4.1115 -2.4327 -1.3012 -1.1033 -0.5253 -1.8809 - 1.3848 - 1.0544 24-May-11 -0.1605 -0.4475 -0.3729 - 1.2467 -0.6836 0.7686 0.44 0.0887 - 1.2036 -0.2825 25-May-11 -0.1429 -1.0625 8.4581 -5.4103 0.7211 0.8242 2.3532 0.3547 -0.2031 0.6309 26-May-11 -0.3398 0.537 1.7253 -2.9552 -0.4068 0.5246 0.5381 0.7775 1.5259 0.1919 27-May-11 0.1914 1.5612 0.2374 -1.7682 0.5065 0.2913 0.0608 -0.2104 0.2004 -0.3448 31-May-11 0.8537 0.4045 1.9966 0.8 0.9103 1.0166 1.2521 0.8434 2.1 1.3198 1-Jun-11 - 1.4029 -3.7067 -5.3849 -3.9683 -1.4175 -1.7252 -2.1491 -0.7144 -2.0568 -2.5168 2-Jun-11 -0.2822 -0.5858 0.8521 -0.6198 -0.8533 -0.7239 -0.2983 0.5 0.1038 3-Jun-11 -0.6262 -0.7997 4.7636 0 0 -0.1844 -0.4944 -1.7427 -0.4975 - 1.1794 6-Jun-11 -0.1818 - 1.7395 -4.7461 -3.0146 -0.1961 - 1.0963 -0.7328 -0.0717 -2.4 -1.1934 7-Jun-11 -0.6434 0.6045 -1.1498 -0.7503 0.2784 -0.3612 2.0646 0.8785 -1.6393 -0.6371 8-Jun-11 0.3971 1.3734 -4.4061 -1.2959 -0.2123 0.95 0.2207 -0.9419 -1.4583 -0.708 9-Jun-11 0.3042 0.7621 1.8437 0.4376 0.6426 0.5201 0.2079 1.0944 1.0571 0.9148 10-Jun-11 - 1.007 -2.1849 0.8689 0.4357 -3.0616 -1.7246 -1.5259 -1.4374 -1.6736 -1.2665 13-Jun-11 -0.0061 0.5584 2.0459 0.4338 -0.76 -0.6894 - 1.1776 0.7022 2.6596 0.3106 14-Jun-11 0.5822 -0.8116 0.598 2.5918 -0.1872 1.4515 0.9032 2.1277 1.8653 1.1038 15-Jun-11 - 1.0907 -1.1628 -4.4755 -1.7895 -1.8926 -2.1398 -1.1934 -2.9937 -1.9329 -1.7042 16-Jun-11 0.2094 4.5316 -3.0015 0.7503 0.3823 0.7119 -0.0126 -2.5808 0.8299 1.5983 17-Jun-11 1.0881 0.0417 0 1.9149 0.277 -0.2525 0.0503 -0.0556 1.3374 0.6666 20-Jun-11 0.3527 0.1667 - 1.8491 1.1482 -0.6043 0.8732 0.7798 0.0185 0.203 0.7813 21-Jun-11 0.7272 2.4126 5.8439 1.2384 0.8859 1.0789 0.7862 1.5382 1.1145 0.5125 22-Jun-11 -0.3249 -0.4874 - 1.1624 -2.2426 - 1.3085 -0.9309 -0.0743 0.8396 0.1002 -0.6798 23-Jun-11 0.2656 0.9796 1.8376 3.6496 -0.2791 - 1.7289 0.1487 0.7964 0.8008 -0.4739 24-Jun-11 -0.6321 -0.9701 -0.5233 -5.1308 -0.8397 -2.1163 0.5815 2.3882 -1.7875 0.0132 27-Jun-11 1.5448 -0.898 -0.3809 2.439 0.9527 1.4848 -1.9068 1.3504 0.2022 0.0132 28-Jun-11 1.4258 0.5354 2.3671 -2.795 0.5767 2.1946 0.4264 3.2186 2.2452 1.0446 29-Jun-11 0.3117 0.7374 0.6403 -2.0234 1.7724 0.7786 1.8107 0.4359 1.5857 0.7982 0.05 0.05 0.04 0.05 0.05 0.05 0.05 0.05 0.05 0.04 0.03 0.03 0.02 0.01 0.02 0.02 0.03 0.02 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM 30-Jun-11 0.5922 0.854 2.9692 -0.3261 -0.3244 1.4081 1.0916 1-Jul-11 1.7429 1.129 -0.3776 1.3086 1.2504 0.7742 1.2497 5-Jul-11 0.5099 -0.1595 0.4135 -1.8299 -0.9812 -0.4999 0.1798 6-Jul-11 1.2997 0.3594 -0.6177 0.1097 0.1367 -0.0368 0.8014 7-Jul-11 -0.6921 1.3132 2.6588 3.0668 0.4948 0.9685 0.4391 8-Jul-11 0.0057 -0.5499 -3.0945 -0.6376 -0.4075 0.0728 -0.2836 11-Jul-11 -0.8499 -1.3428 -1.5967 -3.7433 -0.6989 -0.6309 -0.8294 12-Jul-11 -0.5372 0.6005 -0.6349 -4.3333 0.1373 -0.0122 -0.0717 13-Jul-11 0.1551 0.5173 1.6684 1.0453 0.24 0.7205 1.2434 14-Jul-11 -0.0516 0.3563 -3.5964 -2.1839 - 1.2656 -0.291 -0.4724 15-Jul-11 0.7519 0.5128 -0.1087 - 1.1751 0.2945 0.9241 -0.5102 18-Jul-11 -0.1481 -0.2747 - 1.269 -4.1617 -2.3834 -0.4217 -0.5844 19-Jul-11 5.6652 1.6529 2.4238 2.4814 0.9023 1.1857 1.0557 20-Jul-11 -0.8423 -0.271 2.8684 -1.4528 0.0526 -0.3946 0.1068 21-Jul-11 0.6806 -2.368 0.0349 0.3685 1.1041 2.0648 1.3518 22-Jul-11 0.1514 0.6362 2.0557 -0.8568 -0.1907 0.2352 -0.5382 25-Jul-11 -0.7992 -1.936 -2.7313 -2.963 -1.6151 -0.7627 -1.0352 26-Jul-11 -0.4192 0.4432 - 1.7199 2.0356 0.2648 -0.2365 -0.0357 27-Jul-11 -0.8637 0.2006 -1.2857 -5.1122 -0.9331 -1.2564 -2.2949 28-Jul-11 0.2481 -0.5604 1.9175 0.2628 -1.3684 -2.2206 -0.9006 29-Jul-11 0.0275 0.1208 0 3.4076 -0.6667 -2.0501 0.6017 1-Aug-11 -0.6049 -0.7238 2.1299 -1.1407 -0.9432 -0.2381 -0.1831 2-Aug-11 -1.4938 -2.7542 -4.9705 -4.7436 -0.824 -2.2111 -0.587 3-Aug-11 0.4381 1.0829 -0.5121 1.6151 0.1108 -0.1542 -0.0369 4-Aug-11 -4.1101 -2.2662 -9.0074 -7.0199 -1.6783 -4.9923 -4.7379 5-Aug-11 0.8747 -0.7167 -2.0606 -0.7123 - 1.3881 1.3272 0.0258 8-Aug-11 -3.4744 -5.2654 -2.4752 -5.0215 -7.5899 -6.1882 -4.7914 9-Aug-11 2.6411 1.1206 6.0068 6.9486 6.4018 2.0658 4.7341 10-Aug-11 -4.7301 -2.7925 -4.9481 -5.6497 -5.1267 -4.383 -4.8957 11-Aug-11 2.5778 3.5796 6.2133 4.3413 4.792 5.2183 2.3287 12-Aug-11 0.8817 0.5307 3.9921 0 -0.5059 0.5868 -0.9848 Returns_ACN 0.8513 0.7448 1.4457 0.5668 2.1578 -0.0158 -3.0585 -0.7156 -0.6224 0.2637 -0.2137 - 1.1862 2.7009 -0.3409 0.5701 -0.7451 -0.1632 0.2615 -2.5921 -0.1004 -0.9214 -0.3044 -1.6113 2.7409 -4.396 0.4036 -7.0792 3.2543 -5.6477 4.2672 1.1296 Returns_XRX Returns_BRK 1.561 0.4674 2.8818 0.9045 - 1.3072 -0.9988 0 - 1.0219 1.0407 1.6336 -0.1873 - 1.1187 -3.8462 -2.1196 -0.4878 0.6776 0.1961 0.7126 - 1.4677 -0.2883 -0.5958 -0.9724 -0.8991 -0.3317 2.7218 1.571 - 1.2758 -0.1966 2.3857 1.576 -2.1359 -0.375 -1.7857 -1.4796 -1.1111 -0.5269 -2.145 - 1.0859 -1.6701 0.2142 -0.9554 -0.9085 -2.1436 1.0247 -3.3954 -2.0819 0.907 0.8723 -3.7079 -4.0805 -0.4667 0.3663 -9.7304 -6.4561 6.1039 9.4224 -5.6304 - 7.3084 3.6316 6.1243 0.2503 -0.3067 3month Tbill 0.03 0.02 0.02 0.01 0.03 0.03 0.03 0.03 0.01 0.01 0.02 0.02 0.03 0.02 0.05 0.05 0.05 0.07 0.08 0.07 0.1 0.1 0.06 0.02 0.02 0.01 0.05 0.03 0.02 0.03 0.02 3monthTbili 0.02 0.03 0.01 0.01 0.02 0.01 0.01 DATE Returns_IBM Returns KR Returns_TSLA Returns DAL Returns_TRV Returns XOM Returns TM Returns_ACN Returns XRX Returns_BRK 15-Aug-11 2.8478 0.6159 -0.3041 5.0215 2.2296 3.1806 2.3118 1.4832 3.2459 1.4262 16-Aug-11 - 1.0116 0.9182 -0.4956 4.6448 -0.5548 - 1.0634 -0.9196 -1.0826 -0.6046 - 1.0477 17-Aug-11 0.1401 1.2998 -1.0345 1.8277 0.4232 0.898 -0.9812 -0.5472 0.9732 0.8359 18-Aug-11 -4.4612 -1.9247 -6.0782 -5.2564 -4.6169 -4.342 -4.1644 - 10.3815 -7.5904 -3.8961 19-Aug-11 -3.8394 -0.9594 -8.0791 -2.4357 -0.6628 -1.607 - 1.2156 -2.9063 -4.5632 -1.7683 22-Aug-11 0.9141 0.044 -1.5695 0.1387 -0.6874 0.5444 -0.2263 2.2344 1.2295 -0.7756 23-Aug-11 3.3589 0.5722 4.6014 0.554 0.4682 4.9587 3.3173 4.0619 2.969 2.6401 24-Aug-11 1.4849 -1.5317 3.9634 -0.1377 0.3242 -0.1629 - 1.0977 1.0105 2.7523 1.6669 25-Aug-11 -0.7076 0 -3.1839 -5.7931 -3.0701 -2.4069 - 1.1238 -0.4512 -3.9541 -2.4876 26-Aug-11 2.15 0.8 2.6828 4.246 0.646 1.2122 0.5332 1.6749 2.5232 1.2321 29-Aug-11 2.0575 2.9541 4.1298 5.3371 5.0725 2.0374 0.628 2.6357 4.4042 3.9519 30-Aug-11 -0.0637 -1.242 -0.3238 1.4667 - 1.064 -0.2833 -1.6089 2.0204 0.1241 -0.4683 31-Aug-11 -0.3478 2.1683 0.4466 -1.0512 0.4979 0.1488 1.2687 -0.8144 2.8501 1.0241 1-Sep-11 -0.9191 -1.0611 -2.9911 - 1.4608 -0.4954 -0.716 -0.9326 - 1.2876 -2.2892 -2.2329 2-Sep-11 - 1.9668 -0.9867 -3.875 -2.0216 -2.6688 -1.837 -2.5713 -2.7032 -2.4661 -2.8023 6-Sep-11 - 1.1199 - 1.3865 -0.5635 - 1.9257 -0.6957 -1.3723 - 1.5431 -1.4572 -1.2642 - 1.4415 7-Sep-11 1.3324 3.2513 3.9233 4.7686 4.3272 3.5137 2.3143 2.918 2.8169 3.4079 8-Sep-11 - 1.2312 -0.6383 -0.9648 -2.1419 -1.7523 - 1.127 -0.6872 -0.0575 -2.3661 -1.8246 9-Sep-11 -2.348 -5.6959 -2.7107 -1.7784 -2.4321 -2.4856 -2.2632 -4.5045 -5.4847 -2.3628 12-Sep-11 0.6507 -0.9083 -0.3918 2.7855 1.7034 1.1688 0.5457 0.4014 1.4845 2.1691 13-Sep-11 0.6218 0.7333 5.2448 8.2656 -0.0409 -0.2645 1.2909 1.6793 2.1277 -0.5633 14-Sep-11 2.3313 0.546 1.0797 5.0063 0 1.3817 0.7531 0.8061 1.8229 0.8134 15-Sep-11 1.7041 2.3077 1.9721 0.8343 1.839 1.886 2.3573 3.4133 1.1509 2.0458 16-Sep-11 1.705 -0.973 3.9484 -0.7092 1.5449 0.7296 -0.5617 3.7722 1.3907 1.0165 19-Sep-11 0.0809 -0.0447 -0.1163 -1.0714 -1.4029 -1.1402 0.0424 -0.7634 -1.3716 -2.6415 20-Sep-11 0.9184 0.1341 0.9313 0.722 1.0421 0.4206 -0.5788 -0.3297 -1.8963 0.0861 21-Sep-11 -0.973 -2.9005 -0.6151 -4.4205 - 4.4228 -2.7564 -3.0243 -1.8927 -3.4794 -3.5858 22-Sep-11 -2.5431 -0.1379 -0.8511 -5.25 - 1.6808 -3.7933 -1.9473 -5.6752 -5.0734 - 1.8149 23-Sep-11 0.427 0.2301 2.9263 7.7836 -0.5488 0.1011 1.314 0.0993 -0.1407 0.5606 26-Sep-11 3.053 1.1938 -3.26 1.5912 2.5891 3.4771 1.3559 2.9954 4.2254 8.6183 27-Sep-11 1.8337 -0.4537 2.6254 -1.9277 1.8618 1.6592 0.7881 3.3321 2.2973 -0.0277 0.02 0.01 0.01 0.02 0.01 0.02 0.02 0.02 0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0 0.01 0.02 0.01 3month Tbill 0.02 0.02 0.02 0.02 0.01 DATE Returns_IBM Returns_KR Returns_TSLA Returns DAL Returns_TRV Returns XOM ReturnsTM Returns_ACN Returns XRX Returns_BRK 28-Sep-11 -0.09 0.0456 -6.1092 -0.3686 - 2.173 - 1.1521 0.4942 0.3355 -2.8732 -1.7899 29-Sep-11 0.9124 1.2301 -

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!