Please use Excel to solve the problem and show the full steps. Thanks.

Q2. A winner of the Texas Lotto has decided to invest partly or entirely his award of $50,000 in the stock market. Under consideration are stocks for a petrochemical firm and a public utility. Being discreet, this person decides to minimize the risk of the investment as long as a total return of 8% (i.e., $4,000) is generated. A risk index on a scale of 1-10 (with 10 being the most risky) is assigned to each of the two stocks. Cash savings will generate zero return but will have zero risk. The total risk of the portfolio is found by multiplying the risk of each stock by the dollars invested in that stock and then summing them up. The following table provides a summary of the return and risk: Stock Estimated Return Risk Index Petrochemical 12% 9 Utility 6% 4 Which of the following statement(s) is(are) true? A) The optimal solution is to invest $33,333 in the utility stock and $16,667 in the other stock B) If the investor wants to keep at least $10,000 as cash, the optimal solution will not change. C) If the risk of the petrochemical stock is reduced to 8, the optimal solution will not change. D) If the return rate of the utility stock is increased to 7%, the optimal solution will not change