Answer to these questions

1. You have 35% of your investments in Alphabet with a beta of 0.96, 20% of your investments in PG&E with a beta of 0.23 and 45% of your investments in General Electric with a beta of 1.20. What is the beta of your portfolio? Use Excel to calculate your answer. 2. What is the expected return of an asset with a beta of 1.13 when the risk-free rate is 3.7% and the market rate is 9.2%? 3. Complete both of the following: a. Create a scatterplot with trendline from the data below. b. Calculate the slope given the data below Market Return Tumblehome Return Month (%) (%) 1 2.3 N 0 -1 3 -1 -1.5 -1 -0.75 UT 2.5. 1.5 V IN 3.25 IN 1.75 LO -2 -1.75 10 -2 -3 ENG 6:45 PM