Please answer both questions on an excel sheet with the steps! Thanks

You have $100,000 to invest in a portfolio containing Stock Q and Stock K. Your goal is to create a portfolio that has an expected return of 12.7 percent. If Stock Q has an expected return of 11.4 percent and a beta of 1.25, and Stock K has an expected return of 14.8 percent and a beta of 2.85: 1. How much money will you invest in the two stocks? 2. What is the beta of your portfolio? Required: Answer the two questions with your computations on paper or in Excel