A portfolio manager summarizes the input from the macro and micro forecasters in the following table Micro Forecasts Residual Standard Deviation(%) 50 59 56 Expected Return(%) Asset Stock A Stock B Stock C Stock D Beta 20 18 Macro Forecasts Expected Return(%) Asset T-bills Passive equity portfolio Standard Deviation (%) 0 23 16 a. Calculate expected excess returns, alpha values, and residual variances for these stocks. (Negative values should be indicated by a minus sign. Do not round intermediate calculations. Round "Alpha values" to 1 decimal place.mit the "%"' sign in your response.) Stock A Stock B Stock C Stock D Excess returns Alpha values Residual variances 11% 35 % -4 % 2500 3481 3136 1936 b. Compute the proportion of risky assets invested in the active portfolio. (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) Proportion A portfolio manager summarizes the input from the macro and micro forecasters in the following table Micro Forecasts Residual Standard Deviation(%) 50 59 56 Expected Return(%) Asset Stock A Stock B Stock C Stock D Beta 20 18 Macro Forecasts Expected Return(%) Asset T-bills Passive equity portfolio Standard Deviation (%) 0 23 16 a. Calculate expected excess returns, alpha values, and residual variances for these stocks. (Negative values should be indicated by a minus sign. Do not round intermediate calculations. Round "Alpha values" to 1 decimal place.mit the "%"' sign in your response.) Stock A Stock B Stock C Stock D Excess returns Alpha values Residual variances 11% 35 % -4 % 2500 3481 3136 1936 b. Compute the proportion of risky assets invested in the active portfolio. (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) Proportion