Home Depot Financial Statements Trends

HD -- USA Stock  

USD 188.75  1.22  0.64%

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 Consolidated Income of 5.2 B, Cost of Revenue of 47.8 B or Earning Before Interest and Taxes EBIT of 8.7 B, but also many exotic indicators such as Interest Coverage of 13.1096, Long Term Debt to Equity of 1.9869 or Calculated Tax Rate of 43.0735. 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 B37.8 B39.6 B
Increasing
Slightly volatile
Cash and Equivalents1.8 B2 B1.9 B
Increasing
Stable
Investments409 M48.3 M82.3 M
Increasing
Slightly volatile
Investments Current263.3 M6.9 M32.8 M
Increasing
Slightly volatile
Investments Non Current107.2 M32.4 M45.5 M
Increasing
Very volatile
Deferred Revenue1.3 B1.4 B1.3 B
Increasing
Slightly volatile
Property Plant and Equipment Net20.3 B20 B22.3 B
Decreasing
Stable
Inventory10 B10.6 B10.6 B
Increasing
Slightly volatile
Trade and Non Trade Receivables1.5 B1.7 B1.4 B
Increasing
Slightly volatile
Trade and Non Trade Payables5.4 B5.9 B5.5 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.7 B1.9 B1.5 B
Increasing
Slightly volatile
Total Liabilities26 B32.1 B26.7 B
Increasing
Slightly volatile
Shareholders Equity14.4 B7.3 B12.9 B
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit23.2 B27.9 B22.7 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(481.6 M)(1 B)(278.1 M)
Decreasing
Slightly volatile
Current Assets16.5 B14.8 B14.9 B
Increasing
Slightly volatile
Assets Non Current22.8 B22.9 B24.5 B
Increasing
Very volatile
Current Liabilities12.5 B11.3 B10.9 B
Increasing
Slightly volatile
Liabilities Non Current15.5 B20.8 B16 B
Increasing
Slightly volatile
Tax Liabilities1.2 B1 B890.2 M
Increasing
Slightly volatile
Total Debt29.2 B19.1 B15.5 B
Increasing
Slightly volatile
Debt Current702.3 M491.1 M563.1 M
Decreasing
Stable
Debt Non Current13.5 B18.7 B13.8 B
Increasing
Slightly volatile
Shareholders Equity USD14.4 B7.3 B12.9 B
Decreasing
Slightly volatile
Cash and Equivalents USD1.6 B2 B1.9 B
Increasing
Stable
Total Debt USD14 B19.1 B14.2 B
Increasing
Slightly volatile

Home Depot Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues108.2 B79.7 B79 B
Increasing
Slightly volatile
Cost of Revenue47.8 B52.4 B50.2 B
Increasing
Slightly volatile
Selling General and Administrative Expense14.5 B15.1 B15.6 B
Increasing
Slightly volatile
Operating Expenses15.8 B16.6 B17.1 B
Increasing
Slightly volatile
Interest Expense536 M677.7 M601.2 M
Increasing
Slightly volatile
Income Tax Expense3 B3.6 B3 B
Increasing
Slightly volatile
Net Loss Income from Discontinued Operations(43.8 M)(36.9 M)(52.9 M)
Increasing
Slightly volatile
Consolidated Income5.2 B6.3 B5.1 B
Increasing
Slightly volatile
Net Income11.1 B6.3 B5.6 B
Increasing
Slightly volatile
Net Income Common Stock5.2 B6.3 B5.1 B
Increasing
Slightly volatile
Weighted Average Shares1.1 B1.5 B1.5 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted1.8 B1.5 B1.6 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT8.7 B10.6 B8.7 B
Increasing
Slightly volatile
Revenues USD72.4 B79.7 B76 B
Increasing
Slightly volatile
Net Income Common Stock USD5.2 B6.3 B5.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD8.7 B10.6 B8.7 B
Increasing
Slightly volatile
Gross Profit37.2 B27.2 B26.9 B
Increasing
Slightly volatile
Operating Income8.7 B10.6 B8.7 B
Increasing
Slightly volatile

