Stock Analysis on Net
Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Common-Size Income Statement
Quarterly Data

Beginner level

Home Depot Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended: Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018 Jan 28, 2018 Oct 29, 2017 Jul 30, 2017 Apr 30, 2017 Jan 29, 2017 Oct 30, 2016 Jul 31, 2016 May 1, 2016 Jan 31, 2016 Nov 1, 2015 Aug 2, 2015 May 3, 2015
Net sales 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
Cost of sales -66.43 -65.84 -65.99 -65.94 -66.12 -65.52 -66.17 -65.82 -65.92 -65.21 -65.98 -65.46 -66.11 -65.44 -66.34 -65.86 -65.99 -65.27 -66.28 -65.77 -65.89 -65.33 -66.31 -65.64
Gross profit 33.57% 34.16% 34.01% 34.06% 33.88% 34.48% 33.83% 34.18% 34.08% 34.79% 34.02% 34.54% 33.89% 34.56% 33.66% 34.14% 34.01% 34.73% 33.72% 34.23% 34.11% 34.67% 33.69% 34.36%
Selling, general and administrative -19.18 -18.12 -16.70 -20.63 -18.67 -18.15 -16.36 -18.73 -18.58 -18.28 -16.43 -19.16 -18.59 -18.04 -16.18 -18.26 -18.84 -18.48 -16.58 -18.81 -19.91 -19.07 -17.31 -19.93
Depreciation and amortization -1.74 -1.57 -1.36 -1.84 -2.01 -1.83 -1.60 -1.82 -1.81 -1.80 -1.51 -1.83 -1.94 -1.81 -1.60 -1.86 -1.99 -1.91 -1.65 -1.90 -2.04 -1.94 -1.69 -2.01
Impairment loss 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.93 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
Operating expenses -20.92% -19.69% -18.06% -22.47% -20.68% -19.98% -17.95% -20.55% -21.32% -20.08% -17.94% -20.99% -20.53% -19.85% -17.78% -20.12% -20.83% -20.39% -18.22% -20.71% -21.96% -21.01% -19.00% -21.93%
Operating income 12.66% 14.47% 15.94% 11.59% 13.20% 14.50% 15.88% 13.63% 12.75% 14.71% 16.09% 13.55% 13.35% 14.70% 15.88% 14.02% 13.18% 14.34% 15.50% 13.52% 12.15% 13.66% 14.69% 12.43%
Interest and investment income 0.03 0.03 0.02 0.06 0.07 0.08 0.06 0.06 0.08 0.10 0.09 0.09 0.10 0.09 0.06 0.05 0.05 0.04 0.03 0.03 0.03 0.03 0.60 0.02
Interest expense -1.04 -1.01 -0.91 -1.15 -1.20 -1.11 -0.98 -1.09 -1.02 -0.95 -0.89 -1.05 -1.13 -1.07 -0.94 -1.06 -1.11 -1.06 -0.89 -1.07 -1.15 -1.13 -0.94 -0.94
Other 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.06 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
Interest and other income (expense), net -1.01% -0.98% -0.89% -1.09% -1.13% -1.03% -0.92% -1.03% -1.00% -0.85% -0.81% -0.96% -1.03% -0.99% -0.89% -1.01% -1.06% -1.02% -0.86% -1.04% -1.12% -1.10% -0.34% -0.92%
Earnings before provision for income taxes 11.64% 13.49% 15.06% 10.51% 12.07% 13.47% 14.96% 12.60% 11.75% 13.86% 15.28% 12.59% 12.32% 13.72% 14.99% 13.01% 12.12% 13.32% 14.64% 12.48% 11.02% 12.56% 14.35% 11.51%
Provision for income taxes -2.79 -3.25 -3.67 -2.56 -2.44 -3.30 -3.68 -3.07 -2.90 -2.96 -3.77 -2.96 -4.87 -5.07 -5.49 -4.58 -4.27 -4.82 -5.42 -4.56 -4.01 -4.66 -5.35 -3.95
Net earnings 8.86% 10.23% 11.38% 7.94% 9.62% 10.17% 11.28% 9.53% 8.85% 10.90% 11.51% 9.64% 7.45% 8.65% 9.51% 8.43% 7.85% 8.50% 9.22% 7.92% 7.01% 7.91% 9.00% 7.56%

Based on: 10-K (filing date: 2021-03-24), 10-Q (filing date: 2020-11-24), 10-Q (filing date: 2020-08-25), 10-Q (filing date: 2020-05-27), 10-K (filing date: 2020-03-25), 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27).

Income statement item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Home Depot Inc.’s operating income as a percentage of net sales decreased from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.
Earnings before provision for income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Home Depot Inc.’s earnings before provision for income taxes as a percentage of net sales decreased from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.
Net earnings The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Home Depot Inc.’s net earnings as a percentage of net sales decreased from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021.