investorscraft@gmail.com

Investor's Craft

S&P 500 Health CareS&P 500 EnergyS&P 500 Information Tech.S&P 500 Communic. ServicesS&P 500 Consumer Discret.S&P 500 Consumer StaplesS&P 500 IndustrialsS&P 500 Materials
IntroductionThe concept of valuationRevenue and revenue growthVariable costsFixed costsProduction assets

Intrinsic value of The Home Depot, Inc. (HD)

Previous Close$327.07
Intrinsic Value$116.80
Upside potential  -64%
Previous Close
$327.07
Intrinsic Value
$116.80
Potential        
-64%

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh116.8 116.8

The original valuation is based on fiscal year data as of 2022-01-31 and quarterly data as of 2022-10-31.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

Company description

The Home Depot, Inc. operates as a home improvement retailer. It operates The Home Depot stores that sell various building materials, home improvement products, lawn and garden products, and décor products, as well as facilities maintenance, repair, and operations products The company also offers installation services for flooring, cabinets and cabinet makeovers, countertops, furnaces and central air systems, and windows. In addition, it provides tool and equipment rental services. The company primarily serves homeowners; and professional renovators/remodelers, general contractors, maintenance professionals, handymen, property managers, building service contractors, and specialty tradesmen, such as electricians, plumbers, and painters. It also sells its products through websites, including homedepot.com; blinds.com, an online site for custom window coverings; and thecompanystore.com, an online site for textiles and décor products. As of December 31, 2021, the company operated 2,317 stores in the United States. The Home Depot, Inc. was incorporated in 1978 and is based in Atlanta, Georgia.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2022(a)2023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047

INCOME STATEMENT

Revenue growth rate, %14.4NaN
Revenue, $151157NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m128117NaN
Operating income, $m23040NaN
EBITDA, $m25902NaN
Interest expense (income), $mNaN
Earnings before tax, $m21737NaN
Tax expense, $m5304NaN
Net income, $m16433NaN

BALANCE SHEET

Cash and short-term investments, $m2343NaN
Total assets, $m71876NaN
Adjusted assets (=assets-cash), $m69533NaN
Average production assets, $m39956NaN
Working capital, $m362NaN
Total debt, $m46269NaN
Total liabilities, $m73572NaN
Total equity, $m-1696NaN
Debt-to-equity ratio-27.281NaN
Adjusted equity ratio0.004NaN

CASH FLOW

Net income, $m16433NaN
Depreciation, amort., depletion, $m2862NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m16571NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-2566NaN
Free cash flow, $m19137NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m362
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount