No. of Recommendations: 0
Just for the fun of it I ran the second quarter
numbers on Home Depot. Please note --
this spreadsheet will be outdated in a couple of days (8/17),
when Home Depot posts their third quarter results.
Even so, I was surprised that
they've only come up one point in six months.
It appears that they are paying for all that expansion
with credit cards. Even so, my brother
lives there, and I can't ever find a parking place. I'll repost in a few days
with updates...
Financial AnalysiCompany Being Evaluated Competitor #1 Competitor #2 Competitor #3
Home Depot Lowes <Fill in Name> <Fill in Name>
Current Period Year-ago PeriodYear-over-Year Current Period Current Period Current Period
05/02/1999 05/03/1998 Growth 04/30/1999 <Date> <Date>
Income Statement . . .
Sales 8,952,000 7,123,000 25.7% 3,771,919
Cost of Goods S 6,386,000 5,155,000 23.9% 2,764,829
Net Income 489,000 337,000 45.1% 124,958
Shares Outstand 1,558,000 1,539,000 1.2%
Balance Sheet . . .
Cash & Equivale 604,000 579,000 4.3% 1,065,620
Current Assets 6,211,000 5,221,000 19.0% 4,151,562
Short-term Debt 8,000 5,000 60.0% 224,655
Current Liabili 4,216,000 3,393,000 24.3% 2,598,707
Long-term Debt 1,319,000 1,313,000 0.5% 1,722,316
1 0 0Competitors
Margins & Ratios . . .
Gross Margins 28.7% 27.6% 1.0 26.7% 26.7%
Net Margins 5.5% 4.7% 0.7 3.3% 3.3%
Cash-to-Debt 0.46 0.44 3.6% 0.55 0.55
Net Cash -723000.0 -739000.0 N/A -881351.0 -881351.0
Fool Flow Ratio 1.33 1.37 -2.7% 1.30 1.30
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 2
Gross Margins 0 Net Margins 2
Net Margins 0 Net Cash 0
Cash-to-Debt 0 Fool Flow Ratio 0
Fool Flow Ratio 0 Convenience 4
Your Interest 1 Subtotal 8
Subtotal 3
5) Your Enjoymen 1
Total Score 36 Third Tier
