Here is the last RmRanker Spreadsheet and it's for Walmart:


                                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

                     Walmart                                         Costco           Kmart         Target
                 Current Period Year-ago PeriodYear-over-Year    Current Period  Current Period Current Period
                   01/31/2001     01/31/1999       Growth          08/31/2000      01/31/2001     01/31/2001
Income Statement
  Sales                 191,329        165,013      15.9%                 32,164         37,028         36,903
  Cost of Goods S       150,255        129,664      15.9%                 28,067         28,881         25,295
  Net Income              6,295          5,377      17.1%                    631           (244)         1,264
  Shares Outstand         4,470          4,454      0.4%

Balance Sheet
  Cash & Equivale         2,054          1,856      10.7%                    525            401            356
  Current Assets         26,555         24,356      9.0%                   3,470          7,624          7,304
  Short-term Debt         6,661          5,408      23.2%                     10             68            857
  Current Liabili        28,949         25,803      12.2%                  3,404          3,799          6,301
  Long-term Debt         12,501         13,672      -8.6%                    790          3,027          5,634

Cash Flow Statement
  Operating Cash          9,604          8,194      17.2%                  1,070          1,039          1,905
  Capital Expendi         8,042          6,183      30.1%                  1,228          1,087          2,528
                                                                                1              1              1
Margins & Ratios . . .                                                                                         Competitors' Average
  Gross Margins            21.5%          21.4%      0.0                    12.7%          22.0%          31.5%     22.1%
  Net Margins               3.3%           3.3%      0.0                     2.0%          -0.7%           3.4%      1.6%
  Cash-to-Debt              0.11           0.10     10.2%                    0.66           0.13           0.05      0.12
  Net Cash              -17108.0       -17224.0      N/A                   -275.0        -2694.0        -6135.0   -3034.7
  Fool Flow Ratio           1.10           1.10     -0.4%                    0.87           1.94           1.28      1.36
  Cash King Margi           0.8%           1.2%     -0.4                    -0.5%          -0.1%          -1.7%     -0.8%


                  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                  3
Optimism                       1                                Net Margins                    3
Legitimacy                     1                                Shares Outstandin              2
Inevitability                  1                                Cash-to-Debt                   2
Solitariness                   1                                Fool Flow Ratio                1
Humor                          1                                Expansion Potenti              3
  Subtotal                     7                                  Subtotal                    17

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

                   Total Score               38  Third Tier

                 Finished?  Don't forget to save!

                 Want to modify this sheet?

Donald Hoang