Financials The Home Depot, Inc.

Equities

HD

US4370761029

Home Improvement Products & Services Retailers

Market Closed - Nyse Other stock markets 04:00:02 2025-06-13 pm EDT			5-day change	1st Jan Change
354.66 ^USD	-2.34%		-3.45%	-8.83%

Jun. 04	Home Depot Insider Sold Shares Worth $3,289,951, According to a Recent SEC Filing	MT
May. 30	Home Depot Insider Sold Shares Worth $1,996,328, According to a Recent SEC Filing	MT

Projected Income Statement: The Home Depot, Inc.

Fiscal Period: February	2021	2022	2023	2024	2025	2026	2027	2028
Net sales ¹	132,110	151,157	157,403	152,669	159,514	164,421	171,055	177,930
Change	-	14.42%	4.13%	-3.01%	4.48%	3.08%	4.04%	4.02%
EBITDA ¹	20,907	25,902	27,014	24,936	24,560	25,417	26,911	28,462
Change	-	23.89%	4.29%	-7.69%	-1.51%	3.49%	5.88%	5.76%
EBIT ¹	18,388	23,040	24,039	21,689	21,526	21,838	23,260	24,603
Change	-	25.3%	4.34%	-9.78%	-0.75%	1.45%	6.51%	5.77%
Interest Paid ¹	-1,300	-1,303	-1,562	-1,765	-2,120	-2,232	-2,051	-2,122
Earnings before Tax (EBT) ¹	16,978	21,737	22,477	19,924	19,406	19,377	20,958	22,591
Change	-	28.03%	3.4%	-11.36%	-2.6%	-0.15%	8.16%	7.79%
Net income ¹	12,866	16,433	17,105	15,143	14,806	14,585	15,736	17,158
Change	-	27.72%	4.09%	-11.47%	-2.23%	-1.49%	7.89%	9.04%
Announcement Date	2/23/21	2/22/22	2/21/23	2/20/24	2/25/25	-	-	-

¹USD in Million

Estimates

Fiscal Period: February	2021 Q2	2021 Q3	2021 Q4	2022 Q1	2022 Q2	2022 Q3	2022 Q4	2023 Q1	2023 Q2	2023 Q3	2023 Q4	2024 Q1	2024 Q2	2024 Q3	2024 Q4	2025 Q1	2025 Q2	2025 Q3	2025 Q4	2026 Q1	2026 Q2	2026 Q3	2026 Q4	2027 Q1	2027 Q2	2027 Q3	2027 Q4	2028 Q1
Net sales ¹	38,053	33,536	32,261	37,500	41,118	36,820	35,719	38,908	43,792	38,872	35,831	37,257	42,916	37,710	34,786	36,418	43,175	40,217	39,704	39,856	45,433	41,042	38,057	41,358	47,325	42,928	39,688	43,274
Change	-	-11.87%	-3.8%	16.24%	9.65%	-10.45%	-2.99%	8.93%	12.55%	-11.23%	-7.82%	3.98%	15.19%	-12.13%	-7.75%	4.69%	18.55%	-6.85%	-1.28%	0.38%	13.99%	-9.67%	-7.27%	8.67%	14.43%	-9.29%	-7.55%	9.04%
EBITDA ¹	6,682	5,483	4,859	6,484	7,350	6,509	5,559	6,656	7,956	6,891	5,511	6,344	7,384	6,233	4,975	5,916	7,402	6,275	5,309	6,127	7,659	6,440	5,105	6,550	8,189	6,899	5,506	7,187
Change	-	-17.94%	-11.38%	33.44%	13.36%	-11.44%	-14.6%	19.73%	19.53%	-13.39%	-20.03%	15.12%	16.39%	-15.59%	-20.18%	18.91%	25.12%	-15.23%	-15.39%	15.41%	25.01%	-15.92%	-20.73%	28.3%	25.02%	-15.75%	-20.19%	30.53%
EBIT ¹	6,067	4,852	4,193	5,781	6,639	5,795	4,825	5,929	7,210	6,148	4,752	5,551	6,589	5,406	4,143	5,079	6,624	5,418	4,495	5,133	6,720	5,578	4,312	5,573	7,157	6,004	4,621	6,053
Change	-	-20.03%	-13.58%	37.87%	14.84%	-12.71%	-16.74%	22.88%	21.61%	-14.73%	-22.71%	16.81%	18.7%	-17.95%	-23.36%	22.59%	30.42%	-18.21%	-17.04%	14.19%	30.92%	-16.99%	-22.69%	29.23%	28.42%	-16.11%	-23.03%	30.98%
Charge d'intérêts ¹	-337	-329	-327	-333	-321	-326	-323	-369	-379	-406	-408	-441	-428	-487	-458	-428	-489	-625	-608	-591	-579.2	-547.9	-525	-493.3	-492.7	-490.2	-485.8	-
Earnings before Tax (EBT) ¹	5,730	4,523	3,756	5,448	6,318	5,469	4,502	5,560	6,831	5,742	4,344	5,110	6,161	4,968	3,685	4,651	6,045	4,823	3,887	4,542	6,159	4,961	3,616	5,175	6,878	5,501	3,964	5,559
Change	-	-21.06%	-16.96%	45.05%	15.97%	-13.44%	-17.68%	23.5%	22.86%	-15.94%	-24.35%	17.63%	20.57%	-19.36%	-25.83%	26.21%	29.97%	-20.22%	-19.41%	16.85%	35.59%	-19.45%	-27.1%	43.1%	32.91%	-20.01%	-27.95%	40.24%
Net income ¹	4,332	3,432	2,857	4,145	4,807	4,129	3,352	4,231	5,173	4,339	3,362	3,873	4,659	3,810	2,801	3,600	4,561	3,648	2,997	3,433	4,608	3,746	2,794	3,823	5,201	4,144	2,718	4,225
Change	-	-20.78%	-16.75%	45.08%	15.97%	-14.1%	-18.82%	26.22%	22.26%	-16.12%	-22.52%	15.2%	20.29%	-18.22%	-26.48%	28.53%	26.69%	-20.02%	-17.85%	14.55%	34.23%	-18.71%	-25.42%	36.85%	36.04%	-20.32%	-34.41%	55.45%
Announcement Date	8/18/20	11/17/20	2/23/21	5/18/21	8/17/21	11/16/21	2/22/22	5/17/22	8/16/22	11/15/22	2/21/23	5/16/23	8/15/23	11/14/23	2/20/24	5/14/24	8/13/24	11/12/24	2/25/25	5/20/25	-	-	-	-	-	-	-	-

