XML 52 R36.htm IDEA: XBRL DOCUMENT v3.10.0.1
Employee Benefit Plans (Tables)
 12 Months Ended
Jul. 31, 2018
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) loss for the Company’s pension plans include the following components (in millions):
 
 
Year Ended July 31,
 
 
2018

 
2017

 
2016

Service cost
 
$
8.1

 
$
8.3

 
$
18.4

Interest cost
 
14.8

 
13.5

 
18.9

Expected return on assets
 
(26.2
)
 
(26.4
)
 
(28.8
)
Prior service cost and transition amortization
 
0.3

 
0.6

 
0.8

Actuarial loss amortization
 
4.6

 
7.3

 
8.5

Settlement loss
 
3.5

 
—

 
—

Net periodic benefit costs
 
5.1

 
3.3

 
17.8

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

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

Total recognized in net periodic benefit costs and other comprehensive (income) loss
 
$
(10.5
)
 
$
(26.3
)
 
$
62.1
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, 2018 and 2017 are summarized as follows (in millions):
 
 
Year Ended July 31,
 
 
2018

 
2017

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

 
$
537.3

Service cost
 
8.1

 
8.3

Interest cost
 
14.8

 
13.5

Participant contributions
 
0.8

 
0.8

Actuarial (gain) loss
 
(16.9
)
 
(22.3
)
Currency exchange rates
 
0.5

 
2.7

Settlement
 
(17.7
)
 
—

Benefits paid
 
(16.5
)
 
(25.2
)
Projected benefit obligation, end of year
 
$
488.2

 
$
515.1

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

 
$
455.5

Actual return on plan assets
 
16.5

 
28.4

Company contributions
 
37.6

 
3.1

Participant contributions
 
0.8

 
0.8

Currency exchange rates
 
0.5

 
2.5

Settlement
 
(17.7
)
 
—

Benefits paid
 
(16.5
)
 
(25.2
)
Fair value of plan assets, end of year
 
$
486.3

 
$
465.1

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

 
$
5.7

Other current liabilities
 
(1.5
)
 
(1.6
)
Other long-term liabilities
 
(16.6
)
 
(54.1
)
Net recognized liability
 
$
(1.9
)
 
$
(50.0
)
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
 
2018

 
2017

All U.S. plans:
 
 

 
 

Discount rate
 
4.43
%
 
3.94
%
Non-U.S. plans:
 
 

 
 

Discount rate
 
2.43
%
 
2.40
%
Rate of compensation increase
 
2.69
%
 
2.70
%
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
 
2018

 
2017

 
2016

All U.S. plans:
 
 

 
 

 
 

Discount rate
 
3.94
%
 
3.65
%
 
4.33
%
Expected return on plan assets
 
6.58
%
 
6.90
%
 
6.99
%
Rate of compensation increase
 
N/A

 
2.56
%
 
2.56
%
Non-U.S. plans:
 
 

 
 

 
 

Discount rate
 
2.40
%
 
2.08
%
 
3.14
%
Expected return on plan assets
 
4.19
%
 
3.93
%
 
4.83
%
Rate of compensation increase
 
2.70
%
 
2.69
%
 
2.68
%
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
2019
 
$
29.7

2020
 
26.9

2021
 
28.2

2022
 
27.0

2023
 
27.3

2024-2028
 
141.6
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, 2018 and 2017 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, 2018
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
4.7

 
$
0.3

 
$
—

 
$
—

 
$
5.0

Global equity securities
 
82.4

 
—

 
—

 
31.0

 
113.4

Fixed income securities
 
72.5

 
81.0

 
—

 
—

 
153.5

Private equity and other funds
 
—

 
—

 
—

 
53.7

 
53.7

Real asset funds
 
—

 
—

 
—

 
5.3

 
5.3

Total U.S. assets
 
$
159.6

 
$
81.3

 
$
—

 
$
90.0

 
$
330.9

 
 
 
 
 
 
 
 
 
 
 
July 31, 2017
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
1.8

 
$
3.7

 
$
—

 
$
—

 
$
5.5

Global equity securities
 
60.9

 
—

 
—

 
49.9

 
110.8

Fixed income securities
 
34.9

 
82.5

 
—

 
—

 
117.4

Private equity and other funds
 
—

 
—

 
—

 
65.0

 
65.0

Real asset funds
 
—

 
—

 
—

 
5.3

 
5.3

Total U.S. assets
 
$
97.6

 
$
86.2

 
$
—

 
$
120.2

 
$
304.0
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, 2018 and 2017 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, 2018
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
0.6

 
$
—

 
$
—

 
$
0.6

Global equity securities
 
78.8

 
—

 
—

 
78.8

Fixed income securities
 
11.3

 
—

 
—

 
11.3

Investment funds
 
—

 
36.1

 
—

 
36.1

Insurance contracts
 
—

 
—

 
28.6

 
28.6

Total Non-U.S. assets
 
$
90.7

 
$
36.1

 
$
28.6

 
$
155.4

 
 
 
 
 
 
 
 
 
July 31, 2017
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
0.9

 
$
—

 
$
—

 
$
0.9

Global equity securities
 
79.7

 
—

 
—

 
79.7

Fixed income securities
 
11.9

 
—

 
—

 
11.9

Investment funds
 
—

 
34.3

 
—

 
34.3

Insurance contracts
 
—

 
—

 
34.3

 
34.3

Total Non-U.S. assets
 
$
92.5

 
$
34.3

 
$
34.3

 
$
161.1
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, 2018, 2017 and 2016 (in millions):
 
 
Non-U.S. Pension Plans
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

Unrealized losses
 
(4.0
)
Foreign currency exchange
 
0.2

Purchases
 
0.5

Sales
 
(2.4
)
Ending balance at July 31, 2018
 
$
28.6