Skip to main content
Message Font: Serif | Sans-Serif
 
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

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.