XML 83 R66.htm IDEA: XBRL DOCUMENT v3.7.0.1
SUBSIDIARY GUARANTORS - CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS (Details) - USD ($)
$ in Millions
3 Months Ended
Apr. 30, 2017
May 01, 2016
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities $ 83 $ 76
Cash flows from investing activities    
Capital expenditures (24) (17)
Proceeds from sales of property and equipment 2  
Net cash provided by (used in) investing activities (22) (17)
Cash flows from financing activities    
Borrowings of long-term debt   1,000
Repayments of long-term debt (100) (1,108)
Borrowings on long-term revolver debt 75  
Repayments on long-term revolver debt (55)  
Debt issuance costs (5) (14)
Other financing activities 3 (2)
Net cash provided by (used in) financing activities (66) (127)
Effect of exchange rates on cash   2
Increase (decrease) in cash and cash equivalents (5) (66)
Cash and cash equivalents at beginning of period 75 269
Cash and cash equivalents at end of period 70 203
Eliminations    
Cash flows from investing activities    
Proceeds from (payments of) intercompany notes (73) (105)
Net cash provided by (used in) investing activities (73) (105)
Cash flows from financing activities    
Borrowings from (repayments to) intercompany notes 73 105
Net cash provided by (used in) financing activities 73 105
HDS (Debt Issuer)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 139 169
Cash flows from investing activities    
Capital expenditures (6) (4)
Other investing activities   (1)
Net cash provided by (used in) investing activities (6) (5)
Cash flows from financing activities    
Borrowings from (repayments to) intercompany notes (73) (105)
Borrowings of long-term debt   1,000
Repayments of long-term debt (100) (1,108)
Borrowings on long-term revolver debt 75  
Repayments on long-term revolver debt (54)  
Debt issuance costs (5) (14)
Other financing activities 3 (1)
Net cash provided by (used in) financing activities (154) (228)
Increase (decrease) in cash and cash equivalents (21) (64)
Cash and cash equivalents at beginning of period 51 233
Cash and cash equivalents at end of period 30 169
Subsidiary Guarantors.    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities (56) (93)
Cash flows from investing activities    
Capital expenditures (18) (13)
Proceeds from sales of property and equipment 2  
Proceeds from (payments of) intercompany notes 73 105
Other investing activities   1
Net cash provided by (used in) investing activities 57 93
Cash flows from financing activities    
Other financing activities   (1)
Net cash provided by (used in) financing activities   (1)
Increase (decrease) in cash and cash equivalents 1 (1)
Cash and cash equivalents at beginning of period 17 18
Cash and cash equivalents at end of period 18 17
Non-Guarantor Subsidiaries    
Cash flows from financing activities    
Repayments on long-term revolver debt (1)  
Net cash provided by (used in) financing activities (1)  
Effect of exchange rates on cash   2
Increase (decrease) in cash and cash equivalents (1) 2
Cash and cash equivalents at beginning of period 5 15
Cash and cash equivalents at end of period 4 17
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 83 76
Cash flows from investing activities    
Capital expenditures (24) (17)
Proceeds from sales of property and equipment 2  
Net cash provided by (used in) investing activities (22) (17)
Cash flows from financing activities    
Borrowings of long-term debt   1,000
Repayments of long-term debt (100) (1,108)
Borrowings on long-term revolver debt 75  
Repayments on long-term revolver debt (55)  
Debt issuance costs (5) (14)
Other financing activities 3 (2)
Net cash provided by (used in) financing activities (82) (124)
Effect of exchange rates on cash   2
Increase (decrease) in cash and cash equivalents (21) (63)
Cash and cash equivalents at beginning of period 73 266
Cash and cash equivalents at end of period $ 52 $ 203