Home Depot Financial Statements Trends

HD -- USA Stock  

1.36 Dividend

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.4 B, Consolidated Income of 4.7 B or Cost of Revenue of 60 B, but also many exotic indicators such as Interest Coverage of 14.1813, Long Term Debt to Equity of 9.3895 or Calculated Tax Rate of 32.7624. 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 B47.3 B42.1 B
Increasing
Stable
Cash and Equivalents2.2 B596.9 M792.4 M
Increasing
Very volatile
Investments75.9 M48.3 M54.1 M
Decreasing
Stable
Investments Current5.4 M5.4 M5.9 M
Decreasing
Slightly volatile
Investments Non Current71.4 M41.4 M48.7 M
Decreasing
Stable
Deferred Revenue1.5 B1.3 B1.3 B
Decreasing
Very volatile
Property Plant and Equipment Net22.4 B23.6 B25.3 B
Decreasing
Stable
Inventory13.1 B12.3 B11.3 B
Increasing
Very volatile
Trade and Non Trade Receivables1.4 B1.1 B1.1 B
Decreasing
Stable
Trade and Non Trade Payables6.3 B5.5 B5.3 B
Decreasing
Stable
Goodwill and Intangible Assets1.6 B1.3 B1.3 B
Decreasing
Stable
Total Liabilities31.7 B26.9 B26.5 B
Decreasing
Stable
Shareholders Equity13.2 B16 B15.4 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit22.1 B13.9 B16.3 B
Decreasing
Stable
Accumulated Other Comprehensive Income(116.4 M)(69.3 M)(143.1 M)
Increasing
Slightly volatile
Current Assets16.5 B15.4 B14.3 B
Decreasing
Very volatile
Assets Non Current24.1 B25 B27 B
Decreasing
Slightly volatile
Current Liabilities12.5 B12.8 B11.9 B
Decreasing
Stable
Liabilities Non Current17.9 B14.1 B14.5 B
Decreasing
Stable
Tax Liabilities1.1 B1.1 B987.1 M
Increasing
Slightly volatile
Total Debt35 B13.1 B15.4 B
Increasing
Very volatile
Debt Current1.7 BB1.8 B
Decreasing
Slightly volatile
Debt Non Current15 B11.1 B11.8 B
Decreasing
Stable
Shareholders Equity USD13.2 B16 B15.4 B
Increasing
Slightly volatile
Cash and Equivalents USD1.4 B596.9 M721.2 M
Decreasing
Very volatile
Total Debt USD16.7 B13.1 B13.7 B
Decreasing
Stable
Accounts Payable6.6 B7.8 B6.1 B
Increasing
Slightly volatile
Receivables1.7 B1.9 B1.5 B
Increasing
Slightly volatile
Inventories12.2 B13.9 B11.6 B
Increasing
Slightly volatile

Home Depot Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues110.9 B82 B79.2 B
Increasing
Very volatile
Cost of Revenue60 B54.4 B51.3 B
Decreasing
Very volatile
Selling General and Administrative Expense20.6 B20.5 B18.5 B
Increasing
Slightly volatile
Operating Expenses22.7 B22.6 B20.4 B
Increasing
Slightly volatile
Interest Expense893.4 M884.4 M809.4 M
Increasing
Very volatile
Income Tax Expense2.5 B1.5 B1.6 B
Decreasing
Stable
Net Loss Income from Discontinued Operations26.9 M46.8 M40.8 M
Increasing
Stable
Consolidated Income4.7 B2.6 B3.3 B
Decreasing
Slightly volatile
Net Income11.1 B2.6 B3.9 B
Increasing
Very volatile
Net Income Common Stock4.7 B2.6 B3.3 B
Decreasing
Slightly volatile
Weighted Average Shares1.1 B1.5 B1.6 B
Decreasing
Very volatile
Weighted Average Shares Diluted1.4 B1.5 B1.6 B
Increasing
Very volatile
Earning Before Interest and Taxes EBIT8.1 BB5.7 B
Decreasing
Stable
Revenues USD90.8 B82 B77.4 B
Decreasing
Very volatile
Net Income Common Stock USD4.7 B2.6 B3.3 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes USD8.1 BB5.7 B
Decreasing
Stable
Gross Profit37.2 B27.6 B26.7 B
Increasing
Very volatile
Operating Income8.1 BB5.8 B
Decreasing
Stable
Direct Expenses60.4 B71 B55.2 B
Increasing
Slightly volatile

