Home Depot Financial Statements Trends

HD -- USA Stock  

Earnings Report: February 25, 2020  

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 2.8 B or Cost of Revenue of 29.8 B, but also many exotic indicators such as Interest Coverage of 14.1813, Long Term Debt to Equity of 9.3916 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 B8.5 B13.9 B
Decreasing
Very volatile
Cash and Equivalents2.5 B61.3 M437.8 M
Increasing
Stable
Investments293.1 M155.1 M151.1 M
Increasing
Slightly volatile
Investments Current203.7 M63 M64.6 M
Increasing
Slightly volatile
Investments Non Current127.3 M92.2 M90.5 M
Increasing
Very volatile
Deferred Revenue1.2 B747.5 M809.7 M
Decreasing
Stable
Property Plant and Equipment Net13.5 B5.1 BB
Decreasing
Stable
Inventory6.5 B2.5 B3.7 B
Decreasing
Stable
Trade and Non Trade Receivables921.8 M374.2 M530.5 M
Decreasing
Stable
Trade and Non Trade Payables3.1 B948.5 M1.7 B
Decreasing
Stable
Goodwill and Intangible Assets804.7 M100.3 M350.5 M
Decreasing
Stable
Total Liabilities12.5 B2.7 B7.3 B
Decreasing
Slightly volatile
Shareholders EquityB4.5 B4.6 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit12.3 BB7.5 B
Decreasing
Slightly volatile
Accumulated Other Comprehensive Income(16.3 M)(5.6 M)(76.7 M)
Increasing
Slightly volatile
Current Assets16.5 B3.1 B5.4 B
Decreasing
Very volatile
Assets Non Current14.7 B5.4 B7.5 B
Decreasing
Stable
Current Liabilities12.5 B1.6 B3.8 B
Decreasing
Very volatile
Liabilities Non Current6.5 B1.1 BB
Decreasing
Slightly volatile
Tax Liabilities621.8 M213.3 M270.5 M
Decreasing
Very volatile
Total Debt34.5 B830.8 M6.4 B
Increasing
Very volatile
Debt Current398.1 M2.7 M255.8 M
Decreasing
Slightly volatile
Debt Non Current5.3 B828.1 M3.5 B
Decreasing
Slightly volatile
Shareholders Equity USDB4.5 B4.6 B
Increasing
Slightly volatile
Cash and Equivalents USD719.5 M61.3 M271.4 M
Decreasing
Stable
Total Debt USD5.7 B830.8 M3.8 B
Decreasing
Slightly volatile
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 B14.3 B30.2 B
Increasing
Very volatile
Cost of Revenue29.8 B10.3 B16.6 B
Decreasing
Stable
Selling General and Administrative ExpenseB2.8 B4.6 B
Decreasing
Stable
Operating Expenses9.6 B2.9 B4.9 B
Decreasing
Stable
Interest Expense211 M(8.6 M)101.5 M
Decreasing
Slightly volatile
Income Tax Expense1.6 B431.5 M767.3 M
Decreasing
Stable
Net Loss Income from Discontinued Operations(219.5 M)(226.6 M)(187.6 M)
Decreasing
Slightly volatile
Consolidated Income2.8 B695.2 M1.8 B
Decreasing
Slightly volatile
Net Income11.2 B695.2 M2.5 B
Increasing
Very volatile
Net Income Common Stock2.8 B695.2 M1.8 B
Decreasing
Slightly volatile
Weighted Average Shares1.1 B1.9 B1.9 B
Decreasing
Very volatile
Weighted Average Shares Diluted1.8 B1.9 BB
Increasing
Stable
Earning Before Interest and Taxes EBIT4.6 B1.1 B2.6 B
Decreasing
Slightly volatile
Revenues USD44 B14.3 B24.2 B
Decreasing
Stable
Net Income Common Stock USD2.8 B695.2 M1.8 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes USD4.6 B1.1 B2.6 B
Decreasing
Slightly volatile
Gross Profit37.2 BB9.7 B
Increasing
Very volatile
Operating Income4.6 B1.1 B2.6 B
Decreasing
Slightly volatile
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.9 B)(1.2 B)(1.3 B)
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(188.8 M)(185.8 M)(153.5 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals361.6 M526.9 M427.1 M
Increasing
Slightly volatile
Net Cash Flow from Financing(1.4 B)126 M(1.1 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 720 M112.5 M332 M
Decreasing
Stable
Issuance Purchase of Equity Shares(1.3 B)70.1 M(938.3 M)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (629.6 M)(61 M)(539.7 M)
Increasing
Slightly volatile
Net Cash Flow from Investing(1.7 B)(867.4 M)(1 B)
Increasing
Stable
Net Cash Flow from Operations8.8 B592.8 M2.4 B
Decreasing
Stable
Effect of Exchange Rate Changes on Cash (3.1 M)(68.4 K)(2.1 M)
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents15.5 M(89 M)(242 M)
Increasing
Slightly volatile
Share Based Compensation125.9 M17.2 M49.6 M
Decreasing
Stable
Depreciation Amortization and Accretion821.4 M149.1 M378.1 M
Decreasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share1.73960.3371.291
Decreasing
Slightly volatile
Earnings per Diluted Share10.020.3372.0392
Increasing
Very volatile
Earnings per Basic Share USD1.73960.3371.291
Decreasing
Slightly volatile
Dividends per Basic Common Share0.59110.0380.4557
Decreasing
Slightly volatile
Return on Average Equity1.0E-40.16911.411
Decreasing
Slightly volatile
Return on Average Assets0.13250.1150.1174
Decreasing
Slightly volatile
Return on Invested Capital0.25390.21390.2064
Decreasing
Stable
Gross Margin0.35480.32090.2955
Increasing
Stable
Profit Margin0.0650.05520.0552
Decreasing
Stable
EBITDA Margin0.12340.10120.0992
Decreasing
Stable
Return on Sales0.10650.08970.0877
Decreasing
Stable
Asset Turnover1.82081.89362.0839
Decreasing
Slightly volatile
Payout Ratio0.23570.130.1537
Decreasing
Stable
Enterprise Value over EBITDA12.152612.3213.3739
Decreasing
Slightly volatile
Enterprise Value over EBIT14.278914.415.6072
Decreasing
Slightly volatile
Price to Earnings Ratio23.3432.5933.1365
Increasing
Very volatile
Sales per Share26.03686.715.8638
Decreasing
Slightly volatile
Price to Sales Ratio2.31.63981.8593
Increasing
Stable
Price to Book Value1644.598.1831
Increasing
Slightly volatile
Debt to Equity Ratio3.31040.5451(1.5258)
Increasing
Slightly volatile
Dividend Yield0.01020.00350.0054
Decreasing
Stable
Current Ratio1.11.69741.7267
Decreasing
Very volatile
Free Cash Flow per Share2.33(0.2875)0.8537
Decreasing
Slightly volatile
Book Value per Share5.55182.67842.2918
Increasing
Slightly volatile
Tangible Assets Book Value per Share13.06323.97.3479
Decreasing
Slightly 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.5314.352712.707
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.05364.78983.7734
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.391615.025.3911
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.14042.4592.0571
Increasing
Slightly volatile

Home Depot Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax4.4 B1.1 B2.5 B
Decreasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA18.2 B1.3 B4.2 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD5.4 B1.3 BB
Decreasing
Slightly volatile
Market Capitalization253.3 B27.3 B61.7 B
Increasing
Very volatile
Enterprise Value289.2 B28 B67.6 B
Increasing
Very volatile
Invested Capital21.5 B7.5 B12.1 B
Decreasing
Stable
Average Equity8.4 B4.5 B4.9 B
Increasing
Slightly volatile
Average Assets24.4 B8.5 B12.5 B
Decreasing
Stable
Invested Capital Average21.2 B7.5 B11.8 B
Decreasing
Stable
Tangible Asset Value22.5 B8.4 B11.9 B
Decreasing
Stable
Free Cash Flow1.8 B(615.8 M)682.5 M
Decreasing
Slightly volatile
Working CapitalB1.4 B1.6 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.01%
Forward Price Earnings20.63
Shares Short Prior Month12.29M
Average Daily Volume Last 10 Day3.21M
Average Daily Volume In Three Month3.53M
Date Short InterestOctober 31, 2019
Fifty Day Average233.55
Two Hundred Day Average216.38

Home Depot Upcoming Events

Upcoming Quarterly Earning ReportNovember 19, 2019
Next Earnings ReportFebruary 25, 2020
Next Fiscal Quarter EndOctober 31, 2019
Next Fiscal Year EndFebruary 25, 2020
Last Quarter Report DateJuly 31, 2019
Last Earning Anouncement DateOctober 31, 2018
Search macroaxis.com