Attached files
file | filename |
---|---|
EX-10.31 - EMPLOYMENT ARRANGEMENT BETWEEN EDWARD P. DECKER AND THE HOME DEPOT, INC. - HOME DEPOT, INC. | hd_01282018xexhibit1031.htm |
10-K - 10-K - HOME DEPOT, INC. | hd_10k01282018.htm |
EX-32.2 - SECTION 906 CERTIFICATION OF THE CFO - HOME DEPOT, INC. | hd_01282018xexhibit322.htm |
EX-32.1 - SECTION 906 CERTIFICATION OF THE CEO - HOME DEPOT, INC. | hd_01282018xexhibit321.htm |
EX-31.2 - CERTIFICATION OF THE CFO - HOME DEPOT, INC. | hd_01282018xexhibit312.htm |
EX-31.1 - CERTIFICATION OF THE CEO - HOME DEPOT, INC. | hd_01282018xexhibit311.htm |
EX-23 - CONSENT OF INDEPENDENT REGISTERED PUBLIC ACCOUNTING FIRM - HOME DEPOT, INC. | hd_01282018xexhibit23.htm |
EX-21 - LIST OF SUBSIDIARIES OF THE COMPANY - HOME DEPOT, INC. | hd_01282018xexhibit21.htm |
Exhibit 12
THE HOME DEPOT, INC.
STATEMENT OF COMPUTATION OF RATIO OF EARNINGS TO FIXED CHARGES
Fiscal (1) | |||||||||||||||
in millions, except ratio data | 2017 | 2016 | 2015 | 2014 | 2013 | ||||||||||
Earnings before provision for income taxes | $ | 13,698 | $ | 12,491 | $ | 11,021 | $ | 9,976 | $ | 8,467 | |||||
Less: Capitalized interest | (2 | ) | (1 | ) | (2 | ) | (2 | ) | (2 | ) | |||||
Add: | |||||||||||||||
Portion of rental expense under operating leases deemed to be the equivalent of interest | 354 | 333 | 312 | 312 | 308 | ||||||||||
Interest expense | 1,059 | 973 | 921 | 832 | 713 | ||||||||||
Adjusted earnings | $ | 15,109 | $ | 13,796 | $ | 12,252 | $ | 11,118 | $ | 9,486 | |||||
Fixed charges: | |||||||||||||||
Interest expense | $ | 1,059 | $ | 973 | $ | 921 | $ | 832 | $ | 713 | |||||
Portion of rental expense under operating leases deemed to be the equivalent of interest | 354 | 333 | 312 | 312 | 308 | ||||||||||
Total fixed charges | $ | 1,413 | $ | 1,306 | $ | 1,233 | $ | 1,144 | $ | 1,021 | |||||
Ratio of earnings to fixed charges(2) | 10.7 | x | 10.6 | x | 9.9 | x | 9.7 | x | 9.3 | x |
(1) | Fiscal 2017, 2016, 2015, 2014 and 2013 refer to the fiscal years ended January 28, 2018, January 29, 2017, January 31, 2016, February 1, 2015 and February 2, 2014, respectively. All fiscal years reported include 52 weeks. |
(2) | For purposes of computing the ratio of earnings to fixed charges, “earnings” consist of earnings before provision for income taxes excluding capitalized interest, plus fixed charges. “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 ratio of earnings to fixed charges is calculated as follows: |
(earnings before provision for income taxes) + (fixed charges) - (capitalized interest)
(fixed charges)