1.

- beta rl rm CAPM ru
1.0458606516 0.016259 0.14494984 15.09% 15.09%

2.- Market Debt 41,611.23

Market Cap 348,592.59
rd 0.02276149 Costo de deuda
rlevered 0.10% Costo de capital apalancado
EV 390,203.82
D/EV 0.106639738789428
E/EV 0.893360261210572
3.- WACC 0.33% WACC sin impuestos MM

4.- WACC 0.33% WACC apalancado por impuestos

tx 0.00%
Columna1
5.- a SWAP DEUDA 10,000 RESUMEN

Market Debt 51,611.23

Market Cap 338,592.59 WACC
rd 0.02
rlevered
EV 390,203.82
D/EV 0.132267370782712
E/EV 0.867732629217288
WACC 0.003010602437397 sin impuestos

b SWAP DE ACCIONES

Market Debt
Market Cap
rd 0.02276149
rlevered 16.1893462316486
EV 0.00
D/EV #DIV/0!
E/EV #DIV/0!
WACC #DIV/0! sin impuestos
Columna2 Columna3

sin tx con tx
HOME DEPOT INC
30-Apr-2021 15:15

Debt Structure
Include Subsidiaries: YES, Include Depositary Receipts: NO, Currency: U.S. Dollar

Issuer Description
Issuer Descri HOME DEPOT INC
Immediate Pa--
Ultimate Pare--

