Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please show me how to properly solve this problem? Calculate the return and standard deviation of a portfolio that holds these two stocks

Can you please show me how to properly solve this problem?

Calculate the return and standard deviation of a portfolio that holds these two stocks in the following weights: 0%-100%; 10%-90%; 20%-80%; 30%-70%; 40%-60%; 50%-50%; 60%-40%; 70%-30%; 80%-20%; 90%-10%, 100%-0%. Plot these portfolio return / standard deviation combinations. Make sure return is on the vertical axis and standard deviation is on the horizontal axis. (Important: use a scatterplot) (You may use excel for this part)

IBM MSFT S&P500 Date Adj Close Adj Close Adj Close 1/1/2013 166.326019 23.728479 1498.109985 2/1/2013 170.65 24.031023 1514.680054 3/1/2013 175.440353 24.935972 1569.189941 4/1/2013 170.82 28.849375 1597.569946 5/1/2013 171.097534 30.418219 1630.73999 6/1/2013 157.925735 30.315554 1606.280029 7/1/2013 161.173325 27.945776 1685.72998 8/1/2013 150.620682 29.31498 1632.969971 9/1/2013 153.790421 29.415483 1681.550049 10/1/2013 148.832352 31.298151 1756.540039 11/1/2013 149.222672 33.702305 1805.810059 12/1/2013 156.611816 33.316677 1848.359985 1/1/2014 147.519211 33.699623 1782.589966 2/1/2014 154.607925 34.118206 1859.449951 3/1/2014 161.600845 36.778709 1872.339966 4/1/2014 164.9422 36.249313 1883.949951 5/1/2014 154.775513 36.733837 1923.569946 6/1/2014 153.067429 37.679714 1960.22998 7/1/2014 161.849335 38.998959 1930.670044 8/1/2014 162.381317 41.050098 2003.369995 9/1/2014 161.243607 42.152081 1972.290039 10/1/2014 139.643082 42.688526 2018.050049 11/1/2014 137.748917 43.470474 2067.560059 12/1/2014 137.212143 42.500294 2058.899902 1/1/2015 131.11441 36.964733 1994.98999 2/1/2015 138.49501 40.121365 2104.5 3/1/2015 138.226334 37.467381 2067.889893 4/1/2015 147.518951 44.820786 2085.51001 5/1/2015 146.106522 43.180553 2107.389893 6/1/2015 142.2341 40.947735 2063.110107 7/1/2015 141.648209 43.31279 2103.840088 8/1/2015 129.318802 40.363434 1972.180054 9/1/2015 127.817833 41.320454 1920.030029 10/1/2015 123.506386 49.143898 2079.360107 11/1/2015 122.924469 50.74033 2080.409912 12/1/2015 122.475601 52.144402 2043.939941 1/1/2016 111.057495 51.777847 1940.23999 2/1/2016 116.610802 47.820961 1932.22998 3/1/2016 120.75 52.282135 2059.73999 4/1/2016 131.206726 47.208221 2065.300049 5/1/2016 138.219269 50.171154 2096.949951 6/1/2016 139.0961 48.77763 2098.860107 7/1/2016 145.8752 54.030018 2173.600098 8/1/2016 147.75692 54.773552 2170.949951 9/1/2016 149.75521 55.249226 2168.27002 10/1/2016 151.79542 57.474541 2126.149902 11/1/2016 155.8524 57.800663 2198.810059 12/1/2016 154.824356 60.006588 2238.830078 1/1/2017 162.780579 62.430424 2278.870117 2/1/2017 167.72406 61.783424 2363.639893 3/1/2017 163.710434 63.98444 2362.719971 4/1/2017 169.8546 66.510399 2384.199951 5/1/2017 170.8546 67.851097 2411.800049 6/1/2017 166.8924 67.350868 2423.409912 7/1/2017 169.3258 71.0345 2470.300049 8/1/2017 173.9651 73.057076 2471.649902 9/1/2017 180.95342 73.171272 2519.360107 10/1/2017 200.95423 81.707436 2575.26001 11/1/2017 225.8462 82.679909 2584.840088 12/1/2017 255.8456 84.447639 2673.610107

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

More Books

Students also viewed these Finance questions