Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Date (MCD) Samsung [ER: MCD] [ER: Samsung] 2 7/1/2016 117.65 30780 (MCD) Samsung 3 8/1/2016 115.66 32400 0.84% 5.26% Average monthly return 4
1 Date (MCD) Samsung [ER: MCD] [ER: Samsung] 2 7/1/2016 117.65 30780 (MCD) Samsung 3 8/1/2016 115.66 32400 0.84% 5.26% Average monthly return 4 9/1/2016 115.36 31960 0.86% -1.36% Standard deviation of monthly return 0.60% 0.13% 1.83% 6.82% 5 112.57 32780 0.85% 2.57% 6 119.27 34920 0.94% 6.53% Annualized Mean 7 121.72 36040 0.86% 3.21% Annualized Standard Devitation 7.14% 0.46% 21.90% 23.61% 8 1/1/2017 122.57 39460 0.83% 9.49% 9 2/1/2017 127.65 38440 0.85% -2.58% Correlation 0.12 10 3/1/2017 129.61 41200 0.80% 7.18% Risk free rate 1.45% 10 Year US treasury bonds rate 11 4/1/2017 139.93 44620 0.83% 8.30% 12 5/1/2017 150.89 44700 0.77% 0.18% (MCD) Samsung Portfolio SD Portfolio Return Sharp Ratio 13 6/1/2017 153.16 47540 0.67% 6.35% 14 7/1/2017 155.14 48200 0.66% 1.39% 0.00% 5.00% 100.00% 23.61% 21.90% 0.87 95.00% 22.43% 21.17% 0.88 15 8/1/2017 159.97 46320 0.66% -3.90% 10.00% 90.00% 21.26% 20.43% 0.89 16 9/1/2017 156.68 51280 0.61% 10.71% 15.00% 85.00% 20.08% 19.69% 0.91 17 ######## 166.91 55080 0.68% 7.41% 20.00% 80.00% 18.90% 18.95% 0.93 18 ######## 171.97 50800 0.62% -7.77% 25.00% 75.00% 17.72% 18.21% 0.95 19 ######## 172.12 50960 0.58% 0.31% 30.00% 70.00% 16.54% 17.48% 0.97 20 1/1/2018 171.14 49900 0.58% -2.08% 35.00% 65.00% 15.37% 16.74% 0.99 21 2/1/2018 157.74 47060 0.54% -5.69% 40.00% 60.00% 14.19% 16.00% 1.03 22 3/1/2018 156.38 49220 0.63% 4.59% 45.00% 55.00% 13.01% 15.26% 1.06 23 4/1/2018 167.44 53000 0.68% 7.68% 50.00% 50.00% 11.84% 14.52% 1.10 24 5/1/2018 160.01 50700 0.57% -4.34% 55.00% 45.00% 10.66% 13.79% 1.16 25 6/1/2018 156.69 46650 0.61% -7.99% 60.00% 40.00% 9.48% 13.05% 1.22 26 7/1/2018 157.54 46250 0.64% -0.86% 65.00% 35.00% 8.30% 12.31% 1.31 27 8/1/2018 162.23 48450 0.65% 4.76% 70.00% 30.00% 7.13% 11.57% 1.42 28 9/1/2018 167.29 46450 0.64% -4.13% 75.00% 25.00% 5.95% 10.83% 1.58 29 176.90 42400 0.63% -8.72% 80.00% 20.00% 4.78% 10.09% 1.81 30 188.51 41850 0.60% -1.30% 85.00% 15.00% 3.61% 9.36% 2.19 31 177.57 38700 0.50% -7.53% 90.00% 10.00% 2.45% 8.62% 2.93 32 1/1/2019 178.78 46150 0.57% 19.25% 95.00% 5.00% 1.31% 7.88% 4.92 33 2/1/2019 183.84 45100 0.58% -2.28% 100.00% 0.00% 0.46% 7.14% 12.32 33 2/1/2019 183.84 45100 0.58% -2.28% 100.00% 0.00% 0.46% 7.14% 12.32 34 3/1/2019 189.90 44650 0.56% -1.00% 105.00% -5.00% 1.22% 6.40% 4.05 35 4/1/2019 197.57 45850 0.55% 2.69% 110.00% -10.00% 2.36% 5.67% 1.79 36 5/1/2019 198.27 42500 0.51% -7.31% 115.00% -15.00% 3.52% 4.93% 0.99 37 6/1/2019 207.66 47000 0.53% 10.59% 120.00% -20.00% 4.69% 4.19% 0.58 38 7/1/2019 210.72 45350 0.49% -3.51% 125.00% -25.00% 5.86% 3.45% 0.34 39 8/1/2019 217.97 44000 0.49% -2.98% 130.00% -30.00% 7.04% 2.71% 0.18 40 9/1/2019 214.71 49050 0.45% 11.48% 135.00% -35.00% 8.21% 1.97% 0.06 41 196.70 50400 0.43% 2.75% 140.00% -40.00% 9.39% 1.24% (0.02) 42 194.48 50300 0.50% -0.20% 145.00% -45.00% 10.57% 0.50% (0.09) 43 197.61 55800 0.52% 10.93% 150.00% -50.00% 11.74% -0.24% (0.14) 44 1/1/2020 213.97 56400 0.55% 1.08% 45 2/1/2020 194.17 54200 0.42% -3.90% Portfolio Return 46 3/1/2020 165.35 47750 0.44% -11.90% 47 4/1/2020 187.56 50000 0.69% 4.71% 48 5/1/2020 186.32 50700 0.53% 1.40% 49 6/1/2020 184.47 52800 0.53% 4.14% 50 7/1/2020 194.28 57900 0.57% 9.66% 51 8/1/2020 213.52 54000 0.57% -6.74% 52 9/1/2020 219.49 58200 0.48% 7.78% 53 ######## 213.00 56600 0.44% -2.75% 54 ######## 217.44 66700 0.48% 17.84% Portfolio Return 55 ######## 214.58 81000 0.45% 21.44% 56 1/1/2021 207.84 82000 0.45% 1.23% 57 2/1/2021 206.14 82500 0.48% 0.61% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% -5.00% Portfolio SD 58 3/1/2021 224.14 81400 0.53% -1.33% 59 4/1/2021 236.08 81500 0.47% 0.12% 60 5/1/2021 233.89 80500 0.42% -1.23% 61 6/1/2021 229.62 80500 0.42% 0.00% W1= 62 229.62 79900 0.44% -0.75% [E(r)-r1xo-[E(2)-r]x P [E(r)-r]xo+[E(r) r]x -[E(r) +E(12)] 0120102 63 64 65 66 67 W1 W2 = 1-W1 100.10% -0.10%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started