23. An investor wishes to invest $10,000 for the coming year and anticipates that the market will be in one of four different states at the end of the year. These states affect her investments in each of three possible stocks and a bond as shown in the following table. Unfortunately, she is uncertain about which market state will occur. Because she is risk-averse, the investor would like to invest in a manner so that the return in the worst-case, no matter what market state occurs, is as good as possible. The following table provides the current price of each possible instrument as well as projected year- end prices of each instrument under each of the 4 possible states. Stock A Stock B Stock C Bond D Price $4.94 $5.88 $6.48 $2.68 State 1 $4.58 $5.24 $8.27 $2.11 Possible Market States State 2 State 3 $3.95 $5.67 $7.28 $4.82 $5.65 $7.66 $2.53 $2.80 State 4 $5.39 $6.22 $5.78 $2.09 These data are in the file MarketStates. Formulate her investment problem as a linear program and solve it using Excel Solver. How much should she invest in each security? Note: It is possible to purchase fractional shares. 23. An investor wishes to invest $10,000 for the coming year and anticipates that the market will be in one of four different states at the end of the year. These states affect her investments in each of three possible stocks and a bond as shown in the following table. Unfortunately, she is uncertain about which market state will occur. Because she is risk-averse, the investor would like to invest in a manner so that the return in the worst-case, no matter what market state occurs, is as good as possible. The following table provides the current price of each possible instrument as well as projected year- end prices of each instrument under each of the 4 possible states. Stock A Stock B Stock C Bond D Price $4.94 $5.88 $6.48 $2.68 State 1 $4.58 $5.24 $8.27 $2.11 Possible Market States State 2 State 3 $3.95 $5.67 $7.28 $4.82 $5.65 $7.66 $2.53 $2.80 State 4 $5.39 $6.22 $5.78 $2.09 These data are in the file MarketStates. Formulate her investment problem as a linear program and solve it using Excel Solver. How much should she invest in each security? Note: It is possible to purchase fractional shares