EXCEL PROJECT AND EXCEL SOLUTION Consider a portfolio consisting of the following three stocks:

$\backslash$table$[[,\backslash$table$[[$Portfolio$],[$Weight$]],$Volatility,$\backslash$table$[[$Correlation With the Market$],[$Portfolio$]]],[$HEC Corp,$0\mathrm{.}25,12\%,0\mathrm{.}4],[$Green$,0\mathrm{.}35,25\%,0\mathrm{.}6],[$Midget$,0\mathrm{.}4,13\%,0\mathrm{.}5],[$AliveAndWell$,,,]]$

The volatility of the market portfolio is $10\%$ and it has an expected return of $8\%.$ The risk$-$free rate is $3\%.$

a$.$ Compute the beta and expected return of each stock.

b$.$ Using your answer from part $($a$),$ calculate the expected return of the portfolio.

c$.$ What is the beta of the portfolio?

d$.$ Using your answer from part $($c$),$ calculate the expected return of the portfolio and verify that it matches your answer to part $($b$).$