XML 33 R15.htm IDEA: XBRL DOCUMENT v3.19.1
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
12 Months Ended
Feb. 03, 2019
Jan. 28, 2018
Jan. 29, 2017
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income $ 394 $ 970 $ 196
Reconciliation of net income to net cash provided by (used in) operating activities:      
Depreciation and amortization 106 97 102
Provision for uncollectibles 12 9 6
Non-cash interest expense 17 16 17
Payment of discounts upon extinguishment of debt (4) (6) (7)
Loss on extinguishment & modification of debt 69 84 179
Stock-based compensation expense 26 26 20
Deferred income taxes 122 407 129
(Gain) loss on sales of businesses, net   (934) 6
Other   2 (11)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (79) (173) (38)
(Increase) decrease in inventories (59) (127) (62)
(Increase) decrease in other current assets (1) 6 3
(Increase) decrease in other assets (2)   (2)
Increase (decrease) in accounts payable and accrued liabilities (18) 125 (16)
Increase (decrease) in other long-term liabilities 1   (9)
Net cash provided by (used in) operating activities 584 502 513
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (115) (94) (81)
Payments for businesses acquired, net (362)    
Proceeds from sales of property and equipment   2 32
Proceeds from sales of businesses, net   2,421 28
Net cash provided by (used in) investing activities (477) 2,329 (21)
CASH FLOWS FROM FINANCING ACTIVITIES:      
Borrowings of long-term debt 930 113 1,547
Repayments of long-term debt (1,243) (1,529) (2,631)
Borrowings on long-term revolver debt 523 628 689
Repayments on long-term revolver debt (229) (995) (269)
Debt issuance and modification costs (19) (26) (19)
Other financing activities 1 4 (3)
Net cash provided by (used in) financing activities (627) (2,348) (687)
Effect of exchange rates on cash and cash equivalents     1
Increase (decrease) in cash and cash equivalents (520) 483 (194)
Cash and cash equivalents at beginning of period 558 75 269
Cash and cash equivalents at end of period 38 558 75
HD Supply, Inc. (Total HDS)      
CASH FLOWS FROM OPERATING ACTIVITIES:      
Net income 394 970 196
Reconciliation of net income to net cash provided by (used in) operating activities:      
Depreciation and amortization 106 97 102
Provision for uncollectibles 12 9 6
Non-cash interest expense 17 16 17
Payment of discounts upon extinguishment of debt (4) (6) (7)
Loss on extinguishment & modification of debt 69 84 179
Stock-based compensation expense 26 26 20
Deferred income taxes 122 407 129
(Gain) loss on sales of businesses, net   (934) 6
Other   2 (11)
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:      
(Increase) decrease in receivables (79) (173) (38)
(Increase) decrease in inventories (59) (127) (62)
(Increase) decrease in other current assets (1) 6 3
(Increase) decrease in other assets (2)   (2)
Increase (decrease) in accounts payable and accrued liabilities (18) 125 (16)
Increase (decrease) in other long-term liabilities 1   (9)
Net cash provided by (used in) operating activities 584 502 513
CASH FLOWS FROM INVESTING ACTIVITIES:      
Capital expenditures (115) (94) (81)
Payments for businesses acquired, net (362)    
Proceeds from sales of property and equipment   2 32
Proceeds from sales of businesses, net   2,421 28
Net cash provided by (used in) investing activities (477) 2,329 (21)
CASH FLOWS FROM FINANCING ACTIVITIES:      
Equity distribution to Parent (590) (541)  
Borrowings of long-term debt 930 113 1,547
Repayments of long-term debt (1,243) (1,529) (2,631)
Borrowings on long-term revolver debt 523 628 689
Repayments on long-term revolver debt (229) (995) (269)
Debt issuance and modification costs (19) (26) (19)
Other financing activities 1 4 (3)
Net cash provided by (used in) financing activities (627) (2,346) (686)
Effect of exchange rates on cash and cash equivalents     1
Increase (decrease) in cash and cash equivalents (520) 485 (193)
Cash and cash equivalents at beginning of period 558 73 266
Cash and cash equivalents at end of period $ 38 $ 558 $ 73