Goodman Industries		Landry Incorporated		Market Index
Year	Stock Price	Dividend	Stock Price	Dividend	Includes Divs.
2016	$25.88	$1.73	$73.13	$4.50	17,495.97
2015	$22.13	$1.59	$78.45	$4.35	13,178.55
2014	$24.75	$1.50	$73.13	$4.13	13,019.97
2013	$16.13	$1.43	$85.88	$3.75	9,651.05
2012	$17.06	$1.35	$90.00	$3.38	8,403.42
2011	$11.44	$1.28	$83.63	$3.00	7,058.96

If you formed a portfolio that consisted of 50% Goodman stock and 50% Landry stock, what would be its beta and its required return? PLEASE SHOW FOMULA IN EXCEL