Home Depot Inc (NYSE:HD) Earnings Model
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
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
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
About Gutenberg ResearchWe 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 ProgramOur 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
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.
|
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.
|