Home Depot Financial Statements Trends

HD -- USA Stock  

USD 205.77  1.21  0.58%

This module enables investors to look at Home Depot various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Direct Expenses of 60.1 B, Consolidated Income of 2.8 B or Cost of Revenue of 29.8 B, but also many exotic indicators such as Interest Coverage of 13.8961, Long Term Debt to Equity of 9.2791 or Calculated Tax Rate of 32.7847. This module is a perfect complement to use when analyzing Home Depot Valuation or Volatility. It can also complement various Home Depot Technical models. Please also check analysis of Home Depot Correlation with competitors.
Revenues

Home Depot Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets42 B8.5 B13.4 B
Decreasing
Very volatile
Cash and Equivalents1.8 B61.3 M341.6 M
Increasing
Very volatile
Investments293.1 M155.1 M149.8 M
Increasing
Slightly volatile
Investments Current203.7 M63 M63.8 M
Increasing
Slightly volatile
Investments Non Current127.3 M92.2 M89.7 M
Increasing
Very volatile
Deferred Revenue1.2 B747.5 M796.4 M
Decreasing
Stable
Property Plant and Equipment Net13.5 B5.1 B6.8 B
Decreasing
Stable
Inventory6.5 B2.5 B3.5 B
Decreasing
Stable
Trade and Non Trade Receivables921.8 M374.2 M513.4 M
Decreasing
Stable
Trade and Non Trade Payables3.1 B948.5 M1.6 B
Decreasing
Stable
Goodwill and Intangible Assets804.7 M100.3 M328.5 M
Decreasing
Stable
Total Liabilities12.5 B2.7 B6.9 B
Decreasing
Slightly volatile
Shareholders Equity8 B4.5 B4.6 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit12.3 B3 B7.1 B
Decreasing
Slightly volatile
Accumulated Other Comprehensive Income(16.3 M)(5.6 M)(70.8 M)
Increasing
Slightly volatile
Current Assets16.5 B3.1 B5.2 B
Decreasing
Very volatile
Assets Non Current14.7 B5.4 B7.3 B
Decreasing
Stable
Current Liabilities12.5 B1.6 B3.6 B
Decreasing
Very volatile
Liabilities Non Current6.5 B1.1 B3.8 B
Decreasing
Slightly volatile
Tax Liabilities621.8 M213.3 M263.4 M
Decreasing
Very volatile
Total Debt29.2 B830.8 M5.5 B
Increasing
Very volatile
Debt Current398.1 M2.7 M234.7 M
Decreasing
Slightly volatile
Debt Non Current5.3 B828.1 M3.3 B
Decreasing
Slightly volatile
Shareholders Equity USD8 B4.5 B4.6 B
Increasing
Slightly volatile
Cash and Equivalents USD719.5 M61.3 M253.2 M
Decreasing
Stable
Total Debt USD5.7 B830.8 M3.5 B
Decreasing
Slightly volatile
Accounts Payable6.6 B7.8 B5.9 B
Increasing
Slightly volatile
Receivables1.6 B1.9 B1.5 B
Increasing
Slightly volatile
Inventories12.1 B13.9 B11.5 B
Increasing
Slightly volatile

Home Depot Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues108.2 B14.3 B28.6 B
Increasing
Very volatile
Cost of Revenue29.8 B10.3 B16 B
Decreasing
Stable
Selling General and Administrative Expense9 B2.8 B4.4 B
Decreasing
Stable
Operating Expenses9.6 B2.9 B4.7 B
Decreasing
Stable
Interest Expense211 M(8.6 M)92.5 M
Decreasing
Slightly volatile
Income Tax Expense1.6 B431.5 M734.7 M
Decreasing
Stable
Net Loss Income from Discontinued Operations(219.5 M)(226.6 M)(188.3 M)
Decreasing
Slightly volatile
Consolidated Income2.8 B695.2 M1.7 B
Decreasing
Slightly volatile
Net Income11.1 B695.2 M2.4 B
Increasing
Very volatile
Net Income Common Stock2.8 B695.2 M1.7 B
Decreasing
Slightly volatile
Weighted Average Shares1.1 B1.9 B2 B
Decreasing
Very volatile
Weighted Average Shares Diluted1.8 B1.9 B2 B
Increasing
Stable
Earning Before Interest and Taxes EBIT4.6 B1.1 B2.5 B
Decreasing
Slightly volatile
Revenues USD44 B14.3 B23.2 B
Decreasing
Stable
Net Income Common Stock USD2.8 B695.2 M1.7 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes USD4.6 B1.1 B2.5 B
Decreasing
Slightly volatile
Gross Profit37.2 B4 B9.1 B
Increasing
Very volatile
Operating Income4.6 B1.1 B2.5 B
Decreasing
Slightly volatile
Direct Expenses60.1 B71 B54.6 B
Increasing
Slightly volatile

