A portfolio manager summarizes the input from the macro and micro forecasters in the following table:

Micro ForecastsAssetExpected Return $(\%)$BetaResidual Standard Deviation $(\%)$Stock A$271\mathrm{.}672$Stock B$241\mathrm{.}878$Stock C$230\mathrm{.}967$Stock D$181\mathrm{.}062$

Macro ForecastsAssetExpected Return $(\%)$Standard Deviation $(\%)$T$-$bills$140$Passive equity portfolio$2223$

Required:

Calculate expected excess returns, alpha values, and residual variances for these stocks.

Compute the proportion in the active portfolio and the passive index.

What is the Sharpe ratio for the optimal portfolio?

By how much did the position in the active portfolio improve the Sharpe ratio compared to a purely passive index strategy?

What should be the exact makeup of the complete portfolio $($including the risk$-$free asset$)$ for an investor with a coefficient of risk aversion of $3\mathrm{.}1?$