investorscraft@gmail.com

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

Previous Close$390.28
Intrinsic Value
Upside potential
Previous Close
$390.28

VALUATION INPUT DATA

This valuation is based on fiscal year data as of 2023-01-31 and quarterly data as of 2023-07-31.

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year(a)2024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048

INCOME STATEMENT

Revenue growth rate, %4.1NaN
Revenue, $157403NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m133364NaN
Operating income, $m24039NaN
EBITDA, $m27014NaN
Interest expense (income), $mNaN
Earnings before tax, $m22477NaN
Tax expense, $m5372NaN
Net income, $m17105NaN

BALANCE SHEET

Cash and short-term investments, $m2757NaN
Total assets, $m76445NaN
Adjusted assets (=assets-cash), $m73688NaN
Average production assets, $m32862NaN
Working capital, $m9361NaN
Total debt, $m43193NaN
Total liabilities, $m74883NaN
Total equity, $m1562NaN
Debt-to-equity ratio27.652NaN
Adjusted equity ratio0.000NaN

CASH FLOW

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