Home Depot Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.4 B)(1.5 B)(1.7 B)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(139.4 M)32.4 M4.2 M
Decreasing
Very volatile
Net Cash Flow Investment Acquisitions and Disposals50.6 M(33.4 M)(6.4 M)
Decreasing
Stable
Net Cash Flow from Financing(4.4 B)(3.3 B)(4.5 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities (455.1 M)(2.4 B)(1.6 B)
Decreasing
Stable
Issuance Purchase of Equity Shares(2.1 B)12.6 M(1.1 B)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (1.8 B)(1.4 B)(1.8 B)
Increasing
Slightly volatile
Net Cash Flow from Investing(1.5 B)(1.6 B)(1.8 B)
Increasing
Slightly volatile
Net Cash Flow from Operations8.8 B6.4 B6.6 B
Decreasing
Stable
Effect of Exchange Rate Changes on Cash (37.6 M)(51.8 M)(42.6 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents114.9 M107.1 M(56.7 M)
Increasing
Slightly volatile
Share Based Compensation240.4 M202.4 M193.9 M
Decreasing
Very volatile
Depreciation Amortization and Accretion2.2 B2.2 BB
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share3.34211.542.3075
Decreasing
Slightly volatile
Earnings per Diluted Share10.041.542.9118
Increasing
Very volatile
Earnings per Basic Share USD3.34211.542.3075
Decreasing
Slightly volatile
Dividends per Basic Common Share1.65791.031.2734
Decreasing
Slightly volatile
Return on Average Equity1.19670.14381.5015
Decreasing
Slightly volatile
Return on Average Assets0.20590.05870.0833
Decreasing
Very volatile
Return on Invested Capital0.19220.12080.1335
Decreasing
Stable
Gross Margin0.40190.38760.348
Increasing
Slightly volatile
Profit Margin0.10010.03680.0451
Increasing
Very volatile
EBITDA Margin0.13030.10010.099
Decreasing
Stable
Return on Sales0.10070.0690.0722
Decreasing
Stable
Asset Turnover2.07891.861.7524
Decreasing
Very volatile
Payout Ratio0.51290.60480.6286
Increasing
Very volatile
Enterprise Value over EBITDA11.06848.718.4984
Decreasing
Very volatile
Enterprise Value over EBIT14.552612.6511.8366
Increasing
Very volatile
Price to Earnings Ratio21.3118.4817.0162
Increasing
Slightly volatile
Sales per Share60.521148.7449.4082
Decreasing
Stable
Price to Sales Ratio2.10.58420.7896
Increasing
Very volatile
Price to Book Value1642.366.5695
Increasing
Slightly volatile
Debt to Equity Ratio3.31041.51(0.8257)
Increasing
Slightly volatile
Dividend Yield0.02970.03780.0387
Increasing
Very volatile
Current Ratio1.081.1981.1684
Decreasing
Slightly volatile
Free Cash Flow per Share2.012.622.926
Decreasing
Slightly volatile
Book Value per Share8.08959.519.1363
Increasing
Slightly volatile
Tangible Assets Book Value per Share31.057927.3725.9582
Decreasing
Very volatile
Total Assets Per Share34.22239.821732.4188
Increasing
Slightly volatile
Cash Flow Per Share8.98911.79917.1468
Increasing
Slightly volatile
Return on Investment44.861655.657139.554
Increasing
Slightly volatile
Operating Margin16.5114.352712.7051
Increasing
Slightly volatile
Calculated Tax Rate32.762423.598535.0053
Decreasing
Slightly volatile
Receivables Turnover61.484154.759855.7793
Decreasing
Stable
Inventory Turnover4.83525.3274.8832
Increasing
Slightly volatile
PPandE Turnover4.05254.78983.7733
Increasing
Slightly volatile
Cash and Equivalents Turnover47.434339.625244.0066
Decreasing
Slightly volatile
Accounts Payable Turnover13.449814.194714.1794
Decreasing
Slightly volatile
Accrued Expenses Turnover24.946526.858425.8026
Increasing
Slightly volatile
Interest Coverage14.181315.944614.5031
Increasing
Slightly volatile
Long Term Debt to Equity9.389515.025.3909
Increasing
Slightly volatile
Quick Ratio0.23930.22170.2919
Decreasing
Very volatile
Net Current Assets as percentage of Total Assets7.32644.12028.7879
Decreasing
Slightly volatile
Revenue to Assets2.14162.4592.0572
Increasing
Slightly volatile

Home Depot Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax7.2 B4.1 B4.9 B
Decreasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA18.3 B7.1 B8.4 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD10.3 B7.1 B7.7 B
Decreasing
Stable
Market Capitalization233.4 B42 B70.5 B
Increasing
Very volatile
Enterprise Value270.2 B54.1 B84.8 B
Increasing
Very volatile
Invested Capital48.9 B45.8 B42.3 B
Increasing
Very volatile
Average Equity13.8 B16.3 B16 B
Increasing
Stable
Average Assets51.6 B50.6 B45.4 B
Increasing
Slightly volatile
Invested Capital Average48.9 B47.1 B43 B
Increasing
Stable
Tangible Asset Value47.4 B46 B41.4 B
Increasing
Slightly volatile
Free Cash Flow6.2 B4.4 B4.7 B
Decreasing
Stable
Working CapitalBB2.3 B
Increasing
Slightly volatile
Revenue Per Employee231 K257.8 K228.5 K
Increasing
Slightly volatile
Net Income Per Employee20.9 K26.5 K17.5 K
Increasing
Slightly volatile

Home Depot Fundamental Market Drivers

Short Percent Of Float1.03%
Forward Price Earnings19.67
Shares Short Prior Month12.07M
Average Daily Volume Last 10 Day6.58M
Average Daily Volume In Three Month3.82M
Date Short InterestNovember 15, 2019
Fifty Day Average231.41
Two Hundred Day Average218.23

Home Depot Upcoming Events

Upcoming Quarterly Earning ReportFebruary 25, 2020
Next Earnings ReportMay 19, 2020
Next Fiscal Quarter EndJanuary 31, 2020
Next Fiscal Year EndFebruary 25, 2020
Last Quarter Report DateOctober 31, 2019
Last Earning Anouncement DateJanuary 31, 2019
Search macroaxis.com