5. Portfolio Expected Return - Excel ? - 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri A A % ED Paste BTU- A - Cells Editing Alignment Number Conditional Format as Cell Formatting" Table Styles Styles Clipboard Font A1 : X fo B D E F G H I J 1 2 You own a portfolio that is 35 percent invested in Stock X. 20 percent in Stock Y, and 45 percent in Stock Z. The expected returns on these three stocks are 9 percent, 17 percent, and 13 percent, respectively. What is the expected return on the portfolio? 3 4 5 6 7 Weight of X Weight of Y Weight of Z Stock X E(R) Stock Y E(R) Stock Z E(R) 8 35.00% 20.00% 45.00% 9.00% 17.00% 13.00% 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 Portfolio E(R) 15 16 17 18 19 20 Sheet1 READY X All answers must be entered as a formula. Click OK to begin. OK