Home Depot, Inc. (The) Financial Ratios — ZHD Stock

Profitability (USD)

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Return on Common Equity (%)	21.11	25.42	35.55	58.09	89.64	149.44	298.25	- -	- -	- -	- -	- -	1,162.16	385.37	145.54
Return on Assets (%)	9.63	11.11	13.2	15.77	17.11	18.74	19.73	25.12	23.61	21.12	23.07	23.06	19.8	17.15	14.07
Return on Capital (%)	14.9	17.23	20.91	25.57	28.1	30.92	32.95	42.73	39.49	34.3	38.23	38	31.59	27.13	21.74
Return on Invested Capital (%)	14.67	16.77	20.56	24.37	27.21	30.27	32.16	41.6	38.48	33.53	37.35	37.3	31.02	26.46	21.31
Gross Margin (%)	34.47	34.57	34.15	34.13	34.19	34.16	34.05	34.34	34.09	33.95	33.63	33.53	33.38	33.42	33.32
EBITDA Margin (%)	11.85	12.64	13.86	14.73	15.41	16.28	16.59	16.34	16.46	15.74	17.14	17.16	16.33	15.85	15.19
Operating Margin (%)	9.46	10.39	11.63	12.59	13.3	14.19	14.55	14.58	14.37	13.84	15.24	15.27	14.21	13.49	12.68
Incremental Operating Margin (%)	34.28	25.35	34.5	29.86	24.42	27.21	19.88	15.02	3.26	11.13	25	15.99	49.64	- -	- -
Pretax Margin (%)	8.62	9.66	10.74	11.99	12.45	13.2	13.58	13.45	13.35	12.85	14.38	14.28	13.05	12.17	11.3
Profit Margin (%)	5.52	6.07	6.83	7.63	7.92	8.41	8.55	10.28	10.2	9.74	10.87	10.87	9.92	9.28	8.6
Net Income to Common Margin (%)	5.52	6.07	6.83	7.63	7.92	8.41	8.55	10.28	10.2	9.74	10.87	10.87	9.92	9.28	8.6
Effective Tax Rate (%)	36.01	37.2	36.4	36.4	36.4	36.3	37	23.6	23.6	24.22	24.4	23.9	24	23.7	23.9
Dvd Payout Ratio (%)	42.03	38.43	41.65	39.87	43.24	42.78	48.81	42.3	53	50.14	42.51	45.54	55.36	60.31	64.65
Sustainable Growth Rate (%)	12.24	15.65	20.74	34.93	50.88	85.51	152.69	- -	- -	- -	- -	- -	518.8	152.97	51.45

Credit (USD)

