In: Finance
You have a portfolio with a standard deviation of 26% and an expected return of 15%. You are considering adding one of the two stocks in the following table. If after adding the stock you will have 30% of your money in the new stock and 70% of your money in your existing portfolio, which one should you add?
| 
 Expected Return  | 
 Standard Deviation  | 
 Correlation with Your Portfolio's Returns  | 
|
| 
 Stock A  | 
 15%  | 
 25%  | 
 0.2  | 
| 
 Stock B  | 
 15%  | 
 19%  | 
 0.6  | 
Standard deviation of the portfolio with stock A is _%?
Standard deviation of the portfolio with stock B is _%?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -
