ࡱ> u|  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwxyz{|}~Root Entry F @KWorkbook*_VBA_PROJECT_CUR"('PJ  VBA   (.@`\p Sam Foster Ba= ThisWorkbook=x[;8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1& Baskerville1& Baskerville1& Baskerville1Arial1Arial1Arial1hCentaur1Arial1& Baskerville1& Baskerville1Arial1Arial1Arial1Arial1& Baskerville1Arial1 Arial1 xMS Serif1Arial1Arial1Arial1Arial1Arial1 xMS Serif1Arial1* MS Sans Serif1Arial1* MS Sans Serif1Univers1Univers1 Arial1 Arial1 Arial1Arial1Arial1Arial1$Arial1 Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)m/d mmmm\-yyA<_("$"* #,##0.000_);_("$"* \(#,##0.000\);_("$"* "-"??_);_(@_)C>_("$"* #,##0.0000_);_("$"* \(#,##0.0000\);_("$"* "-"??_);_(@_) 0.0%mmmm\ d\,\ yyyy yyyy3._(* #,##0.0_);_(* \(#,##0.0\);_(* "-"?_);_(@_) 0.0000000 0.00000000 0.000000000 0.000000 0.00000 0.0000 0.0000.00_);\(0.00\) "$"#,##0.00#,##0.0_);\(#,##0.0\)0.000000000000000%0.00000000000000%% "$"#,##0.0_);[Red]\("$"#,##0.0\) 00000#,##0.000_);\(#,##0.000\)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)                + ) , * / 0 %      #  ! # +  # +   +" +  ! '    & &  #@@  #@  #@  # + # +# # # @ # " + #@ +#@ +# +#@ #@ #  # 1"@ @ 1"@ "@ "@ 1"@ "@ #"@  "@  " @  @@  @   @  @    @   @   , $`! &a h $a h &a#x $a l $` $h!   "   ) )# * )" *  ) " "  s ""@ @  #    # & &  #          #  &  &    ! " & #  " " "   &          &  &  +&  &   &     & &     & & & & & & & +& +& '& '& " & &  2 & +& +& +& "     +& & " + & +&   #  "   # '& & " &  ,& & & 1"  " " '& ,& &  1" " '# ! &     " +& & & & '! # & & & "    & &     2 & # & #  #  +&          @  " "   ""@ @ ! 1"@ # "#@@ "#@ "#  @ "@ "#@ "# "# "@ +"#@ +"# +"# 1"@ + #@ + # + # # +#@ +# +# +# #@ # # "@ ,#  # #"@ # @ # #  #"@ '#"@ 1"""@ @ '"@ "@  r#""@ @ #"@ # 1&""@ @ + "@ ""@@ " " @  "@  "@   # & & # & +  & +#  +    #   "         A # !       &  # #  +! ,& ,& ,&` ,&` - # ( '( ) #( ( (( "@ " @  H  L  L  L  L  H 1r"@ @ 1"@  L " #  . . " " " " " " " "  Normal_Company Info8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`j READ ME !!!!!s Data Entry SSG (pg1)  SSG (pg2)2w get quoteӘ Calculations SSG RAW FILE, Average0 Average1 Average2 Average3 Average4 Average5 Average6 Average7 Average8 Average9+ Book1_Sheet1_List; dataget:q$EPS_Exp_Growth: " EPS_Hist_avg: # EPS_Preferred: &EPS_Str_line_fit: $EPS_Two_pt_avg: ! EPS_YBGuess: % Get_data_from_Internet getdatafromxls! No_of_years: OpenSSGFileDialog  ;/  ;:   ;L?% quotes?IM_quotes_symbol_hd_type_Quote;C Restore0 Restore1 Restore2 Restore3 Restore4 Restore5 Restore6 Restore7 Restore8 Restore9&Sales_Exp_Growth:$Sales_Hist_avg:%Sales_Preferred:(Sales_Str_line_fit:&Sales_Two_pt_avg:# Sales_YBGuess: sharesplit`ijb(1#.3  @@   Company Prepared By High PriceDate Low PriceData taken fromEarnings Per Share EPS trendSymbolDividend Per Share Where Traded Sales trendMain product/service(Total Preferred Shares Outstanding (mil)Income Tax Rate (%)%Total Common Shares Outstanding (mil)Total Debt ($mil)Quarter EndingEPS Latest QuarterEPS Year Ago Quarter Current Price52 Week High Price52 Week Low PriceLatest Data YearRecent Severe Market Low Price'NAIC Preferred Procedure to Project EPS5yr Projections for:% Pre-Tax Profit'Weighted average of the last five years Tax Rate (%)Number of Preferred SharesNumber of Common Shares Estimated EPSRECENT QUARTERLY FIGURESCAPITALIZATION Authorized OutstandingSALESEPS PreferredLatest QuarterCommonYear Ago QuarterPercentage ChangePotential Dilution. VISUAL ANALYSIS of Sales, Earnings and PriceHistorical Sales GrowthHistorical EPS GrowthEstimated Future Sales GrowthEstimated Future EPS Growth EVALUATING MANAGEMENTLAST 5 TRENDYEAR AVGUPDOWNAB4PRICE-EARNINGS HISTORY as an indicator of the future PRESENT PRICEHIGH THIS YEAR LOW THIS YEARPRICEEarningsPrice Earnings RatioDividendYearHIGHLOW Per Share% Payout % High YieldTOTALAVERAGEAVERAGE PRICE EARNINGS RATIOCURRENT PRICE EARNINGS RATIO0EVALUATING RISK and REWARD over the next 5 yearsHIGH PRICE - NEXT 5 YEARS Avg. High P/EXLOW PRICE - NEXT 5 YEARS(a) Avg. Low P/E=(b)(c) Present Divd.(d) High YieldSelected Estimated Low Price =CZONING1/3 of Range = Lower 1/3 =to(Buy) Middle 1/3 =(Maybe) Upper 1/3 =(Sell)Present Market Price of is in therangeD9UP-SIDE DOWN-SIDE RATIO (Potential Gain vs. Risk of Loss)EPRICE TARGET (Simple Interest)5-YEAR POTENTIAL"AVERAGE YIELD OVER NEXT FIVE YEARS$Avg. Earnings Per Share Next 5 Years,ESTIMATED ANNUAL RETURN OVER NEXT FIVE YEARSdivided by 5 ==Est future Sales growth rate via the Straight Line Fit method%6:Est future Sales growth rate via the NAIC Preferred method%3>Est future Sales growth rate via the Exponential Growth method%7?Est future Sales growth rate via the Two-Point Averaging method%8*Historical Sales growth rate for the last (Historical EPS growth rate for the last 8Est future EPS growth rate via the NAIC Preferred method#1<Est future EPS growth rate via the Exponential Growth method#5=Est future EPS growth rate via the Two-Point Averaging method#6;Est future EPS growth rate via the Straight Line Fit method#4"Recent Severe Market Low Price = Price Dividend Will Support #Avg Low Price of the Last 5 Years =High Forecast Price, Minus Low Forecast Price, Equals Get this ?????? 5 Year Appreciation Potential Average Yield +Total Annual Return for 5 Years (average) ESTIMATED APR AND RETURN X Avg. % Payout ;% Pre-tax Profit on Sales (Net Before Taxes / Sales)Market Capitalization ($mil)Relative Value = < 100% is DESIREDMarket Capitalization% Return on Shr. Equity ROEAPR% Total Return[G][C][D][I]Net Profit ($mill)(Value Line)Sales or Revenues ($mill)Sales ($mill) Latest QuarterSales ($mill) Year Ago Quarter WANT > 3 TO 1 WANT >15%PTo Calculate the Earnings Per Share (EPS) five years from now do you wish to use!)ITo Calculate the Sales growth rate five years from now do you wish to use!".Est future EPS growth rate via Your Best Guess0Est future Sales growth rate via Your Best Guess! Total DebtBook Value Per ShareBetaRevenues ($mill)6% Returned on Equity (E/S / Book Value)1/4 of Range = Data for the graph on SSG(pg1)Strong Buy Under Strong Sell Over = Forecast High PRICEEstimated High Earnings/Share Estimated Low Earnings/Share Minus Present Price Minus Low Price Present Price High Price INVEST THIS Appreciation Present Market Price Present Full Year's Dividend Present Price of Stock /Present Yield or % Returned on Purchase Price IgnoreDO NOT MESS WITH THIS PAGE # of OLD # of NewLow Price (Oldest Year)Sales (Oldest Year)SalesTax Rate (Oldest Year)Tax RatePreTax Inc (Oldest Year) PreTax IncNet Income (Oldest Year) Net IncomeBook Value (Oldest Year) Book Value Earnings per Share (Oldest Year)Earnings per Share Dividend per Share (Oldest Year)Dividend per Share Current P/ECurrent DividendLast yr of dataNo of Data Years Used 52 Week high 52 Week low Number common shares outstanding #auth. common #pref shares #auth pref Total debt Pot. dilutionLatest quarterly salesYear Ago quarterly salesLatest quarterly E/SYear Ago quarterly E/Slast CY of data +5Outside e/s estChoice low price (5Yr Avg Low) Choice hi PE Choice low PEAdd/Delete flag Low e/s est.Qtrly e/s growthProj e/s growthQtrly sales growthProj sales growth Current yield Avg. yieldHist. e/s growthAvg PE U:D ratio5 yr. sales est.Avg pre-tax prof.Income tax ratePref. dividendsProj. liabilitiesProj. out. sharesPref. proc. e/sVisual e/s est.Last CY trend e/sHist. sales growthAvg. ROELow price est.Avg. price est.Sell level priceProj. div payout% Previous E/S New EpS estProj. hi price Current CashCurrent Accounts ReceivablesCurrent InventoriesCurrent assets!Short Term Debt (Sum Last 4 Qtrs)Current liabilitiesYear Ago Current CashYear Ago Accounts ReceivablesYear Ago InventoriesYear Ago Curr assetsYear Ago Debt Year Ago Cur liabilitiesTotal capitalizationLong term debt (Oldest)Long term debt"Number shares outstanding (Oldest)Number shares outstandingCash flow/sh (Oldest) Cash flow/sh Total assetsInterest coverage % Total returnProj. e/s growthsevere low price R squaredReservedQuarterly Sales (Oldest)Quarterly Sales Quarterly E/S (Oldest) Quarterly E/SQuarterly Dividends (Oldest)Quarterly DividendsINSIDE OWNERSHIPINSTITUTIONAL HOLDINGS#Ace 5 Year Estimate E/S Growth RatePREDICTABILITYLT DEBTFiscal Yr end MonthNameExchange Data sourceDate of data Creationv-l pagecode Reserved industrySplit Ratio During QuarterLatest Quarter Ending DateMonth of Latest Quarterly DataYear of Latest Quarterly DataSoftware Version Sic CodeS & P Stock RankFinancial strength VL Safety VL!Quarterly Pre-Tax Income (Oldest)Quarterly Pre-Tax Income 'Quarterly Pre-Tax Income (Most Recent)Quarterly Net Income (Oldest)Quarterly Net Income "Quarterly Net Income (Most Recent)+E/S in 5 Yrs. Based on Ace Proj Growth RateHistorical 5 Yr E/S Growth RateCurrent PE/Ace 5 Yr Growth rate S&P Rating Avg 5 Yr PEProj 5 Yr High Price%Proj Compounded Appreciation of Price Current YieldProj Total Return"Historical 5 Yr. Sales Growth Rate$Historical 5 Yr E/S Growth R-SquaredIndustry Group% Off 52 Week High Price% Above 52 Week Low PriceRelative Value PE/Avg ROEDebt as % of CapitalNext Year E/S estimate'Historical 5 Yr. Sales Growth R-SquaredKNOWN PROBLEMS:`The Visual Analysis chart will give an error message "Negative or zero values cannot be properlyl charted on a log chart" if any of the revenues, earnings or pre-tax profit figures are zero or negative.aI have attempted to make the workbook useable for both user-contributed datafiles in the SSG Filec Library, which have the user's projections, as well as the Undervalued Stock and Stock to Studya Datafiles on the NAIC Web Site, which do not have judgement. However, this may cause trouble in some circumstances.dIf less than 10 years of positive earnings and sales are included in the data, some calculations may/ display errors in Excel (#NUM! or #DIV/0!).High Price (oldest) High trend< Low trend_You should always make your own judgements about a company's future growth and price potential.dThis workbook will read *.SSG datafiles, the default file format of NAIC's SSG software programs. Itb*.SSG files are available from several online sources, and investors often share their analyses by,e-mailing, or downloading, these data files.XFrom your SSG program, you can export a *.SSG file, which may then be imported into this2spreadsheet and converted to a readable text file.\To use the workbook, click the Import SSG File button on the Stock Selection Guide Page, anddselect the *.SSG file you wish to view. All data will be imported and all calculations will be done.mrequires Excel 5.0 or later. Mainly it provides a format that uses formulas that the NAIC organization uses.G(www.better-investing.org) It has been tested on Excel for Mac as well.(e)Projected Low Price =[P]'a (G)rowth, an (I)ncome, a (C)yclical,#a Cyclical but the maket is (D)own,or use (P)rojected Low Price?   the NAIC (P)referred method, $ the Exponential (G)rowth method, % the (T)wo-Point Averaging method,  & or the Straight Line (F)it method, # the Straight Line (F)it method, 6 OR use the (Y)our Best Guess that you entered above? DO NOT USE********************* THE MORE YOU USE THE AVERAGES, THE LESS ACCURATE YOUR RESULTING DATA WILL BE!!!!!!!!!!!!!!!!!!!! **********************YIs this stock;(used for the low price)(used for the high price)FPlease report all errors and/or glitches or suggestions to Sam Foster.PEG(By Sam Foster (sfoster@anythingetal.com)Some Macros were obtained from Douglas Gerlach (by permission) (Ver.2.2)(gerlach@better-investing.org) and the original layout of the charts from R. Beaubien (Rev. 1.52)(bad email add.)This program and / or any part of this program and any formula are for use as a tool by the USER HE(S) ASSUMES ALL RISK and the originators (Foster, Gerlach, and Beaubien) hold no liability for any results obtained from the use of this or part of the program.\#`a#xGCurrent Volume Ticker Symbol Version 5.1SSG-XLT-51.xlt NewsChart SEC FilingsProfileConference CallsHomeMarketsOptionsHighLowOpenBidAskMore...ResearchFreeRealTime.com FRT Express FRT Stream | Insight CommunityTools Join for FREE Why Sign Up?Quote Time&Sales MessageBoardMultexInvestorForgot Your Login? Latest News PR Newswire Business Wire Market UpdateBefore the BellAfter the Bell WatchList ETF Center Most ActivesPercent Gainers Market PlaceTrader's LibraryHelpPortfolio TrackerSearch SEC FilingsDJIANasdaqS&P 500 30 Yr Bond 10 Yr BondLast Change (%)After Hours Chg (%)** Trade TimeExchange Quote Bid (size) Ask (size)N/A Day Volume Last Size Latest Ticks # of TradesAvg Trade SizeVWAP 52 Wk High 52 Wk Low Prev Close Avg Day VolR** Represents the price change since the close of normal trading hours at 4 pm ET.Exchange market data provided by DTN Market Access. Data and information is provided for informational purposes only, and is not intended for trading purposes. Neither FreeRealTime.com nor any of its data or content providers shall be liable for any errors or delays in the content, or for any actions taken in reliance thereon. By accessing the FreeRealTime.com site, a member has agreed to the FreeRealTime.com Member Agreement.0User Agreement, Privacy Statement, Version 3.50 Nforgot your login? - my member info - help - site map - about us - contact us + Pre-AnnouncePick of the DayI View WatchList Edit Watchlist Symbol Search Portfolio TrackerReal-time ECN Quote* P/E RatioMarket Cap (mil)* A Real-time ECN Quote is a real-time quote from a participating ECN (Island, Instinet) and does not necessarily represent the best bid or ask in the marketplace. ECN's (Electronic Communications Networks) are electronic marketplaces that match buy and sell orders with each other.PZSSG-XLT-R51.xlt Sam Foster (Rev. 1.52 by R. Beaubien) 1-14-04 [sfoster@anythingetal.com] ACopyright 1998-2004 FreeRealTime.com, Inc. All rights reserved.N$7 Trades at Scottrade. Ranked "Highest in Customer Satisfaction" 5 times! GO! $7 TRADES!)6:57:56 PM EDT - Sunday, October 17, 2004#Markets are closed for the weekend. Click HereMore LOW3LOWE'S COMPANIES INC - New York Stock Exchange: LOW 0.35 (0.64) 0.05 (0.09)0 (0) 0.30 (0.55)=+==Y6:57:56 PM EDT - Sunday, October 17, 2004- Exchange quote is delayed at least 15 minutes.'6 6wM7278@9%9z:_:Y;> <b<G</=1>K@0 A{ B C D LE1FFnGS HHPI5 JJKK@L%MMNN3OOz9PPQRS0V :X"Z[y\9__L _ *` `b a aK a Zb efGh  (.@ &~orNs  dMbP?_*+%M\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dhh??cU} \F&   ; Fw Gv Hp Fq FS FZ F[ FT FU FV FW FX FYI JR KF FG FH FI FJ FK FL FM FN4, "u% "Fr %FnD>@%7 Sheet6 (.@ $QxGξ 8^  dMbP?_*+%&A&?'?MSHARP AL-1540CS od,,LetterSCPI&SHARP AL-1540CS od,,LetterH ~ 33**** o****d"Ariald,3333 ~ ~ 33 @222222< Username unknownJobname unknown`@< dSC0C"2,,??cU} $%} $}  } $ }  } $             @           T" D   D D D  D  D  D  D  D D$? D$@ D$@ D$@ D@ D  n&I܆XDD?DA @(DD?@DBn&܆XDD?DA @(DD?@DBn&XXDD333333?DA @(DD333333?@DBn&X\XDD?DA @(DD?@DBBT`,ZA @@:B ^P  n&dXDD?DA @(DD?@DBn&hhXDD?DA @(DD?@DBn&lXDD333333?DA @(DD333333?@DBn&pXDD?DA @(DD?@DBBT7t,Z'A @@:'B- ^Q  \&xFDZ9DA @@DZ9DB\&a|FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB\&C*FDZ9DA @@DZ9DB ^ u  $%%%%%  U $%%%%%          \&FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB\&FDZ9DA @@DZ9DB ^    $      '%%%%    $ %%%%%       R  HLLA@--------------------@LLB--------------------   -------------------- 3  -------------------- $  -------------------- aP  -------------------- | -------------------- :  -------------------- =  -------------------- tB  -------------------- kB  -------------------- (%%%%     Wi WWWWWWWWW   k _l --  )  _N ,X8D  D D D tD  BD   Bad Data! DD " DD " DD" DD" DD" DD B Bad Data!  .u  -- )lbD D D D `D  <D  Insufficent Data!5 years."6 years."7 years."8 years."9 years." 10 years.BInsufficent Data!N,8D  D D D tD  BD   Bad Data! DD " DD " DD" DD" DD" DD B Bad Data! .t --TZ CInsufficent Data!  ` s_AZ0Z' Try a Different One!!!!  BA @HZ0Z' Try a Different One!!!! @"BTry a Different One!!!!i Ea=SD.DA@n/a$D.D@Bn/a  )v)/+DD )q  ^a +0D D <D D D  [D   Bad Data!9% `~`4~b4D"9% `@~`~b4D"9%`~`~b4D"9%`~`T~b4D"9%`(~``~b4D"9%` ~`l~b4DB?@@@@$@?@@@@@&@?@@@@@@(@?@@@@@@ @*@?@@@@@@ @"@,@ ?@@@@@@ @"@$@.@ Bad Data!  )w)+D D D <D D D  [D   Bad Data!9% ` ~`H~b4D"9% `T~`~b4D"9%`~`b~b4D"9%`b~`~b4D"9%`~`~b4D"9%` ~`~b4DB?@@@@$@?@@@@@&@?@@@@@@(@?@@@@@@ @*@?@@@@@@ @"@,@ ?@@@@@@ @"@$@.@ Bad Data! )r  +!lD lD $D D D  XD   Bad Data!6% B% B@"0% B% B"6% B% B @"0% B% B"6% B% B@"0% B% BB Bad Data!  )x+  D lD $D D D  XD   Bad Data!6% B% B@"0% B% B"6% B% B @"0% B% B"6% B% B@"0% B% BB Bad Data! )s  8J +qD sD ,D D D  WD   Bad Data!5% b1`~D"5% b1`~D"5%b1`~D"5%b1`~D"5%b1`~D"5%b1`~DB.@?.@?.@?.@?.@?.@? Bad Data!  )yJ+l D sD ,D D D  WD   Bad Data!5% b1` ~D"5% b1`8~D"5%b1`D~D"5%b1`\~ xD"5%b1`t~0D"5%b1`~wDB.@?.@?.@?.@?.@?.@? Bad Data! )p  b _m   c~  ?  )~ ? )  d  ?\,* Use DZ D?dA.% to equal Your Projected High Price for year DAEnter in more DataxUse DZ D?dA.% to equal Your Projected High Price for year DBEnter in more Data  e  ggܯQ@Est. Number of Preferred Shares Outstanding (mill) for the year D@DAEst. Number of Preferred Shares Outstanding (mill) for the year 5  ] ]d`N=Est. Number of Common Shares Outstanding (mill) for the year D@A>Est. Number of Common Shares Outstanding (mill) for the year 5 b? ?E/Sales or Revenues ($mill) for D@"Sales or Revenues ($mill) for 5! c; %Income Tax Rate (%) D@Income Tax Rate (%) 5" dE   /Projected High Price for year D@@"Projected High Price for year 5  f  gD `.Projected Low Price for year D@@!Projected Low Price for year 5  L tMc `` ab" D b  Db Db D b D b D b D b D b Db Db? Db@ Db@ Db@ Db@ Db@  D`D~2l!`h2NN2NNBLx4bcLsw !"#$%&'()*+,- ./3456789:;<=>? c c ` d@e? e?   L? ep= ף?   eʡ?   enV}r?   e67k?   e_ q?   e%{?   egQ?   e=?   eS:?   e>͌]?   eFӻ?   e#`o+?   e ̭?  % eo@!D ? `!c !``!d$@e?!e?!!!!L?!e](\?!!!eK?! !! ez-!l?! !! em>"?! !! eXPX?! !! e~Z-?! !! e*,&@!!!e0ԭ@!!!e> @!!!eEO.@!!!e36V @!!!e^@ @!!!eFa@!!%!eK@"D!?!`"c "``"d.@e?"effffff?""""Lffffff?"e(\(?"""e-$U?" "" eZC?" "" eoB@" "" e&)&@" "" eʀG@" "" ex@"""e[IS$ @"""e㯦.@"""e%y} @"""erf@"""eODz[t@"""e4eυM@""%"eʓ,F @#D"ffffff?"`#c #``#d4@e?#e333333?####L333333?#e ףp= ?###eS?# ## eǘ@# ## eP@# ## eSK@# ## e=Z @# ## e73@###eu@###e~V@###eA^g@###e82 !@###ewoW f%@###e[)@##%#e:!e.@$D#333333?#`$c $``$d?e?$e?$$$$L?$e?$$$e@?$ $$ e@$ $$ ej@$ $$ e@$ $$ e@$ $$ e@$$$ee@$$$e _"@$$$evH'@$$$e-@$$$e@02@$$$eļ6@$$%$e4&k<@%D$?$`%c %``%d>@e?%e?%%%%L?%e ףp= ?%%%e~jt@% %% eGJ@% %% eòҤ @% %% ee'N@% %% e[r@% %% eP @%%%e5%@%%%ew Z+@%%%e_<1@%%%ez|NOL7@%%%eɟnLI>@%%%e{~ׯC@%%%%e W˗I@D%?%`&c.&```````````````````` 'c'+++++++++ 'Xo'++++ ((+++++++++Y )) +D) +)Y *\*!Q.FZ Z Z Z Z *f*Z@PZZ9{Gz?A @$@ZZ9{Gz?B ++!,D+Z ,,*-D,Z -"-# D-[ . ;. C< %D)D*D+D,D-.[/[3 44 55 66 77 88 99 : ; < = > ?>?0:00000<L.A777W @ABCDEFG @ A B C D E F GcN - 6 ( 333ff3  x  6~CC@],@~0cp~9$ $<Restore< &/xx  68~CC@ ],@8~c~9# $<Restore< &/xx  6~CC@ ],@~d`~9" $<Restore< &/xx  6\~CC@ ],@\~dĕ~9! $<Restore< &/xx  6ȍ~CC@  ],@ȍ~He~9  $<Restore< &/xx  6l8~CC@  ],@l8~e~9 $<Restore< &/xx  69~CC@  ], @9~xf8~9 $<Restore< &/xx  6h~CC@  ], @h~g4h~9 $<Restore< &/xx  6i~CC@  ], @i~gP0i~9 $<Restore< &/xx  6~CC@ ], @~@hli~9 $<Restore< &/xx  6~CC@  ],@~h~9 $<AVERAGE Average< e 0xx  6g~CC@  ],@g~pi~9 $<AVERAGE Average< e 0xx  6N~CC@   ],@N~jg~9 $<AVERAGE Average< e 0xx  6O~CC@   ],@O~jܖ8O~9 $<AVERAGE Average< e 0xx  6ж~CC@   ],@ж~8kO~9 $<AVERAGE Average< e 0xx  6l~CC@   ],@l~k ~9 $<AVERAGE Average< e 0xx  6M~CC@   ],@M~hl0d~9 $<AVERAGE Average< e 0xx  6 ~CC@  ],@ ~mL~9 $<AVERAGE Average< e 0xx  687~CC@  ],@87~mh6~9  $<AVERAGE Average< e 0xx  6P~CC@  ],@P~lZ~9  $<AVERAGE Average< e 0~~  <hz~CC@?  ],@hz~[~9+ $ < Share Split<@ xx ! 6z~CC@ ],!@z~[z~9 $ < Import .SSG<H xx , 6{~CC@KdPx],,@{~[ؗ,{~9 $<Get data from Internet<~xx - 6(|~CC@+G],-@(|~\{~9 $)<*Get data from a old Excel SSG spreadsheet<)@@>@   ')*/%7  ?  SSG spreadsheetCC ? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D? SSG spreadsheetCC D  ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D   ?  SSG spreadsheetCC D ? SSG spreadsheetCC D Sheet1 (.@ @:&  dMbP?_*+% &Q?'?(?)?MSHARP AL-1540CS od,,LetterSCPI&SHARP AL-1540CS od,,LetterH ~ 33**** o****d"Ariald,3333 ~ ~ 33 @222222< Username unknownJobname unknown`@< dSC0C"d,,cU} #} $ #} m #} $ #} #} I #} I #} #} I#} $ #} $ @     x@      x@ J  ;  lZ Company\8Z \lDZDate]Z ] l Z Prepared By^Z ^lZData taken from^Z ^ l:Z Where Traded^Z ^lܱZ Ticker Symbol^Z ^ lZMain product/service^Z ^ $'aZ .Aa %!&& l" # $ ' Z  % & '() Z   *( + Z + Z  ) ( )Z   l* + Z + Z ,  - Z  .  l+Y $CD D D A @-D D @D B-Y V$ CD D D A @-D D @D B- , /, _` l,/,0~ 1? p- qqqqqqq 2k #j"$T 4 ) - . @4 8 9 : @; < = > ? )3) 3 -kk - kk .44444444444 45 86.8+(8C& Bad Data!87<8CInsufficent Data!8 86/8fX`8 C Bad Data!8 7t9CInsufficent Data! 9 9609+ZY  #*ZP  #'ZG  #%]ZT  #);ZF  #(Incorrect Entry""""B 9 9619gaZY  #ZP  #ZG  # ]ZT  #;ZF  #Incorrect Entry""""Bn/a :A:89+ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method :A:8в:+ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method;69:;<:<69;;=:==>=?=Z  < $(  d  s *AM?% 7] (y  (.@&A Page &PM\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dX??33d23 M NM4 3Q  30%Q ;%%Q ;Q3_  NM  d4EC4 3Q  25%Q ;$$Q ;Q3_  NM   d4EC4 3Q  20%Q ;##Q ;Q3_  NM  d4EC4 3Q  15%Q ;""Q ;Q3_  NM  d4EC4 3Q  10%Q ;!!Q ;Q3_  NM  d4EC4 3Q 5%Q ; Q ;Q 3_  NM  d4EC4  3Q SalesQ ;Q ;Q3_ NM   d4E4  3Q  EPSQ+ ;Q ;Q3_  NM   d4E4  3Q  High PriceQ ;Q ;Q3_ NM   d4E4  3Q  Low PriceQ ;Q ;Q 3_  NM   d4E4D$% /3O& Q4$% /3O& Q4FA9n3O3 bo! ! 43*?"! ! ! 43" w3O% ;3OQ423  NM44$% @/3OQ'4$% /3OQ'4444 e""""""""" "                            ? ? ? ? ? ? @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@e?????? ??333333?ffffff???  ףp= ?? ףp= ?(\(?](\?p= ף? ~jt@@?S?-$U?K?ʡ? GJ@@ǘ@ZC?z-!l?nV}r? òҤ @j@P@oB@m>"?67k? e'N@@SK@&)&@XPX?_ q? [r@@=Z @ʀG@~Z-?%{? P @@73@x@*,&@gQ?  5%@ e@ u@ [IS$ @ 0ԭ@ =?     w Z+@  _"@ ~V@ 㯦.@ > @ S:?     _<1@ vH'@ A^g@ %y} @ EO.@ >͌]?     z|NOL7@ -@ 82 !@ rf@ 36V @ Fӻ?     ɟnLI>@ @02@ woW f%@ ODz[t@ ^@ @ #`o+?    {~ׯC@ļ6@[)@4eυM@Fa@ ̭? e   > @Text 3f]D $<NAIC STOCK SELECTION GUIDE<[>@J %7 Sheet2 (.@ LP%~Lbi  dMbP?_*+%&?'?(?)?MSHARP AL-1540CS od,,LetterSCPI&SHARP AL-1540CS od,,LetterH ~ 33**** o****d"Ariald,3333 ~ ~ 33 @222222< Username unknownJobname unknown`@< dSC0C"Z,,cU} k} k} Ik}  mk} k} mk} k} k} m k} k} $ k} $ LJ@K@ x@@@@@@J  @  @  @ J x@@@@x~ i@ j2 l Z Company  m Z nn*opqqrrrrrsrtuurqqq ivlw   ivlw   x3 y4yz{!|" Z !|  Z!| Z!| Z! | Z! | Z! | Z! | Z! | Z| Z }5 }6 ~7 8  s]Z Z Z  B%Bad Data$ZZ ZB Bad Datas$]Z Z Z  B%Bad Data$ZZ ZB Bad Datas8]Z Z Z  B%Bad Data$ZZ ZB Bad DatasL]Z Z Z  B%Bad Data$ZZ ZB Bad Datas z`]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas Ot ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas  ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas  ]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datas 4]Z  Z  Z  B%Bad Data$Z Z Z B Bad Datasij ]Z Z Z  B%Bad Data$ZZ ZB Bad Data#9J % B D 9  سZ --------------------Z --------------------30 Z --------------------\ Z -------------------- aZ --------------------  Z -------------------- :Z --------------------  Z -------------------- 8Z --------------------kdZ --------------------#4h % B D~ o@ :&qqqqqqqqqqqqqqqq iv  ;  Z  <  Z =   Z   >  ?  @ A  B  C  D  E  C D E  F G ~ ?! ZZ Z Z S ǐ =Z Z A @-@Z Z B- S  =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K. 5D DA @-@D DB-~ @! ZZ Z Z S R =Z Z A @-@Z Z B- S  =Z Z A @-@Z Z B-  Z K 5D DA @-@D DB-K  5D DA @-@D DB-~ @! ZZ Z Z S İ =Z Z A @-@Z Z B- S  =Z Z A @-@Z Z B-  Z K5D DA @-@D DB-K޼ 5D DA @-@D DB-~ @! ZZ Z Z S 0 =Z Z A @-@Z Z B- S ĵ =Z Z A @-@Z Z B-  Z Kȵ5D DA @-@D DB-Ku̵5D DA @-@D DB-~ @ ZZZZS е =ZZA @-@ZZB- S Ե =ZZA @-@ZZB-   ZKiص5D DA @-@D DB-Kܵ$ 5D DA @-@D DB-~ @ H # % O '9% AA @-% @B O  9% AA @-% @B  O 9%A @-%@B ~ @ I # %B O 9% BA @-% @BB- O 9% BA @-% @BB-  O9%BA @-%@BB- ~  @ JQ;$ $ BA @-$ $ @BB-~  "@  K %ZZ kj~ o@ Lqqqqqqqqq   qq !hK DD qq  8 M  N D - O   CZ  !x(9 DD  A  +ZY (Y)our Best GuessZP NAIC (P)referred methodZG "Exponential (G)rowth methodZT #(T)wo-Point Averaging methodSZF !Straight Line (F)it methodIncorrect Entry""""BNAIC (P)referred method  9 P   Q  R(D - O    Z S!7gݛ DD  & T |*D    \  ]  !Z ^DV&l.2XFsssso*D !"x#$%&x'(x)*@ +x@,@ -@.@/x@0@1x@2@3@4@5@6x@7@8@9@:@;x@<J@ =x@>@?@&   !U! !z! Z! ! ! !&""# #V # # E D # # $W$ ${ $ $ S$ $ SZ$ 'DD  %B B%D %BB$ $$% %X % #% # %B$% :&' 'Y'7,ZP  $ZG  $}ZI  $$ \ZC  $;ZD  $!Incorrect Entry!""""BA @-ZP  $ZG  $}ZI  $$ \ZC  $;ZD  $!Incorrect Entry!""""@"B-'Q'0;ZP /((e) Selected just because it LOOKED GOODZG (a) Selected for GrowthZI (d) Selected for IncomeZC (b) Cyclical Company\ZD 4-(c) Cyclical Company (but the market is down)Error!""""B(a) Selected for Growth(' :( )Z )[)NN*x(.D* *} **7` D'-* *~ * !* l, D*D** *\*-*H- D* * , ,],7d% D*-, ,^!,N. D*D*, , _, ,b,b,cl- D* ,c - -`!-N- D*D*- -^!-O, D-D*- - a- - - !-vaN0 D*D, - . .b!.O3 D-D*. .^.x(* D*. . c. . . !.-0P. DD, .*/0 0d0 Z0 0e00 2*D0D-  Strong BuyD0D- D0D, B$ BuyD0D- D0D- B$ MaybeiD0D. D0D. B$ Sell8D0D.  Strong SellError""""B0 0 f0 *1 2g 2h 2 2 3 33x(4 D3 3 3 3 0Z3 4 4 S4 38DZ Not Meaningful!DZ ^ZD'  N.M.F.3DZZD'A To 1""B4 5 553 Z5 5 5 5 7h,D*-5 $6 7i 7j 8 88x(:D8 8 8~ 8@@ 89 9S(9 :|H DZ9 9 9 $9HDZ 9 : ::5Z:!:yH D8D9 ::;~ <o@ <k&<qqqqqqqqqqqqqqqq*= >8 >>->@Z>? ?S&? \>ZZ? ? ? DlDD>|>. ..N (F.o@@Ax@BC@D@E@Fx@G@H@I@J@ K0@ @@-@:Z@*A B9 Bl&BC CmC=C -`SD':::::BC C C C l? D-C "D DS*D/TIDCDZ DE E E C ZE  GZ Gn G H HHH:| D9 H H oH H @ I D9  H @ `HpCJD9?AQA @!D9?AQ@B HI I I @/TJ DD I A >ItJ(DDA @@$DBJ J !J BpU* DH DI  J C JJxK4DHDIA @@DHDIB JK|5 Z]ZSSG-XLT-R51.xlt Sam Foster (Rev. 1.52 by R. Beaubien) 1-14-04 [sfoster@anythingetal.com] K  K >hRK49 <DJAQA @DJ@AQB Kk.Fpc*.0 "(  RB  C B4 4]̫ZRB  C B99],ZRB  C B??]|ZRB  C B DD]쮎ZRB  C BC$ $]`ߎTLB  3  $ $]`xp2  6AA B?J0L<]xp2  6AA B? 35@]xp2  6AA B? f]xp2   6AA B?6/ 1] Hxp2 ! 6AA B?p`]!౎xp2 " 6AA B?GMI@]"x>@  ,,,,%700 00 ?00 6AA B?Buy?00 6AA B? Maybe?00 6AA B? Sell? 6AA B? x? 6AA B?X? 6AA B?x4444?44 6AA B??44 6AA B?44 44 ?44 6AA B??44 6AA B? Sheet3 (.@ D{@&  dMbP?_*+%MSHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"dXX??U} }  } m } I } D    @ @@@@@@ N N$NNNNNNNNNNNNNNN NN N N NNNNNNNNNNNNN(NNNNNNNNNNNNNNNNN Nx NNN N~ N N N Ny  N  N  N  N  N N N N(NNNNNNNNNNNNNNNNN(NNNNNNNNNNNNNNNNN N N$NNNNNNNNNNNNNNN(NNNNNNNNNNNNNNNNN N&NNNNNNNNNNNNNNNN( NNNNNNNNNNNNNNNNN N N~ N N NNNNNNNNNNNNN NNNNN N N~ PuP.A NN ~ Nj@ NNNNNN N N$ NNNNNNNNNNNNNNN N N NNN N N~ Pޝ@ NN ~ N@ NNNNNNN N$NNNNNNNNNNNNNNNN N NNN NN~ PA@ NN ~  N~@ NNNNNNN N$NNNNNNNNNNNNNNNN N NNN NN~ NP~@ NN ~  N@ NNNNNNN Ny$NNNNNNNNNNNNNNNN Nz NNN NN~ NPy@ NN ~  N@ NNNNNNN N|$NNNNNNNNNNNNNNNN NN S NNNNNNNNNNNNNN N}N N NNNNNNNNNNNNNN NN N N NNNNNN  N  N  N NNNN N{N~ N@ N NNNNNN  Q>>?  N  Q NNNN N$NNNNNNNNNNNNNNNN N$NNNNNNNNNNNNNNNN NN N NNNNNNNNNNNNNN NN N N NNNNNN  Q  N NNNNN NN~ S@ N~ V`@NNNNN  N  Q NNNNN NN N N NNNNNN  N  N NNNNN NN OOe@N@NNNNN  No@N@  NNNND*lDZ,,,D,8,Tl@@@@@TT@@T !"#$%&'()*+,-./0123456789:;<=>? N N N N N N NNNNN N N NNNN !NNN!OO`FAO@!NNNNN ! N@S@ ! NNNN"N "Ny"N "N "N "N"NNNNN " N " N" NNNN#N #N#N#R@O@R#NNNNN # N6@O@@ # NNNN$N $N$N $N $NNNNNNNNNNNNN%N %N$%NOONNNNNNNNNNNN&N &N&N &N &NNNNNNNNNNNNN'N 'N$'NOOONNNNNNONNNN(N (N(N (N (NNNNNNNNNNNNN)N )N$)NNNNNNNNNNNNNNN*N *N$*NNNNNNNNNNNNNNN+N +N+N +N +NNNNNNNNNNNNN,N ,N$,NNNNNNNNNNNNNNN-N -N-N -N -NNNNNNNNNNNNN.N .N$.NNNNNNNNNNNNNNN/N /N$/NNNNNNNNNNNNNNN0N 0N$0NNNNNNNNNNNNNNN1N 1N$1NNNNNNNNNNNNNNN2N 2N$2NNNNNNNNNNNNNNN3N 3N$3NNNNNNNNNNNNNNN4N 4N$4NNNNNNNNNNNNNNN5N 5N$5NNNNNNNNNNNNNNN6N 6N$6NNNNNNNNNNNNNNN7N 7N$7NNNNNNNNNNNNNNN8N 8N$8NNNNNNNNNNNNNNN9N 9N$9NNNNNNNNNNNNNNN:N :N$:NNNNNNNNNNNNNNN;N ;N$;NNNNNNNNNNNNNNN(<NNNNNNNNNNNNNNNNN(=NNNNNNNNNNNNNNNNN(>NNNNNNNNNNNNNNNNN ?N&?NNNNNNNNNNNNNNNND lhzT@T@T@@T@T@@@@@@@@@@@@@@,,,@ABC(@NNNNNNNNNNNNNNNNN AN&ANNNNNNNNNNNNNNNN BN&BNNNNNNNNNNNNNNNN(CNNNNNNNNNNNNNNNNN <,88> @!!!4A%quotes?IM=quotes&symbol=hd&type=Quote DOLhttp://quotes.freerealtime.com/dl/frt/quotes?IM=quotes&symbol=LOW&type=Quote:%quotes?IM=quotes&symbol=hd&type=Quotes&#%7 Sheet7 (.@ G  dMbP?_*+%M\\192.168.1.151\SHARP AL-1540CS odXXLetterSCPI&SHARP AL-1540CS odXXLetterH ff**** o****d"ArialdXffff  ffb@222222< Username unknownJobname unknown`@< dSC0C"RXX??U} } } $ } I } $       @     ?A ?B/00000 ?C122222 ?D933333 ?E:;;;;; ?B<44444 ?B=5555 5  ?F=555> 5  ?G 677777 ?' G D D D  ? G D @  ? Z  ? G D   ?Z  ? GD  ?GD'JDD D K LD D KK  K  K  K  K  KL?GDM LD D NNN  N  N  N  N  NO?'GDD D M LD D NNN  N  N  N  N  NO?'GDD D 'P DD D N LD D NN  N  N  N  N  NO?GDM LD D NNN  N  N  N  N  NO?'GDD D MNNNNNNNNO?'GDD D MNNNNNNNNO?GDQRRRRRRRRS?'GDD D ?GD?'GDD D  ?H ?I:,,,,,,,,5tKWWKWK5>@"""%7  ? DD D  AL-1540CS ?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D  ? DD D  AL-1540CS D   ? DD D  AL-1540CS D ?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D?DD D  AL-1540CS D  ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D   ? DD D  AL-1540CS D  Sheet4 (.@ DXn~ NhX  dMbP?_*+%"?? U} Z} WVVV     XXY UO U U U U U U U U U U U U U U U U U U U U U U U U U U U U UW UW UDl !"#$%&'()*+,-./0123456789:;<=>? W U~ W?!W !U"W "U#W #U$W $U%W %U&W &U'W 'U (U )U *U +U ,U -U .U /U 0U 1U,1WD1D1ffffff? 2U 3U 4U 5U 6U 7U 8U 9U :U ;U <U =U >U ?UDl&>@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @U AU BU CU DU EU FU GU HU IU JU KU LU MU NU OU PU QU RU SU TU UU VU WU XU YU ZU [U \U ]U ^U _UD@l`abcdefghijklmnopqrstuvwxyz{|}~ `U aU bZ cZ dZ eU fU gU hU iU jU kZ lZ m[ nZ oZ pZX qZ rZ sZ tZ uZ vZ wZ xZ yZ zZ {Z |Z }Z ~Z ZD@l Z Z Z Z Z Z ZW Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z U U U U U U U U UDJl [ U [ Z U U U U U U U U U U U U U U U U U U U U U U U U U U U UD@l U U U  U  Z  Z  Z  Z U U U U U U U U U U U U U U U U U U U U U U U UD@l U Z Z U U Z Z U U U U U U U U\ U Z  Z! [" Z# U$ U U U U U U U U U\ U%\ UD^l      U U U U U U U U U U U U U U& U' U U U U U( U U U) U* [+ [, U U U U U UD@l !"#$%&'()*+,-./0123456789:;<=>? U !U "U #U $U %U &U 'U (U )U *U +U ,U -U .U /U 0U 1U 2U 3U 4U 5U 6U 7U 8U 9U :U- ;U. <U. =U. >U. ?U.D@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @U. AU/ BU0 CU1 DU1 EU1 FU1 GU1 HU1 IU2J\ JU KU LU MU NU OU PU QU RU SU TU UU VU WU XU YU ZU3 [U4 \U5 ]U6 ^U7 _U8DJl`abcdefghijklmnopqrstuvwxyz{|}~ `U9 aU: bU; cU< dU= eU> fU? gU@ hUA iUB jUC kUD lUE mU nU oU pU qU rU sU tU uU vU wU xU yU zU {U |U }U ~U UD@l U U U U U U U U U U U U U U U U$ ,>@%7 Sheet5 ThisWorkbook"__SRP_14l__SRP