XML 28 R13.htm IDEA: XBRL DOCUMENT v3.20.2
CONSOLIDATED STATEMENTS OF CASH FLOWS (HD Supply, Inc.) - USD ($)
$ in Millions
9 Months Ended
Nov. 01, 2020
Nov. 03, 2019
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income $ 1,811.2 $ 373.7
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 78.2 82.7
Provision for credit losses 11.8 7.4
Non-cash interest expense 4.5 4.6
Loss on extinguishment & modification of debt 5.5  
Gain on sale of business (1,762.0)  
Stock-based compensation expense 14.7 18.1
Deferred income taxes (27.4) 101.8
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (83.1) (133.7)
(Increase) decrease in inventories 17.3 (34.3)
(Increase) decrease in other current assets 8.2 (2.5)
(Increase) decrease in other assets (2.1) 0.3
Increase (decrease) in accounts payable and accrued liabilities 425.2 75.8
Increase (decrease) in other long term liabilities 21.9  
Net cash provided by (used in) operating activities 523.9 496.6
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (54.6) (89.1)
Proceeds from sales of property and equipment 0.3 2.7
Proceeds from sales of businesses, net 2,845.5  
Payments for businesses acquired, net of cash acquired   (9.4)
Net cash provided by (used in) investing activities 2,791.2 (95.8)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Repayments of long-term debt (532.3) (8.0)
Repayments of financing liabilities   (87.9)
Borrowings on long-term revolver debt 434.1 978.0
Repayments on long-term revolver debt (693.6) (964.3)
Debt issuance and modification costs   (0.1)
Other financing activities (1.0) (0.8)
Net cash provided by (used in) financing activities (1,034.6) (402.3)
Effect of exchange rates on cash and cash equivalents 0.1  
Increase (decrease) in cash and cash equivalents 2,280.6 (1.5)
Cash and cash equivalents at beginning of period 34.4 38.0
Cash and cash equivalents at end of period 2,315.0 36.5
HD Supply, Inc.    
CASH FLOWS FROM OPERATING ACTIVITIES:    
Net income 1,811.2 373.7
Reconciliation of net income to net cash provided by (used in) operating activities:    
Depreciation and amortization 78.2 82.7
Provision for credit losses 11.8 7.4
Non-cash interest expense 4.5 4.6
Loss on extinguishment & modification of debt 5.5  
Gain on sale of business (1,762.0)  
Stock-based compensation expense 14.7 18.1
Deferred income taxes (27.4) 101.8
Other   2.7
Changes in assets and liabilities, net of the effects of acquisitions & dispositions:    
(Increase) decrease in receivables (83.1) (133.7)
(Increase) decrease in inventories 17.3 (34.3)
(Increase) decrease in other current assets 8.1 (2.3)
(Increase) decrease in other assets (2.1) 0.3
Increase (decrease) in accounts payable and accrued liabilities 425.2 75.8
Increase (decrease) in other long term liabilities 21.9  
Net cash provided by (used in) operating activities 523.8 496.8
CASH FLOWS FROM INVESTING ACTIVITIES:    
Capital expenditures (54.6) (89.1)
Proceeds from sales of property and equipment 0.3 2.7
Proceeds from sales of businesses, net 2,845.5  
Payments for businesses acquired, net of cash acquired   (9.4)
Net cash provided by (used in) investing activities 2,791.2 (95.8)
CASH FLOWS FROM FINANCING ACTIVITIES:    
Equity distribution to Parent (242.4) (319.2)
Repayments of long-term debt (532.3) (8.0)
Repayments of financing liabilities   (87.9)
Borrowings on long-term revolver debt 434.1 978.0
Repayments on long-term revolver debt (693.6) (964.3)
Debt issuance and modification costs   (0.1)
Other financing activities (1.0) (0.8)
Net cash provided by (used in) financing activities (1,035.2) (402.3)
Effect of exchange rates on cash and cash equivalents 0.1  
Increase (decrease) in cash and cash equivalents 2,279.9 (1.3)
Cash and cash equivalents at beginning of period 34.4 37.8
Cash and cash equivalents at end of period $ 2,314.3 $ 36.5