Intro

You found the following covariance matrix for 3 stocks:

	C	D	E	F
1		Amazon	Exxon	Walmart
2	Amazon	0.066	0.025	0.013
3	Exxon	0.025	0.044	0.0088
4	Walmart	0.013	0.0088	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

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?

w_A = 0.4 w_E = 0.25 w_W = 0.35