MUST SHOW ALL CORRECT EXCEL FORMULAS

Portfolio expected return - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial 12 -A A Paste BIU- A- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing > Clipboard Font D14 v fx A B c D E F H K 3 You own a portfolio that has $2,650 invested in Stock A and $4,450 invested in Stock B. If the expected returns on these stocks are 8 percent and 11 percent, respectively, what is the expected return on the portfolio? 4 5 6 $ $ 7 Stock A value Stock B value Stock A E(R) Stock B E(R) 2,650 4,450 8.00% 11.00% 8 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 Portfolio value 15 16 Weight of A 17 18 19 20 Weight of B Portfolio E(R) 21 22