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

Hunter Frayne's Contributor Page


Company: Home Depot Inc (NYSE:HD)
Last Updated: February 23, 2020 
(Prior to the fiscal 4Q2019 earnings release on February 25, 2020).​
View: Bullish
Model description:
The main reasons behind my assumptions of the home depot model are comp-store sales, operating expenses and cost of goods sold. Comp-store sales plays a more pertinent factor in my model, as estimates of operating expenses and cost of goods sold are not expected to change drastically. In the 3Q earnings call Home Depot appealed to its strong expense control and continued productivity in their business model as reasons for a strong operating expense performance. I believe that any benefit accrued from those factors will likely be eroded by the costs of changing their legacy IT system, as it is very expensive as workflow, dependency and ROI issues present themselves during this change....click here to continue reading
Home Depot Earnings Model (Hunter Frayne).xlsx
File Size: 126 kb
File Type: xlsx
Download File


Picture
Hunter Frayne is an undergraduate student at the University of Connecticut studying philosophy and economics. At UConn, Hunter is involved in finance society, pre-law society, and club hockey. Professionally he has had a variety of internships including at the Attorney General's Office, Pitch Gauge, The Hanover Insurance Group, IBM and now Gutenburg Research. In his free time when Hunter is not studying the market and researching securities he enjoys working out, hiking, and spending time with his family.
​
​​Disclosure: ​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.