Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Find the optimal investment portfolio in the risky assets. What is the expected returns, mean, variance and s.d this of this portfolio. Assuming all of

Find the optimal investment portfolio in the risky assets. What is the expected returns, mean, variance and s.d this of this portfolio. Assuming all of these assets are risky.

Date PG Microsoft BAC Exxon Expected Monthly Return
2/3/1997 0.039059 -0.04394 0.109771 -0.02517 Expected Monthly Return
3/3/1997 -0.04485 -0.05994 -0.07011 0.074816 PG 0.010848
4/1/1997 0.099732 0.325186 0.088252 0.051471 Microsoft 0.014854
5/1/1997 0.096787 0.02085 -0.0247 0.053613 BAC 0.011589
6/2/1997 0.024472 0.018853 0.102423 0.033628 Exxon 0.012043
7/1/1997 0.080347 0.118736 0.102398 0.048801
8/1/1997 -0.12496 -0.06478 -0.1604 -0.04122 Variance
9/2/1997 0.037519 0.000737 0.041554 0.046828 Variance
10/1/1997 -0.01181 -0.01767 -0.03368 -0.04067 PG 0.004478
11/3/1997 0.120612 0.088456 0.00429 -0.00042 Microsoft 0.012820
12/1/1997 0.047318 -0.08678 0.018687 0.002969 BAC 0.005611
1/2/1998 -0.01495 0.1546 -0.0152 -0.03087 Exxon 0.002820
2/2/1998 0.08301 0.135859 0.143693 0.082024
3/2/1998 -0.00596 0.056354 0.070731 0.060887 Covariance
4/1/1998 -0.0228 0.007077 0.042156 0.080578 Cov(PG, Microsoft) -0.000649
5/1/1998 0.020264 -0.05892 -0.00667 -0.02955 Cov(PG, BAC) 0.000683
6/1/1998 0.085766 0.277427 0.020991 0.012323 Cov(PG, Exxon) 0.000433
7/1/1998 -0.12555 0.014388 0.039885 -0.01575 Cov(Microsoft, BAC) 0.001681
8/3/1998 -0.03613 -0.12722 -0.27916 -0.06293 Cov(Microsoft, Exxon) 0.000804
9/1/1998 -0.07037 0.147283 -0.06308 0.079193 Cov(BAC, Exxon) 0.000757
10/1/1998 0.251503 -0.03807 0.074941 0.014029
11/2/1998 -0.01215 0.152324 0.133442 0.05321
12/1/1998 0.042346 0.136981 -0.07112 -0.02492
1/4/1999 -0.00165 0.261679 0.111743 -0.03938
2/1/1999 -0.01512 -0.14226 -0.02327 -0.04711
3/1/1999 0.094361 0.194093 0.088614 0.06
4/1/1999 -0.03929 -0.09269 0.013567 0.177287
5/3/1999 -0.00478 -0.00779 -0.09629 -0.03357
6/1/1999 -0.0563 0.117754 0.141424 -0.03442
7/1/1999 0.031383 -0.04862 -0.0946 0.029164
8/2/1999 0.095943 0.078932 -0.0883 -0.00126
9/1/1999 -0.05528 -0.02184 -0.07252 -0.03657
10/1/1999 0.122319 0.02233 0.156916 -0.02552
11/1/1999 0.029724 -0.01632 -0.09074 0.077569
12/1/1999 0.014433 0.282236 -0.13617 0.015581
1/3/2000 -0.07498 -0.16169 -0.0349 0.028843
2/1/2000 -0.13062 -0.08686 -0.0505 -0.08619
3/1/2000 -0.35411 0.18888 0.152988 0.035574
4/3/2000 0.057826 -0.34365 -0.06549 -0.00378
5/1/2000 0.113029 -0.10304 0.141377 0.07814
6/1/2000 -0.1466 0.278816 -0.22424 -0.05781
7/3/2000 0.010385 -0.12728 0.101858 0.021489
8/1/2000 0.084797 0 0.141786 0.02378
9/1/2000 0.083695 -0.13608 -0.02243 0.091423
10/2/2000 0.071038 0.141761 -0.08226 0.000819
11/1/2000 0.048299 -0.16696 -0.15732 -0.00845
12/1/2000 0.047696 -0.24374 0.149059 -0.0121
1/2/2001 -0.0799 0.407075 0.172544 -0.03201
2/1/2001 -0.01851 -0.03352 -0.04726 -0.03191
3/1/2001 -0.11214 -0.07308 0.079481 -0.00059
4/2/2001 -0.03476 0.238753 0.022977 0.093908
5/1/2001 0.069628 0.021215 0.067892 0.00652
6/1/2001 -0.00673 0.055282 0.013384 -0.01538
7/2/2001 0.119397 -0.09343 0.059906 -0.04386
8/1/2001 0.044078 -0.13802 -0.03338 -0.03326
9/4/2001 -0.01837 -0.1029 -0.0419 -0.01868
10/1/2001 0.019041 0.136126 0.010091 0.001209
11/1/2001 0.049936 0.104315 0.040438 -0.04648
12/3/2001 0.021479 0.031866 0.035665 0.050965
1/2/2002 0.037248 -0.0386 0.001325 -0.00633
2/1/2002 0.037938 -0.08413 0.02425 0.063959
3/1/2002 0.0625 0.03382 0.063711 0.061254
4/1/2002 0.00604 -0.13368 0.065561 -0.08349
5/1/2002 -0.00783 -0.02564 0.045955 -0.00029
6/3/2002 0.004999 0.074163 -0.06427 0.024612
7/1/2002 0.001571 -0.12249 -0.0551 -0.10152
8/1/2002 -0.00392 0.022843 0.053799 -0.0296
9/3/2002 0.008397 -0.10868 -0.08106 -0.10003
10/1/2002 -0.00598 0.22216 0.093723 0.055029
11/1/2002 -0.04424 0.078815 0.004265 0.04076
12/2/2002 0.016708 -0.10389 0.001931 0.003983
1/2/2003 0.000269 -0.082 0.006936 -0.02248
2/3/2003 -0.04336 0.002053 -0.01186 0.003044
3/3/2003 0.087838 0.021516 -0.02517 0.02731
4/1/2003 0.013716 0.056169 0.107668 0.00722
5/1/2003 0.021956 -0.03751 0.002152 0.041382
6/2/2003 -0.02873 0.041934 0.074087 -0.01345
7/1/2003 -0.00977 0.02983 0.044652 -0.0092
8/1/2003 -0.00649 0.004138 -0.04019 0.066901
9/2/2003 0.063268 0.048535 -0.00532 -0.0294
10/1/2003 0.064175 -0.05459 -0.0294 -0.00031
11/3/2003 -0.02103 -0.01663 -0.00413 -0.0034
12/1/2003 0.037999 0.064819 0.077774 0.132485
1/2/2004 0.016598 0.010146 0.012829 -0.00521
2/2/2004 0.014091 -0.04061 0.005383 0.040209
3/1/2004 0.023158 -0.06008 -0.00157 -0.01377
4/1/2004 0.013581 0.047942 -0.00599 0.023087
5/3/2004 0.019141 0.004159 0.032688 0.023091
6/1/2004 0.009808 0.088357 0.027658 0.02693
7/1/2004 -0.03761 -0.00211 0.004785 0.042458
8/2/2004 0.073223 -0.03898 0.058333 0.001677
9/1/2004 -0.03301 0.012787 -0.027 0.048314
10/1/2004 -0.04987 0.011319 0.033526 0.01848
11/1/2004 0.044861 0.068446 0.032998 0.046819
12/1/2004 0.030013 -0.00322 0.025717 0.000214
1/3/2005 -0.02934 -0.01657 -0.0132 0.006632
2/1/2005 -0.0025 -0.03946 0.005884 0.232944
3/1/2005 -0.00167 -0.03937 -0.04547 -0.05861
4/1/2005 0.026795 0.046771 0.021448 -0.04303
5/2/2005 0.018552 0.022979 0.028361 -0.00957
6/1/2005 -0.04343 -0.03744 -0.00583 0.022604
7/1/2005 0.059845 0.031115 -0.04401 0.022294
8/1/2005 -0.00257 0.072087 -0.0014 0.02458
9/1/2005 0.071655 -0.0602 -0.02179 0.060606
10/3/2005 -0.05356 -0.00125 0.039132 -0.11633
11/1/2005 0.021468 0.080383 0.060473 0.038876
12/1/2005 0.012037 -0.05513 0.005702 -0.03205
1/3/2006 0.028318 0.076295 -0.04175 0.117129
2/1/2006 0.01175 -0.04208 0.036848 -0.04883
3/1/2006 -0.03847 0.012663 0.00415 0.025036
4/3/2006 0.015852 -0.11254 0.096099 0.036549
5/1/2006 -0.06818 -0.05856 -0.0205 -0.0295
6/1/2006 0.02492 0.028531 -0.00602 0.007162
7/3/2006 0.016534 0.032742 0.071169 0.104232
8/1/2006 0.101416 0.072215 0.009718 0.003455
9/1/2006 0.001216 0.064066 0.040734 -0.0083
10/2/2006 0.027937 0.049788 0.005591 0.064394
11/1/2006 -0.00945 0.026103 0.010051 0.080071
12/1/2006 0.023517 0.017198 -0.00847 -0.00233
1/3/2007 0.0333 0.041916 0.003844 -0.04046

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Digital Business And Electronic Commerce

Authors: Bernd W Wirtz

1st Edition

3030634817, 9783030634810

More Books

Students also viewed these Finance questions