XML 52 R20.htm IDEA: XBRL DOCUMENT v3.7.0.1
Acquisitions (Tables)
6 Months Ended
Jul. 31, 2017
Business Combinations [Abstract]  
Schedule of Recognized Identified Assets Acquired and Liabilities Assumed [Table Text Block]
The preliminary allocation of the estimated purchase price to assets acquired and liabilities assumed is as follows:
(in millions)
 
Cash
$
176

Accounts receivable
1,837

Inventories
233

Prepaid expenses and other current assets
102

Property and equipment, net
61

Goodwill
616

Intangible assets
941

Other assets, net
166

       Total assets
4,132

 


Other current liabilities
1,190

Revolving credit loans and long-term debt
119

Other long-term liabilities
106

       Total liabilities
1,415

 
 
       Estimated purchase price
$
2,717

Business Acquisition, Pro Forma Information [Table Text Block]
The following table presents unaudited supplemental pro forma information as if the TS acquisition had occurred at the beginning of fiscal 2017. The pro forma results presented are based on combining the stand-alone operating results of the Company and TS for the periods prior to the acquisition date after giving effect to certain adjustments related to the transaction. The pro forma results exclude any benefits that may result from potential cost synergies of the combined company and certain non-recurring costs. As a result, the pro forma information below does not purport to present what actual results would have been had the acquisition actually been consummated on the date indicated and it is not necessarily indicative of the results of operations that may result in the future.

 
Three months ended July 31,
 
Six months ended July 31,
 
2017
 
2016
 
2017
 
2016
(in millions)
 
 
 
 
 
 
 
Pro forma net sales
$
8,883

 
$
8,737

 
$
17,280

 
$
16,914

Pro forma net income

$
49

 
$
56

 
$
84

 
$
87

Adjustments reflected in the pro forma results include the following:
Amortization of acquired intangible assets based on the preliminary valuation and estimated purchase price
Interest costs associated with the transaction
Removal of certain non-recurring transaction costs
Tax effects of adjustments based on an estimated statutory tax rate
Acquisition and integration expenses [Table Text Block]
Acquisition, integration and restructuring expenses for the three and six months ended July 31, 2017 are comprised of the following:

 
July 31, 2017
 
July 31, 2017
(in thousands)
 
 
 
Professional services
$
15,101

 
$
27,008

Restructuring costs
6,982

 
17,327

Transaction related costs
2,050

 
17,229

Other
5,984

 
10,619

Total
$
30,117

 
$
72,183


Schedule of Restructuring Reserve by Type of Cost [Table Text Block]
Restructuring activity during the six months ended July 31, 2017 is as follows:
 
 
Six months ended July 31, 2017
 
 
Severance
 
Facility Exit Costs
 
Total
(in thousands)
 
 
 
 
 
 
Fiscal 2018 restructuring expenses
 
$
13,667

 
$
3,660

 
$
17,327

Cash payments
 
(8,967
)
 
(1,572
)
 
(10,539
)
Foreign currency translation
 
182

 
25

 
207

Balance at July 31, 2017
 
$
4,882

 
$
2,113

 
$
6,995