Excel Activity: Feasible Portfolios

Following is information for the required returns and standard deviations of returns for A, B, and C:

Stock	ri	i
A	7.0%	35.47%
B	10.0%	50.65%
C	18.0%	88.75%

The correlation coefficients for each pair are shown in the following matrix, with each cell in the matrix giving the correlation between the stock in that row and column. For example, _AB = 0.1554 is in the row for A and the column for B. Notice that the diagonal values are equal to 1 because a variable is always perfectly correlated with itself.

	A	B	C
A	1.0000	0.1554	0.1890
B	0.1554	1.0000	0.1644
C	0.1890	0.1644	1.0000

Do not round intermediate calculations. Round your answers to two decimal places.

A. The partial model lists sixty six different combinations of portfolio weights (only six of them are shown below). For each combination of weights, find the required return and standard deviation.

wA	wB	wC	p	rP
0%	80%	20%	???? %	???? %
10%	70%	20%	???? %	???? %
30%	10%	60%	???? %	???? %
50%	20%	30%	???? %	???? %
60%	10%	30%	???? %	???? %
70%	20%	10%	???? %	???? %