Home Depot Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.9 B)(1.2 B)(1.2 B)
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(188.8 M)(185.8 M)(154.1 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals361.6 M526.9 M429.7 M
Increasing
Slightly volatile
Net Cash Flow from Financing(1.4 B)126 M(1 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 720 M112.5 M312.5 M
Decreasing
Stable
Issuance Purchase of Equity Shares(1.3 B)70.1 M(853.6 M)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (629.6 M)(61 M)(500.4 M)
Increasing
Slightly volatile
Net Cash Flow from Investing(1.7 B)(867.4 M)(979.8 M)
Increasing
Stable
Net Cash Flow from Operations8.7 B592.8 M2.2 B
Decreasing
Stable
Effect of Exchange Rate Changes on Cash (3.1 M)(68.4 K)(1.9 M)
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents15.5 M(89 M)(230.1 M)
Increasing
Slightly volatile
Share Based Compensation125.9 M17.2 M46.7 M
Decreasing
Stable
Depreciation Amortization and Accretion821.4 M149.1 M357.4 M
Decreasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share1.73960.3371.2078
Decreasing
Slightly volatile
Earnings per Diluted Share9.730.3371.8695
Increasing
Very volatile
Earnings per Basic Share USD1.73960.3371.2078
Decreasing
Slightly volatile
Dividends per Basic Common Share0.59110.0380.4205
Decreasing
Slightly volatile
Return on Average Equity5.46520.16911.7611
Decreasing
Stable
Return on Average Assets0.22280.1150.1235
Decreasing
Very volatile
Return on Invested Capital0.25390.21390.2047
Decreasing
Stable
Gross Margin0.35480.32090.2941
Increasing
Stable
Profit Margin0.10280.05520.0578
Increasing
Very volatile
EBITDA Margin0.12340.10120.0983
Decreasing
Stable
Return on Sales0.10650.08970.0868
Decreasing
Stable
Asset Turnover1.82091.89362.0856
Decreasing
Slightly volatile
Payout Ratio0.23570.130.1503
Decreasing
Stable
Enterprise Value over EBITDA12.151512.319213.3999
Decreasing
Slightly volatile
Enterprise Value over EBIT14.279214.415.6399
Decreasing
Slightly volatile
Price to Earnings Ratio19.7932.593533.0975
Decreasing
Very volatile
Sales per Share26.03436.698815.0269
Decreasing
Slightly volatile
Price to Sales Ratio1.961.63981.8279
Decreasing
Stable
Price to Book Value1644.5927.8341
Increasing
Slightly volatile
Debt to Equity Ratio1.21820.5451(1.5335)
Increasing
Slightly volatile
Dividend Yield0.01020.00350.0052
Decreasing
Stable
Current Ratio1.111.69741.7408
Decreasing
Very volatile
Free Cash Flow per Share1.61(0.2875)0.7017
Decreasing
Slightly volatile
Book Value per Share5.6132.67842.2974
Increasing
Slightly volatile
Tangible Assets Book Value per Share13.26783.9027.0931
Decreasing
Slightly volatile
Total Assets Per Share33.966939.821731.7021
Increasing
Slightly volatile
Cash Flow Per Share8.873311.79916.7931
Increasing
Slightly volatile
Return on Investment44.070755.657137.5654
Increasing
Slightly volatile
Operating Margin16.5714.352712.2562
Increasing
Slightly volatile
Calculated Tax Rate32.784723.598534.9404
Decreasing
Slightly volatile
Receivables Turnover61.855854.759856.8746
Decreasing
Stable
Inventory Turnover4.81415.3274.8241
Increasing
Slightly volatile
PPandE Turnover4.01844.78983.6696
Increasing
Slightly volatile
Cash and Equivalents Turnover52.376939.625246.4521
Decreasing
Slightly volatile
Accounts Payable Turnover13.427814.194714.1379
Decreasing
Stable
Accrued Expenses Turnover24.924326.858425.6167
Increasing
Slightly volatile
Interest Coverage13.896115.944613.7582
Increasing
Slightly volatile
Long Term Debt to Equity9.279115.02084.9698
Increasing
Slightly volatile
Quick Ratio0.23380.22170.2863
Increasing
Very volatile
Net Current Assets as percentage of Total Assets7.15524.12028.7624
Decreasing
Slightly volatile
Revenue to Assets2.13062.4592.0198
Increasing
Slightly volatile

Home Depot Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax4.4 B1.1 B2.4 B
Decreasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA17.9 B1.3 B3.9 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD5.4 B1.3 B2.9 B
Decreasing
Slightly volatile
Market Capitalization212.4 B27.3 B55.2 B
Increasing
Very volatile
Enterprise Value239.8 B28 B59.9 B
Increasing
Very volatile
Invested Capital21.5 B7.5 B11.7 B
Decreasing
Stable
Average Equity8.4 B4.5 B4.9 B
Increasing
Slightly volatile
Average Assets24.4 B8.5 B12 B
Decreasing
Stable
Invested Capital Average21.2 B7.5 B11.4 B
Decreasing
Stable
Tangible Asset Value22.5 B8.4 B11.5 B
Decreasing
Stable
Free Cash Flow1.8 B(615.8 M)581 M
Decreasing
Slightly volatile
Working Capital4 B1.4 B1.5 B
Increasing
Slightly volatile
Revenue Per Employee230.9 K257.8 K226.9 K
Increasing
Slightly volatile
Net Income Per Employee20.5 K26.5 K16.8 K
Increasing
Slightly volatile

Home Depot Fundamental Market Drivers

Short Percent Of Float0.88%
Forward Price Earnings17.46
Shares Short Prior Month9.61M
Average Daily Volume Last 10 Day3.59M
Average Daily Volume In Three Month4.19M
Date Short InterestApril 30, 2019
Fifty Day Average199.50
Two Hundred Day Average184.58

Home Depot Upcoming Events

Upcoming Quarterly ReportAugust 13, 2019
Next Earnings ReportNovember 12, 2019
Search macroaxis.com