Question: Need help creating a graph showing all the portfolio's expected returns (on y-axis) as a function of volatility on (x-axis). See instruction step 3 in

Need help creating a graph showing all the portfolio's expected returns (on y-axis) as a function of volatility on (x-axis). See instruction step 3 in Red.

Need help creating a graph showing all the
B C D E F G H I K M N Q R U w Z AA AB AC AD AE Tickers ER Just one Portfolio 2 KL 0.08 0.20 Weight_KLF 3 BB 0.12 0.30 Weight_BB E[Ro] 5 0.5 Var[Rpf] Tasks: Opf Covariance Matrix 1. Provide reasonable inputs for the expected returns, volatility, and correlation in cells SB$2:$C$3 and SB$5. You can also change the tickers in SA$2:$A$3. NOTE: Please pick two risky assets. 8 KLF BE 2. Fill the cells $8$9 to $C$10 to calculate each entry of the covariance matrix. You might have to search online for this. 9 KLF 0.04 0.03 3. You will create a graph showing all the portfolio's expected returns (on y-axis) as a function of volatility on (x-axis). 10 BB 0.03 0.09 11 1. In the Table located below row 12, assume a complete portfolio and calculate the weight in the second ticker in the column $8, based on the given weights in column $A. Enter your formula in cell $8$14, then use the auto-fill. 12 Table of portfolios to graph 2. Enter a formula in cell $C$14 to calculate the expected return of the first portfolio of the Table. Then use auto-fill to copy/paste the formula all the way to $C$114. 13 Weight_KLF Weight_BB E[Rp] Var[Rot] 3. Enter a formula in cell $D$14 to calculate the variance of the first portfolio of the Table. Then use auto-fill to copy/paste the formula all the way to $0$114. 14 0% 4. Enter a formula in cell SE$14 to calculate the volatility of the first portfolio of the Table. Then use auto-fill to copy/paste the formula all the way to SE$114. 15 1% 5. Insert an x-y scatter Chart. Add a new series. Data from SE$14-SE$114 will be for the x-axis, and data from $C$14 -$C$114 will be for the y-axis. 16 2% 4. Input some weight for the first ticker in cell $G$2. 17 3% 5. Calculate the weight of the second ticker in cell $G$3. 18 49% 6. Calculate the expected return, variance, and volatility of this specific portfolio in cells $G$4 to $G$6. 19 5% 7. Add the information of this specific portfolio to the add by adding a new series, using just one point with a larger marker. 20 6% 7% 8% 23 9% 24 10% 11% 12% 13% 14% 29 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 26% 27% 28% 29% 30% 31% 32%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!