Debt Structure
Name Issues Outstanding Issued
Bonds 29 33400000000 33400000000
Bonds to Be I 0 0 0
Bonds (as Bo 0 0 0
Bonds (as Bor 0 0 0
Loans 30 4070000000
Total 32 33400000000 37470000000
Inactive Bond 548 0 42872484008.2

valor de mer 37541.23385

prestamos 4070
total market 41611.23385
TimeToMaturiPercentYield
360d 0.231614 0.00231614
720d 0.485291 0.00485291
1080d 0.712289 0.00712289
1440d 0.941224 0.00941224
1800d 1.180664 0.01180664
2160d 1.425538 0.01425538
2520d 1.666282 0.01666282
2880d 1.891905 0.01891905
3240d 2.095701 0.02095701
3600d 2.276149 0.02276149
4320d 2.570293 0.02570293
5400d 2.867715 0.02867715
7200d 3.095676 0.03095676
9000d 3.142359 0.03142359
10800d 3.122232 0.03122232
TimeToMaturiPercentYield
30d 0.0101 0.000101
60d 0.0101 0.000101
90d 0.0127 0.000127
180d 0.0304 0.000304
360d 0.0507 0.000507
720d 0.1623 0.001623
1080d 0.335 0.00335
1800d 0.8541 0.008541
2520d 1.3133 0.013133
3600d 1.6259 0.016259
7200d 2.1765 0.021765
10800d 2.2952 0.022952
#NAME?
HD .SPX
PERCENT_CHG(TR.Pr
PERCENT_CHG(TR.PriceClose(SDate
3/31/2021 18.15824107765 4.24386340081077
2/26/2021 -4.608226866553 2.60914749719997
1/29/2021 1.9576839093442 -1.11366401584636
12/31/2020 -4.250027035795 3.71214066594324
11/30/2020 4.0118480746879 10.7545658050863
10/30/2020 -3.96096647582 -2.76657746060065
9/30/2020 -2.57156890261 -3.92279540954944
8/31/2020 7.3637425138423 7.00646873242192
7/31/2020 5.9798012055407 5.51012969754442
6/30/2020 0.8169671603348 1.83884032835027
5/29/2020 13.032798071237 4.52817750126184
4/30/2020 17.738739221252 12.6844102933154
3/31/2020 -14.29030481087 -12.5119320835957
2/28/2020 -4.498027181061 -8.41104690096481
1/31/2020 4.4509570473487 -0.162808981112927
12/31/2019 -0.965942587638 2.85898031824463
11/29/2019 -5.997953789752 3.40470640909151
10/31/2019 1.1033531592104 2.04317474821449
9/30/2019 1.8033434250362 1.71811676906569
8/30/2019 6.654499508634 -1.80916527422678
7/31/2019 2.7503966918306 1.31281953660393
6/28/2019 9.5443771398473 6.8930183208215
5/31/2019 -6.799214531173 -6.57777264811615
4/30/2019 6.1545677210902 3.93134349421394
3/29/2019 3.6458895970617 1.79242877510784
2/28/2019 0.8772407780744 2.9728930143116
1/31/2019 6.8152717960657 7.8684404731037
12/31/2018 -4.713842058563 -9.17769557672173
11/30/2018 2.5244484876052 1.78593817991401
10/31/2018 -15.09534153995 -6.94033589798146
9/28/2018 3.1777656024306 0.429430091813947
8/31/2018 1.6454029971648 3.0263218631604
7/31/2018 1.2403895438237 3.60215864654186
6/29/2018 4.5832216563924 0.484240020404614
5/31/2018 0.9469696969697 2.16083533165914
4/30/2018 3.6804308797128 0.271880100118533
3/29/2018 -2.211005650957 -2.68845137683643
2/28/2018 -9.273270283723 -3.89473796041518
1/31/2018 5.9990502822772 5.61787246457037
12/29/2017 5.3998442887332 0.983161981885352
11/30/2017 8.4690553745928 2.80826013684054
 10/31/2017 1.3573000733676 2.2188174774546
9/29/2017 9.1345833055315 1.93028948273421
8/31/2017 0.1804812834225 0.05464923288669
7/31/2017 -2.477183833116 1.93487688835155
6/30/2017 -0.071656569605 0.481383199270241
5/31/2017 -1.659192825112 1.15762100494926
4/28/2017 6.3134236872574 0.9091216902553
3/31/2017 1.3249603201988 -0.038923017041515
2/28/2017 5.3278092746039 3.71982605414087
1/31/2017 2.6103818615752 1.78843413747359
12/30/2016 3.6166924265842 1.8200754044233
11/30/2016 6.0568805835587 3.41744467699832
10/31/2016 -5.183400683867 -1.94256250374722
9/30/2016 -4.056069191769 -0.123448259978343
8/31/2016 -2.980324074074 -0.121917556128087
7/29/2016 8.2621975095936 3.56098072286859
6/30/2016 -3.353012412958 0.09060735540974
5/31/2016 -1.32198073045 1.53294920834745
4/29/2016 NaN NaN

REND PROMEDIO MES 0.0159953381692 0.01207915359497

DESVIACION MENSUAL 0.0629300965051 0.043300423847187

REND PROMEDIO ANNUAL 0.19194405803 0.144949843139639

DESVIACION ANNUAL 0.2179962489442 0.14999706818519
BETA 1.0458606516303

Precio de accion 30 de abril 2021 323.67

HG(TR.PriceClose(SDate=0,Curn=USD,Frq=M,EDate=-59),,lag=-1D)
Home Depot Inc | Balance Sheet                                30-Apr-2021 15:13

Balance Sheet
Annual Standardised in Millions of U.S. Dollars
2021 2020 2019 2018
Earnings Quality Score 91  93  86  95 
Period End Date 31-Jan-2021  02-Feb-2020  03-Feb-2019  28-Jan-2018 
Assets ($ Millions)
Cash and Short Term Investments 7,895 2,133 1,778 3,595
Cash & Equivalents 7,895 2,133 1,778 3,595
Accounts Receivable - Trade, Net 2,992 2,106 1,936 1,952
Total Receivables, Net 2,992 2,106 1,936 1,952
Total Inventory 16,627 14,531 13,925 12,748
Prepaid Expenses -- -- -- --
Other Current Assets, Total 963 1,040 890 638
Deferred Income Tax - Current Asset -- -- -- --
Other Current Assets 963 1,040 890 638
Total Current Assets 28,477 19,810 18,529 18,933

Property/Plant/Equipment, Total - Gross 54,763 50,455 42,939 41,414

Buildings - Gross 20,763 20,221 19,904 19,710
Land/Improvements - Gross 8,543 8,390 8,363 8,352
Construction in Progress - Gross 1,068 1,005 820 538
Other Property/Plant/Equipment - Gross 24,389 20,839 13,852 12,814
Property/Plant/Equipment, Total - Net 30,667 28,365 22,375 22,075
Accumulated Depreciation, Total (24,096) (22,090) (20,564) (19,339)
Goodwill, Net 7,126 2,254 2,252 2,275
Intangibles, Net -- -- -- --
Long Term Investments -- -- -- --
Note Receivable - Long Term -- -- -- --
Other Long Term Assets, Total 4,311 807 847 1,246
Defered Income Tax - Long Term Asset -- -- 121 119
Other Long Term Assets 4,311 807 726 1,127
Total Assets 70,581 51,236 44,003 44,529

Liabilities ($ Millions)
Accounts Payable 11,606 7,787 7,755 7,244
Payable/Accrued -- -- -- --
Accrued Expenses 7,128 5,604 4,773 4,330
Notes Payable/Short Term Debt 0 974 1,339 1,559
Current Port. of LT Debt/Capital Leases 1,416 1,839 1,056 1,202
Other Current liabilities, Total 3,016 2,171 1,793 1,859
Customer Advances 2,823 2,116 1,782 1,805
Income Taxes Payable 193 55 11 54
 Deferred Income Tax - Current Liability -- -- -- --
Total Current Liabilities 23,166 18,375 16,716 16,194

Total Long Term Debt 35,822 28,670 26,807 24,267

Long Term Debt 33,122 27,589 26,807 24,267
Capital Lease Obligations 2,700 1,081 -- --
Total Debt 37,238 31,483 29,202 27,028
Deferred Income Tax 1,131 706 491 440
Deferred Income Tax - LT Liability 1,131 706 491 440
Minority Interest -- -- -- --
Other Liabilities, Total 7,163 6,601 1,867 2,174
Other Long Term Liabilities 7,163 6,601 1,867 2,174
Total Liabilities 67,282 54,352 45,881 43,075

Shareholders Equity ($ Millions)

Redeemable Preferred Stock, Total -- -- -- --
Preferred Stock - Non Redeemable, Net -- -- -- --
Common Stock, Total 89 89 89 89
Common Stock 89 89 89 89
Additional Paid-In Capital 11,540 11,001 10,578 10,192
Retained Earnings (Accumulated Deficit) 58,134 51,729 46,423 39,935
Treasury Stock - Common (65,793) (65,196) (58,196) (48,196)
ESOP Debt Guarantee -- -- -- --
Unrealized Gain (Loss) -- -- -- --
Other Equity, Total (671) (739) (772) (566)
Other Comprehensive Income (671) (739) (772) (566)
Total Equity 3,299 (3,116) (1,878) 1,454

Total Liabilities & Shareholders' Equity 70,581 51,236 44,003 44,529

Supplemental ($ Millions)
Shares Outstanding - Common Issue 2 -- -- -- --
Shares Outstanding - Common Issue 3 -- -- -- --
Shares Outstanding - Common Issue 4 -- -- -- --
Total Common Shares Outstanding 1,077 1,077 1,105 1,158
Shares Outs - Common Stock Primary Issue 1,077 1,077 1,105 1,158
Treas Shares - Common Stock Prmry Issue 712 709 677 622
Treasury Shares - Common Issue 2 -- -- -- --
Treasury Shares - Common Issue 3 -- -- -- --
Treasury Shares - Common Issue 4 -- -- -- --
Total Preferred Shares Outstanding -- -- -- --
Treasury Shares - Preferred Issue 1 -- -- -- --
Treasury Shares - Preferred Issue 2 -- -- -- --
Treasury Shares - Preferred Issue 3 -- -- -- --
Treasury Shares - Preferred Issue 4 -- -- -- --
Treasury Shares - Preferred Issue 5 -- -- -- --
Treasury Shares - Preferred Issue 6 -- -- -- --
Minority Interest - Redeemable -- -- -- --
Minority Interest - Non Redeemable -- -- -- --
Total Equity & Minority Interest 3,299 (3,116) (1,878) 1,454
Full-Time Employees 504,800 415,700 413,000 413,000
Part-Time Employees -- -- -- --
Number of Common Shareholders 116,000 121,000 110,000 2,053,000
Other Property/Plant/Equipment - Net -- -- -- --
Intangibles - Net -- -- -- --
Goodwill - Net 7,126 2,254 2,252 2,275
Accumulated Goodwill Amortization Suppl. -- -- -- --
Accumulated Intangible Amort, Suppl. -- -- -- --
Wgt Avg Rem Lease Term (Yrs)-Oper Lease 10 -- -- --
Wgt Avg Rem Lease Term (Yrs)-Fin Lease 15 -- -- --
Wgt Avg Disc Rate - Operating Lease 3 -- -- --
Wgt Avg Disc Rate - Finance Lease 6 -- -- --
Right-of-Use Assets-Cap.Lease,Net-Suppl. -- -- -- --
Right-of-Use Assets-Cap.Lease,Gross-Sup. 3,308 1,578 1,392 1,308
Right-of-Use Assets-Cap.Lease,Depr.-Sup. 815 644 -- --
Right-of-Use Assets-Op.Lease, Net-Suppl. 5,962 5,595 -- --
Right-of-Use Assets-Op.Lease, Gross-Sup. 5,962 5,595 -- --
Right-of-Use Assets-Op.Lease, Depr.-Sup. -- -- -- --
Non-Current Marketable Securities,Suppl. -- -- -- --
Contract Assets - Short Term -- -- -- --
Contract Assets - Long Term -- -- -- --
Deferred Revenue - Current 2,823 2,116 1,782 1,805
Deferred Revenue - Long Term -- -- -- --
Short Term Debt Financial Sector, Suppl. -- -- -- --
Curr Port - LTD/Cap Lse Fin Sec., Suppl. -- -- -- --
Long Term Debt Financial Sector, Suppl. -- -- -- --
Capital Lease Oblig. - Fin Sector, Suppl -- -- -- --
Curr. Port. of LT Capital Leases, Suppl. 66 84 -- --
Curr Port of LT Operating Leases, Suppl. 828 828 -- --
Long-Term Operating Lease Liabs., Suppl. 5,356 5,066 -- --
Curr Derivative Liab. Hedging, Suppl. -- -- -- --
Curr Derivative Liab. Spec./Trdg, Suppl. -- -- -- --
Non-Curr Derivative Liab. Hedging, Suppl -- -- -- --
Non-Curr Derivative Liab Spec/Trdg Suppl -- -- -- --
Leverage Ratio (Basel 3) -- -- -- --
Net Stable Funding Ratio (Basel 3) -- -- -- --
Liquidity Coverage Ratio (Basel 3) -- -- -- --
Capital Adequacy - Core Tier 1 (Value) -- -- -- --
Capital Adequacy - Hybrid Tier 1 (Value) -- -- -- --
Capital Adequacy -Tier 1 Capital (Value) -- -- -- --
Capital Adequacy -Tier 2 Capital (Value) -- -- -- --
Capital Adequacy -Tier 3 Capital (Value) -- -- -- --
Capital Adequacy - Total Capital (Value) -- -- -- --
Total Risk-Weighted Capital -- -- -- --
Capital Adequacy - Core Tier 1 Capital % -- -- -- --
Capital Adequacy - Tier 1 Capital % -- -- -- --
Capital Adequacy - Tier 2 Capital % -- -- -- --
Capital Adequacy - Tier 3 Capital % -- -- -- --
Capital Adequacy - Total Capital % -- -- -- --
Trading Account -- -- -- --
Credit Exposure -- -- -- --
Non-Performing Loans -- -- -- --
Assets under Management -- -- -- --
Loans - Stage 1 - Gross, Total -- -- -- --
Loans - Stage 2 - Gross, Total -- -- -- --
Loans - Stage 3 - Gross, Total -- -- -- --
Total Current Assets less Inventory 11,850 5,279 4,604 6,185
Revolving Line of Credit - Outstanding -- -- -- --
Rvlvng Line of Credit - Principal Amount -- -- -- --
Rvlvng Line of Credit - Unused Amount -- -- -- --
Net Debt Incl. Pref.Stock & Min.Interest 29,343 29,350 27,424 23,433
Tangible Book Value, Common Equity (3,827) (5,370) (4,130) (821)
Reported Total Assets -- -- -- --
Reported Total Liabilities -- -- -- --
Shareholders' Equity Excl. Stock Subscr. -- -- -- --
Reported Shareholder's Equity -- -- -- --
Reported Net Assets -- -- -- --
Reported Net Assets to Total Assets -- -- -- --
Reported Return on Assets -- -- -- --
Reported Return on Equity -- -- -- --
Islamic Investments & Deposits -- -- -- --
Islamic Receivables -- -- -- --
Islamic Debt -- -- -- --
Islamic Section, Supplemental -- -- -- --
Debt & Lease, Pension Items ($ Millions)
Total Long Term Debt, Supplemental 34,750 29,500 27,100 24,750
Long Term Debt Maturing within 1 Year 1,350 1,750 1,000 1,150
Long Term Debt Maturing in Year 2 2,250 2,350 1,750 1,000
Long Term Debt Maturing in Year 3 1,000 2,250 2,350 1,750
Long Term Debt Maturing in Year 4 1,100 1,000 2,250 2,350
 Long Term Debt Maturing in Year 5 1,000 1,100 1,000 1,250
Long Term Debt Maturing in 2-3 Years 3,250 4,600 4,100 2,750
Long Term Debt Maturing in 4-5 Years 2,100 2,100 3,250 3,600
Long Term Debt Matur. in Year 6 & Beyond 28,050 21,050 18,750 17,250
Total Capital Leases, Supplemental 2,766 1,165 1,049 984
Interest Costs (927) (608) (660) (769)
Capital Lease Payments Due in Year 1 272 172 150 147
Capital Lease Payments Due in Year 2 285 171 167 142
Capital Lease Payments Due in Year 3 280 170 143 156
Capital Lease Payments Due in Year 4 273 164 142 132
Capital Lease Payments Due in Year 5 317 148 137 132
Capital Lease Payments Due in 2-3 Years 565 341 310 298
Capital Lease Payments Due in 4-5 Years 590 312 279 264
Cap. Lease Pymts. Due in Year 6 & Beyond 2,266 948 970 1,044
Total Operating Leases, Supplemental 6,184 5,894 7,036 7,138
Operating Lease Payments Due in Year 1 955 955 976 921
Operating Lease Payments Due in Year 2 960 875 912 869
Operating Lease Payments Due in Year 3 854 772 792 786
Operating Lease Payments Due in Year 4 738 677 682 696
Operating Lease Payments Due in Year 5 614 579 584 580
Operating Lease Pymts. Due in 2-3 Years 1,814 1,647 1,704 1,655
Operating Lease Pymts. Due in 4-5 Years 1,352 1,256 1,266 1,276
Oper. Lse. Pymts. Due in Year 6 & Beyond 2,063 2,036 3,090 3,286
Operating Leases - Interest Cost (938) (786) -- --
Total Funded Status -- -- -- --
Period End Assumptions -- -- -- --
Net Assets Recognized on Balance Sheet -- -- -- --
Asset Allocation -- -- -- --
Total Plan Obligations -- -- -- --
Total Plan Assets -- -- -- --
 2017 2016 2015
91  91  92 
29-Jan-2017  31-Jan-2016  01-Feb-2015 

2,538 2,216 1,723

2,538 2,216 1,723
2,029 1,890 1,484
2,029 1,890 1,484
12,549 11,809 11,079
-- -- --
608 569 1,016
-- -- 444
608 569 572
17,724 16,484 15,302

40,426 39,266 38,513

19,291 -- 19,178
8,207 -- 8,243
739 -- 585
12,189 39,266 10,507
21,914 22,191 22,720
(18,512) (17,075) (15,793)
2,093 2,102 1,353
-- -- --
-- -- --
-- -- --
1,235 1,196 571
91 -- 51
1,144 1,196 520
42,966 41,973 39,946

7,000 6,565 5,807

-- -- --
4,187 3,932 3,630
710 350 290
542 77 38
1,694 1,600 1,504
1,669 1,566 1,468
25 34 35
 -- -- 1
14,133 12,524 11,269

22,349 20,789 16,869

22,349 20,789 16,869
-- -- --
23,601 21,216 17,197
296 379 642
296 379 642
-- -- --
1,855 1,965 1,844
1,855 1,965 1,844
38,633 35,657 30,624

-- -- --
-- -- --
88 88 88
88 88 88
9,787 9,347 8,885
35,519 30,973 26,995
(40,194) (33,194) (26,194)
-- -- --
-- -- --
(867) (898) (452)
(867) (898) (452)
4,333 6,316 9,322

42,966 41,973 39,946

-- -- --
-- -- --
-- -- --
1,203 1,252 1,307
1,203 1,252 1,307
573 520 461
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
 -- -- --
-- -- --
-- -- --
-- -- --
-- -- --
4,333 6,316 9,322
406,000 385,000 371,000
-- -- --
1,633,000 1,477,000 1,448,000
-- -- --
-- -- --
2,093 2,102 1,353
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
1,169 -- 905
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
1,669 1,566 1,468
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
 -- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
5,175 4,675 4,223
-- -- --
-- -- --
-- -- --
21,063 19,000 15,474
2,240 4,214 7,969
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --

22,915 -- 16,875
542 -- 38
1,200 -- 3,100
1,000 -- 37
573 -- 1,200
 2,400 -- 1,000
2,200 -- 3,137
2,973 -- 2,200
17,200 -- 11,500
878 -- 684
(758) -- (726)
130 -- 113
127 -- 111
124 -- 108
141 -- 101
118 -- 97
251 -- 219
259 -- 198
996 -- 880
7,453 -- 7,705
907 -- 893
826 -- 817
746 -- 737
661 -- 638
586 -- 561
1,572 -- 1,554
1,247 -- 1,199
3,727 -- 4,059
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
Home Depot Inc | Income Statement                                30-Apr-2021 15:14

Income Statement
Annual Standardised in Millions of U.S. Dollars
2021 2020 2019 2018
Earnings Quality Score 91  93  86  95 
Period End Date 31-Jan-2021  02-Feb-2020  03-Feb-2019  28-Jan-2018 
Revenue 132,110 110,225 108,203 100,904
Net Sales 132,110 110,225 108,203 100,904
Other Revenue, Total -- -- -- --
Total Revenue 132,110 110,225 108,203 100,904
Cost of Revenue, Total 87,257 72,653 71,043 66,548
Cost of Revenue 87,257 72,653 71,043 66,548
Gross Profit 44,853 37,572 37,160 34,356

Selling/General/Admin. Expenses, Total 22,447 19,740 19,513 17,864

Selling/General/Administrative Expense 22,447 19,740 19,513 17,864
Research & Development -- -- -- --
Depreciation/Amortization 2,128 1,989 1,870 1,811
Depreciation 2,128 1,989 1,870 1,811
Interest Expense, Net - Operating -- -- -- --
Interest/Investment Income - Operating -- -- -- --
Interest Expense(Income) - Net Operating -- -- -- --
Interest Exp.(Inc.),Net-Operating, Total -- -- -- --
Unusual Expense (Income) 2,000 0 247 --
Impairment-Assets Held for Use 0 0 247 --
Other Unusual Expense (Income) 2,000 -- -- --
Other Operating Expenses, Total -- -- -- --
Total Operating Expense 113,832 94,382 92,673 86,223
Operating Income 18,278 15,843 15,530 14,681
Interest Expense, Net Non-Operating (1,347) (1,201) (1,051) (1,057)
Interest Expense - Non-Operating (1,347) (1,201) (1,051) (1,057)
Interest/Invest Income - Non-Operating 47 73 93 74
Interest Income - Non-Operating 47 73 93 74
Interest Income(Exp), Net Non-Operating -- -- -- --
Interest Inc.(Exp.),Net-Non-Op., Total (1,300) (1,128) (958) (983)
Gain (Loss) on Sale of Assets -- -- -- --
Other, Net 0 0 (16) --
Other Non-Operating Income (Expense) 0 0 (16) --
Net Income Before Taxes 16,978 14,715 14,556 13,698
Provision for Income Taxes 4,112 3,473 3,520 4,941
Net Income After Taxes 12,866 11,242 11,036 8,757
Minority Interest -- -- -- --
Equity In Affiliates -- -- -- --
U.S. GAAP Adjustment -- -- -- --
Net Income Before Extra. Items 12,866 11,242 11,036 8,757

Accounting Change -- -- -- --
Discontinued Operations -- -- -- --
Extraordinary Item -- 0 85 (127)
Tax on Extraordinary Items -- -- -- --
Total Extraordinary Items -- 0 85 (127)
Net Income 12,866 11,242 11,121 8,630

Preferred Dividends -- -- -- --
General Partners' Distributions -- -- -- --
Miscellaneous Earnings Adjustment -- -- -- --
Pro Forma Adjustment -- -- -- --
Interest Adjustment - Primary EPS -- -- -- --
Total Adjustments to Net Income -- -- -- --
Income Available to Com Excl ExtraOrd 12,866 11,242 11,036 8,757
Income Available to Com Incl ExtraOrd 12,866 11,242 11,121 8,630
Basic Weighted Average Shares 1,074 1,093 1,137 1,178
Basic EPS Excluding Extraordinary Items 11.98 10.29 9.71 7.43
Basic EPS Including Extraordinary Items 11.98 10.29 9.78 7.33
Dilution Adjustment -- -- -- --
Diluted Net Income 12,866 11,242 11,121 8,630
Diluted Weighted Average Shares 1,078 1,097 1,143 1,184
Diluted EPS Excluding ExtraOrd Items 11.94 10.25 9.66 7.40
Diluted EPS Including ExtraOrd Items 11.94 10.25 9.73 7.29
Supplemental ($ Millions)
DPS - Common Stock Primary Issue 6.00 5.44 4.12 3.56
Dividends per Share - Com Stock Issue 2 -- -- -- --
Dividends per Share - Com Stock Issue 3 -- -- -- --
Dividends per Share - Com Stock Issue 4 -- -- -- --
Special DPS - Common Stock Primary Issue -- -- -- --
Special DPS - Common Stock Issue 2 -- -- -- --
Special DPS - Common Stock Issue 3 -- -- -- --
Special DPS - Common Stock Issue 4 -- -- -- --
Gross Dividends - Common Stock 6,451 5,958 4,704 4,212
Pro Forma Stock Compensation Expense -- -- -- --
Net Income after Stock Based Comp. Exp. -- -- -- --
Basic EPS after Stock Based Comp. Exp. -- -- -- --
Diluted EPS after Stock Based Comp. Exp. -- -- -- --
(Gain) Loss on Sale of Assets, Suppl. -- -- -- --
Impairment-Assets Held for Sale, Suppl. -- -- -- --
Impairment-Assets Held for Use, Suppl. -- -- -- --
Litigation Charge, Supplemental -- -- -- --
Purchased R&D Written-Off, Supplemental -- -- -- --
Restructuring Charge, Supplemental -- -- -- --
Other Unusual Expense(Income), Suppl. -- -- -- --
Non-Recurring Items, Supplemental, Total -- -- -- --
Total Special Items 2,000 0 247 --
Normalized Income Before Taxes 18,978 14,715 14,803 13,698
Effect of Special Items on Income Taxes 484 0 60 --
Inc Tax Ex Impact of Sp Items 4,596 3,473 3,580 4,941
Normalized Income After Taxes 14,382 11,242 11,223 8,757
Normalized Inc. Avail to Com. 14,382 11,242 11,223 8,757
Basic Normalized EPS 13.39 10.29 9.87 7.43
Diluted Normalized EPS 13.34 10.25 9.82 7.40
EPS, Supplemental -- -- -- --
Funds From Operations - REIT -- -- -- --
Amort of Acquisition Costs, Supplemental -- -- -- --
Amort of Intangibles, Supplemental -- -- -- --
Amort. of Right-of-Use Intang.Assets,Sup -- -- -- --
Depreciation, Supplemental 2,519 2,296 2,152 2,062
Depreciation of Right-of-Use Assets,Sup. 167 86 -- --
Interest Expense, Supplemental 1,347 1,201 1,051 1,057
Interest Capitalized, Supplemental -- -- -- (2)
Interest Expense on Lease Liabs., Suppl. 112 92 -- --
Interest Expense (Financial Oper), Suppl -- -- -- --
Net Revenues -- -- -- --
Rental Expense, Supplemental 782 1,166 1,091 1,053
Labor & Related Expense Suppl. -- -- -- --
Stock-Based Compensation, Supplemental 310 251 282 273
Variable Lease Expense - Unclassified -- -- -- --
Variable Operating Lease Expenses 277 -- -- --
Variable Financial Lease Expenses -- -- -- --
Short-Term Lease Cost 75 -- -- --
Sublease Income (13) -- -- --
Lease Expense -Total 1,400 -- -- --
Advertising Expense, Supplemental -- -- -- --
Equity in Affiliates, Supplemental -- -- -- --
Minority Interest, Supplemental -- -- -- --
Income Taxes - Non-Recurring Tax Change -- 0 (85) 127
Research & Development Exp, Supplemental -- -- -- --
Audit Fees -- -- 6 6
Audit-Related Fees -- -- 0 0
Tax Fees -- -- 0 1
All Other Fees -- -- 0 0
Reported Recurring Revenue -- -- -- --
Reported Net Premiums Written -- -- -- --
Reported Total Revenue -- -- -- --
Reported Operating Revenue -- -- -- --
Reported Total Cost of Revenue -- -- -- --
Reported Total Sales, General & Admin. -- -- -- --
Reported Gross Profit -- -- -- --
Reported Operating Profit -- -- -- --
Reported Operating Profit Margin -- -- -- --
Reported Ordinary Profit -- -- -- --
Reported Net Income After Tax -- -- -- --
Reported Basic EPS -- -- -- --
Reported Diluted EPS -- -- -- --
Reported Net Business Profits -- -- -- --
Islamic Income -- -- -- --
Zakat -- -- -- --
COVID-19 Non-Recurring Inc/Exp - Other 2,000 -- -- --
COVID-19 One-time Provisions -- -- -- --
COVID-19 Restructuring Chrgs/Provisions -- -- -- --
COVID-19 Impairment of Long-Term Assets -- -- -- --
COVID-19 One-time Government Grants -- -- -- --
COVID-19 Inc Taxes - Non-Recurring -- -- -- --
Islamic Section, Supplemental -- -- -- --
Normalized EBIT 20,278 15,843 15,777 14,681
Normalized EBITDA 22,797 18,139 17,929 16,743
Tax & Pension Items ($ Millions)
Current Tax - Total 4,719 3,282 3,473 4,558
Current Tax - Domestic 3,462 2,370 2,557 3,728
Current Tax - Foreign 329 340 372 331
Current Tax - Local 928 572 544 499
Deferred Tax - Total (607) 191 47 383
Deferred Tax - Domestic (404) 259 90 206
Deferred Tax - Foreign 6 4 (44) 88
Deferred Tax - Local (209) (72) 1 89
Income Tax - Total 4,112 3,473 3,520 4,941
Income Tax by Region - Total -- -- -- --
Domestic Pension Plan Expense -- -- -- --
Foreign Pension Plan Expense -- -- -- --
Post-Retirement Plan Expense -- -- -- --
Total Pension Expense -- 267 213 211
Defined Contribution Expense - Domestic -- 267 213 211
Assumptions -- -- -- --
Total Plan Interest Cost -- -- -- --
Total Plan Service Cost -- -- -- --
Total Plan Expected Return -- -- -- --
Total Plan Other Expense -- -- -- --
Dividends and Capital Changes
Home Depot Ord Shs
$1.50 F $1.36 F $1.03 F $0.89 F
(19-Nov) Ann.  (21-Nov) Ann.  (15-Nov) Ann.  (16-Nov) Ann. 
$1.50 I $1.36 I $1.03 I $0.89 I
(18-Aug) Ann.  (22-Aug) Ann.  (16-Aug) Ann.  (17-Aug) Ann. 
$1.50 I $1.36 I $1.03 I $0.89 I
(19-May) Ann.  (23-May) Ann.  (17-May) Ann.  (18-May) Ann. 
$1.50 I $1.36 I $1.03 I $0.89 I
Cash Dividend (25-Feb) Ann.  (26-Feb) Ann.  (20-Feb) Ann.  (21-Feb) Ann. 
1x 1x
-- (26-Feb)  -- (01-Dec) 
1x
Buyback -- -- -- (01-Feb) 
Dividends & Capital Changes After Jan-2021
Home Depot Ord Shs
2021 Cash Dividend $1.65 I
(23-Feb) Ann. 
 2017 2016 2015
91  91  92 
29-Jan-2017  31-Jan-2016  01-Feb-2015 
94,595 88,519 83,176
94,595 88,519 83,176
-- -- --
94,595 88,519 83,176
62,282 58,254 54,787
62,282 58,254 54,787
32,313 30,265 28,389

17,132 16,801 16,280

17,132 16,801 16,280
-- -- --
1,754 1,690 1,640
1,754 1,690 1,640
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
81,168 76,745 72,707
13,427 11,774 10,469
(972) (919) (830)
(972) (919) (830)
36 166 337
36 166 337
-- -- --
(936) (753) (493)
-- -- --
-- -- --
-- -- --
12,491 11,021 9,976
4,534 4,012 3,631
7,957 7,009 6,345
-- -- --
 -- -- --
-- -- --
7,957 7,009 6,345

-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
7,957 7,009 6,345

-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
7,957 7,009 6,345
7,957 7,009 6,345
1,229 1,277 1,338
6.47 5.49 4.74
6.47 5.49 4.74
-- 0 0
7,957 7,009 6,345
1,234 1,283 1,346
6.45 5.46 4.71
6.45 5.46 4.71

2.76 2.36 1.88

-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
3,404 3,031 2,530
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
 -- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
12,491 11,021 9,976
-- -- --
4,534 4,012 3,631
7,957 7,009 6,345
7,957 7,009 6,345
6.47 5.49 4.74
6.45 5.46 4.71
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
1,973 1,863 1,786
-- -- --
972 919 830
(1) (2) (2)
-- -- --
-- -- --
-- -- --
984 922 918
-- -- --
267 244 225
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
6 5 5
0 0 0
1 0 1
 0 0 0
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
-- -- --
13,427 11,774 10,469
15,400 13,637 12,255

4,647 3,990 3,515

3,870 3,228 2,884
315 296 258
462 466 373
(113) 22 116
(102) 21 127
(24) (9) 0
13 10 (11)
4,534 4,012 3,631
-- -- --
-- -- --
-- -- --
-- -- --
195 186 182
195 186 182
-- -- --
 -- -- --
-- -- --
-- -- --
-- -- --

$0.69 F $0.59 F $0.47 F

(17-Nov) Ann.  (19-Nov) Ann.  (20-Nov) Ann. 
$0.69 I $0.59 I $0.47 I
(18-Aug) Ann.  (20-Aug) Ann.  (21-Aug) Ann. 
$0.69 I $0.59 I $0.47 I
(19-May) Ann.  (21-May) Ann.  (22-May) Ann. 
$0.69 I $0.59 I $0.47 I
(23-Feb) Ann.  (24-Feb) Ann.  (25-Feb) Ann. 
1x
-- (24-Feb)  --

-- -- --