XML 84 R69.htm IDEA: XBRL DOCUMENT v3.8.0.1
SUBSIDIARY GUARANTORS - CONDENSED CONSOLIDATING CASH FLOW STATEMENTS (Details) - USD ($)
$ in Millions
3 Months Ended
Apr. 29, 2018
Apr. 30, 2017
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities $ 50 $ 83
Cash flows from investing activities    
Capital expenditures (19) (24)
Payments from sales businesses, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (381) (22)
Cash flows from financing activities    
Repayments of long-term debt (3) (100)
Borrowings on long-term revolver debt 6 75
Repayments on long-term revolver debt (9) (55)
Debt issuance costs   (5)
Other financing activities (3) 3
Net cash provided by (used in) financing activities (77) (66)
Increase (decrease) in cash and cash equivalents (408) (5)
Cash and cash equivalents at beginning of period 558 75
Cash and cash equivalents at end of period 150 70
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 50 83
Cash flows from investing activities    
Capital expenditures (19) (24)
Payments from sales businesses, net (362)  
Proceeds from sales of property and equipment   2
Net cash provided by (used in) investing activities (381) (22)
Cash flows from financing activities    
Equity contribution (distribution) (71)  
Repayments of long-term debt (3) (100)
Borrowings on long-term revolver debt 6 75
Repayments on long-term revolver debt (9) (55)
Debt issuance costs   (5)
Other financing activities (3) 3
Net cash provided by (used in) financing activities (80) (82)
Increase (decrease) in cash and cash equivalents (411) (21)
Cash and cash equivalents at beginning of period 558 73
Cash and cash equivalents at end of period 147 52
Reportable Legal Entities | HDS (Debt Issuer)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 113 139
Cash flows from investing activities    
Capital expenditures (9) (6)
Investments in equity affiliates (365)  
Net cash provided by (used in) investing activities (374) (6)
Cash flows from financing activities    
Equity contribution (distribution) (71)  
Borrowings of (repayments of) intercompany notes (75) (73)
Repayments of long-term debt (3) (100)
Borrowings on long-term revolver debt   75
Repayments on long-term revolver debt   (54)
Debt issuance costs   (5)
Other financing activities (3) 3
Net cash provided by (used in) financing activities (152) (154)
Increase (decrease) in cash and cash equivalents (413) (21)
Cash and cash equivalents at beginning of period 539 51
Cash and cash equivalents at end of period 126 30
Reportable Legal Entities | Subsidiary Guarantors    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities (66) (56)
Cash flows from investing activities    
Capital expenditures (10) (18)
Proceeds from sales of property and equipment   2
Proceeds from (payments of) intercompany notes 75 73
Net cash provided by (used in) investing activities 65 57
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 2 1
Cash and cash equivalents at beginning of period 15 17
Cash and cash equivalents at end of period 17 18
Reportable Legal Entities | Non-Guarantor Subsidiaries    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 3  
Cash flows from investing activities    
Payments from sales businesses, net (362)  
Investments in equity affiliates (3)  
Net cash provided by (used in) investing activities (365)  
Cash flows from financing activities    
Equity contribution (distribution) 365  
Borrowings on long-term revolver debt 6  
Repayments on long-term revolver debt (9) (1)
Net cash provided by (used in) financing activities 362 (1)
Increase (decrease) in cash and cash equivalents   (1)
Cash and cash equivalents at beginning of period 4 5
Cash and cash equivalents at end of period 4 4
Cash contribution 365  
Eliminations    
Cash flows from investing activities    
Investments in equity affiliates 368  
Proceeds from (payments of) intercompany notes (75) (73)
Net cash provided by (used in) investing activities 293 (73)
Cash flows from financing activities    
Equity contribution (distribution) (368)  
Borrowings of (repayments of) intercompany notes 75 73
Net cash provided by (used in) financing activities $ (293) $ 73