d$.$ Estimate Goodman's and Landry's betas as the slopes of regression lines with stock return on the vertical axis $($y$-$axis$)$ and market return on the horizontal axis $($x$-$axis$).($Hint: Use Excel's SLOPE function.$)$ Round your answers to four decimal places.

Goodman$$s beta:

Landry$$s beta:

e$.$ The risk$-$free rate on long$-$term Treasury bonds is $6\mathrm{.}26\%.$ Assume that the market risk premium is $5\%.$ What is the required return on the market? Round your answer to two decimal places.

Now use the SML equation to calculate the two companies' required returns. Round your answers to two decimal places.

Goodman$$s required return $\%$:

Landry$$s required return $\%$:

f$.$ If you formed a portfolio that consisted of $50\%$ Goodman stock and $50\%$ Landry stock, what would its beta and its required return be$?$ Round your answer for the portfolio's beta to four decimal places and for the portfolio's required return to two decimal places.

Portfolio$$s beta:

Portfolios required return: $\%$

g$.$ Suppose an investor wants to include some Goodman Industries stock in his portfolio. Stocks A$,$ B$,$ and C are currently in the portfolio, and their betas are $0\mathrm{.}858,0\mathrm{.}968,$ and $1\mathrm{.}535,$ respectively. Calculate the new portfolio's required return if it consists of $25\%$ Goodman, $10\%$ Stock A$,45\%$ Stock B$,$ and $20\%$ Stock C$.$ Round your answer to two decimal places.

Check all asnwers and help with the above please, thank you!