Home Depot Financial Statements Trends

HD -- USA Stock  

USD 169.99  2.02  1.20%

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 8.2 B, Cost of Revenue of 68.5 B or Earning Before Interest and Taxes EBIT of 13.9 B, but also many exotic indicators such as Interest Coverage of 18.3954, Long Term Debt to Equity of 3.8908 or Calculated Tax Rate of 42.8273. 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 B42 B39.9 B
Increasing
Slightly volatile
Cash and Equivalents1.8 B2.2 B1.8 B
Increasing
Slightly volatile
Investments49.4 M42 M51.8 M
Decreasing
Slightly volatile
Investments Current7.1 M6 M11.3 M
Decreasing
Slightly volatile
Investments Non Current42.4 M36 M40.4 M
Decreasing
Slightly volatile
Deferred Revenue1.8 B1.6 B1.3 B
Increasing
Slightly volatile
Property Plant and Equipment Net26.1 B22.2 B23.3 B
Increasing
Stable
Inventory13.9 B11.8 B10.9 B
Increasing
Slightly volatile
Trade and Non Trade Receivables2.2 B1.9 B1.4 B
Increasing
Slightly volatile
Trade and Non Trade Payables7.7 B6.6 B5.6 B
Increasing
Slightly volatile
Goodwill and Intangible Assets2.5 B2.1 B1.5 B
Increasing
Slightly volatile
Total Liabilities41.9 B35.7 B27.3 B
Increasing
Slightly volatile
Shareholders Equity7.4 B6.3 B13.2 B
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit36.4 B31 B22.5 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(1.1 B)(898 M)(246.4 M)
Decreasing
Slightly volatile
Current Assets16.5 B16.5 B14.8 B
Increasing
Slightly volatile
Assets Non Current30 B25.5 B25.5 B
Increasing
Slightly volatile
Current Liabilities12.5 B12.5 B10.9 B
Increasing
Slightly volatile
Liabilities Non Current27.2 B23.1 B16.2 B
Increasing
Slightly volatile
Tax Liabilities1 B889 M874.8 M
Increasing
Slightly volatile
Total Debt25.8 B21.2 B14.6 B
Increasing
Slightly volatile
Debt Current502.4 M427 M652.8 M
Decreasing
Slightly volatile
Debt Non Current24.5 B20.8 B13.9 B
Increasing
Slightly volatile
Shareholders Equity USD7.4 B6.3 B13.2 B
Decreasing
Slightly volatile
Cash and Equivalents USD2.6 B2.2 B1.9 B
Increasing
Slightly volatile
Total Debt USD25 B21.2 B14.5 B
Increasing
Slightly volatile

Home Depot Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues105.6 B88.5 B78.1 B
Increasing
Slightly volatile
Cost of Revenue68.5 B58.3 B51.5 B
Increasing
Slightly volatile
Selling General and Administrative Expense19.8 B16.8 B16.3 B
Increasing
Slightly volatile
Operating Expenses21.8 B18.5 B17.9 B
Increasing
Slightly volatile
Interest Expense885.9 M753 M638 M
Increasing
Slightly volatile
Income Tax Expense4.7 B4 B2.9 B
Increasing
Slightly volatile
Net Loss Income from Discontinued Operations(48.2 M)(41 M)(45.9 M)
Increasing
Stable
Consolidated Income8.2 B7 B5.1 B
Increasing
Slightly volatile
Net Income10.6 B7 B5.3 B
Increasing
Slightly volatile
Net Income Common Stock8.2 B7 B5.1 B
Increasing
Slightly volatile
Weighted Average Shares1.1 B1.3 B1.5 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted1.5 B1.3 B1.6 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT13.9 B11.8 B8.6 B
Increasing
Slightly volatile
Revenues USD104.1 B88.5 B78 B
Increasing
Slightly volatile
Net Income Common Stock USD8.2 B7 B5.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD13.9 B11.8 B8.6 B
Increasing
Slightly volatile
Gross Profit34.4 B30.3 B26.4 B
Increasing
Slightly volatile
Operating Income13.9 B11.8 B8.6 B
Increasing
Slightly volatile

