Someone had answered a question similar to this without too much explanation so I did not understand how it is done. How would you calculate these using shortcuts on excell? You have observed the following returns over time:
Year	Stock A	Stock B	Market
1997	14.000%	15.000%	14.193%
1998	11.000%	9.000%	11.974%
1999	-2.500%	5.000%	5.127%
2000	14.000%	7.500%	6.105%
2001	20.000%	13.500%	20.776%
2002	21.500%	14.000%	25.667%
2003	22.400%	13.500%	22.733%
2004	19.900%	14.400%	16.864%
2005	21.100%	16.700%	13.930%
2006	24.000%	18.800%	19.798%
2007	26.300%	19.700%	17.842%
2008	25.500%	21.100%	18.820%
2009	22.100%	23.400%	20.776%
2010	13.500%	11.500%	19.798%
2011	6.400%	8.800%	10.996%
2012	-1.100%	4.200%	-0.741%
2013	-4.000%	5.600%	-0.252%
2014	6.500%	6.800%	6.105%
2015	7.400%	8.700%	10.996%
2016	9.900%	9.900%	13.930%

Assume the risk-free rate is 3.55% and the market risk premium is 4.60%.
INPUT DATA		rRF	3.55%	Market Risk Premium		4.60%
a. What are the betas of Stocks A and B?
bA			bB
b. What are the required rates of return for Stocks A and B?
rA			rB
c. What is the required rate of return for a portfolio consisting of 40% A and 60% B?
INPUT DATA		wA	40.00%		rp
d. Stock A is trading at a price consistent with the security market line. If your analysis suggests that Stock A will provide a return above the SML, does your analysis suggest that Stock A is undervalued or overvalued? Explain