Investor’s Craft

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

Previos Close

$283

Intrinsic Value

$196.13

Potential        

-31%

STOCK VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate, %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Revenue / Adjusted assets

Based on fiscal year data as of 2020-01-31 and quarterly data as of 2020-07-31.

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.

Premium membership allows you to recalculate the intrinsic value for different input parameters.

MEMBERSHIP

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045

INCOME STATEMENT

Revenue growth rate, %NaN
Revenue, $NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $mNaN
Operating income, $mNaN
EBITDA, $mNaN
Interest expense (income), $mNaN
Earnings before tax, $mNaN
Tax expense, $mNaN
Net income, $mNaN

BALANCE SHEET

Cash and short-term investments, $mNaN
Total assets, $mNaN
Adjusted assets (=assets-cash), $mNaN
Average production assets, $mNaN
Working capital, $mNaN
Total debt, $mNaN
Total liabilities, $mNaN
Total equity, $mNaN
Debt-to-equity ratioNaN
Adjusted equity ratioNaN

CASH FLOW

Net income, $mNaN
Depreciation, amort., depletion, $mNaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $mNaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Cash from investing activities, $mNaN
Free cash flow, $mNaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow (-), $mNaN
Cash flow adjustment, $mNaN
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN

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 provide installation, home maintenance, and professional service programs to do-it-yourself and professional customers. The company also offers installation programs that include flooring, cabinets and cabinet makeovers, countertops, furnaces and central air systems, and windows; and professional installation in various categories sold through its stores and in-home sales programs, as well as acts as a general contractor to provide installation services to its do-it-for-me customers through third-party installers. In addition, it provides tool and equipment rental services. The company primarily serves home owners; and professional renovators/remodelers, general contractors, handymen, property managers, building service contractors, and specialty tradesmen, such as electricians, plumbers, and painters. It also sells its products online. As of August 4, 2020, the company operated 2,293 retail stores in 50 states, the District of Columbia, Puerto Rico, the U.S. Virgin Islands, Guam, 10 Canadian provinces, and Mexico. The Home Depot, Inc. was founded in 1978 and is based in Atlanta, Georgia.