Use Excel Solver to answer the question

5. You are a wealth manager and have the ability to invest in the following stocks. Each stock has an expected return for the next year. Each company, based on the value of the company, is classified as a large, medium or small cap company Expected return Vianct A gritek Akamai Baidu Blucora BrainyBrawn Carbonite Finance Online ChitrChatr Crexendo Endexx Envestnet Liberty Power Flashzero Faceboolk Genesis IAC InterNAIP iPass J2 Global 7.50% 8.60% 7.90% 6.10% 5.20% 8.00% 1.20% 3.50% 3.80% 7.60% 7.10% 6.50% 6.60% 7.00% 5.80% 4.70% 9.10% 2.30% 6.70% 5.80% 4.70% 2 A client comes to you and wants to maximize their return for this year. She has $500,000 in which to inxest. She has specific requirements to which she wants you to adhere. She wants no more than 25% of her portfolio to include small cap companies and no less than 60% of her portfolio in large cap companies. As diversification is important, she requires that one stock cannot be more than 25% of her portfolio. a. Based on this information, where should you invest her money? (10 points)