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 (NYSE:HD) Earnings Model


Picture
Picture
Model Description: This model uses comparable store sales, store count estimates, and ratio analysis to forecast earnings. The model is calibrated to meet management's guidance and consensus estimates as a "base-case" scenario. You can enter your own assumptions into the blue cells to form your own earnings forecast.​
Basic Version: Includes 4 quarters of forecasts, Income Statement and Segment details.
Premium Version: Includes ~5 years of forecasts, Income Statement, Segment details, Balance Sheet, Cash Flow, and target share valuation.​​​
Model Developer: 
Paul DeAngelis. Paul was a member of our University of Connecticut Financial Modeling Intern Team. 
Model last updated by: John Moschella, CFA, CPA
Subscribe for HD Model Updates

Home Depot Models From Our Community


Contributor: Fady Antoon​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.86B and $2.18 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.32.
Home Depot Earnings Model (Fady Antoon).xlsx
File Size: 133 kb
File Type: xlsx
Download File

Model Description

Contributor: Jay Nguyen
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.90B and $2.20 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.50.
Home Depot Earnings Model (Jay Nguyen).xlsx
File Size: 115 kb
File Type: xlsx
Download File

Model Description

Contributor: Rahul Rana​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.95B and $2.12 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.43.
Home Depot Earnings Model (Rahul Rana).xlsx
File Size: 131 kb
File Type: xlsx
Download File

Model Description

Contributor: Kaustubh Tiwari​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.00B and $2.33 per share.
Next twelve month revenue & EPS forecast: $112.3B and $10.55.
Home Depot Earnings Model (Kaustubh Tiwari).xlsx
File Size: 127 kb
File Type: xlsx
Download File

Model Description

Contributor: Jordan Wang​
Date of publication: February 23, 2020
View on Home Depot: Neutral
F4Q2019 revenue & EPS forecast: $25.76B and $1.89 per share.
Next twelve month revenue & EPS forecast: $113.6B and $10.18.
Home Depot Earnings Model (Jordan Wang).xlsx
File Size: 127 kb
File Type: xlsx
Download File

Model Description

Contributor: Faiz Jumma​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.89B and $2.13 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.43.
Home Depot Earnings Model (Faiz Jumma).xlsx
File Size: 131 kb
File Type: xlsx
Download File

Model Description

Contributor: Hunter Frayne
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.89B and $2.52 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.82.
Home Depot Earnings Model (Hunter Frayne).xlsx
File Size: 126 kb
File Type: xlsx
Download File

Model Description

Contributor: Manav Sharma​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.90B and $2.10 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.40.
Home Depot Earnings Model (Manav Sharma).xlsx
File Size: 127 kb
File Type: xlsx
Download File

Model Description

Contributor: Sahyaja Munamala & Rhea Jhamb​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.92B and $2.13 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.43.
Home Depot Earnings Model (Munamala & Jhamb).xlsx
File Size: 120 kb
File Type: xlsx
Download File

Model Description

Contributor: Blake Reino​
Date of publication: February 23, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.67B and $2.14 per share.
Next twelve month revenue & EPS forecast: $113.6B and $10.39.
Home Depot Earnings Model (Blake Reino).xlsx
File Size: 131 kb
File Type: xlsx
Download File

Model Description

Contributor: Venkat Anna​
Date of publication: February 24, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.86B and $2.20 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.51.
Home Depot Earnings Model (Venkat Anna).xlsx
File Size: 127 kb
File Type: xlsx
Download File

Model Description

Contributor: James McCabe​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.90B and $2.11 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.58.
Home Depot Earnings Model (James McCabe).xlsx
File Size: 47 kb
File Type: xlsx
Download File

Model Description

Contributor: Vandan Patel​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.95B and $2.31 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.61.
Home Depot Earnings Model (Vandan Patel).xlsx
File Size: 120 kb
File Type: xlsx
Download File

Model Description

Contributor: Rayhan Murad​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $26.04B and $2.21 per share.
Next twelve month revenue & EPS forecast: $114.0B and $10.51.
Home Depot Earnings Model (Rayhan Murad).xlsx
File Size: 121 kb
File Type: xlsx
Download File

Model Description

Contributor: Jack Muratori​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.95B and $2.21 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.51.
Home Depot Earnings Model (Jack Muratori).xlsx
File Size: 120 kb
File Type: xlsx
Download File

Model Description

Contributor: Shivam Khandelwal​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $26.00B and $2.19 per share.
Next twelve month revenue & EPS forecast: $114.0B and $10.50.
Home Depot Earnings Model (Shivam Khandelwal).xlsx
File Size: 120 kb
File Type: xlsx
Download File

Model Description

