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

Author: Jack Muratori, Published: February 17, 2020 9:57pm, Category: Earnings Preview (Prior to Fiscal 4Q2019 earnings)

Summary of Model: ​This model forecasts future revenue based on positive impacts of the implementation of strategic initiatives aimed at improving customer experience, macroeconomic trends, and a recovery in commodity prices in improving comparable store sales. Gross margin projections are based on recent de-escalation of the trade war in stabilizing tariffs, and mitigation of shrink and product mix in increasing expenses.
Model Forecast Description: ​I expect to see consistent growth in Home Depot Inc. during F4Q2019 and fiscal 2020 earnings seasons. In the F3Q2019 earnings call, Home Depot forecasted total sales growth of 1.8% YoY ($110.15B), comparable store sales growth of 3.5% YoY, and diluted EPS growth of 3.1% to $10.03 for FY2019. I expect to see comparable store sales growth on the upper range of management's guidance for FY2019, specifically due to several factors indicating strong fourth quarter sales that will carry into fiscal 2020. A combined influence of continued benefit from strategic initiatives, a recovery from third quarter commodity deflation, and an outlook for a strong housing market in the coming years all point towards an upward trend in comparable store sales. 

Strategic initiatives aiming at improving customer experiences, such as the recent enhancements to Home Depot’s website, have positively affected sales growth. During F3Q2019 the company saw “double-digit online growth,” with more than half of these online orders being picked up in stores with BOPIS lockers. At the same time, comparable transactions increased by 1.8%, and with the implementation of this modified website we will see this growth continue. 

Home Depot also stands to benefit from current macroeconomic trends. Reflected by historically low mortgage rates (down 1.2 pt YoY to 3.7% according to the National Census Bureau), in November the number of homes sold in the U.S. was up 0.5% to 245,223, the median sale price of homes was up 5% YoY, and the most recent data provided by the Federal Reserve showed delinquency rates down 0.33%, all of which indicating a strong housing market. Home builders across the country can expect to benefit from these trends, which I anticipate to result in continued growth of Home Depot’s comparable store sales in supplying these contractors. 

The recent rise in commodity prices, primarily lumber and copper, also foreshadow growth in comparable store sales for Home Depots F4Q2019 and 2020 earnings. According to Trading Economics, lumber prices were down by 1.8% YoY in October, but since then there has been gradual inflation. The most recent data released by Trading Economics shows an increase of almost 26% from third quarter lumber prices, from $359.8 per 1000 board feet in October to $455.1 in the start of February. 

Increased costs arising from tariffs, along with shrink and product mix negatively affected Q3 gross margin. Recent decreases in tariffs and continued mitigation of the impact of these tariffs by Home Depot, combined with strong expense control will limit this decline in gross margin in the upcoming months. 

Overall, this model shows a bullish forecast, with sales growth, comparable store sales growth and diluted EPS growth above managements forecast for 2019 that will carry on into fiscal 2020. 

Home Depot Earnings Model (Jack Muratori).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.