Gutenberg Research
  • Home
  • Education
    • Cooperative Education Program >
      • Virtual (Summer '23) >
        • Training Hub (Summer '23)
        • Meetings (Summer '23) >
          • Kick-off Call/Orientation (Summer '23)
          • Meeting 1: Building the Model (Summer '23)
          • Meeting 2: Entering Your Forecast Into The Model (Summer '23)
          • Meeting 3: Target Valuation (Summer '23)
          • Meeting 4: Live Starbucks Release (Summer '23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Summer '23)
        • Other Links (Summer '23) >
          • Revised Model
          • Model Submission (Summer '23)
          • Co-op Bio Form (Summer '23)
          • About the Exam (Summer '23)
          • Program Exam (Summer '23)
          • Completing the Program (Summer '23)
          • Co-op Program (Summer '23)
        • Classes (Summer '23) >
          • Class 1 - Introduction to Financial Modeling (Summer '23)
          • Class 2 - Building the Income Statement (Summer '23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Summer '23)
          • Class 4 - Model Calibration & Forecasting (Summer '23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Summer '23)
          • Class 6 - Discounted Cash Flow Valuation (Summer '23)
          • Class 7 - Market Multiple-Based Valuation (Summer '23)
          • Class 8 - How to Use Your Earnings Model (Summer '23)
      • Babson Bootcamp (Spring'23) >
        • Training Hub (Babson Spring'23)
        • Meetings (Babson) >
          • Kick-off Call/Orientation (Babson Spring'23)
          • Bootcamp Session (Babson Spring'23)
          • Live FOMC Statement Release (Spring'23)
          • Office Hours (Babson Spring'23)
          • Live Starbucks Release (Spring'23)
          • Lunch Discussion (Babson Spring'23)
        • Other Links (Babson) >
          • Model Submission (Spring'23)
          • Co-op Bio Form (Spring'23)
          • About the Exam
          • Program Exam (Spring'23)
          • Co-op Q&A (Spring'23)
          • Completing the Program
      • Virtual (Winter '22-'23) >
        • Training Hub (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 (Murad)​

Author: Rayhan Murad, Published: February 17, 2020 9:52pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​This model projects future earnings for Home Depot (NYSE: HD). Key drivers in this model include the strength of the 2019 holiday shopping season and a positive online retail presence. Home Depot has begun executing on a series of strategic initiatives that modernize the customer experience (B2B website, etc) that create a unique value proposition for Pro and DIY customers alike. Management’s ability to execute on these initiatives are, in part, why I remain bullish on Home Depot’s performance in Q42019 and FY2020. I project comparable store sales to rise to 5.5% in Q42019, thanks to solid sales growth in the holiday season. Despite a shorter holiday season, a strong macroeconomic climate acted as a significant tailwind for the industry as a whole. Online store spending hit record levels in 2019, and I’m confident in Home Depot’s ability to capture a large portion of that spending. Furthermore, investments in Home Depot’s online retail presence are paying dividends now: online traffic growth was healthy, conversion is up, and online sales growth is up. Initiatives such as in-store pickups have been successful as well, as more than 50% of online orders are picked up in stores and 95% of customers rate their experience 5 out of 5 stars. The result of this is comparable-store sales of 3.6% in FY2019, which is higher than management’s expectation by one point. Increased commodity prices in copper and lumber and a phase one trade deal between the United States and China lend themselves to gross margins of 34% in Q42019.

Home Depot Earnings Model (Rayhan Murad).xlsx
File Size: 121 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.