PLEASE DO IN EXCEL!!

Problem 7-22 Greta, an elderly investor, has a degree of risk aversion of A = 3 when applied to return on wealth over a one-year horizon. She is pondering two portfolios, the S&P 500 and a hedge fund, as well as a number of 3-year strategies. (All rates are annual, continuously compounded.) The S&P 500 risk premium is estimated at 7% per year, with a SD of 20%. The hedge fund risk premium is estimated at 5% with a SD of 26%. The return on each of these portfolios in any year is uncorrelated with its return or the return of any other portfolio in any other year. The hedge fund management claims the correlation coefficient between the annual returns on the S&P 500 and the hedge fund in the same year is zero, but Greta believes this is far from certain. Compute the estimated 1-year risk premiums, SDs, and Sharpe ratios for the two portfolios. (Do not round your intermediate calculations. Round "Sharpe ratios" to 4 decimal places and other answers to 2 decimal places.) & Answer is not complete. S&P Portfolio Hedge Fund Portfolio 15.76 X Risk premiums SDs Sharpe ratios 22.50 X 34.64 X 45.03X