Home Depot Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.7 B)(1.5 B)(1.5 B)
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(2 B)(1.7 B)(626.3 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals169.4 M144 M180 M
Increasing
Slightly volatile
Net Cash Flow from Financing(6.8 B)(5.8 B)(4.9 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 4.7 B4 B1.6 B
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(8 B)(6.8 B)(4.3 B)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (3.6 B)(3 B)(2.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(3.5 B)(3 B)(2.1 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations8.2 B9.4 B7.3 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (130.6 M)(111 M)(55 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents710.6 M604 M524.4 M
Decreasing
Stable
Share Based Compensation287.1 M244 M218.4 M
Increasing
Slightly volatile
Depreciation Amortization and Accretion2.2 B1.9 B1.7 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share6.45885.493.6016
Increasing
Slightly volatile
Earnings per Diluted Share9.145.463.8058
Increasing
Slightly volatile
Earnings per Basic Share USD6.45885.493.6016
Increasing
Slightly volatile
Dividends per Basic Common Share2.77652.361.5339
Increasing
Slightly volatile
Return on Average Equity5.46520.8820.8465
Increasing
Slightly volatile
Return on Average Assets0.21250.1630.1244
Increasing
Slightly volatile
Return on Invested Capital0.32820.2790.2247
Increasing
Slightly volatile
Gross Margin0.40240.3420.3436
Increasing
Slightly volatile
Profit Margin0.10.0790.0646
Increasing
Slightly volatile
EBITDA Margin0.18120.1540.1316
Increasing
Slightly volatile
Return on Sales0.15650.1330.109
Increasing
Slightly volatile
Asset Turnover2.41532.0531.8982
Increasing
Slightly volatile
Payout Ratio0.50590.430.4369
Increasing
Very volatile
Enterprise Value over EBITDA15.292912.99911.9597
Increasing
Stable
Enterprise Value over EBIT17.647115.014.1373
Increasing
Stable
Price to Earnings Ratio19.0222.90721.6839
Decreasing
Stable
Sales per Share81.550669.31853.9841
Increasing
Slightly volatile
Price to Sales Ratio1.861.8141.4151
Increasing
Slightly volatile
Price to Book Value14925.24522.6458
Increasing
Slightly volatile
Debt to Equity Ratio6.64245.6462.9737
Increasing
Slightly volatile
Dividend Yield0.02240.0190.0217
Decreasing
Stable
Current Ratio1.091.3161.3477
Decreasing
Slightly volatile
Free Cash Flow per Share1.566.1973.7673
Increasing
Slightly volatile
Book Value per Share5.91655.0298.526
Decreasing
Slightly volatile
Tangible Assets Book Value per Share37.345931.74427.1291
Increasing
Slightly volatile
Total Assets Per Share39.982133.984829.6253
Increasing
Slightly volatile
Cash Flow Per Share8.80767.48645.4266
Increasing
Slightly volatile
Return on Investment51.160743.486631.9595
Increasing
Slightly volatile
Operating Margin16.5513.301111.0941
Increasing
Slightly volatile
Calculated Tax Rate42.827336.403236.8872
Increasing
Slightly volatile
Receivables Turnover61.900552.615456.8443
Increasing
Very volatile
Inventory Turnover5.98875.09044.8077
Increasing
Slightly volatile
PPandE Turnover4.65043.95283.4002
Increasing
Slightly volatile
Cash and Equivalents Turnover53.021645.068464.5898
Decreasing
Slightly volatile
Accounts Payable Turnover16.88114.348914.3886
Increasing
Slightly volatile
Accrued Expenses Turnover31.382726.675326.2829
Increasing
Slightly volatile
Interest Coverage18.395415.636114.4559
Increasing
Stable
Long Term Debt to Equity3.89083.30721.6538
Increasing
Slightly volatile
Quick Ratio0.38490.32720.2886
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets12.351210.49859.9517
Increasing
Slightly volatile
Revenue to Assets2.44752.08041.9214
Increasing
Slightly volatile

Home Depot Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax13 B11 B8 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA17.5 B13.6 B10.5 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD16 B13.6 B10.3 B
Increasing
Slightly volatile
Market Capitalization196.4 B159.4 B112.5 B
Increasing
Slightly volatile
Enterprise Value219.2 B177.3 B124.6 B
Increasing
Slightly volatile
Invested Capital51.6 B43.9 B40.3 B
Increasing
Slightly volatile
Average Equity9.3 B7.9 B14 B
Decreasing
Slightly volatile
Average Assets50.7 B43.1 B41.9 B
Increasing
Slightly volatile
Invested Capital Average49.7 B42.2 B39 B
Increasing
Slightly volatile
Tangible Asset Value46.9 B39.9 B39 B
Increasing
Slightly volatile
Free Cash Flow9.3 B7.9 B6 B
Increasing
Slightly volatile
Working Capital4 B4 B3.9 B
Increasing
Slightly volatile
Revenue Per Employee271.2 K230.6 K227.3 K
Increasing
Slightly volatile
Net Income Per Employee21.5 K18.3 K14.6 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.71%
Forward Price Earnings16.90
Shares Short Prior Month8.62M
Average Daily Volume Last 10 Day5.62M
Average Daily Volume In Three Month5.66M
Date Short InterestNovember 15, 2018
Fifty Day Average177.00
Two Hundred Day Average193.10

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 Analyst Recommendations module to analyst recommendations and target price estimates broken down by several categories.
Search macroaxis.com