FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 111 AA % Paste Alignment Number Cells Editing Conditional Format as Cell Formatting" Table Styles" Styles Clipboard Font A1 : X for B D E F G H 1 J 1 N You own a stock portfolio invested 35 percent in Stock Q, 25 percent in Stock R, 30 percent in Stock S, and 10 percent in Stock T. The betas for these four stocks are .84, 1.17, 1.11, and 1.36, respectively. What is the portfolio beta? 3 4 5 6 7 8 Weight of a Weight of R Weight of S Weight of T Beta of Q Beta of R Beta of S Beta of T 9 35.00% 25.00% 30.00% 10.00% 0.84 1.17 1.11 1.36 10 11 12 13 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 18 Portfolio beta 19 20 21 Sheet1