A B C D E F 1 2 3 You have $10,000 to invest in a stock portfolio. Your choices are Stock X with an expected return of 12.4 percent and Stock Y with an expected return of 10.1 percent. If your goal is to create a portfolio with an expected return of 10.85 percent, how much money will you invest in Stock X? In Stock Y? 4 Input area: 5 6 Portfolio value 7 Stock X E(R) 8 Stock Y E(R) $10,000 12.40% 10.10% 10.85% 9 Portfolio E(R) 10 11 (Use cells A6 to B9 from the given information to complete this question.) 12 13 Output area: 14 15 Weight of Stock X 1.0000 16 Weight of Stock Y 17 Dollar in Stock X 18 Dollars in Stock Y 19 20 20 27