use Microsoft excel

1. In the past five years, the market portfolio's average return was 11.0%, the market portfolios standard deviation was 31.0%, and the riskfree rate was 3.5%. During the same period, the table below lists the average return, standard deviation, beta, and non-systematic risk of six portfolios. Port Ave Return Port Std Dev Port Beta Port Non-sys Risk Port 1 15.3% 25.0% 0.7 18.5% Port 4 Port 5 7.3% 1.9% 31.4% 26.3% 1.8 0.8 0.4 7.2% 24.8% 24.5% Port 2 Port 3 12.4% 13.8% 37.0% 43.8% 1.3 19.9% Port 6 11.0% 47.3% 1.9 12.6% What has been the performance of each portfolio? Which portfolio did the best