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 (Wang)​

Author: Jordan Wang, Published: February 23, 2020 1:54pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​In my opinion, the Home Depot’s key value drivers which are used to forecast its earnings model are how Home Depot and the whole retail sector has done in this holiday shopping season, how the prices of lumber and copper behave this 4th quarter, and how the intensity of the trade war between China and the U.S affects the tariffs. At the beginning of 2019, Home Depot strategically invested in improving the customer experience by unifying online and offline operations. In the earnings call in December, the company’s management stated that there are both long-term and short-term investments, so the results could be taking more time to be capitalized. Personally, I decreased the SG&A rate from 18.4% to 18.3% because I believe that management will be able to continue the expense control execution. As Us and China signed a deal to ease trade war in January, the effect of international tariffs will less adversely impact the result. Moreover, as lumber and copper deflation was cited by management as a key reason for falling comp store sales, their significant increase in prices from the last quarter would contribute positively to 4th quarter’s comp store sales and gross margin. Therefore, I increased the gross margin from 33.8% to 34.1%. Last but not least, I project comparable store sales increases in 4th quarter to 4.9%, which is a bit less than the increase in percentage of last year’s 4th quarter due to a shorten holiday shopping season. Overall, I have a bullish view on 2019’s 4th quarter and 2020 projection.

Home Depot Earnings Model (Jordan Wang).xlsx
File Size: 127 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.