NAIC INVESTOR'S TOOLKIT DATA = REPORT=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D BASIC = DATA=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Company: Pfizer Inc. Price: 31.730 = Date: 12/10/2002 Ticker: PFE Industry: Pharmaceuticals High: 42.500 = Low: 25.100 Traded: NYSE Source: Value Line Date: 10/25/2002 = Total Debt($M): 11438.0 Reference: 1279 Preparer: Don = Pfd Stock($M): 0.0 = Pfd Div'd($M): 0.0 Last Full Fiscal Year: 2001 Month Fiscal Year Ends: December = Common Shares(M): 6189.7 Analyst's EPS Growth Est.(%): 17.50 Common = Dividends($): 0.500 Analyst's EPS Est.($): 2.80 % = Insider Ownership: 0.5 Quality Source: VL Institutional = Holdings(000): 3806527.0 Quality Rating: A++ Fully = Diluted Shares(M): 0.000 QUARTERLY = DATA=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Last Quarter of Data: 3rd Quarter 2002 Quarter Sales EPS PTP Tax% 4th Quarter FY 2000 8105.0 0.27 =20 1st Quarter FY 2001 7645.0 0.33 2600.0 668.0 2nd Quarter FY 2001 7686.0 0.30 2391.0 590.0 3rd Quarter FY 2001 7898.0 0.34 2072.0 0.0 4th Quarter FY 2001 9030.0 0.34 =20 1st Quarter FY 2002 8418.0 0.39 =20 2nd Quarter FY 2002 8033.0 0.33 =20 3rd Quarter FY 2002 8725.0 0.39 2350.0 0.0 ANNUAL = DATA=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Last Full Fiscal Year: 2001 Year High Low EPS Div'd Bk Val Sales Net = Prof TaxRate Shrs Out 1992 7.200 5.433 0.27 0.123 1.21 7230.2 = 1093.5 28.6 3902.00 1993 6.300 4.367 0.31 0.140 1.00 7477.7 = 1179.8 26.3 3851.00 1994 6.600 4.433 0.35 0.157 1.15 8281.3 = 1298.4 30.0 3771.00 1995 11.133 6.200 0.41 0.173 1.44 10021.0 = 1554.2 32.1 3824.00 1996 15.200 10.033 0.50 0.200 1.80 11306.0 = 1929.0 31.0 3870.00 1997 26.667 13.433 0.57 0.227 2.04 12504.0 = 2213.0 28.0 3882.00 1998 42.958 23.708 0.67 0.253 2.27 13544.0 = 2633.6 28.0 3882.00 1999 50.000 31.500 0.87 0.310 2.31 16204.0 = 3393.2 28.6 3847.00 2000 49.250 30.000 1.02 0.360 2.55 29574.0 = 6495.0 28.1 6314.00 2001 46.750 34.000 1.31 0.440 2.91 32259.0 = 8349.5 25.2 6277.00 Estimated Tax = Rate: 16.5 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Prepared using the NAIC Investor's Toolkit. 12/10/2002 11:25:39 PM NAIC INVESTOR=92S TOOLKIT ANALYSIS = REPORT=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D12/10/2002 Pfizer Inc. (PFE NYSE) Current Price: 31.7 Current P/E: = 21.9 FY 2001 ended 12/31/2001 Data through 3rd = quarter FY 2002(9/30/2002) Prepared by: Don Source of data: Value Line = (10/25/2002) Capitalization:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D Total Debt ($M): $11,438.0 Debt/Capital: 38.8% % Insiders % Institution=20 Preferred($M): .0 N/A N/A =20 Common Sh(M): 6,189.7 0.5 61.5 =20 Quarterly Performance (Qtr End 9/30/2002) = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D Sales($M) EPS($) Latest Quarter: 8,725.0 0.39 Year Ago Quarter: 7,898.0 0.34 Percentage Change: 10.5% 14.7% Section 1 - Annual Historical and Estimated Future Growth Rates = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D Historical Sales Growth: 18.1 Outliers: None Historical EPS Growth: 19.0 Estimated Future Sales Growth: 15.0 Estimated Future EPS Growth: 11.6 Projection started from last = annual data point Section 2 Evaluating Management = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 5 yr.Avg. Trend Outliers 2A % Pre-Tax Profit on Sales: 29.2 UP None 2B % Earned on Equity: 36.0 UP None Section 3 - Price-Earnings History = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D Outliers 3B7 Average Low Price: $ 26.50 None 3D7 Average High P/E: 50.60 None 3E7 Average Low P/E: 30.10 None 3G Average % Payout: 36.50% None Average P/E: 40.30 Current P/E: 21.90 Projected P/E: = 19.61 Section 4 - Evaluating Risk and Reward = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D 4A Average High P/E: 50.60 Estimated High EPS 2.27 Forecast High Price: 114.90 4B Average Low P/E: 30.10 4B Estimated Low EPS: 1.31 Selected Estimated Low Price: 26.50 4C Zoning = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D 26.50 --Buy -- 55.97 --Hold-- 85.43 --Sell-- 114.90=20 Zoning set at: 33%-33%-33% Current Price of 31.73 is in the 'Buy' range 4D Upside/Downside = Ratio:=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Upside/Downside Ratio: 15.9 Relative Value: 54.3 Projected Rel. Val.: 48.6 Section 5 - Five-Year Potential = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 5A Present Yield: 1.6 5B Average Yield: 2.1 5C Total Return(simple): 54.5 Total Return(compounded): 38.0 = Projected Avg. Ret: 30.8 Preferred Procedure Calculations = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Default Override Projected 5 Year Sales @ 15.0% 0.0 64,884.4 Less Expenses 29.2% 0.0 -45,938.1 Less Taxes 25.2% 0.0 -4,774.5 Less Preferred Dividends $0.0 0.0 0.0 = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Projected 5 Yr Total Earnings 14,171.8 Divided by Shares Outs. 6189.7 0.0 2.29 Calculated Growth Rate 11.8 Prepared using the NAIC Investor's Toolkit 12/10/2002 11:25:39 PM