XML 93 R72.htm IDEA: XBRL DOCUMENT v3.10.0.1
SUBSIDIARY GUARANTORS - CONDENSED CONSOLIDATING CASH FLOW STATEMENTS (Details) - USD ($)
$ in Millions
9 Months Ended
Oct. 28, 2018
Oct. 29, 2017
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities $ 379 $ 320
Cash flows from investing activities    
Capital expenditures (79) (65)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Proceeds from sales businesses, net   2,450
Net cash provided by (used in) investing activities (441) 2,387
Cash flows from financing activities    
Borrowings of long-term debt 930 113
Repayments of long-term debt (1,240) (1,526)
Borrowings on long-term revolver debt 100 624
Repayments on long-term revolver debt (49) (989)
Debt issuance costs (18) (26)
Other financing activities (2) 1
Net cash provided by (used in) financing activities (444) (2,321)
Increase (decrease) in cash and cash equivalents (506) 386
Cash and cash equivalents at beginning of period 558 75
Cash and cash equivalents at end of period 52 461
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 379 320
Cash flows from investing activities    
Capital expenditures (79) (65)
Payments for businesses acquired, net (362)  
Proceeds from sales of property and equipment   2
Proceeds from sales businesses, net   2,450
Net cash provided by (used in) investing activities (441) 2,387
Cash flows from financing activities    
Equity contribution (distribution) (172) (516)
Borrowings of long-term debt 930 113
Repayments of long-term debt (1,240) (1,526)
Borrowings on long-term revolver debt 100 624
Repayments on long-term revolver debt (49) (989)
Debt issuance costs (18) (26)
Other financing activities (2) 1
Net cash provided by (used in) financing activities (451) (2,319)
Increase (decrease) in cash and cash equivalents (513) 388
Cash and cash equivalents at beginning of period 558 73
Cash and cash equivalents at end of period 45 461
Reportable Legal Entities | HDS (Debt Issuer)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 366 260
Cash flows from investing activities    
Capital expenditures (20) (18)
Proceeds from sales businesses, net   2,450
Purchases of investments (7)  
Investments in equity affiliates (365)  
Net cash provided by (used in) investing activities (392) 2,432
Cash flows from financing activities    
Equity contribution (distribution) (172) (516)
Borrowings of (repayments of) intercompany notes (46) 12
Borrowings of long-term debt 930 113
Repayments of long-term debt (1,240) (1,526)
Borrowings on long-term revolver debt 90 621
Repayments on long-term revolver debt (30) (981)
Debt issuance costs (18) (26)
Other financing activities (5) 1
Net cash provided by (used in) financing activities (491) (2,302)
Increase (decrease) in cash and cash equivalents (517) 390
Cash and cash equivalents at beginning of period 539 51
Cash and cash equivalents at end of period 22 441
Reportable Legal Entities | Subsidiary Guarantors    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 4 55
Cash flows from investing activities    
Capital expenditures (58) (47)
Proceeds from sales of property and equipment   2
Proceeds from (payments of) intercompany notes 46 (12)
Net cash provided by (used in) investing activities (12) (57)
Cash flows from financing activities    
Equity contribution (distribution) 3  
Borrowings of long-term debt 10  
Net cash provided by (used in) financing activities 13  
Increase (decrease) in cash and cash equivalents 5 (2)
Cash and cash equivalents at beginning of period 15 17
Cash and cash equivalents at end of period 20 15
Reportable Legal Entities | Non-Guarantor Subsidiaries    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net cash flows from operating activities 9 5
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 (19) (8)
Net cash provided by (used in) financing activities 356 (5)
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 3 5
Cash contribution 365  
Consolidating Adjustments    
Cash flows from investing activities    
Purchases of investments 7  
Investments in equity affiliates 368  
Proceeds from (payments of) intercompany notes (46) 12
Net cash provided by (used in) investing activities 329 12
Cash flows from financing activities    
Equity contribution (distribution) (368)  
Borrowings of (repayments of) intercompany notes 46 (12)
Borrowings of long-term debt (10)  
Other financing activities 3  
Net cash provided by (used in) financing activities $ (329) $ (12)