Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the portfolio optimization problem discussed in class, we minimized the portfolio's standard deviation subject to a constraint on the portfolio's expected return. Here we

image text in transcribed
In the portfolio optimization problem discussed in class, we minimized the portfolio's standard deviation subject to a constraint on the portfolio's expected return. Here we will require the portfolio's expected return to be at least 12%. In the table below are the closing prices of four stocks on the last Friday of October in each of the last six years (taken from finance.yahoo.com). Stock1 is General Motors (GM); Stock2 is Bank of America (BAC); Stock3 is Merck (MRK); and Stock4 is Starbucks (SBUX). Date Stock1 Stock2 Stock3 Stock4 10/28/2016 31.32 16.68 56.11 53.53 10/27/2017 44.64 27.80 55.53 54.88 10/26/2018 32.65 26.39 67.13 58.07 10/25/2019 36.74 31.72 78.44 83.38 10/30/2020 34.53 23.70 71.71 86.96 10/29/2021 54.43 47.78 88.05 106.07 Note that there are 4 stocks here instead of just 3. First, copy the above table into the "RawData" sheet and calculate the annual returns, means and standard deviations, and all of the pairwise correlations among the stocks. Then carefully expand the model to include Stock4. Pay close attention to the covariance C and the X matrices, which must be square, i.e., 4 rows x 4 columns. Then get Solver to find the new optimal solution

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

World Economic And Social Survey 2012 In Search Of New Development Finance

Authors: United Nations Department Of Economic And Social Affairs

1st Edition

9210555112, 9789210555111

More Books

Students also viewed these Economics questions

Question

Where do you have gaps?

Answered: 1 week ago