XML 51 R36.htm IDEA: XBRL DOCUMENT v3.7.0.1
Employee Benefit Plans (Tables)
12 Months Ended
Jul. 31, 2017
Defined Benefit Plan Disclosure [Line Items]  
Schedule of net periodic pension costs and amounts recognized in other comprehensive income
Net periodic pension costs and amounts recognized in other comprehensive income for the Company’s pension plans include the following components (in millions):
 
 
Year Ended July 31,
 
 
2017

 
2016

 
2015

Service cost
 
$
8.3

 
$
18.4

 
$
20.4

Interest cost
 
13.5

 
18.9

 
19.1

Expected return on assets
 
(26.4
)
 
(28.8
)
 
(29.5
)
Prior service cost and transition amortization
 
0.6

 
0.8

 
0.6

Actuarial loss amortization
 
7.3

 
8.5

 
7.1

Settlement loss
 

 

 
3.9

Net periodic benefit costs
 
3.3

 
17.8

 
21.6

Other changes recognized in other comprehensive income:
 
 
 
 
 
 
Net actuarial (gain) loss
 
(21.7
)
 
53.6

 
3.5

Amortization of asset obligations
 
(0.2
)
 
(0.4
)
 
(0.2
)
Amortization of prior service cost
 
(0.4
)
 
(0.4
)
 
(0.4
)
Amortization of net actuarial loss
 
(7.3
)
 
(8.5
)
 
(11.0
)
Total recognized in other comprehensive income
 
(29.6
)
 
44.3

 
(8.1
)
Total recognized in net periodic benefit costs and other comprehensive income
 
$
(26.3
)
 
$
62.1

 
$
13.5

Schedule of changes in projected benefit obligations, fair value of plan assets and funded status
The changes in projected benefit obligations, fair value of plan assets and funded status of the Company’s pension plans for the years ended July 31, 2017 and 2016 are summarized as follows (in millions):
 
 
Year Ended July 31,
 
 
2017

 
2016

Change in projected benefit obligation:
 
 
 
 
Projected benefit obligation, beginning of year
 
$
537.3

 
$
498.7

Service cost
 
8.3

 
18.4

Interest cost
 
13.5

 
18.9

Participant contributions
 
0.8

 
1.0

Actuarial (gain) loss
 
(22.3
)
 
50.0

Currency exchange rates
 
2.7

 
(17.2
)
Benefits paid
 
(25.2
)
 
(32.5
)
Projected benefit obligation, end of year
 
$
515.1

 
$
537.3

Change in fair value of plan assets:
 
 
 
 
Fair value of plan assets, beginning of year
 
$
455.5

 
$
478.5

Actual return on plan assets
 
28.4

 
22.2

Company contributions
 
3.1

 
4.2

Participant contributions
 
0.8

 
1.0

Currency exchange rates
 
2.5

 
(17.9
)
Benefits paid
 
(25.2
)
 
(32.5
)
Fair value of plan assets, end of year
 
$
465.1

 
$
455.5

Funded status:
 
 
 
 
Projected benefit obligation in excess of plan assets at end of fiscal year
 
$
(50.0
)
 
$
(81.8
)
 
 
 
 
 
Amounts recognized on the Consolidated Balance Sheets consist of:
 
 
 
 
Other long-term assets
 
$
5.7

 
$
1.4

Other current liabilities
 
(1.6
)
 
(1.5
)
Other long-term liabilities
 
(54.1
)
 
(81.7
)
Net recognized liability
 
$
(50.0
)
 
$
(81.8
)
Schedule of weighted-average discount rates in determining actuarial present value of projected benefit obligation
The weighted-average discount rate and rates of increase in future compensation levels used in determining the actuarial present value of the projected benefit obligation are as follows:
Projected Benefit Obligation
 
Year Ended July 31,
Weighted average actuarial assumptions
 
2017

 
2016

All U.S. plans:
 
 

 
 

Discount rate
 
3.94
%
 
3.65
%
Rate of compensation increase (1)
 
N/A

 
2.56
%
Non-U.S. plans:
 
 

 
 

Discount rate
 
2.40
%
 
2.08
%
Rate of compensation increase
 
2.70
%
 
2.69
%

(1) Compensation increase is no longer applicable due to the freeze of the Salaried Pension Plan effective August 1, 2016.
Schedule of assumptions used to determine net periodic benefit cost
The weighted-average discount rates, expected returns on plan assets and rates of increase in future compensation levels used to determine the net periodic benefit cost are as follows:
Net Periodic Benefit Cost
 
Year Ended July 31,
Weighted average actuarial assumptions
 
2017

 
2016

 
2015

All U.S. plans:
 
 

 
 

 
 

Discount rate
 
3.65
%
 
4.33
%
 
4.33
%
Expected return on plan assets
 
6.90
%
 
6.99
%
 
7.14
%
Rate of compensation increase
 
2.56
%
 
2.56
%
 
