XML 31 R12.htm IDEA: XBRL DOCUMENT v3.6.0.2
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
12 Months Ended
Jan. 29, 2017
Jan. 31, 2016
Feb. 01, 2015
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income $ 196 $ 1,472 $ 3
Reconciliation of net income to net cash provided by (used in) operating activities:      
Depreciation and amortization 102 134 226
Provision for uncollectibles 6 8 7
Non-cash interest expense 17 23 25
Payment of discounts upon extinguishment of debt (7) (12) (1)
Loss on extinguishment & modification of debt 179 100 108
(Gain) loss on sales of businesses, net 6 (186) (8)
Stock-based compensation expense 20 16 17
Deferred income taxes 129 (839) 55
Other (11) (4)  
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (38) (63) (90)
(Increase) decrease in inventories (62) (38) (71)
(Increase) decrease in other current assets 3 11 18
(Increase) decrease in other assets (2)    
Increase (decrease) in accounts payable and accrued liabilities (16) (14) 1
Increase (decrease) in other long-term liabilities (9) (186) 5
Net cash provided by (used in) operating activities 513 422 295
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (81) (86) (119)
Proceeds from sales of property and equipment 32 3 5
Proceeds from sales of businesses, net 28 809 198
Net cash provided by (used in) investing activities (21) 726 84
CASH FLOWS FROM FINANCING ACTIVITIES:      
Borrowings of long-term debt 1,547 287 1,270
Repayments of long-term debt (2,631) (1,152) (1,385)
Borrowings on long-term revolver debt 689 784 878
Repayments on long-term revolver debt (269) (880) (1,142)
Debt issuance and modification costs (19) (6) (21)
Other financing activities (3) 2  
Net cash provided by (used in) financing activities (687) (962) (404)
Effect of exchange rates on cash and cash equivalents 1 (2) (5)
Increase (decrease) in cash and cash equivalents (194) 184 (30)
Cash and cash equivalents at beginning of period 269 85 115
Cash and cash equivalents at end of period 75 269 85
HD Supply, Inc. (Total HDS)      
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income 196 1,472 3
Reconciliation of net income to net cash provided by (used in) operating activities:      
Depreciation and amortization 102 134 226
Provision for uncollectibles 6 8 7
Non-cash interest expense 17 23 25
Payment of discounts upon extinguishment of debt (7) (12) (1)
Loss on extinguishment & modification of debt 179 100 108
(Gain) loss on sales of businesses, net 6 (186) (8)
Stock-based compensation expense 20 16 17
Deferred income taxes 129 (839) 55
Other (11) (4)  
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (38) (63) (90)
(Increase) decrease in inventories (62) (38) (71)
(Increase) decrease in other current assets 3 11 18
(Increase) decrease in other assets (2)    
Increase (decrease) in accounts payable and accrued liabilities (16) (14) 1
Increase (decrease) in other long-term liabilities (9) (186) 5
Net cash provided by (used in) operating activities 513 422 295
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (81) (86) (119)
Proceeds from sales of property and equipment 32 3 5
Proceeds from sales of businesses, net 28 809 198
Net cash provided by (used in) investing activities (21) 726 84
CASH FLOWS FROM FINANCING ACTIVITIES:      
Borrowings of long-term debt 1,547 287 1,270
Repayments of long-term debt (2,631) (1,152) (1,385)
Borrowings on long-term revolver debt 689 784 878
Repayments on long-term revolver debt (269) (880) (1,142)
Debt issuance and modification costs (19) (6) (21)
Other financing activities (3) 2  
Net cash provided by (used in) financing activities (686) (965) (400)
Effect of exchange rates on cash and cash equivalents 1 (2) (5)
Increase (decrease) in cash and cash equivalents (193) 181 (26)
Cash and cash equivalents at beginning of period 266 85 111
Cash and cash equivalents at end of period $ 73 $ 266 $ 85