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

Author: Manav Sharma, Published: February 23, 2020 2:18pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​The Key Drivers of the 4Q2019 Home Depot Earnings model incorporates 2019 Holiday shopping numbers, the rebounding of copper and lumber prices, and the de-escalation of the trade war. Strong holiday shopping results this past year as well as improvements in Home Depot’s online store and BOPIS system, which helped deliver a strong comparable-store sale for 4Q2019. Home Depot’s earnings felt the effects of lumber and copper price deflation throughout 3Q2019. The lumber and copper markets in 4Q2019 are back on track and are rising steadily, which should help increase Home Depot’s comparable-store sales as well as their gross margin. The de-escalation of trade wars and the reduction of tariffs will allow Home Depot’s gross margin to grow this quarter as well. As housing numbers continue to improve and homeowners continue to look to remodel their homes, there seems to be a positive outlook for Home Depot coming into 2020. Overall the model has a bullish outlook on Home Depot with projections for comparable-store sales at 4.875% and gross margin at 33.86% for 4Q2019 and comparable-store sales at 3.5% for FY2019.

Home Depot Earnings Model (Manav Sharma).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.