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

Author: Steven Hromin, Published: February 17, 2020 10:10pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​After scraping by analyst expectations in Q3 2019, Home Depot appears poised to exceed estimates in this upcoming Q4 2019 earnings. My earnings model shows EPS coming in at $2.19, solidly above current estimates of $2.11. Revenue is estimated to come in at $25.79B, driven by the opening of two new stores as well as Comparable Same Store Sales (SSS) of 4.5%. Gross Margins hover around expected values, dipping just below management guidance of 34% as product mix adversely impacts margins. Operating Margin dips to a 4-quarter low of 13.5% for similar reasons, as expense execution is challenged by SG&A deleveraging and lumber prices failing to favor the company. Highlights of the model results include:
  • Revenue of $25.798B.
  • Gross Profit of $8.72B.
  • Net Income of $2.378B.
  • Store Count as of February 3, 2020 of 2,292.
  • Fiscal Year 2019 SSS of 3.4%.

Recently, management provided an initial fiscal 2020 forecast as follows:
  • Sales growth between 3.5% - 4%.
  • Same Store Sales between 3.5% - 4%.
  • Operating Margin of approximately 14.0 percent.
  • Gross Margin hovering around 34% on a full-year basis.

Given the aftermath of the last quarter's results, I believe sentiment on HD is unfairly negative. If the company reports results similar to those laid out here, I further believe optimism for future performance could push the stock up materially in the days following the February 25, 2020 earnings release. After a deep dive into Home Depot's business model, mission statement, competitive advantage, and potential earnings growth, I believe management can continue to drive success and create value for shareholders.

Home Depot Earnings Model (Steven Hromin).xlsx
File Size: 130 kb
File Type: xlsx
Download File


​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.