Contributor: Steven Hromin​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.80B and $2.19 per share.
Next twelve month revenue & EPS forecast: $113.6B and $10.88.
Home Depot Earnings Model (Steven Hromin).xlsx
File Size: 130 kb
File Type: xlsx
Download File

Model Description

Contributor: Rithvik Reddy​
Date of publication: February 17, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.92B and $2.26 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.56.
Home Depot Earnings Model (Rithvik Reddy).xlsx
File Size: 120 kb
File Type: xlsx
Download File

Model Description

Contributor: Matthew Rossi​
Date of publication: January 26, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.90B and $2.11 per share.
Next twelve month revenue & EPS forecast: $113.9B and $10.58.
Home Depot Earnings Model (Matthew Rossi).xlsx
File Size: 123 kb
File Type: xlsx
Download File

Model Description

Contributor: Hrishikesh (Hrishi) Bopalkar​
Date of publication: January 26, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.88B and $2.11 per share.
Next twelve month revenue & EPS forecast: $113.8B and $10.41.
Home Depot Earnings Model (Hrishikesh Bopalkar).xlsx
File Size: 123 kb
File Type: xlsx
Download File

Model Description

Contributor: Gene Lin​
Date of publication: January 26, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $26.00B and $2.19 per share.
Next twelve month revenue & EPS forecast: $114.0B and $10.50.
Home Depot Earnings Model (Gene Lin).xlsx
File Size: 123 kb
File Type: xlsx
Download File

Model Description

Contributor: Adit Jain​
Date of publication: January 26, 2020
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.69B and $2.35 per share.
Next twelve month revenue & EPS forecast: $121.4B and $11.71
Home Depot Earnings Model (Adit Jain).xlsx
File Size: 123 kb
File Type: xlsx
Download File

Model Description

Contributor: Anik Subramanian​
Date of publication: February 2, 2020 ​
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.81B and $2.07 per share.
Next twelve month revenue & EPS forecast: $113.7B and $10.38
Home Depot Earnings Model (Anik Subramanian).xlsx
File Size: 123 kb
File Type: xlsx
Download File

Model Description

Contributor: Janushkaa Dharmesh​
Date of publication: February 2, 2020 ​
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $29.34B and $2.09 per share.
Next twelve month revenue & EPS forecast: $117.3B and $10.39
Home Depot Earnings Model (Janushkaa Dharmesh).xlsx
File Size: 124 kb
File Type: xlsx
Download File

Model Description

Contributor: Al McPhee​
Date of publication: February 2, 2020 ​
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.87B and $2.16 per share.
Next twelve month revenue & EPS forecast: $114.0B and $10.48
Home Depot Earnings Model (Al Mcphee).xlsx
File Size: 124 kb
File Type: xlsx
Download File

Model Description

Contributor: Shrujay Rompicherla
Date of publication: February 2, 2020 ​
View on Home Depot: Bullish
F4Q2019 revenue & EPS forecast: $25.65B and $2.03 per share.
Next twelve month revenue & EPS forecast: $113.6B and $10.33
Home Depot Earnings Model (Shrujay Rompicherla).xlsx
File Size: 56 kb
File Type: xlsx
Download File

Model Description

About Gutenberg Research

​​We are an interactive earnings modeling community, driving the evolution of equity research. Our mission is to make dynamic earnings models, available to everyone. We are currently building an inventory of models covering companies...continue reading 

Modeling Training Program

Our Certificate in Financial Modeling Program provides an easy to follow, step-by-step approach to financial modeling training.  In this program we build a financial model from the ground up..continue reading

New to Earnings Modeling? Check Out Our Training Program or Textbook

Certificate in Financial Modeling Program
In this program we build a financial model from the ground up, starting with a blank spreadsheet, and ending with a comprehensive set of interrelated financial statements and share valuation estimates. There are three primary components to the program, all designed to add various elements to your training: 1) the written curriculum, 2) demonstration videos, and 3) supporting spreadsheets.  At the completion of this training program you will receive a Certificate in Financial Modeling from The Equity Research Institute at Gutenberg Research. In order to qualify for the Certificate, you must pass our financial modeling exam which covers the topics in the program curriculum, and submit an earnings model based on the methods described in the program curriculum.
Click for Program Details

Financial Modeling for Equity Research
This book demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street equity research analysts. The accompanying spreadsheets demonstrate the key concepts and can be used as templates to create an earnings model for nearly any company. Readers without prior financial analysis experience will gain a fundamental understanding of exactly what modeling entails, and will learn how to create a basic form of an earnings model. Advanced readers will be introduced to more complex topics such as linking the financial statements, future period calibration, and incorporating macroeconomic variables into discounted valuation analysis through the equity risk premium and application of the capital asset pricing model.
Click for Paperback
Click for eBook
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.