Home Depot Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.6 B)(1.3 B)(1.5 B)
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(858.5 M)(1.5 B)(662.5 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals193.9 M165.6 M198.3 M
Increasing
Stable
Net Cash Flow from Financing(5.8 B)(6.7 B)(5.1 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 2.4 B3.6 B1.9 B
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(6.2 B)(7.8 B)(4.8 B)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (2.7 B)(3.5 B)(2.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(2.4 B)(2.7 B)(2 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations8.7 B8.4 B7.5 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (76.8 M)(127.7 M)(57.4 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents526.4 M694.6 M557 M
Decreasing
Stable
Share Based Compensation204.2 M219.6 M215.1 M
Increasing
Slightly volatile
Depreciation Amortization and Accretion1.5 B1.7 B1.7 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share3.70684.9413.6723
Increasing
Slightly volatile
Earnings per Diluted Share9.734.9144.1528
Increasing
Slightly volatile
Earnings per Basic Share USD3.70684.9413.6723
Increasing
Slightly volatile
Dividends per Basic Common Share1.50222.1241.5297
Increasing
Slightly volatile
Return on Average Equity5.46520.79380.9023
Increasing
Slightly volatile
Return on Average Assets0.22280.14670.1332
Increasing
Slightly volatile
Return on Invested Capital0.30410.32090.2407
Increasing
Slightly volatile
Gross Margin0.30260.30780.3329
Decreasing
Stable
Profit Margin0.10280.07110.0681
Increasing
Slightly volatile
EBITDA Margin0.12510.13860.1312
Increasing
Slightly volatile
Return on Sales0.10610.11970.1098
Increasing
Slightly volatile
Asset Turnover2.27392.3611.9482
Increasing
Slightly volatile
Payout Ratio0.34580.3870.3998
Increasing
Very volatile
Enterprise Value over EBITDA10.393811.699111.8954
Decreasing
Very volatile
Enterprise Value over EBIT12.073713.513.9645
Decreasing
Stable
Price to Earnings Ratio19.426.343122.5719
Decreasing
Stable
Sales per Share50.530262.386253.066
Increasing
Slightly volatile
Price to Sales Ratio1.971.63261.518
Increasing
Slightly volatile
Price to Book Value16422.720525.6498
Increasing
Slightly volatile
Debt to Equity Ratio3.31045.08143.0098
Increasing
Slightly volatile
Dividend Yield0.01690.01710.0192
Decreasing
Very volatile
Current Ratio1.111.51341.3756
Decreasing
Slightly volatile
Free Cash Flow per Share1.595.57734.0449
Increasing
Slightly volatile
Book Value per Share8.90135.78348.3775
Decreasing
Slightly volatile
Tangible Assets Book Value per Share24.520628.569626.4614
Increasing
Slightly volatile
Total Assets Per Share27.625630.586329.1219
Increasing
Slightly volatile
Cash Flow Per Share5.42956.73785.435
Increasing
Slightly volatile
Return on Investment31.829739.137932.4064
Increasing
Slightly volatile
Operating Margin16.5711.97111.5838
Increasing
Slightly volatile
Calculated Tax Rate43.073541.863737.4298
Increasing
Slightly volatile
Receivables Turnover48.037147.353954.295
Decreasing
Stable
Inventory Turnover4.33574.58134.6998
Increasing
Stable
PPandE Turnover3.18023.55753.3523
Increasing
Slightly volatile
Cash and Equivalents Turnover72.294951.828658.1561
Decreasing
Slightly volatile
Accounts Payable Turnover12.637412.91413.9823
Decreasing
Slightly volatile
Accrued Expenses Turnover30.925630.676626.7186
Increasing
Slightly volatile
Interest Coverage13.109614.072514.7157
Decreasing
Very volatile
Long Term Debt to Equity1.98692.97641.6979
Increasing
Slightly volatile
Quick Ratio0.26270.29450.2918
Increasing
Stable
Net Current Assets as percentage of Total Assets8.7849.44869.9946
Increasing
Very volatile
Revenue to Assets1.75151.87241.8751
Increasing
Slightly volatile

Home Depot Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax8.2 B9.9 B8.1 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA17.9 B12.3 B11 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD10.3 B12.3 B10.4 B
Increasing
Slightly volatile
Market Capitalization213.2 B143.5 B122.9 B
Increasing
Slightly volatile
Enterprise Value239.4 B159.5 B135.7 B
Increasing
Slightly volatile
Invested Capital36.5 B39.5 B39 B
Increasing
Slightly volatile
Average Equity15.7 B9.1 B13.7 B
Decreasing
Slightly volatile
Average Assets37.7 B38.8 B40.4 B
Increasing
Stable
Invested Capital Average34.3 B38 B37.4 B
Increasing
Slightly volatile
Tangible Asset Value35 B35.9 B37.7 B
Increasing
Stable
Free Cash Flow5.5 B7.1 B5.9 B
Increasing
Slightly volatile
Working Capital4 B3.6 B4 B
Decreasing
Very volatile
Revenue Per Employee268.4 K265.1 K230.7 K
Increasing
Slightly volatile
Net Income Per Employee14.1 K16.4 K14.7 K
Increasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities

Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Home Depot Fundamental Drivers

The Home Depot Fundamental Market Drivers

Short Percent Of Float0.73%
Forward Price Earnings17.08
Shares Short Prior Month8.04M
Average Daily Volume Last 10 Day4.89M
Average Daily Volume In Three Month4.72M
Date Short InterestFebruary 28, 2019
Fifty Day Average185.79
Two Hundred Day Average184.76

Home Depot Upcoming Events

Home Depot Upcoming Company Events

Upcoming Quarterly ReportMay 16, 2017
Next Earnings ReportAugust 15, 2017
Please also check analysis of Home Depot Correlation with competitors. Please also try Premium Stories module to follow macroaxis premium stories from verified contributors across different equity types, categories and coverage scope.
Search macroaxis.com