You found the following covariance matrix for 3 stocks:

	C	D	E	F
1		Amazon	Exxon	Walmart
2	Amazon	0.061	0.025	0.017
3	Exxon	0.025	0.044	0.0081
4	Walmart	0.017	0.0081	0.064

Part 1:

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?

Part 2:

You did extensive security research and came up with the following annual expected returns:

E(r_A) = 0.07 E(r_E) = 0.06 E(r_W) = 0.05

What is the expected return of the equally-weighted portfolio? Use Excel's SUMPRODUCT() function.

Part 3:

What is the variance of the portfolio with the following weights?

x_A = 0.4 x_E = 0.25 x_W = 0.35