Credit Ratios API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Total Debt	10,788	10,796	14,724	17,197	21,216	23,601	27,028	29,202	37,377	43,422	46,269	50,364	52,243	62,290	65,350
ST Debt	30	1,321	33	328	427	1,252	2,761	2,395	3,641	2,244	4,312	2,176	2,418	6,172	10,849
LT Debt	10,758	9,475	14,691	16,869	20,789	22,349	24,267	26,807	33,736	41,178	41,957	48,188	49,825	56,118	54,501
Total Debt/EBITDA	1.29	1.14	1.35	1.4	1.56	1.53	1.61	1.65	2.06	2.09	1.79	1.86	2.1	2.46	2.61
Net Debt/EBITDA	1.05	0.88	1.17	1.26	1.39	1.37	1.4	1.55	1.62	1.41	1.46	1.5	1.62	2.05	2.17
Total Debt/EBIT	1.62	1.39	1.61	1.64	1.8	1.76	1.84	1.88	2.36	2.38	2.01	2.1	2.41	2.89	3.13
Net Debt/EBIT	1.32	1.07	1.4	1.48	1.61	1.57	1.6	1.77	1.85	1.61	1.64	1.68	1.86	2.4	2.6
EBITDA to Interest Expense	13.77	14.95	15.36	14.77	14.84	15.84	15.84	16.82	15.1	15.44	19.23	16.71	12.83	10.89	10.37
EBITDA-CapEx/Interest Expense	13.77	14.95	15.36	14.77	14.84	15.84	15.84	16.82	15.1	15.44	19.23	16.71	12.83	10.89	10.37
EBIT to Interest Expense	10.99	12.29	12.89	12.61	12.81	13.81	13.89	15.01	13.19	13.57	17.1	14.87	11.16	9.27	8.66
Interest Expense	606	632	711	830	919	972	1,057	1,051	1,201	1,347	1,347	1,617	1,943	2,321	2,412
Common Equity/Total Assets	44.17	43.27	30.9	23.34	15.05	10.08	3.27	-4.27	-6.08	4.67	-2.36	2.04	1.36	6.91	12.19
Long-Term Debt/Equity (%)	60.11	53.3	117.32	180.96	329.15	515.79	1,668.98	- -	- -	1,248.2	- -	3,085.02	4,772.51	845.15	425.36
Long-Term Debt/Capital (%)	37.5	33.16	53.92	63.61	75.51	80.01	85.2	98.11	98.47	88.14	94.13	92.8	93.5	81.41	69.73
Long-Term Debt/Total Assets (%)	26.55	23.06	36.26	42.23	49.53	52.02	54.5	60.92	65.84	58.34	58.37	63.04	65.11	58.38	51.86
Total Debt/Equity (%)	60.27	60.73	117.59	184.48	335.91	544.68	1,858.87	-1,554.95	-1,199.52	1,316.22	-2,728.12	3,224.33	5,004.12	938.1	510.03
Total Debt/Capital (%)	37.61	37.78	54.04	64.85	77.06	84.49	94.9	106.87	109.09	92.94	103.8	96.99	98.04	90.37	83.61
Total Debt/Total Assets (%)	26.63	26.28	36.34	43.05	50.55	54.93	60.7	66.36	72.95	61.52	64.37	65.88	68.26	64.81	62.18
Net Debt to Equity	49.17	46.7	102.18	165.99	300.82	486.11	1,611.62	-1,460.28	-941.91	889.45	-2,225.41	2,588.73	3,865.04	778.98	424.44
Net Debt/Capital (%)	32.96	31.83	50.54	62.41	75.05	82.94	94.16	107.35	91.35	75.58	89.37	82.24	81.47	76.89	70.84
EBITDA	8,343	9,450	10,923	12,255	13,637	15,400	16,743	17,682	18,139	20,797	25,902	27,014	24,936	25,287	25,011
EBITDA-CapEx	8,343	9,450	10,923	12,255	13,637	15,400	16,743	17,682	18,139	20,797	25,902	27,014	24,936	25,287	25,011
Operating Income (Loss)	6,661	7,766	9,166	10,469	11,774	13,427	14,681	15,777	15,843	18,278	23,040	24,039	21,689	21,526	20,890

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Cash Ratio	0.21	0.22	0.18	0.15	0.18	0.18	0.22	0.11	0.12	0.34	0.08	0.12	0.17	0.06	0.04
Current Ratio	1.55	1.34	1.42	1.36	1.32	1.25	1.17	1.11	1.08	1.23	1.01	1.41	1.35	1.11	1.06
Quick Ratio	0.34	0.34	0.31	0.28	0.33	0.32	0.34	0.22	0.23	0.47	0.2	0.26	0.32	0.23	0.22
CFO/Avg Current Liab	0.68	0.67	0.69	0.75	0.79	0.73	0.79	0.8	0.78	0.91	0.64	0.56	0.94	0.78	0.53
Common Equity/Total Assets	44.17	43.27	30.9	23.34	15.05	10.08	3.27	-4.27	-6.08	4.67	-2.36	2.04	1.36	6.91	12.19
Long-Term Debt/Equity (%)	60.11	53.3	117.32	180.96	329.15	515.79	1,668.98	- -	- -	1,248.2	- -	3,085.02	4,772.51	845.15	425.36
Long-Term Debt/Capital (%)	37.5	33.16	53.92	63.61	75.51	80.01	85.2	98.11	98.47	88.14	94.13	92.8	93.5	81.41	69.73
Long-Term Debt/Total Assets (%)	26.55	23.06	36.26	42.23	49.53	52.02	54.5	60.92	65.84	58.34	58.37	63.04	65.11	58.38	51.86
Total Debt/Equity (%)	60.27	60.73	117.59	184.48	335.91	544.68	1,858.87	-1,554.95	-1,199.52	1,316.22	-2,728.12	3,224.33	5,004.12	938.1	510.03
Total Debt/Capital (%)	37.61	37.78	54.04	64.85	77.06	84.49	94.9	106.87	109.09	92.94	103.8	96.99	98.04	90.37	83.61
Total Debt/Total Assets (%)	26.63	26.28	36.34	43.05	50.55	54.93	60.7	66.36	72.95	61.52	64.37	65.88	68.26	64.81	62.18
CFO/Total Liabilities	29.4	29.93	27.25	26.91	26.29	25.32	27.93	28.69	25.18	28	22.52	19.52	28.05	22.14	17.69
CFO/CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Accounts Receivable Turnover	- -	56.63	56.44	57.72	52.47	54.68	63.58	66.71	65.26	61.62	55.46	55.01	54.77	45.11	35.23
Days Sales Outstanding	- -	6.45	6.47	6.32	6.96	6.68	5.74	5.47	5.59	5.92	6.58	6.64	6.66	8.09	10.36
Inventory Turnover	4.4	4.65	4.77	4.95	5.09	5.11	5.26	5.33	5.11	5.6	5.19	4.46	4.44	4.78	4.46
Days Inventory Outstanding	82.88	78.49	76.55	73.74	71.7	71.37	69.37	68.52	71.48	65.17	70.39	81.9	82.29	76.34	81.88
Accounts Payable Turnover	9.58	9.64	9.35	9.45	9.54	9.29	9.37	9.63	9.43	9.21	8.44	8.63	9.11	9.89	9.58
Accounts Payable Turnover Days	38.12	37.88	39.03	38.64	38.28	39.28	38.95	37.9	38.72	39.61	43.26	42.3	40.08	36.9	38.11
Cash Conversion Cycle	- -	47.05	43.98	41.42	40.38	38.77	36.17	36.09	38.36	31.48	33.72	46.24	48.87	47.53	54.12
Inventory to Cash Days	- -	-72.04	-70.08	-67.41	-64.75	-64.7	-63.63	-63.05	-65.89	-59.24	-63.81	-75.27	-75.63	-68.25	-71.52
Inventories	10,325	10,710	11,057	11,079	11,809	12,549	12,748	13,925	14,531	16,627	22,068	24,886	20,976	23,451	25,817
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	10,325	10,710	11,057	11,079	11,809	12,549	12,748	13,925	14,531	16,627	22,068	24,886	20,976	23,451	25,817
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
- Cash & Cash Equivalents	1,987	2,494	1,929	1,723	2,216	2,538	3,595	1,778	2,133	7,895	2,343	2,757	3,760	1,659	1,389
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	10,788	10,796	14,724	17,197	21,216	23,601	27,028	29,202	37,377	43,422	46,269	50,364	52,243	62,290	65,350
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Capital	28,686	28,573	27,246	26,519	27,532	27,934	28,482	27,324	34,261	46,721	44,573	51,926	53,287	68,930	78,163
Total Debt/Capital (%)	37.61	37.78	54.04	64.85	77.06	84.49	94.9	106.87	109.09	92.94	103.8	96.99	98.04	90.37	83.61
Total Debt / EV	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Market Cap	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Sales	70,395	74,754	78,812	83,176	88,519	94,595	100,904	108,203	110,225	132,110	151,157	157,403	152,669	159,514	164,683
TTM EBITDA	8,343	9,450	10,923	12,255	13,637	15,400	16,743	17,682	18,139	20,797	25,902	27,014	24,936	25,287	25,011
TTM Operating Income	6,661	7,766	9,166	10,469	11,774	13,427	14,681	15,777	15,843	18,278	23,040	24,039	21,689	21,526	20,890
TTM Cash Flow to Firm	7,039	7,372	8,080	8,770	9,957	10,402	12,697	13,968	14,605	19,860	17,589	15,846	22,649	21,581	18,161
TTM Free Cash Flow to Firm	7,039	7,372	8,080	8,770	9,957	10,402	12,697	13,968	14,605	19,860	17,589	15,846	22,649	21,581	18,161

Multiples (USD)

Valuation Multiples API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2012	01/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Price/Free Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Low Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	7.6
EV/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Last Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	8.17
High Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	8.25
Enterprise Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Per Share Data Items (USD)

Per-Share Data API ChatGPT

No data availableFinancial data will appear here once available