l

Calculate the portfolio ratio analysis of the two portfolios and the stock benchmark and explain which portfolio the investor should invest using the template and upload your work on Active Learning. Description Stock Stock Stock Portfolio Z Portfolio X Benchmark Market (m) Average Retur 15.00% 18.00% 9.00% Risk-Free Return 1.50% 1.50% 1.50% Standard Deviation 22.00% 33.00% 16.00% 1.250x 1.400x 1.000x Beta Output Risk Premium Return Market Premium Capital Asset Pricing Model Sharpe Ratio Jensen's Alpha Treynor Measure M-Square show excel commands if any, i need the work done in excel Calculate the portfolio ratio analysis of the two portfolios and the stock benchmark and explain which portfolio the investor should invest using the template and upload your work on Active Learning. Description Stock Stock Stock Portfolio Z Portfolio X Benchmark Market (m) Average Retur 15.00% 18.00% 9.00% Risk-Free Return 1.50% 1.50% 1.50% Standard Deviation 22.00% 33.00% 16.00% 1.250x 1.400x 1.000x Beta Output Risk Premium Return Market Premium Capital Asset Pricing Model Sharpe Ratio Jensen's Alpha Treynor Measure M-Square show excel commands if any, i need the work done in excel