5.Consider the more realistic case where short sales are NOT allowed and no more than 40% of the portfolio and no less than 5% is invested in any ETF. Including all 11 ETFs, use Excel Solver to find the Minimum Variance Portfolio (MVP).What is the portfolio standard deviation for the MVP portfolio?Enter your answer rounded to two decimal places.Do not enter % in the answer box.For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.

6.Use the data from problem 5, but now find the MVP using only 9 of the 11 ETFs.Add constraints in Excel Solver so that the portfolio weights are 0% for 2 ETFs (inVersion B:exclude PFF and JNK.)Use Excel Solver to find the new Minimum Variance Portfolio (MVP) with these two additional constraints.What is the portfolio standard deviation for the new MVP portfolio?Enter your answer rounded to two decimal places.Do not enter % in the answer box.For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.

https://docs.google.com/spreadsheets/d/1rTR8je9UHN-yCTXz0NuoZybWybHbZWvRf_5JIBechrc/edit?usp=sharing

above is excel file link