Intro You found the following covariance matrix for 3 stocks: 2 Amazon 3 Exxon 4 Walmart DE F Amazon Exxon Walmart 0.35 0.025 0.01 0.025 0.21 0.02 0.01 0.02 0.15 Part 1 Attempt 1/5 for 10 pts. Add the border-multiplied covariance matrix, i.e., the covariance matrix bordered by the portfolio weights, below the table. What is the variance of the equally-weighted portfolio? 3+ decima Submit Part 2 - Attempt 1/5 for 10 pts. You did extensive security research and came up with the following annual expected returns: E(RA) = 0.07 E(RE) = 0.06 E(RW) = 0.05 What is the expected return of the equally-weighted portfolio? Use Excel's SUMPRODUCTO function. 3+ decima Submit Part 3 Attempt 175 for 10 pts. The yield on treasury bills is 1.1%. What is the Sharpe ratio of the equally-weighted portfolio? 3+ decima Submit Part 4 Attempt 1/5 for 10 pts. Determine the optimal risky portfolio (ORP) using Excel's Solver tool. What is the Sharpe ratio of the portfolio? 3+ decima Submit Intro You found the following covariance matrix for 3 stocks: 2 Amazon 3 Exxon 4 Walmart DE F Amazon Exxon Walmart 0.35 0.025 0.01 0.025 0.21 0.02 0.01 0.02 0.15 Part 1 Attempt 1/5 for 10 pts. Add the border-multiplied covariance matrix, i.e., the covariance matrix bordered by the portfolio weights, below the table. What is the variance of the equally-weighted portfolio? 3+ decima Submit Part 2 - Attempt 1/5 for 10 pts. You did extensive security research and came up with the following annual expected returns: E(RA) = 0.07 E(RE) = 0.06 E(RW) = 0.05 What is the expected return of the equally-weighted portfolio? Use Excel's SUMPRODUCTO function. 3+ decima Submit Part 3 Attempt 175 for 10 pts. The yield on treasury bills is 1.1%. What is the Sharpe ratio of the equally-weighted portfolio? 3+ decima Submit Part 4 Attempt 1/5 for 10 pts. Determine the optimal risky portfolio (ORP) using Excel's Solver tool. What is the Sharpe ratio of the portfolio? 3+ decima Submit