solve without using excel.

show work please.

Beta Expected Return (%) 16.0 12.9 12.2 11.4 11.3 10.1 10.0 9.8 U.S. Steel Disney Ford General Electric Monsanto Boeing Union Pacific Alphabet Exxon Mobil Amazon Intel Pfizer Starbucks IBM McDonald's Coca-Cola Campbell Soup Walmart Newmont Mining PG&E 1.85 1.42 1.31 1.20 1.19 1.01 1.00 0.96 0.94 0.93 0.91 0.90 0.79 0.59 0.51 0.49 0.47 0.26 0.24 0.23 9.6 9.5 9.4 9.3 8.5 7.1 6.6 6.4 6.3 4.8 4.7 4.6 c. Now repeat parts ( u n U 1 13. CAPM and Expected Return. Suppose that the Treasury bill rate is 6% rather than the 3% value assumed in Table 12.2. Use the betas in Table 12.2 to answer the following questions. (L012-2) a. How does this change your estimate of the rate of return on the market portfolio? b. Using your answer to part (a), calculate the expected return on the stocks in Table 12.2. c. Suppose now that you continued to assume that the expected return on the market remained at 10%. Now what would be the expected return on each stock? d. Compare your expected returns in part (c) to those in Table 12.2. Which stocks have a higher expected return? Which lower? If you neglect to adjust the forecast of the market return to the change in the risk-free rate, how are your estimates of expected return likely to be biased? e. Would Walmart offer a higher or lower expected return if the interest rate were 6% rather than 3%? Assume that the expected rate of return on the market remains at 10%