In: Finance
There are three economy situations and two stocks. Information is as follows.
| 
 Economy  | 
 Stock A  | 
 Stock B  | 
|
| 
 Booming  | 
 0.3  | 
 10%  | 
 20%  | 
| 
 Neutral  | 
 0.3  | 
 5%  | 
 0%  | 
| 
 Recession  | 
 0.4  | 
 0%  | 
 -10%  | 
a. What are the expected returns for both stock A and B, respectively?
b. What is the standard deviation/ risk for stock A?
c. What is the portfolio return given that you have $10,000 and allocate $4,000 in stock A?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -
