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

Author: Gene Lin, Published: January 26, 2020 4:25pm, Category: Earnings Preview (Prior to the Fiscal 4Q2019 earnings release)

Summary of Model: ​Home Depot's key value drivers of this model include the 2019 holiday shopping season and increasing commodity prices. Home Depot has modernized key technological infrastructure as well as introduce new initiatives (BOPIS lockers, etc.) to improve the customer service experience. This allowed the company to capitalize on trends seen during the recent holiday shopping season and is part of why I have a bullish view on 2019Q4 and 2020 projections. I project comparable store sales increases in 2019Q4 to 5.3% due to a great holiday shopping season. Black Friday, Cyber Monday, and Super Saturday (which had a record $34.4bn run) all performed due to a solid economy, a shortened holiday season (Thanksgiving was six days late as compared to 2018), and BOPIS and online store sale services (both of which, Home Depot provides). Furthermore, lumber and copper prices rose during 2019Q4 to pre-2019Q3 levels. As lumber and copper deflation was cited by management as a key reason for falling comp store sales, an increase in 2019Q4 should result in the reverse. The result is a 2019FY comp store sales of 3.6%, which beat management's guidance by 0.1%. For gross margin, 2019Q4 gross margin is up to 34% due to increased lumber and copper prices as well as a stable (rather than escalating) trade war.

Home Depot Earnings Model (Gene Lin).xlsx
File Size: 123 kb
File Type: xlsx
Download File

About the Model Developer

​Disclosure of Potential Conflicts of Interest: ​The author was a part time employee of the company during this time period. He witnessed first hand some aspects which are relevant to the model (such as the holiday shopping season).
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.