Skip to main content
Message Font: Serif | Sans-Serif
 
No. of Recommendations: 2
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
Print the post  

Announcements

When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.