A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts Asset Expected Return (%) Beta Residual Standard Deviation (%) Stock A 22 1.5 50 Stock B 20 2.1 59 Stock C 18 1.3 56 Stock D 14 1.4 44 Macro Forecasts Asset Expected Return (%) Standard Deviation (%) T-bills 11 0 Passive equity portfolio 16 23 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.Omit the "%" sign in your response.) Stock A Stock B Stock C Stock D Excess returns % % % % Alpha values % % % % Residual variances 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 c. What is Sharpes measure for the optimal portfolio and how much of it is contributed by the active portfolio? (Do not round intermediate calculations. Enter your answers as decimals rounded to 4 places.) Sharpe's measure Active portfolio d. What should be the exact makeup of the complete portfolio for an investor with a coefficient of risk aversion of 3.5? (Do not round intermediate calculations. Round your answers to 2 decimal places. Omit the % sign in your response.) Final Positions Bills % M % A % B % C % D % Total %