Hell0-

I am working on my homework and was wondering if you can help me with the following question

Q.You have a $2 million portfolio consisting of a $100,000 investment in each of 20 different stocks. The portfolio has a beta of 0.85. You are considering selling $100,000 worth of one stock with a beta of 1.15 and using the proceeds to purchase another stock with a beta of 1.35. What will the portfolio's new beta be after these transactions? Do not round intermediate calculations. Round your answer to two decimal places. Can you show me how to set it up in Excel?