Hello fellow Fools,

Over the past week i completed several othere RMRanker spreadsheets.

this one is for Cisco.


                                The Motley Fool's Rule Maker Ranker
                                Version 3 -- Updated June 2000

                                               Hey Fool, start here!      (point your mouse right HERE)

                                Continue Here for Instructions

                                                                                 (Please read all three of these competitor comments.)
Financial AnalysiCompany Being Evaluated                          Competitor #1   Competitor #2  Competitor #3

                      Cisco                                          Lucent          Nortel         Juniper
                 Current Period Year-ago PeriodYear-over-Year    Current Period  Current Period Current Period
                    29-Jul-00      31-Jul-99       Growth          12/31/2000      12/31/2000     12/31/2000
Income Statement
  Sales                  18,928         12,173      55.5%                 33,813         30,275            674
  Cost of Goods S         6,746          4,259      58.4%                 19,539         17,103            203
  Net Income              2,668          2,023      31.9%                  1,219         (3,470)           148
  Shares Outstand         7,438          7,062      5.3%

Balance Sheet
  Cash & Equivale         5,525          2,102     162.8%                  1,467          1,644            563
  Current Assets         11,110          4,761     133.4%                 21,490         16,530          1,349
  Short-term Debt             0              0     No Debt                 3,483            760              0
  Current Liabili         5,196          3,038      71.0%                 10,877          9,058            216
  Long-term Debt              0              0     No Debt                 3,076          1,178          1,157

Cash Flow Statement
  Operating Cash          6,141          4,325      42.0%                    304             40            269
  Capital Expendi         1,086            602      80.4%                  2,701          1,949             75
                                                                                1              1              1
Margins & Ratios . . .                                                                                         Competitors' Average
  Gross Margins            64.4%          65.0%     -0.7                    42.2%          43.5%          69.9%     51.9%
  Net Margins              14.1%          16.6%     -2.5                     3.6%         -11.5%          22.0%      4.7%
  Cash-to-Debt          No Debt!       No Debt!   No Debt!                   0.22           0.85           0.49      0.38
  Net Cash                5525.0         2102.0    162.8%                 -5092.0         -294.0         -594.0   -1993.3
  Fool Flow Ratio           1.07           0.88     22.8%                    2.71           1.79           3.64      2.71
  Cash King Margi          26.7%          30.6%     -3.9                    -7.1%          -6.3%          28.8%      5.1%


                  Continue Here

Ranking Rule Makers

1) Brand          Points (0-1)                                  3) Financial Dire Points (0-3)
Familiarity                    1                                Sales Growth                   3
Openness                       1                                Gross Margins                  2
Optimism                       1                                Net Margins                    1
Legitimacy                     1                                Shares Outstandin              1
Inevitability                  1                                Cash-to-Debt                   3
Solitariness                   1                                Fool Flow Ratio                0
Humor                          1                                Expansion Potenti              3
  Subtotal                     7                                  Subtotal                    13

2) Financial Loca Points (0-2)                                  4) Monopoly Statu Points (0-4)
Mass Market Habit              1                                Gross Margins                  4
Gross Margins                  2                                Net Margins                    4
Net Margins                    2                                Net Cash                       4
Cash-to-Debt                   2                                Fool Flow Ratio                4
Fool Flow Ratio                1                                Convenience                    4
Your Interest                  2                                  Subtotal                    20
  Subtotal                    10
                                                                5) Your  Enjoymen              1

                   Total Score               51   Top Tier!

                 Finished?  Don't forget to save!

                 Want to modify this sheet?


Donald Hoang