Please Help! show all formula and calculation step by step.

The following were the PE ratios of he firms in the aerospace/defense industry at the end of December 1993, With additional data on expected growth and risk

Company		PE Ratio	Expected Growth		Beta	Payout
Boeing		17.3	3.50%		1.10	28%
General Dynamics		15.5	11.50%		1.25	40%
General Motors- Hughes		16.5	13.00%		0.85	41%
Grumman		11.4	10.50%		0.80	37%
Lockheed Corporation		10.2	9.50%		0.85	37%
Logicon		12.4	14.00%		0.85	11%
Loral Corporation		13.3	16.50%		0.75	23%
Martin Marietta		11.0	8.00%		0.85	22%
McDonnell Douglas		22.6	13.00%		1.15	37%
Northrop		9.5	9.00%		1.05	47%
Raytheon		12.1	9.50%		0.75	28%
Rockwell		13.9	11.50%		1.00	38%
Thiokol		8.7	5.50%		0.95	15%
United Industrial		10.4	4.50%		0.70	50%

a. Using a regression, control for differences across firms on risk, growth, and payout. Specify how you would use this regression to spot under- and over-

valued stocks. What are the limitations of this approach? (please Show how you run the regression in excel)