Use the Variance Covariance matrix in the data file Construct a model to determine the following: a. Calculate an envelope portfolio assuming the risk-free rate is 4%. b. Calculate an envelope portfolio assuming the risk-free rate is 10%. c. Using EXCELs Data Table Feature, create a one-way data table that determines the different means and standard deviations for combinations of Envelope Portfolio 1 and Envelope Portfolio 2 by varying the proportion of Portfolio 1 from -4 to +4 in increments of 0.40. d. Graph the combinations of the portfolios from the one-way data table and add the individual asset means and standard deviations to the graph. e. Provide a title on the graph and label the axes of the graph. f. Using EXCELs Text Box feature, explain whether the portfolio combinations could be on the efficient frontier

Given information:

	Variance-Covariance Matrix
	Stock A	Stock B	Stock C	Stock D	Stock E	Stock F	Stock G
Stock A	0.0009	-0.0005	0.0001	-0.0005	-0.0012	0.0004	0.0003
Stock B	-0.0005	0.0331	0.0032	0.0033	-0.0011	0.0024	-0.0008
Stock C	0.0001	0.0032	0.0097	0.0011	-0.0014	-0.0022	0.0005
Stock D	-0.0005	0.0033	0.0011	0.0050	0.0011	0.0025	0.0006
Stock E	-0.0012	-0.0011	-0.0014	0.0011	0.0070	0.0021	0.0006
Stock F	0.0004	0.0024	-0.0022	0.0025	0.0021	0.0056	0.0016
Stock G	0.0003	-0.0008	0.0005	0.0006	0.0006	0.0016	0.0009

Means

2.84%

4.00%

5.00%

1.65%

3.19%

-1.01%

2.08%