Stock Analysis on Net
Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Common-Size Balance Sheet: Assets 
Quarterly Data

Home Depot Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Aug 2, 2026 May 3, 2026 Feb 1, 2026 Nov 2, 2025 Aug 3, 2025 May 4, 2025 Feb 2, 2025 Oct 27, 2024 Jul 28, 2024 Apr 28, 2024 Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020
Cash and cash equivalents 1.91 1.48 1.32 1.58 2.80 1.38 1.73 1.57 1.67 5.38 4.91 2.72 3.68 1.65 3.61 3.20 1.66 3.71 3.26 6.94 6.45 9.16 11.19 21.90 22.32 14.80
Receivables, net 6.37 6.14 5.33 6.37 5.88 5.94 5.10 5.94 5.68 5.18 4.35 5.20 5.02 5.52 4.34 4.86 4.91 5.14 4.77 4.84 4.69 4.99 4.24 3.98 4.04 4.44
Merchandise inventories 24.54 25.28 24.57 24.66 24.83 25.98 24.40 24.57 23.81 28.29 27.41 30.17 30.46 33.21 32.55 33.46 34.41 33.04 30.70 28.18 26.72 26.43 23.56 24.14 21.31 25.52
Other current assets 1.67 1.54 1.51 1.38 1.87 1.52 1.74 1.79 2.17 2.32 2.24 2.50 2.51 2.07 1.98 2.30 2.46 2.34 1.69 1.76 2.07 1.68 1.36 1.54 1.83 1.67
Current assets 34.48% 34.45% 32.72% 33.98% 35.37% 34.82% 32.96% 33.88% 33.32% 41.17% 38.91% 40.60% 41.67% 42.45% 42.48% 43.82% 43.44% 44.23% 40.42% 41.72% 39.94% 42.27% 40.35% 51.56% 49.51% 46.44%
Net property and equipment 25.73 25.88 26.66 26.05 26.88 27.01 27.78 27.32 27.51 32.81 34.17 34.05 33.88 33.61 33.53 32.84 33.30 32.87 35.06 34.14 34.97 34.00 35.00 35.64 36.92 38.64
Operating lease right-of-use assets 8.50 8.60 8.76 8.51 8.66 8.77 8.94 8.76 8.89 9.99 10.30 9.36 9.35 9.07 9.08 8.49 8.09 7.81 8.30 8.08 8.42 8.08 8.45 8.12 8.58 9.59
Goodwill 20.93 20.83 21.26 20.95 19.61 19.73 20.26 19.97 20.05 10.68 11.05 10.50 10.03 9.75 9.74 9.67 9.83 9.73 10.36 10.19 10.53 9.84 10.10 3.34 3.52 3.78
Intangible assets, net 9.58 9.49 9.83 9.80 8.77 8.96 9.35 9.37 9.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other assets 0.76 0.75 0.77 0.71 0.71 0.70 0.71 0.70 0.71 5.34 5.57 5.49 5.07 5.12 5.18 5.19 5.35 5.36 5.85 5.86 6.14 5.82 6.11 1.34 1.47 1.55
Long-term assets 65.52% 65.55% 67.28% 66.02% 64.63% 65.18% 67.04% 66.12% 66.68% 58.83% 61.09% 59.40% 58.33% 57.55% 57.52% 56.18% 56.56% 55.77% 59.58% 58.28% 60.06% 57.73% 59.65% 48.44% 50.49% 53.56%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2026-08-02), 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03).


An analysis of the asset structure reveals a fundamental shift in the composition of the balance sheet, moving from a liquidity-heavy position to one dominated by long-term and intangible assets. Current assets, which initially comprised between 46% and 51% of total assets in 2020, experienced a steady decline, stabilizing between 32% and 34% by 2026. Conversely, long-term assets increased from approximately 53% to a range of 65% to 67% over the same period.

Liquidity and Working Capital
A significant reduction in cash and cash equivalents is observed, falling from a peak of 22.32% in August 2020 to below 2% for the majority of the period between 2022 and 2026. While cash positions diminished, receivables, net, showed a gradual upward trend, increasing from 4.44% in May 2020 to 6.37% by August 2026, suggesting a slight increase in the proportion of credit sales or a change in collection timing relative to total asset growth.
Inventory Management
Merchandise inventories exhibited a period of volatility and expansion, rising from 25.52% in May 2020 to a peak of 34.41% in July 2022. Following this peak, a normalization phase occurred, with inventory levels receding and stabilizing around 24% to 25% of total assets from 2024 through 2026.
Fixed and Operating Assets
Net property and equipment demonstrated a consistent long-term decline as a percentage of total assets, dropping from 38.64% in early 2020 to approximately 25.73% by August 2026. Operating lease right-of-use assets remained relatively stable, fluctuating within a narrow band between 8% and 10%.
Intangible Assets and Strategic Growth
A structural transformation occurred in July 2024, marked by a sharp increase in goodwill, which rose from 10.68% in April 2024 to 20.05% in July 2024, remaining near 21% thereafter. This coincides with the first appearance of intangible assets, net, which entered the balance sheet at 9.51% in July 2024 and remained consistent through 2026. This simultaneous surge in goodwill and the introduction of intangible assets indicates a significant acquisition event that fundamentally altered the asset base.

AI Ask an analyst for more