- HD Dashboard
- Financials
- Filings
-
Holdings
- Transcripts
- ETFs
- Insider
- Institutional
- Shorts
-
S-3ASR Filing
The Home Depot, Inc. (HD) S-3ASRAutomatic shelf registration
Filed: 23 Jun 06, 12:00am
Exhibit 12.1
THE HOME DEPOT, INC. AND SUBSIDIARIES
RATIO OF EARNINGS TO FIXED CHARGES
($ in millions, except ratio data)
| Fiscal Year(1) | Three Months Ended April 30, 2006 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 2002 | 2003 | 2004 | 2005 | |||||||||||||||
Earnings Before Income Taxes | $ | 4,957 | $ | 5,872 | $ | 6,843 | $ | 7,912 | $ | 9,282 | $ | 2,370 | ||||||||
Less: Capitalized Interest | (84 | ) | (59 | ) | (50 | ) | (40 | ) | (51 | ) | (9 | ) | ||||||||
Add: | ||||||||||||||||||||
Portion of Rental Expense under operating leases deemed to be the equivalent of interest | 122 | 132 | 145 | 170 | 191 | 53 | ||||||||||||||
Interest Expense | 110 | 96 | 112 | 110 | 194 | 72 | ||||||||||||||
Adjusted Earnings | $ | 5,105 | $ | 6,041 | $ | 7,050 | $ | 8,152 | $ | 9,616 | $ | 2,486 | ||||||||
Fixed Charges: | ||||||||||||||||||||
Interest Expense | $ | 110 | $ | 96 | $ | 112 | $ | 110 | $ | 194 | $ | 72 | ||||||||
Portion of Rental Expense under operating leases deemed to be the equivalent of interest | 122 | 132 | 145 | 170 | 191 | 53 | ||||||||||||||
Total Fixed Charges | $ | 232 | $ | 228 | $ | 257 | $ | 280 | $ | 385 | $ | 125 | ||||||||
Ratio of Earnings to Fixed Charges (2) | 22.0x | 26.5x | 27.4x | 29.1x | 25.0x | 19.8x |
(earnings before income taxes) + (fixed charges) - (capitalized interest)
(fixed charges)