Balance Sheet Data
The Home Depot, Inc. (HD)
$319.62
+6.13 (+1.96%)
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
| Total Cash | 1,778 | 2,133 | 7,895 | 2,343 | 2,757 | 4,454.63 | 4,903.14 | 5,396.80 | 5,940.17 | 6,538.24 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 1,936 | 2,106 | 2,992 | 3,426 | 3,317 | 3,582.31 | 3,942.98 | 4,339.97 | 4,776.94 | 5,257.89 |
| Account Receivables (%) | ||||||||||
| Inventories | 13,925 | 14,531 | 16,627 | 22,068 | 24,886 | 23,925.19 | 26,334.05 | 28,985.45 | 31,903.79 | 35,115.96 |
| Inventories (%) | ||||||||||
| Accounts Payable | 7,755 | 7,787 | 11,606 | 13,462 | 11,443 | 13,580.33 | 14,947.63 | 16,452.61 | 18,109.11 | 19,932.38 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -2,442 | -2,678 | -2,463 | -2,566 | -3,119 | -3,544.68 | -3,901.57 | -4,294.39 | -4,726.76 | -5,202.67 |
| Capital Expenditure (%) |
To support growth, companies need to keep investing in capital items – including property, plants and equipment.
To calculate this net investment,we take capital expenditure (found in the company’s statement of cash flows)
and subtract non-cash depreciation (found on the income statement).
Working capital refers to the cash a company needs for day-to-day operations.
The faster a company expands, the more cash it will need.
To calculate working capital, we take current assets and subtract current liabilities.
You can find both of these on a company’s balance sheet, which is published in its quarterly and annual financial statements.