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