NO EXCEL. THANKS.

Now, here is some data taken from the S&P Capital IQ database on comparable firms to Precision Castparts Corp: Company Comp Set Company Name TEV/EBIT LTM Latest 15.5% 12.8% B.BX 14.0% Tev Total Revenues LTM. TEVEDA LTN - Latest Latest 20 13.0x 12 10, B. 1x 103x 10.3x 18.7% 10.13 94x 1.1% 114x 1.1x 8.1% Rockwell Collina IncNYSECOL) L-3 Communications Holdings Inc. (NYSELLLI Spirit AeroSystems Holdings, Inc. (NYSESPR) Triumph Group, Inc. (NYSETGI) Textron Inc. (NYSETXT BE Aerospace Inc. (NasdaqGS:BEAV) General Dynamics Corporation (NYSEGD) Northrop Grumman Corporation (NYSENOCH The Boeing Company (NYSEBA) Huntington Ingalls Industries, Inc. (NYSEHI 14.8x 22.x 11 AX 10.7x 14.4% 10.2x Summary Statistics TEVIEBT LTM - Latest 22.8% High Low Mean Medien Tev Total Revenues LIM. TEVERTDA LTM . Latest Latest 3.3x 18,7x 1.1% 8.1 1. EX 11.CX 1.2x 10.3x 13. 13.3x (a) Using the comparable firm data and Precision Castparts data, calculate an estimate for Precision Castparts' share price based on EBITDA and comment on how it compares to the offer price of $235/share (i.e. is it higher, lower or the same?) (5 pts) Now, here is some data taken from the S&P Capital IQ database on comparable firms to Precision Castparts Corp: Company Comp Set Company Name TEV/EBIT LTM Latest 15.5% 12.8% B.BX 14.0% Tev Total Revenues LTM. TEVEDA LTN - Latest Latest 20 13.0x 12 10, B. 1x 103x 10.3x 18.7% 10.13 94x 1.1% 114x 1.1x 8.1% Rockwell Collina IncNYSECOL) L-3 Communications Holdings Inc. (NYSELLLI Spirit AeroSystems Holdings, Inc. (NYSESPR) Triumph Group, Inc. (NYSETGI) Textron Inc. (NYSETXT BE Aerospace Inc. (NasdaqGS:BEAV) General Dynamics Corporation (NYSEGD) Northrop Grumman Corporation (NYSENOCH The Boeing Company (NYSEBA) Huntington Ingalls Industries, Inc. (NYSEHI 14.8x 22.x 11 AX 10.7x 14.4% 10.2x Summary Statistics TEVIEBT LTM - Latest 22.8% High Low Mean Medien Tev Total Revenues LIM. TEVERTDA LTM . Latest Latest 3.3x 18,7x 1.1% 8.1 1. EX 11.CX 1.2x 10.3x 13. 13.3x (a) Using the comparable firm data and Precision Castparts data, calculate an estimate for Precision Castparts' share price based on EBITDA and comment on how it compares to the offer price of $235/share (i.e. is it higher, lower or the same?) (5 pts)