XML 82 R67.htm IDEA: XBRL DOCUMENT v3.10.0.1
SUBSIDIARY GUARANTORS - CONDENSED CONSOLIDATING CASH FLOW STATEMENTS (Details) - USD ($)
$ in Millions
6 Months Ended
Jul. 29, 2018
Jul. 30, 2017
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities $ 186 $ 189
Cash flows from investing activities    
Capital expenditures (47) (43)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (409) (41)
Cash flows from financing activities    
Repayments of long-term debt (5) (103)
Borrowings on long-term revolver debt 10 599
Repayments on long-term revolver debt (16) (261)
Debt issuance costs   (6)
Other financing activities (3)  
Net cash provided by (used in) financing activities (107) (156)
Increase (decrease) in cash and cash equivalents (330) (8)
Cash and cash equivalents at beginning of period 558 75
Cash and cash equivalents at end of period 228 67
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 186 189
Cash flows from investing activities    
Capital expenditures (47) (43)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (409) (41)
Cash flows from financing activities    
Equity contribution (distribution) (94) (395)
Repayments of long-term debt (5) (103)
Borrowings on long-term revolver debt 10 599
Repayments on long-term revolver debt (16) (261)
Debt issuance costs   (6)
Other financing activities (3)  
Net cash provided by (used in) financing activities (108) (166)
Increase (decrease) in cash and cash equivalents (331) (18)
Cash and cash equivalents at beginning of period 558 73
Cash and cash equivalents at end of period 227 55
Reportable Legal Entities | HDS (Debt Issuer)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 208 227
Cash flows from investing activities    
Capital expenditures (17) (9)
Investments in equity affiliates (365)  
Net cash provided by (used in) investing activities (382) (9)
Cash flows from financing activities    
Equity contribution (distribution) (94) (395)
Borrowings of (repayments of) intercompany notes (58) (73)
Repayments of long-term debt (5) (103)
Borrowings on long-term revolver debt   596
Repayments on long-term revolver debt   (256)
Debt issuance costs   (6)
Other financing activities (4)  
Net cash provided by (used in) financing activities (161) (237)
Increase (decrease) in cash and cash equivalents (335) (19)
Cash and cash equivalents at beginning of period 539 51
Cash and cash equivalents at end of period 204 32
Reportable Legal Entities | Subsidiary Guarantors    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities (27) (41)
Cash flows from investing activities    
Capital expenditures (29) (34)
Proceeds from sales of property and equipment   2
Proceeds from (payments of) intercompany notes 58 73
Net cash provided by (used in) investing activities 29 41
Cash flows from financing activities    
Equity contribution (distribution) 3  
Net cash provided by (used in) financing activities 3  
Increase (decrease) in cash and cash equivalents 5  
Cash and cash equivalents at beginning of period 15 17
Cash and cash equivalents at end of period 20 17
Reportable Legal Entities | Non-Guarantor Subsidiaries    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 5 3
Cash flows from investing activities    
Capital expenditures (1)  
Payments for businesses acquired, net (362)  
Investments in equity affiliates (3)  
Net cash provided by (used in) investing activities (366)  
Cash flows from financing activities    
Equity contribution (distribution) 365  
Borrowings on long-term revolver debt 10 3
Repayments on long-term revolver debt (16) (5)
Other financing activities 1  
Net cash provided by (used in) financing activities 360 (2)
Increase (decrease) in cash and cash equivalents (1) 1
Cash and cash equivalents at beginning of period 4 5
Cash and cash equivalents at end of period 3 6
Cash contribution 365  
Eliminations    
Cash flows from investing activities    
Investments in equity affiliates 368  
Proceeds from (payments of) intercompany notes (58) (73)
Net cash provided by (used in) investing activities 310 (73)
Cash flows from financing activities    
Equity contribution (distribution) (368)  
Borrowings of (repayments of) intercompany notes 58 73
Net cash provided by (used in) financing activities $ (310) $ 73