No. of Recommendations: 4
Greetings,
Now that I have current numbers for some of Intel's
competitors, I have re-done the Rule Maker Ranking
Spreadsheet for Intel.
It is basically the same as what I posted last week,
though there is a 2 point difference, due to the fact
that AMD's Fool Flow Ratio is just a bit higher than
Intel's.
This still leaves Intel with a 52 ranking.
Patrick
The Motley Fool's Rule Maker Ranker
Version 2.0 -- Last Updated April 19, 1999
Hey Fool, start here! (drop your mouse on this to read)
Continue Here for Instructions
Financial AnalysiCompany Being Evaluated Competitor #1 Competitor #2 Competitor #3
Intel AMD Motorola <Fill in Name>
Current PeriodYear-ago PerioYear-over-Year Current Period Current PeriodCurrent Period
Dec-99 Dec-98 Growth Dec-99 Dec-99 <Date>
Income Statement . . .
Sales 8,212 7,614 7.9% 969 8,498
Cost of Goods S 3,176 3,160 0.5% 582 5,606
Net Income 2,108 2,064 2.1% 65 349
Shares Outstand 3,336 3,325 0.3%
Balance Sheet . . .
Cash & Equivale 11,788 7,626 54.6% 597 3,345
Current Assets 17,819 13,475 32.2% 1,410 16,503
Short-term Debt 230 159 44.7% 0 2,504
Current Liabili 7,099 5,804 22.3% 911 12,416
Long-term Debt 955 702 36.0% 1,427 3,089
1 1 0Competitor
Margins & Ratios . . .
Gross Margins 61.3% 58.5% 2.8 39.9% 34.0% 37.0%
Net Margins 25.7% 27.1% -1.4 6.7% 4.1% 5.4%
Cash-to-Debt 9.95 8.86 12.3% 0.42 0.60 0.56
Net Cash 10603.0 6765.0 56.7% -830.0 -2248.0 -1539.0
Fool Flow Ratio 0.88 1.04 -15.3% 0.89 1.33 1.11
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 1
Legitimacy 1 Shares Outstandin 2
Inevitability 1 Cash-to-Debt 2
Solitariness 1 Fool Flow Ratio 3
Humor 1 Expansion Potenti 3
Subtotal 7 Subtotal 15
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 2
Fool Flow Ratio 2 Convenience 4
Your Interest 2 Subtotal 18
Subtotal 11
5) Your Enjoymen 1
Total Score 52 TopTier!
Finished? Don't forget to save!
Want to modify this sheet?
About the Rule Maker Portfolio
The Motley Fool