Gutenberg Research
  • Home
  • Models
  • Education
    • Cooperative Education Program >
      • Enroll Today >
        • Program Enrollment (Virtual)
        • Program Enrollment (Bootcamp - Boston)
        • Program Enrollment (Bootcamp - New York)
      • Training Hub (Winter'22-'23) >
        • Meetings >
          • Kick-off Call/Orientation (Winter'22-'23)
          • Meeting 1: Building the Model (Winter'22-'23)
          • Meeting 2: Entering Your Forecast Into The Model (Winter'22-'23)
          • Meeting 3: Target Valuation (Winter'22-'23)
          • Meeting 4: Live Starbucks Release (Winter'22-'23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Winter'22-'23)
        • Classes >
          • Class 1 - Introduction to Financial Modeling (Winter'22-'23)
          • Class 2 - Building the Income Statement (Winter'22-'23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Winter'22-'23)
          • Class 4 - Model Calibration & Forecasting (Winter'22-'23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Winter'22-'23)
          • Class 6 - Discounted Cash Flow Valuation (Winter'22-'23)
          • Class 7 - Market Multiple-Based Valuation (Winter'22-'23)
          • Class 8 - How to Use Your Earnings Model (Winter'22-'23)
    • Books >
      • Procrastinator's Guide - SBUX >
        • Templates - SBUX
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Home Depot Inc Earnings Model (McCabe)​

Author: James McCabe, Published: February 17, 2020 9:31pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​Many factors contribute to the Home Depot Q4 2019 earnings estimates, especially the constant commodity growth which includes copper and lumber and the holiday sales. My belief is that starting in the Q4 2019 comparable sales will contribute to a bullish trend into and continuing on in 2020. Comparable store sales will rise in Q4 not only due to the continued growth in commodities but the the holiday sales season. The sales over the past 5 years have only increased and have shown to have a significant impact on retail stores such as Home Depot. Although I believe these positive effects will be better replicated in the 2020 Q1, they will still be up from Q3 considering copper and lumber themselves are selling at a higher price than initially anticipated for this time. It is also important to recognize the upcoming elections which can limit the risk of tariff costs which can lead to a bullish effect on comp sales once again, showing higher margins on sales of commodities.

​On the other hand and something that can bring back the comparable store sales is the IT unwinding. Although it is not of major concern, anything as involved as IT, an organizational tool that strong, can take more than a quarter to get fully functioning. So, due to this problem that I see continuing on in Q4, comp store sales won't be as drastic. Some Statistics:
  • Lumber: OCT. 1st = 361.7 DEC 31st = 426.2
  • Copper: OCT 1st = 2.56 DEC 31st = 2.79
  • Black Friday (thebalance.com): 2013 - $767.24(spent per shopper) $584.1 billion (total spent) (Increase of) 2.9% 2018 - (per shopper) $1,007.24 $717.5 billion (total Spent) 4.3% (increase of)

Home Depot Earnings Model (James McCabe).xlsx
File Size: 47 kb
File Type: xlsx
Download File

About the Model Developer

​Disclosure of Potential Conflicts of Interest: ​The author of this article/model has no financial investment or other conflict of interest related to the subject company or other companies discussed. Any views made or implied in the content represent the author’s opinions.
Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.