XML 24 R9.htm IDEA: XBRL DOCUMENT v3.8.0.1
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
9 Months Ended
Oct. 29, 2017
Oct. 30, 2016
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income $ 979 $ 144
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 73 76
Provision for uncollectibles 6 5
Non-cash interest expense 11 13
Payment of discounts upon extinguishment of debt (6)  
Loss on extinguishment & modification of debt 81 174
Stock-based compensation expense 19 15
Deferred income taxes 316 93
(Gain) loss on sales of businesses, net (930) 7
Other   (2)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (249) (236)
(Increase) decrease in inventories (116) (119)
(Increase) decrease in other current assets 1  
(Increase) decrease in other assets 1  
Increase (decrease) in accounts payable and accrued liabilities 132 134
Increase (decrease) in other long-term liabilities 2  
Net cash provided by (used in) 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 and cash equivalents   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
HD Supply, Inc. (Total HDS)    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income 979 144
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 73 76
Provision for uncollectibles 6 5
Non-cash interest expense 11 13
Payment of discounts upon extinguishment of debt (6)  
Loss on extinguishment & modification of debt 81 174
Stock-based compensation expense 19 15
Deferred income taxes 316 93
(Gain) loss on sales of businesses, net (930) 7
Other   (2)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (249) (236)
(Increase) decrease in inventories (116) (119)
(Increase) decrease in other current assets 1  
(Increase) decrease in other assets 1  
Increase (decrease) in accounts payable and accrued liabilities 132 134
Increase (decrease) in other long-term liabilities 2  
Net cash provided by (used in) 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 and cash equivalents   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