¹USD in Million

Estimates

Forecast Balance Sheet: The Home Depot, Inc.

Fiscal Period: February	2021	2022	2023	2024	2025	2026	2027	2028
Net Debt ¹	29,343	37,743	40,436	40,351	51,408	48,238	46,731	47,802
Change	-	28.63%	7.14%	-0.21%	27.4%	-6.17%	-3.12%	2.29%
Announcement Date	2/23/21	2/22/22	2/21/23	2/20/24	2/25/25	-	-	-

¹USD in Million

Estimates

Cash Flow Forecast: The Home Depot, Inc.

Fiscal Period: February	2021	2022	2023	2024	2025	2026	2027	2028
CAPEX ¹	2,463	2,566	3,119	3,226	3,485	3,824	3,788	3,873
Change	-	4.18%	21.55%	3.43%	8.03%	9.73%	-0.95%	2.25%
Free Cash Flow (FCF) ¹	16,376	14,005	11,496	17,946	16,325	14,855	16,347	16,655
Change	-	-14.48%	-17.92%	56.11%	-9.03%	-9.01%	10.05%	1.88%
Announcement Date	2/23/21	2/22/22	2/21/23	2/20/24	2/25/25	-	-	-

¹USD in Million

Estimates

Forecast Financial Ratios: The Home Depot, Inc.

Fiscal Period: February	2021	2022	2023	2024	2025	2026	2027	2028
Profitability
EBITDA Margin (%)	15.83%	17.14%	17.16%	16.33%	15.4%	15.46%	15.73%	16%
EBIT Margin (%)	13.92%	15.24%	15.27%	14.21%	13.49%	13.28%	13.6%	13.83%
EBT Margin (%)	12.85%	14.38%	14.28%	13.05%	12.17%	11.78%	12.25%	12.7%
Net margin (%)	9.74%	10.87%	10.87%	9.92%	9.28%	8.87%	9.2%	9.64%
FCF margin (%)	12.4%	9.27%	7.3%	11.75%	10.23%	9.03%	9.56%	9.36%
FCF / Net Income (%)	127.28%	85.22%	67.21%	118.51%	110.26%	101.85%	103.89%	97.07%
Profitability
ROA	21.12%	23.07%	23.06%	19.8%	17.15%	15.45%	16.57%	16%
ROE	458.03%	2,050.28%	-	1,162.16%	385.37%	154.95%	113.84%	110.11%
Financial Health
Leverage (Debt/EBITDA)	1.4x	1.46x	1.5x	1.62x	2.09x	1.9x	1.74x	1.68x
Debt / Free cash flow	1.79x	2.69x	3.52x	2.25x	3.15x	3.25x	2.86x	2.87x
Capital Intensity
CAPEX / Current Assets (%)	1.86%	1.7%	1.98%	2.11%	2.18%	2.33%	2.21%	2.18%
CAPEX / EBITDA (%)	11.78%	9.91%	11.55%	12.94%	14.19%	15.05%	14.08%	13.61%
CAPEX / FCF (%)	15.04%	18.32%	27.13%	17.98%	21.35%	25.74%	23.17%	23.25%
Items per share
Cash flow per share ¹	17.48	15.66	14.26	21.13	19.95	18.83	22.58	25.15
Change	-	-10.38%	-8.96%	48.19%	-5.59%	-5.59%	19.91%	11.34%
Dividend per Share ¹	6.15	7.6	-	8.52	9	9.216	9.804	10.53
Change	-	23.58%	-	-	5.63%	2.4%	6.38%	7.44%
Book Value Per Share ¹	3.063	-1.639	-	1.042	6.687	12.78	14.69	17.41
Change	-	-153.49%	-	-	541.79%	91.07%	14.96%	18.56%
EPS ¹	11.94	15.53	16.69	15.11	14.91	14.63	15.95	17.38
Change	-	30.07%	7.47%	-9.47%	-1.32%	-1.87%	9.03%	8.94%
Nbr of stocks (in thousands)	1,076,601	1,044,239	1,019,186	995,262	993,363	994,928	994,928	994,928
Announcement Date	2/23/21	2/22/22	2/21/23	2/20/24	2/25/25	-	-	-