answers in excel formulas please

5. Using the SML- Excel 6 ? ES X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 M Paste BIU- 5 nts = % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font Skipped E14 X ka 4 A B D F G H eBook Asset W has an expected return of 11.8 percent and a beta of 1.15. If the risk-free rate is 3.7 percent, complete the following table for portfolios of Asset W and a risk-free asset. Illustrate the relationship between portfolio expected return and portfolio beta by calculating the expected returns and betas of portfolios with various weights invested in the stock and risk-free asset. What is the slope of the line that results? Print 4 5 References 6 7 Stock E(R) Stock beta Risk-free return 11.80% 1.15 3.70% 8 9 10 11 12 13 14 15 16 17 18 19 Complete the following analysis. Do not hard code values in your calculations. Weight of W Weight of risk-free Portfolio E(R) Portfolio beta 0% 100% 25% 75% 50% 50% 75% 25% 100% 0% 125% -25% 150% -50% 20 21 Sheet1 READY 100% A B D E F G 5 H 1 6 7 8 Stock E(R) Stock beta Risk-free return 11.80% 1.15 3.70% 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 15 16 Weight of W Weight of risk-free Portfolio E(R) Portfolio beta 0% 100% 25% 75% 50% 50% 75% 25% 100% 0% 125% -25% 150% -50% 17 18 19 20 21 22 Slope of SML 23 24 25 26 Sheet1 CH READY 3 100% E