2.61
%
Non-U.S. plans:
 
 

 
 

 
 

Discount rate
 
2.08
%
 
3.14
%
 
3.64
%
Expected return on plan assets
 
3.93
%
 
4.83
%
 
5.41
%
Rate of compensation increase
 
2.69
%
 
2.68
%
 
2.79
%
Schedule of estimated future benefit payments
The estimated future benefit payments for the Company’s U.S. and non-U.S. plans are as follows (in millions):
Year Ending July 31,
 
Estimated Future Benefit Payments
2018
 
$
28.9

2019
 
26.8

2020
 
28.4

2021
 
28.6

2022
 
27.5

2022-2026
 
144.4

U.S. Plan  
Defined Benefit Plan Disclosure [Line Items]  
Schedule of estimated fair value of pension plan assets and their respective levels in the fair value hierarchy
The estimated fair value of U.S. pension plan assets and their respective levels in the fair value hierarchy at July 31, 2017 and 2016 by asset category are as follows (in millions):
 
 
U.S Pension Plans
Asset Category
 
Quoted Prices in
Active Markets
for Identical
Assets
(Level 1)
 
Significant
Observable
Inputs
(Level 2)
 
Significant
Unobservable
Inputs
(Level 3)
 
Measured Using NAV Per Share as Practical Expedient
 
Total
July 31, 2017
 
 
 
 
 
 
 
 
 
 
Cash and Cash Equivalents
 
$
1.8

 
$
3.7

 
$

 
$

 
$
5.5

Global Equity Securities
 
60.9

 

 

 
80.3

 
141.2

Fixed Income Securities
 
34.9

 
82.5

 

 
34.6

 
152.0

Real Assets
 

 

 

 
5.3

 
5.3

Total U.S. Assets
 
$
97.6

 
$
86.2

 
$

 
$
120.2

 
$
304.0

 
 
 
 
 
 
 
 
 
 
 
July 31, 2016
 
 
 
 
 
 
 
 
 
 
Cash and Cash Equivalents
 
$
1.2

 
$

 
$

 
$

 
$
1.2

Global Equity Securities
 
62.2

 

 

 
100.2

 
162.4

Fixed Income Securities
 
72.2

 

 

 
47.3

 
119.5

Real Assets
 
5.9

 

 

 
7.9

 
13.8

Total U.S. Assets
 
$
141.5

 
$

 
$

 
$
155.4

 
$
296.9

Non - U.S. Plan  
Defined Benefit Plan Disclosure [Line Items]  
Schedule of estimated fair value of pension plan assets and their respective levels in the fair value hierarchy
The estimated fair values of non-U.S. pension plan assets and their respective levels in the fair value hierarchy at July 31, 2017 and 2016 by asset category are as follows (in millions):
 
 
Non-U.S. Pension Plans
Asset Category
 
Quoted Prices in
Active Markets
for Identical
Assets
(Level 1)
 
Significant
Observable
Inputs
(Level 2)
 
Significant
Unobservable
Inputs
(Level 3)
 
Total
July 31, 2017
 
 
 
 
 
 
 
 
Cash and Cash Equivalents
 
$
0.9

 
$

 
$

 
$
0.9

Global Equity Securities
 
79.7

 

 

 
79.7

Fixed Income Securities
 
11.9

 
34.3

 

 
46.2

Insurance Contracts
 

 

 
34.3

 
34.3

Total Non-U.S. Assets
 
$
92.5

 
$
34.3

 
$
34.3

 
$
161.1

 
 
 
 
 
 
 
 
 
July 31, 2016
 
 
 
 
 
 
 
 
Cash and Cash Equivalents
 
$
0.5

 
$

 
$

 
$
0.5

Global Equity Securities
 
69.2

 

 

 
69.2

Fixed Income Securities
 
4.6

 
35.8

 

 
40.4

Equity/Fixed Income
 
16.7

 

 
31.8

 
48.5

Total Non-U.S. Assets
 
$
91.0

 
$
35.8

 
$
31.8

 
$
158.6

Summary of the changes in the fair value of non-U.S. pension plans' assets with unobservable inputs
The following table summarizes the changes in the fair values of the non-U.S. pension plans’ Level 3 assets for the years ended July 31, 2017, 2016 and 2015 (in millions):
 
 
Non-U.S. Pension Plans
Ending balance at July 31, 2014
 
$
30.5

Unrealized gains
 
1.3

Foreign currency exchange
 
(5.5
)
Purchases
 
2.7

Sales
 
(0.8
)
Ending balance at July 31, 2015
 
$
28.2

Unrealized gains
 
2.7

Foreign currency exchange
 
0.3

Purchases
 
2.7

Sales
 
(2.1
)
Ending balance at July 31, 2016
 
$
31.8

Unrealized gains
 
1.2

Foreign currency exchange
 
1.7

Purchases
 
1.0

Sales
 
(1.4
)
Ending balance at July 31, 2017
 
$
34.3