In: Finance
Estimated Rate of Return on Alternative Investments | |||||||
State of | Probability | High | U.S. | Market | 2-Stocks | ||
Economy | of State | T-Bills | Tech | Collections | Rubber | Portfolio | HT&Coll |
Recession | 0.1 | 8.0% | -22.0% | 28.0% | 10.0% | -13.0% | |
Below Average | 0.2 | 8.0% | -2.0% | 14.7% | -10.0% | 1.0% | |
Average | 0.4 | 8.0% | 20.0% | 0.0% | 7.0% | 15.0% | |
Above Average | 0.2 | 8.0% | 35.0% | -10.0% | 45.0% | 29.0% | |
Boom | 0.1 | 8.0% | 50.0% | -20.0% | 30.0% | 43.0% | |
E(R) | 8.0% | 1.7% | 13.8% | 15.0% | |||
Standard Deviation |
0.0% | 13.4% | 18.8% |
15.3% |
III. Calculate the E(R) of a portfolio consisting of 50% in High Tech and 50% in Collections.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -