Question

# An investor wishes to invest \$10,000 for the coming year and anticipates that the market will...

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.

 Possible Market States Price State 1 State 2 State 3 State 4 Stock A \$4.94 \$4.58 \$3.95 \$5.67 \$5.39 Stock B \$5.88 \$5.24 \$7.28 \$4.82 \$6.22 Stock C \$6.48 \$8.27 \$5.65 \$7.66 \$5.78 Bond D \$2.68 \$2.11 \$2.53 \$2.80 \$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.

We will choose the proportion in each stock and bond such that subject to total below 10000, the returns obtained is maximum.