XML 163 R144.htm IDEA: XBRL DOCUMENT v3.6.0.2
GUARANTOR SUBSIDIARIES - CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS (Details) - USD ($)
$ in Millions
12 Months Ended
Jan. 29, 2017
Jan. 31, 2016
Feb. 01, 2015
CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS      
Net cash flows from operating activities $ 513 $ 422 $ 295
Cash flows from investing activities      
Capital expenditures (81) (86) (119)
Proceeds from sales of property and equipment 32 3 5
Proceeds from sales of businesses, net 28 809 198
Net cash provided by (used in) investing activities (21) 726 84
Cash flows from financing activities      
Proceeds from stock options exercised 33 74 48
Purchase of treasury shares (34) (71) (52)
Borrowings of long-term debt 1,547 287 1,270
Repayments of long-term debt (2,631) (1,152) (1,385)
Borrowings on long-term revolver 689 784 878
Repayments on long-term revolver (269) (880) (1,142)
Debt issuance and modification fees (19) (6) (21)
Other financing activities (3) 2  
Net cash provided by (used in) financing activities (687) (962) (404)
Effect of exchange rates on cash 1 (2) (5)
Increase (decrease) in cash and cash equivalents (194) 184 (30)
Cash and cash equivalents at beginning of period 269 85 115
Cash and cash equivalents at end of period 75 269 85
Eliminations      
Cash flows from investing activities      
(Investments in) return of capital in equity affiliates (71) (34) (27)
Proceeds from (payments of) intercompany notes (43) 16 (25)
Net cash provided by (used in) investing activities (114) (18) (52)
Cash flows from financing activities      
Equity contribution (return of capital) 71 34 27
Borrowings from (repayments to) intercompany notes 43 (16) 25
Net cash provided by (used in) financing activities 114 18 52
HDS (Debt Issuer)      
CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS      
Net cash flows from operating activities 524 329 191
Cash flows from investing activities      
Capital expenditures (17) (18) (17)
Proceeds from sales of property and equipment     1
Proceeds from sales of businesses, net 28 809 198
(Investments in) return of capital in equity affiliates 71 34 27
Net cash provided by (used in) investing activities 82 825 209
Cash flows from financing activities      
Borrowings from (repayments to) intercompany notes (43) 16 (25)
Borrowings of long-term debt 1,547 287 1,270
Repayments of long-term debt (2,631) (1,152) (1,385)
Borrowings on long-term revolver 629 784 878
Repayments on long-term revolver (269) (880) (1,142)
Debt issuance and modification fees (19) (6) (21)
Other financing activities (2) 2  
Net cash provided by (used in) financing activities (788) (949) (425)
Increase (decrease) in cash and cash equivalents (182) 205 (25)
Cash and cash equivalents at beginning of period 233 28 53
Cash and cash equivalents at end of period 51 233 28
Subsidiary Guarantors      
CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS      
Net cash flows from operating activities (12) 75 81
Cash flows from investing activities      
Capital expenditures (63) (67) (102)
Proceeds from sales of property and equipment 32 3 4
Proceeds from (payments of) intercompany notes 43 (16) 25
Net cash provided by (used in) investing activities 12 (80) (73)
Cash flows from financing activities      
Equity contribution (return of capital)   (2)  
Other financing activities (1)    
Net cash provided by (used in) financing activities (1) (2)  
Increase (decrease) in cash and cash equivalents (1) (7) 8
Cash and cash equivalents at beginning of period 18 25 17
Cash and cash equivalents at end of period 17 18 25
Non-Guarantor Subsidiaries      
CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS      
Net cash flows from operating activities 1 18 23
Cash flows from investing activities      
Capital expenditures (1) (1)  
Net cash provided by (used in) investing activities (1) (1)  
Cash flows from financing activities      
Equity contribution (return of capital) (71) (32) (27)
Borrowings on long-term revolver 60    
Net cash provided by (used in) financing activities (11) (32) (27)
Effect of exchange rates on cash 1 (2) (5)
Increase (decrease) in cash and cash equivalents (10) (17) (9)
Cash and cash equivalents at beginning of period 15 32 41
Cash and cash equivalents at end of period 5 15 32
HD Supply, Inc. (Total HDS)      
CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS      
Net cash flows from operating activities 513 422 295
Cash flows from investing activities      
Capital expenditures (81) (86) (119)
Proceeds from sales of property and equipment 32 3 5
Proceeds from sales of businesses, net 28 809 198
Net cash provided by (used in) investing activities (21) 726 84
Cash flows from financing activities      
Borrowings of long-term debt 1,547 287 1,270
Repayments of long-term debt (2,631) (1,152) (1,385)
Borrowings on long-term revolver 689 784 878
Repayments on long-term revolver (269) (880) (1,142)
Debt issuance and modification fees (19) (6) (21)
Other financing activities (3) 2  
Net cash provided by (used in) financing activities (686) (965) (400)
Effect of exchange rates on cash 1 (2) (5)
Increase (decrease) in cash and cash equivalents (193) 181 (26)
Cash and cash equivalents at beginning of period 266 85 111
Cash and cash equivalents at end of period 73 266 85
Holdings      
Cash flows from financing activities      
Proceeds from stock options exercised 33 74 48
Purchase of treasury shares (34) (71) (52)
Net cash provided by (used in) financing activities (1) 3 (4)
Increase (decrease) in cash and cash equivalents (1) 3 (4)
Cash and cash equivalents at beginning of period 3   $ 4
Cash and cash equivalents at end of period $ 2 $ 3