Please use excel to solve and show working.

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In * Calibri 11 M Paste BIU. Cells Editing A A % - A. Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx Clipboard Font A1 D E G 1 2 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? 6 6 S $ 8 Stock A value Stock B value Stock A E(R) Stock B E(R) 2650 4.450 8.00% 11.00% 9 11 Complete the following analysis. Do not hard code values in your calculations. Portfolio value Weight of A Weight of B Portfolio E(R) sheet