Please put the formula you used in getting your answer.

Excel Assignment i Submitted 18.5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 86 Calibri 11 AA % M 3 Paste BIU- A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 fx 0/20 points awarded B D E F G H I Scored 3 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. 4 eBook 5 Ask 6 Print 7 8 References Year 1 2 3 4 5 X 15% 26% 7% -13% 11% Y 21% 36% 13% -26% 15% 9 10 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations. You must use the built-in Excel functions to answer this question. 15 16 X Y 17 X 18 Arithmetic average return * Variance Standard Deviation x 19 X Excel Assignment i Submitted Using the SML - Excel ? 4 x 5 15.5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A | A % Paste BIU, D- A- Cells Editing 0/20 points awarded Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A Scored A1 V : X D E F G H I eBook 1 2 Ask Print References 3 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? 4 5 6 7 Stock E(R) Stock beta Risk-free return 11.80% 1.15 3.70% 8 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 X H5 Using the SML - Excel ? 5 4 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 AA A % Paste BIU- Cells Editing 0/20 points awarded Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A Scored 1 fix v A D E F G H H I 1 eBook 6 B C Stock E(R) Stock beta Risk-free return Ask 7 8 11.80% 1.15 3.70% Print 9 References 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% X X 25% 75% X X 50% 50% X X 75% 25% X 100% 0% X 125% -25% X X 150% -50% X X 17 18 19 20 21 22 Slope of SML X