2. Using the Optimizer Excel Spreadsheet provided as part of the Phase 2 assignment on Canvas and the 5 stocks you chose during Phase 1 , come up with expectations for annual returns, annual standard deviations, and the correlations between each pair of stocks and enter them in the spreadsheet (Cells A6:H11 - IN YELLOW). Also include an expectation for the Risk-Free Rate in Cell K4. Any data and calculations used when coming up with your expectations should be included within the Optimizer Excel sheet on separately labeled tabs. a. Create a consolidated table that shows corresponding Portfolio Statistics (Cells A32:B35) and the weight in each stock under the following scenarios i. Each stock with a 20% weight (equally weighted). ii. A portfolio that has the same standard deviation as the equally weighted portfolio above but changes the % in each stock to maximize the portfolio's expected return. Assume no short sales are allowed (no negative weights). iii. A portfolio that has the same standard deviation as the equally weighted portfolio but changes the \% in each stock to maximize the portfolio's expected return but allows short sale (negative weights). iv. A portfolio that has the lowest standard deviation, assuming no short sales (no negative weights). v. A portfolio that has the highest Sharpe Ratio, assuming no short sales (no negative weights. 2. Using the Optimizer Excel Spreadsheet provided as part of the Phase 2 assignment on Canvas and the 5 stocks you chose during Phase 1 , come up with expectations for annual returns, annual standard deviations, and the correlations between each pair of stocks and enter them in the spreadsheet (Cells A6:H11 - IN YELLOW). Also include an expectation for the Risk-Free Rate in Cell K4. Any data and calculations used when coming up with your expectations should be included within the Optimizer Excel sheet on separately labeled tabs. a. Create a consolidated table that shows corresponding Portfolio Statistics (Cells A32:B35) and the weight in each stock under the following scenarios i. Each stock with a 20% weight (equally weighted). ii. A portfolio that has the same standard deviation as the equally weighted portfolio above but changes the % in each stock to maximize the portfolio's expected return. Assume no short sales are allowed (no negative weights). iii. A portfolio that has the same standard deviation as the equally weighted portfolio but changes the \% in each stock to maximize the portfolio's expected return but allows short sale (negative weights). iv. A portfolio that has the lowest standard deviation, assuming no short sales (no negative weights). v. A portfolio that has the highest Sharpe Ratio, assuming no short sales (no negative weights