Question 2 50% 2 3 4 5 50% The Beijing-based investment firm of Hillhouse Capital specializes in recommending technology stock portfolios for wealthy clients and prohibits all clients from short selling and lending. The table below describes the seven companies that are under consideration for an investment portfolio Company Name Expected Annual Standard Deviation Index (Location) Rate of Return of Annual Return 1 Tencent (Shenzhen) 80% Huawei (Shenzhen) 70% 40% Foxconn (Shenzhen) 30% 20% Ant Group (Hangzhou) 50% Alibaba Group (Hangzhou) 40% 80% 6 eBay (Foreign) 10% 10% 7 Amazon.com (Foreign) 20% 50% a) Susan, one of the Hillhouse Capital's clients, has an objective to maximize expected annual rate of return on investing in exactly four companies with the same amount of capital, subject to the following specifications: At least two Shenzhen companies must be in the portfolio If Tencent stock is included in the portfolio, then Ant Group stock must also be included. Exactly one of the two Hangzhou companies must be included. No more than one investment can be made in foreign companies. Let X be the binary variable for the ith company on the table, where X= 1 if the ith company is included in the portfolio X-0 otherwise for i = 1,...,7. Determine the objective function and the constraints of Susan's portfolio in terms of the Xi's. b) Alex, another client of Hillhouse Capital, has up to $3 million available for investment. He would like to minimize the variance of the portfolio's return given by (0.25Y? +0.08Y, Y, +0.1673 +0.08Y,Y, +0.04Y; +0.25y; +0.08Y,Ys +0.6473 +0.0193 +0.08YY, +0.2577). where y, is the percentage of the portfolio devoted to the i-th company on the table for i = 1, ...,7. Alex wants the expected annual rate of return for the total portfolio to be at least 30%. No individual stock can constitute more than 70% of the portfolio. The screen capture below shows the spreadsheet result of Alex's optimal portfolio D G H 1 2 3 4 5 6 7 Decision Variables Y1 Y2 Y3 Y4 YS Y6 47 0.1043 0.0807 0.2186 0.0725 0.0196 0.5044 Objective Function Variance 0.0120 RHS 0.3 0.8 1 1 0.7 1 0.3 1 0.5 1 0.4 1 0.1 1 0.2 1 8 9 10 1 LHS 0.3 > 1 0.1043 0.0807 0.2186 0.0725 0.0196 0.5044 OC 11 1 11 0.71 0.7 0.71 0.7 0.71 0.71 0.7 KUR 12 1 13 1 1 14 15 i) Give the spreadsheet formula in cell 7. ii) Interpret row 8. ii) Determine the constraints of Alex's portfolio in terms of the Y's. iv) Fill in the window below with all necessary solver parameters. Solver Parameters Set Objective: 41 O Value of 0 To: O Max By Changing Variable Cells: 17 Subject to the Constraints: Add Change Delete Reset All Options Load/Save Make Unconstrained Variables Non-Negative Select a Solving GRG Nonlinear Method: GRG Nonlinear Simplex LP Solving Method Evolutionary Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close v) Suggest one way to improve the search for the optimal solution. vi) With reference to the reduced gradient of 0.0157 for Y7 and Lagrange multiplier of 0.0787 for row 7 in the sensitivity report of the spreadsheet result, find the minimized variance of the portfolio's return if the expected annual rate of return for the total portfolio changes to be at least 35%, keeping all other parameters fixed