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

Author: Vandan Patel, Published: February 17, 2020 9:47pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​In Q3, Home Depot beat earnings by $0.01 ($2.53 vs. $2.52 expected). Yet, they missed on revenue ($27.22 billion vs. 27.33 billion expected) and comparable store sales (3.6% vs. 4.7% expected). This resulted in shares dipping 5% after the report went public. 

Home Depot reaffirmed its guidance fiscal 2019, 52-week year compared fiscal 2018, a 53-week year, as follows total sales growth of approximately 1.8% and comparable sales growth for the comparable 52-week period of approximately 3.5% and diluted earnings-per-share growth of approximately 3.1% from fiscal 2018 to $10.03.

In addition, Home Depot is providing a preliminary fiscal 2020 outlook projecting total sales growth of approximately 3.5 to 4.0%, comparable sales growth of approximately 3.5 to 4.0%, operating margin of approximately 14.0%, and return on invested capital of approximately 45.0%.

The market this past year has soared as consumer spending has been strong and stable. I believe this will factor into a Q4 rebound from a poor Q3 performance in comparable store sales and revenue. Home Depot’s long-term strategic investment initiatives are being seen as sales from digital expansion increased online sales by 22% from a year earlier. I believe this will assist strong results in Q4 results as revenue from Black Friday and Cyber Monday sales will be strong. As business get more digital, Home Depot is taking the right steps by investing in their online platforms. I believe these results will compound over time and gain momentum for long term growth. The focus on the customer and enhancing customer experience is a long-term strategic move to keep Home Depot competitive and retain growth.

I believe comparable store sales is one of the most important metrics to perceive a company’s success. In Q3 comp sales growth was negatively affected because of lumber price deflation which drove numbers down by 0.65% or $175 million. Fortunately, lumber prices have been on the uptrend during 4Q, which I believe will play a big role for driving comparable sales growth. On top of this, I believe they will adapt to tariff changes, keep costs low, and manage operating costs effectively resulting in a strong performance. 

Home Depot Earnings Model (Vandan Patel).xlsx
File Size: 120 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.