Assignment 8: Portfolio You we asked to do the following portfolio vestiment decision for an entry test your job market & Scoose the risk free me , and then find the efficient portfolio Tangency portfolio or the market portfolio notice the return frequency when compute Sharpe Ratio) 9) you are required to put not more than 35 at the risk free asset find the efficient portfolio allocation In your portfolio, you want to diversity and inwes stocks in different sectors four stocks total from following four sectors, one from each sector Teder. Franca, Consumer Goods, Utes Thee more stocks from other sectors: Services, Industrial Goods, Bas Material Real Estate, Healthcare 1) Download past 5 ya /2015 11/2020 weekly stod prices for the above selected stocks, 2) Compute expected returns and create a variance covariancemetre For each of the following portfoli, esse find portfolio location weghts, portio in return and risk 3) Find the wine portfolio without w igowed restriction Copy and display your sover constraint window 4) Find And a portion of expected thout imposed to A s we greater than and less than 100 percent Copy and display your solver constrant window 5) Find a customized portfolio with maximum expected return according to the following a wewhnesch Stockis greater than and less than 100 ) Nore of stod has weight of more then SON Each of the stocks shall be invested the total weight of it and come Goods cannot ceed on The offerent between the weight of Financial and Technology must be at least 3x and at most 15 f ast two stocks the weight rester than 10 For each sections are shot of your over popup screen that it cos ts in your sales from porta to part 6) Find coverence between ports And 7 Da l ist of portfolios based on portfolio A and a by changing the portfol weights, find the efficient frontier, and display the efficient frontier on the chart Assignment 8: Portfolio You we asked to do the following portfolio vestiment decision for an entry test your job market & Scoose the risk free me , and then find the efficient portfolio Tangency portfolio or the market portfolio notice the return frequency when compute Sharpe Ratio) 9) you are required to put not more than 35 at the risk free asset find the efficient portfolio allocation In your portfolio, you want to diversity and inwes stocks in different sectors four stocks total from following four sectors, one from each sector Teder. Franca, Consumer Goods, Utes Thee more stocks from other sectors: Services, Industrial Goods, Bas Material Real Estate, Healthcare 1) Download past 5 ya /2015 11/2020 weekly stod prices for the above selected stocks, 2) Compute expected returns and create a variance covariancemetre For each of the following portfoli, esse find portfolio location weghts, portio in return and risk 3) Find the wine portfolio without w igowed restriction Copy and display your sover constraint window 4) Find And a portion of expected thout imposed to A s we greater than and less than 100 percent Copy and display your solver constrant window 5) Find a customized portfolio with maximum expected return according to the following a wewhnesch Stockis greater than and less than 100 ) Nore of stod has weight of more then SON Each of the stocks shall be invested the total weight of it and come Goods cannot ceed on The offerent between the weight of Financial and Technology must be at least 3x and at most 15 f ast two stocks the weight rester than 10 For each sections are shot of your over popup screen that it cos ts in your sales from porta to part 6) Find coverence between ports And 7 Da l ist of portfolios based on portfolio A and a by changing the portfol weights, find the efficient frontier, and display the efficient frontier on the chart