Home Depot Financial Statements Trends

The Home Depot Inc -- USA Stock  

USD 181.8  0.45  0.25%

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 7 B, Cost of Revenue of 59.5 B or Earning Before Interest and Taxes EBIT of 11.7 B, but also many exotic indicators such as Interest Coverage of 19.406, Long Term Debt to Equity of 2.693 or Calculated Tax Rate of 38.3161. 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.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(710.5 M)(898 M)(79.8 M)
Decreasing
Slightly volatile
Total Assets42 B39.9 B40.1 B
Increasing
Slightly volatile
Current Assets16.5 B15.3 B14.6 B
Increasing
Slightly volatile
Assets Non Current26.4 B25.5 B25.5 B
Increasing
Stable
Cash and Equivalents3.5 B2.2 B1.8 B
Increasing
Slightly volatile
Cash and Equivalents USD2.1 B2.2 B1.7 B
Increasing
Slightly volatile
Total Debt25.6 B21.2 B13.9 B
Increasing
Slightly volatile
Debt Current397.4 M427 M779 M
Decreasing
Slightly volatile
Debt Non Current19.8 B20.8 B12.7 B
Increasing
Slightly volatile
Total Debt USD20.2 B21.2 B13.5 B
Increasing
Slightly volatile
Deferred Revenue1.6 B1.6 B1.3 B
Increasing
Slightly volatile
Shareholders Equity8.2 B6.3 B14.2 B
Decreasing
Slightly volatile
Shareholders Equity USD8.2 B6.3 B14.2 B
Decreasing
Slightly volatile
Goodwill and Intangible Assets1.8 B2.1 B1.3 B
Increasing
Slightly volatile
Inventory12 B11.8 B10.7 B
Increasing
Slightly volatile
Investments49.4 M42 M77.8 M
Decreasing
Slightly volatile
Investments Current7.1 M6 M11.8 M
Decreasing
Slightly volatile
Investments Non Current42.4 M36 M65.9 M
Decreasing
Slightly volatile
Total Liabilities34.9 B35.7 B26 B
Increasing
Slightly volatile
Current Liabilities12.5 B11.3 B10.9 B
Increasing
Slightly volatile
Liabilities Non Current22.4 B23.1 B15 B
Increasing
Slightly volatile
Trade and Non Trade Payables6.5 B6.6 B5.4 B
Increasing
Slightly volatile
Property Plant and Equipment Net23.6 B22.2 B23.5 B
Decreasing
Very volatile
Trade and Non Trade Receivables1.8 B1.9 B1.4 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit30.5 B31 B20.4 B
Increasing
Slightly volatile
Tax Liabilities1.1 B889 M900.7 M
Increasing
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income7 B7 B4.7 B
Increasing
Slightly volatile
Cost of Revenue59.5 B58.3 B50.2 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT11.7 B11.8 B8.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD11.7 B11.8 B8.1 B
Increasing
Slightly volatile
Gross Profit32.3 B30.3 B25.8 B
Increasing
Slightly volatile
Interest Expense655.8 M753 M607.9 M
Increasing
Slightly volatile
Net Income8.6 B7 B4.9 B
Increasing
Slightly volatile
Net Income Common Stock7 B7 B4.7 B
Increasing
Slightly volatile
Net Income Common Stock USD7 B7 B4.7 B
Increasing
Slightly volatile
Net Income from Discontinued Operations(48.2 M)(41 M)(57.9 M)
Increasing
Slightly volatile
Operating Expenses19.2 B18.5 B17.7 B
Increasing
Slightly volatile
Operating Income11.7 B11.8 B8 B
Increasing
Slightly volatile
Revenues99.2 B88.5 B76.6 B
Increasing
Slightly volatile
Revenues USD90.4 B88.5 B75.9 B
Increasing
Slightly volatile
Selling General and Administrative Expense17.4 B16.8 B16.1 B
Increasing
Slightly volatile
Weighted Average Shares1.2 B1.3 B1.6 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted1.4 B1.3 B1.6 B
Decreasing
Slightly volatile
Income Tax Expense4 B4 B2.7 B
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.5 B)(1.5 B)(1.6 B)
Increasing
Slightly volatile
Depreciation Amortization and Accretion1.9 B1.9 B1.7 B
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents265.3 M604 M424.1 M
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(982.1 M)(1.7 B)287.7 M
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(7.1 B)(6.8 B)(4.6 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 3.3 B4 B1.3 B
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (2.9 B)(3 B)(2 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(6.8 B)(5.8 B)(5.3 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(2.2 B)(3 B)(1.3 B)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals245.8 M144 M147.2 M
Increasing
Slightly volatile
Net Cash Flow from Operations11.6 B9.4 B7.2 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (114.2 M)(111 M)(44.4 M)
Decreasing
Slightly volatile
Share Based Compensation246.8 M244 M212 M
Increasing
Slightly volatile
Cash Beginning of Year1.9 B1.7 B1.3 B
Increasing
Slightly volatile
Cash End of Year2.1 B2.2 B1.5 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover2.12582.0531.8301
Increasing
Slightly volatile
Book Value per Share6.39795.0299.0331
Decreasing
Slightly volatile
Current Ratio1.31.3161.3518
Decreasing
Very volatile
Debt to Equity Ratio7025.64660.6165
Increasing
Slightly volatile
Share Dilution Ratio1.05831.00471.0094
Increasing
Slightly volatile
Dividend Yield0.01950.0190.0224
Decreasing
Stable
Dividends per Basic Common Share2.23162.361.3668
Increasing
Slightly volatile
EBITDA Margin0.15840.1540.127
Increasing
Slightly volatile
Earnings per Basic Share5.38425.493.2529
Increasing
Slightly volatile
Earnings per Diluted Share7.25.463.3867
Increasing
Slightly volatile
EPS Diluted Growth0.2440.21090.1403
Increasing
Slightly volatile
EPS Growth0.24650.21440.1421
Increasing
Slightly volatile
Earnings per Basic Share USD5.38425.493.2529
Increasing
Slightly volatile
Enterprise Value over EBIT15.263215.013.3553
Increasing
Very volatile
Enterprise Value over EBITDA13.376312.99911.2814
Increasing
Stable
Free Cash Flow per Share4.16.1973.5747
Increasing
Slightly volatile
Gross Margin0.35950.3420.3395
Increasing
Slightly volatile
Financial Leverage0.99950.94610.9233
Increasing
Slightly volatile
Leverage Ratio4.62794.89933.0563
Increasing
Slightly volatile
NCFO Growth0.14020.18580.0646
Increasing
Slightly volatile
Net Income Growth0.17640.15690.0882
Increasing
Slightly volatile
Profit Margin0.08160.0790.0612
Increasing
Slightly volatile
Payout Ratio0.43530.430.4267
Increasing
Very volatile
Price to Book Value83.625.24515.3347
Increasing
Slightly volatile
Price to Earnings Ratio25.2822.90721.3628
Increasing
Very volatile
Price to Sales Ratio2.141.8141.3479
Increasing
Slightly volatile
Revenue Growth0.06130.06110.0206
Increasing
Slightly volatile
Return on Average Assets0.19480.1630.1166
Increasing
Slightly volatile
Return on Average Equity1.64510.8820.4713
Increasing
Slightly volatile
Return on Invested Capital0.27840.2790.211
Increasing
Slightly volatile
Return on Sales0.13630.1330.1043
Increasing
Slightly volatile
Weighted Average Share Growth(0.0555)(0.0445)(0.0483)
Increasing
Very volatile
Sales per Share69.201169.31850.6646
Increasing
Slightly volatile
Tax Efficiency0.67180.64040.6417
Increasing
Stable
Tangible Assets Book Value per Share32.236331.74426.2145
Increasing
Slightly volatile
Total Assets Per Share33.972633.984828.4781
Increasing
Slightly volatile
Cash Flow Per Share7.25927.48644.9561
Increasing
Slightly volatile
Return on Investment43.384343.486629.4669
Increasing
Slightly volatile
Operating Margin14.5313.301110.5976
Increasing
Slightly volatile
Calculated Tax Rate38.316136.403236.5114
Increasing
Stable
Receivables Turnover58.155352.615454.9773
Increasing
Stable
Inventory Turnover5.25755.09044.6711
Increasing
Slightly volatile
PPandE Turnover3.98623.95283.25
Increasing
Slightly volatile
Cash and Equivalents Turnover47.760245.068472.5325
Decreasing
Slightly volatile
Accounts Payable Turnover15.117914.348914.015
Increasing
Slightly volatile
Accrued Expenses Turnover27.819926.675325.8156
Increasing
Stable
Interest Coverage19.40615.636114.2073
Increasing
Stable
Long Term Debt to Equity2.6933.30721.3319
Increasing
Slightly volatile
Quick Ratio0.32160.32720.2674
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets10.839310.49859.3208
Increasing
Slightly volatile
Revenue to Assets2.19082.08041.872
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets44.7 B43.1 B42 B
Increasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA16.4 B13.6 B10 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD13.6 B13.6 B9.8 B
Increasing
Slightly volatile
Earnings before Tax11.1 B11 B7.5 B
Increasing
Slightly volatile
Average Equity9.8 B7.9 B15.2 B
Decreasing
Slightly volatile
Enterprise Value229.1 B177.3 B115.9 B
Increasing
Slightly volatile
Free Cash Flow7.8 B7.9 B5.4 B
Increasing
Slightly volatile
Invested Capital45.6 B43.9 B39.8 B
Increasing
Slightly volatile
Invested Capital Average44.3 B42.2 B38.8 B
Increasing
Slightly volatile
Market Capitalization212.5 B159.4 B104.9 B
Increasing
Slightly volatile
Tangible Asset Value41.3 B39.9 B38.8 B
Increasing
Slightly volatile
Working Capital4 B4 B3.7 B
Increasing
Slightly volatile
Revenue Per Employee239.7 K230.6 K224.6 K
Increasing
Very volatile
Net Income Per Employee18.6 K18.3 K13.9 K
Increasing
Slightly volatile