Gutenberg Research
  • Home
  • Models
    • Modeling Approach
  • Education
    • Cooperative Education Program
    • Book >
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
    • Intern Program >
      • New Intern Sign-up
      • Intern Training (Winter 2020 Round)
      • Intern Program Exam
      • Intern Bio Form
      • Intern Model Submission
  • 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 entertainment 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 2021. All Rights Reserved.