Question
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
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.
Step by Step Solution
3.48 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
I Formulation as linear program is following i ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started