Please show all work on excel

A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts Asset Residual Standard Deviation (%) 58 Stock A Stock B Stock c Stock D Expected Return (%) 24 20 19 16 Beta 0.9 1.4 0.7 0.8 70 61 53 Macro Forecasts Expected Return Asset (%) T-bills Passive equity portfolio 20 Standard Deviation (%) 13 0 31 Calculate the following for a portfolio manager who is not allowed to short sell securities. The manager's Sharpe ratio is 0.2488. a. What is the cost of the restriction in terms of Sharpe's measure? (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) Cost of restriction b. What is the utility loss to the investor (A = 2.9) given his new complete portfolio? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Cases Utility Levels Unconstrained Constrained Passive A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts Asset Residual Standard Deviation (%) 58 Stock A Stock B Stock c Stock D Expected Return (%) 24 20 19 16 Beta 0.9 1.4 0.7 0.8 70 61 53 Macro Forecasts Expected Return Asset (%) T-bills Passive equity portfolio 20 Standard Deviation (%) 13 0 31 Calculate the following for a portfolio manager who is not allowed to short sell securities. The manager's Sharpe ratio is 0.2488. a. What is the cost of the restriction in terms of Sharpe's measure? (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) Cost of restriction b. What is the utility loss to the investor (A = 2.9) given his new complete portfolio? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Cases Utility Levels Unconstrained Constrained Passive