Skip to main content
Message Font: Serif | Sans-Serif
 
No. of Recommendations: 3
Hello everybody,

This is the first time i have completed a Rule Maker Ranker
Spreadsheet. Would someone care to look this over and tell
me if i did this right?


Financial AnalysiCompany Being Evaluated                          Competitor #1   Competitor #2  Competitor #3

                 Johnson & Johnson                                    Merck          Pfizer     Procter & Gamble
                 Current Period Year-ago PeriodYear-over-Year    Current Period  Current Period Current Period
                      2000           1999          Growth             2000            2000           2000
Income Statement
  Sales                  29,139         27,471      6.1%                  40,363         29,574         39,595
  Cost of Goods S         8,861          8,442      5.0%                  22,444          4,907         21,469
  Net Income              4,800          4,167      15.2%                  6,822          3,726          3,618
  Shares Outstand         1,417          1,418      -0.1%

Balance Sheet
  Cash & Equivale         5,744          3,879      48.1%                  4,255          6,863          3,556
  Current Assets         15,450         13,200      17.0%                 13,353         17,187         12,876
  Short-term Debt         1,479          1,806     -18.1%                  3,319          4,289          4,279
  Current Liabili         7,140          7,454      -4.2%                  9,710         11,981         11,059
  Long-term Debt          2,037          2,450     -16.9%                  3,601          1,123         11,782

Cash Flow Statement
  Operating Cash          6,563          5,760      13.9%                  7,687          6,195          5,435
  Capital Expendi         1,714          1,999     -14.3%                  2,728          2,191          2,733
                                                                                1              1              1
Margins & Ratios . . .                                                                                         Competitors' Average
  Gross Margins            69.6%          69.3%      0.3                    44.4%          83.4%          45.8%     57.9%
  Net Margins              16.5%          15.2%      1.3                    16.9%          12.6%           9.1%     12.9%
  Cash-to-Debt              1.63           0.91     79.2%                    0.61           1.27           0.22      0.52
  Net Cash                2228.0         -377.0      N/A                  -2665.4         1451.0       -12505.0   -4573.1
  Fool Flow Ratio           1.71           1.65     3.9%                     1.42           1.34           1.37      1.38
  Cash King Margi          16.6%          13.7%      3.0                    12.3%          13.5%           6.8%     10.9%


                  Continue Here 

Ranking Rule Makers

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

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

                   Total Score               44  Second Tier

Thanks,

Donald Hoang aka ddph81
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.