Attached files

file filename
10-Q - FORM 10-Q - HOME DEPOT, INC.d10q.htm
EX-31.2 - CERTIFICATION - HOME DEPOT, INC.dex312.htm
EX-31.1 - CERTIFICATION - HOME DEPOT, INC.dex311.htm
EX-32.1 - SECTION 906 CERTIFICATION - HOME DEPOT, INC.dex321.htm
EX-32.2 - SECTION 906 CERTIFICATION - HOME DEPOT, INC.dex322.htm
EX-15.1 - LETTER OF KPMG LLP - HOME DEPOT, INC.dex151.htm
EXCEL - IDEA: XBRL DOCUMENT - HOME DEPOT, INC.Financial_Report.xls
EX-3.1 - AMENDED AND RESTATED CERTIFICATE OF INCORPORATION - HOME DEPOT, INC.dex31.htm

Exhibit 12.1

THE HOME DEPOT, INC. AND SUBSIDIARIES

STATEMENT OF COMPUTATION OF RATIO OF EARNINGS TO FIXED CHARGES

(amounts in millions, except ratio data)

 

           Fiscal Year(1)  
     Six Months
Ended

July  31, 2011
    2010     2009     2008     2007     2006  

Earnings From Continuing Operations Before Income Taxes

   $ 3,431      $ 5,273      $ 3,982      $ 3,590      $ 6,620      $ 8,502   

Less: Capitalized Interest

     (1     (3     (4     (20     (46     (47

Add:

            

Portion of Rental Expense under operating leases deemed to be the equivalent of interest

     142        278        277        286        279        257   

Interest Expense

     291        533        680        644        741        437   
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Adjusted Earnings

   $ 3,863      $ 6,081      $ 4,935      $ 4,500      $ 7,594      $ 9,149   
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Fixed Charges:

            

Interest Expense

   $ 291      $ 533      $ 680      $ 644      $ 741      $ 437   

Portion of Rental Expense under operating leases deemed to be the equivalent of interest

     142        278        277        286        279        257   
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Total Fixed Charges

   $ 433      $ 811      $ 957      $ 930      $ 1,020      $ 694   
  

 

 

   

 

 

   

 

 

   

 

 

   

 

 

   

 

 

 

Ratio of Earnings to Fixed Charges (2)

     8.9x        7.5x        5.2x        4.8x        7.4x        13.2x   

 

(1)

Fiscal years 2010, 2009, 2008, 2007 and 2006 refer to the fiscal years ended January 30, 2011, January 31, 2010, February 1, 2009, February 3, 2008 and January 28, 2007, respectively. Fiscal year 2007 includes 53 weeks; all other fiscal years reported include 52 weeks.

 

(2) 

For purposes of computing the ratios of earnings to fixed charges, “earnings” consist of earnings from continuing operations before income taxes plus fixed charges, excluding capitalized interest. “Fixed charges” consist of interest incurred on indebtedness including capitalized interest, amortization of debt expenses and the portion of rental expense under operating leases deemed to be the equivalent of interest. The ratios of earnings to fixed charges are calculated as follows:

(earnings from continuing operations before income taxes)+(fixed charges)-(capitalized interest)

(fixed charges)