XML 81 R66.htm IDEA: XBRL DOCUMENT v3.8.0.1
SUBSIDIARY GUARANTORS - CONDENSED CONSOLIDATING STATEMENTS OF CASH FLOWS (Details) - USD ($)
$ in Millions
9 Months Ended
Oct. 29, 2017
Oct. 30, 2016
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities $ 320 $ 304
Cash flows from investing activities    
Capital expenditures (65) (59)
Proceeds from sales of property and equipment 2 2
Proceeds from sales of businesses, net 2,450 28
Net cash provided by (used in) investing activities 2,387 (29)
Cash flows from financing activities    
Borrowings of long-term debt 113 1,547
Repayments of long-term debt (1,526) (2,435)
Borrowings on long-term revolver debt 624 510
Repayments on long-term revolver debt (989)  
Debt issuance costs (26) (19)
Other financing activities 1 (1)
Net cash provided by (used in) financing activities (2,321) (399)
Effect of exchange rates on cash   1
Increase (decrease) in cash and cash equivalents 386 (123)
Cash and cash equivalents at beginning of period 75 269
Cash and cash equivalents at end of period 461 146
Eliminations    
Cash flows from investing activities    
Proceeds from (payments of) intercompany notes 12 (101)
Net cash provided by (used in) investing activities 12 (101)
Cash flows from financing activities    
Borrowings of (repayments of) intercompany notes (12) 101
Net cash provided by (used in) financing activities (12) 101
HDS (Debt Issuer)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 260 355
Cash flows from investing activities    
Capital expenditures (18) (14)
Proceeds from sales of businesses, net 2,450 28
Net cash provided by (used in) investing activities 2,432 14
Cash flows from financing activities    
Equity distribution (516)  
Borrowings of (repayments of) intercompany notes 12 (101)
Borrowings of long-term debt 113 1,547
Repayments of long-term debt (1,526) (2,435)
Borrowings on long-term revolver debt 621 510
Repayments on long-term revolver debt (981)  
Debt issuance costs (26) (19)
Other financing activities 1  
Net cash provided by (used in) financing activities (2,302) (498)
Increase (decrease) in cash and cash equivalents 390 (129)
Cash and cash equivalents at beginning of period 51 233
Cash and cash equivalents at end of period 441 104
Subsidiary Guarantors    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 55 (54)
Cash flows from investing activities    
Capital expenditures (47) (45)
Proceeds from sales of property and equipment 2 2
Proceeds from (payments of) intercompany notes (12) 101
Net cash provided by (used in) investing activities (57) 58
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 (2) 3
Cash and cash equivalents at beginning of period 17 18
Cash and cash equivalents at end of period 15 21
Non-Guarantor Subsidiaries    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 5 3
Cash flows from financing activities    
Borrowings on long-term revolver debt 3  
Repayments on long-term revolver debt (8)  
Net cash provided by (used in) financing activities (5)  
Effect of exchange rates on cash   1
Increase (decrease) in cash and cash equivalents   4
Cash and cash equivalents at beginning of period 5 15
Cash and cash equivalents at end of period 5 19
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 320 304
Cash flows from investing activities    
Capital expenditures (65) (59)
Proceeds from sales of property and equipment 2 2
Proceeds from sales of businesses, net 2,450 28
Net cash provided by (used in) investing activities 2,387 (29)
Cash flows from financing activities    
Equity distribution (516)  
Borrowings of long-term debt 113 1,547
Repayments of long-term debt (1,526) (2,435)
Borrowings on long-term revolver debt 624 510
Repayments on long-term revolver debt (989)  
Debt issuance costs (26) (19)
Other financing activities 1 (1)
Net cash provided by (used in) financing activities (2,319) (398)
Effect of exchange rates on cash   1
Increase (decrease) in cash and cash equivalents 388 (122)
Cash and cash equivalents at beginning of period 73 266
Cash and cash equivalents at end of period $ 461 $ 144