Rendering

Component: (Network and Table)
Network
2350301 - Disclosure - Pension and Other Post-Retirement Plans (Tables)
(http://www.staples.com/role/PensionAndOtherPostRetirementPlansTables)
Table(Implied)
Slicers (applies to each fact value in each table cell)
Compensation and Retirement Disclosure [Abstract]Period [Axis]
2016-01-31 - 2017-01-28
Compensation and Retirement Disclosure [Abstract]
 
Schedule of funded status
The following table presents a summary of the total projected benefit obligation, the fair value of plan assets and the associated funded status recorded in the consolidated balance sheet at January 28, 2017 and January 30, 2016 (in millions):
 
 
January 28, 2017
 
January 30, 2016
 
 
Projected
Benefit
Obligations
 
Fair Value
of Plan
Assets
 
Funded
Status
 
Projected
Benefit
Obligations
 
Fair Value
of Plan
Assets
 
Funded
Status
Overfunded Plans:
 
 
 
 
 
 
 
 
 
 
 
 
International plans
 
$
(927
)
 
$
978

 
$
51

 
$
(924
)
 
$
969

 
$
45

Underfunded Plans:
 
 
 
 
 
 
 
 
 
 
 
 
U.S. plans
 
$

 
$

 
$

 
$
(37
)
 
$
27

 
$
(10
)
International plans
 
(65
)
 
37

 
(28
)
 
(65
)
 
37

 
(28
)
Total Underfunded Plans
 
$
(65
)
 
$
37

 
$
(28
)
 
$
(102
)
 
$
64

 
$
(38
)
 
 
Schedule of net cost
The following tables present a summary of the total net periodic cost (income) recorded in the Consolidated Statement of Income for 2016, 2015 and 2014 related to the plans (in millions):
 
 
2016
 
 
Pension Plans
 
Post-retirement
Benefit Plan
 
 
U.S. Plans
 
International Plans
 
Total
 
Total
Service cost
 
$

 
$
11

 
$
11

 
$
2

Interest cost
 
2

 
21

 
23

 
3

Expected return on plan assets
 
(2
)
 
(48
)
 
(50
)
 

Amortization of unrecognized losses and prior service costs
 
1

 
14

 
15

 
2

Settlement or curtailment loss
 
9

 

 
9

 
3

Total cost (benefit)
 
$
10

 
$
(2
)
 
$
8

 
$
10

 
 
2015
 
 
Pension Plans
 
Post-retirement
Benefit Plan
 
 
U.S. Plans
 
International Plans
 
Total
 
Total
Service cost
 
$

 
$
19

 
$
19

 
$
2

Interest cost
 
2

 
15

 
17

 
3

Expected return on plan assets
 
(2
)
 
(50
)
 
(52
)
 

Amortization of unrecognized losses and prior service costs
 
1

 
13

 
14

 
3

Total cost (benefit)
 
$
1

 
$
(3
)
 
$
(2
)
 
$
8

 
 
2014
 
 
Pension Plans
 
Post-retirement
Benefit Plan
 
 
U.S. Plans
 
International Plans
 
Total
 
Total
Service cost
 
$

 
$
10

 
$
10

 
$
1

Interest cost
 
2

 
29

 
31

 
2

Expected return on plan assets
 
(2
)
 
(51
)
 
(53
)
 

Amortization of unrecognized losses and prior service costs
 

 
10

 
10

 
2

Settlement loss
 
1

 

 
1

 

Total cost (benefit)
 
$
1

 
$
(2
)
 
$
(1
)
 
$
5



    
 
 
Schedule of changes in benefit obligations
The following table presents the changes in benefit obligations during 2015 and 2016 (in millions):
 
 
Pension Plans
 
Post-retirement
Benefit Plans
 
 
U.S. Plans
 
International
Plans
 
Total
 
Total
Projected benefit obligation at January 31, 2015
 
$
41

 
$
1,169

 
$
1,210

 
$
59

Service cost
 

 
19

 
19

 
2

Interest cost
 
2

 
15

 
17

 
3

Plan participants' contributions
 

 
1

 
1

 

Actuarial gains
 
(4
)
 
(129
)
 
(133
)
 
(3
)
Benefits paid
 
(2
)
 
(44
)
 
(46
)
 

Other
 

 
(1
)
 
(1
)
 

Currency translation adjustments
 

 
(41
)
 
(41
)
 

Projected benefit obligation at January 30, 2016
 
$
37

 
$
989

 
$
1,026

 
$
61

Service cost
 

 
11

 
11

 
2

Interest cost
 
2

 
21

 
23

 
3

Actuarial losses (gains)
 

 
43

 
43

 
(13
)
Benefits paid
 
(40
)
 
(43
)
 
(83
)
 

Negative amendment
 

 

 

 
(7
)
Settlements and curtailments
 
1

 

 
1

 
(4
)
Currency translation adjustments
 

 
(28
)
 
(28
)
 

Projected benefit obligation at January 28, 2017
 
$

 
$
993

 
$
993

 
$
42

 
 
Schedule of changes in plan assets
The following table presents the changes in pension plan assets for each of the defined benefit pension plans during 2015 and 2016 (in millions):
 
 
U.S. Plans
 
International
Plans
 
Total
Fair value of plan assets at January 31, 2015
 
$
31

 
$
1,106

 
$
1,137

Actual return on plan assets
 
(2
)
 
(28
)
 
(30
)
Employer's contributions
 

 
10

 
10

Plan participants' contributions
 

 
1

 
1

Benefits paid
 
(2
)
 
(44
)
 
(46
)
Currency translation adjustments
 

 
(39
)
 
(39
)
Fair value of plan assets at January 30, 2016
 
$
27

 
$
1,006

 
$
1,033

Actual return on plan assets
 
2

 
70

 
72

Employer's contributions
 
11

 
11

 
22

Benefits paid
 
(40
)
 
(43
)
 
(83
)
Currency translation adjustments
 

 
(29
)
 
(29
)
Fair value of plan assets at January 28, 2017
 
$

 
$
1,015

 
$
1,015

 
 
Amounts recognized in the balance sheet
Amounts recognized in the consolidated balance sheet consist of the following (in millions):
 
 
January 28, 2017
 
 
International
Pension Plans
 
 
Post-Retirement Benefit Plans
Prepaid benefit cost (included in other assets)
 
$
51

 
 
$

Accrued benefit liability (included in other long-term obligations)
 
(28
)
 
 
(42
)
Accumulated other comprehensive loss
 
291

 
 
1

Net amount recognized
 
$
314

 
 
$
(41
)
 
 
January 30, 2016
 
 
Pension Plans
 
Post-retirement
Benefit Plans
 
 
 
 
U.S. Plans
 
International
Plans
 
Total
 
Total
Prepaid benefit cost (included in other assets)
 
$

 
$
45

 
$
45

 
$

Accrued benefit liability (included in other long-term obligations)
 
(10
)
 
(28
)
 
(38
)
 
(61
)
Accumulated other comprehensive loss
 
10

 
283

 
293

 
31

Net amount recognized
 
$

 
$
300

 
$
300

 
$
(30
)
 
 
Schedule of assumptions
The following table presents the assumptions used to measure the net periodic cost and the year-end benefit obligations for the defined benefit pension and post-retirement benefit plans for 2016, 2015 and 2014:
 
 
2016
 
 
Pension Plans
 
Post-retirement Benefit Plan
 
 
U.S.
Plans
 
International
Plans
 
 
 
Weighted-average assumptions used to measure net periodic pension cost:
 
 
 
 
 
 
Discount rate
 
4.5
%
 
1.9
%
 
4.4
%
Expected return on plan assets
 
6.0
%
 
4.4
%
 
%
Rate of compensation increase
 
%
 
1.9
%
 
%
Weighted-average assumptions used to measure benefit obligations at year-end:
 
 
 
 
 
 
Discount rate
 
%
 
1.5
%
 
4.4
%
Rate of compensation increase
 
%
 
1.0
%
 
%
Rate of pension increase
 
%
 
1.7
%
 
%
 
 
2015
 
 
Pension Plans
 
Post-retirement Benefit Plan
 
 
U.S.
Plans
 
International
Plans
 
 
 
Weighted-average assumptions used to measure net periodic pension cost:
 
 
 
 
 
 
Discount rate
 
3.8
%
 
1.2
%
 
4.6
%
Expected return on plan assets
 
6.0
%
 
4.4
%
 
%
Rate of compensation increase
 
%
 
1.8
%
 
3.5
%
Weighted-average assumptions used to measure benefit obligations at year-end:
 
 
 
 
 
 
Discount rate
 
4.5
%
 
1.8
%
 
4.6
%
Rate of compensation increase
 
%
 
1.8
%
 
3.5
%
Rate of pension increase
 
%
 
1.0
%
 
%
 
 
2014
 
 
Pension Plans
 
Post-retirement Benefit Plan
 
 
U.S.
Plans
 
International
Plans
 
 
 
 
Weighted-average assumptions used to measure net periodic pension cost:
 
 
 
 
 
 
Discount rate
 
4.8
%
 
3.0
%
 
4.1
%
Expected return on plan assets
 
6.0
%
 
4.7
%
 
%
Rate of compensation increase
 
%
 
1.1
%
 
2.5
%
Weighted-average assumptions used to measure benefit obligations at year-end:
 
 
 
 
 
 
Discount rate
 
3.8
%
 
1.3
%
 
4.1
%
Rate of compensation increase
 
%
 
2.0
%
 
2.5
%
Rate of pension increase
 
%
 
1.1
%
 
%
 
 
Schedule of changes in discount rate and other assumptions
The following table shows the effect on pension obligations at January 28, 2017 of a change in discount rate and other assumptions (in millions):
 
 
Change in Discount Rate
 
 
(0.25)%
 
No change
 
0.25%
Change in rate of compensation increase:
 
 
 
 
 
 
(0.25)%
 
$
37

 
$
(1
)
 
$
(36
)
No change
 
38

 

 
(35
)
0.25%
 
39

 
1

 
(34
)
Change in rate of pension increase:
 
 
 
 
 
 
(0.25)%
 
$
1

 
$
(35
)
 
$
(68
)
No change
 
38

 

 
(35
)
0.25%
 
77

 
37

 
(1
)
 
 
Schedule of actual and target asset allocations
The Company's pension plans' actual and target asset allocations at January 28, 2017 and January 30, 2016 are as follows:
 
 
International Plans
 
 
Actual
 
Target
 
Asset allocation:
 
 
 
 
 
Equity securities
 
26
%
 
25
%
 
Debt securities
 
67
%
 
62
%
 
Real estate
 
6
%
 
8
%
 
Cash
 
%
 
%
 
Other
 
1
%
 
5
%
 
Total
 
100
%
 
100
%
 
 
 
January 30, 2016
 
 
Actual
 
Target
 
 
U.S.
Plans
 
International
Plans
 
Total
 
U.S.
Plans
 
International
Plans
 
Total
Asset allocation:
 
 
 
 
 
 
 
 
 
 
 
 
Equity securities
 
48
%
 
26
%
 
27
%
 
50
%
 
26
%
 
26
%
Debt securities
 
49
%
 
62
%
 
62
%
 
50
%
 
62
%
 
62
%
Real estate
 
3
%
 
8
%
 
7
%
 
%
 
8
%
 
8
%
Cash
 
%
 
2
%
 
2
%
 
%
 
%
 
%
Other
 
%
 
2
%
 
2
%
 
%
 
4
%
 
4
%
Total
 
100
%
 
100
%
 
100
%
 
100
%
 
100
%
 
100
%
 
 
Fair value of pension plan assets
The fair values of the Company's pension plan assets at January 28, 2017 and January 30, 2016 by asset category are as follows (in millions):
 
 
January 28, 2017
 
 
International Plans
 
 
 
 
Quoted Prices in Active Markets for Identical Assets
 
Significant Other Observable Inputs
 
Unobservable Inputs
Asset Category:
 
Fair Market
Value
 
Level 1
 
Level 2
 
Level 3
Equity securities (1)
 
$
263

 
$
209

 
$
40

 
$
14

Debt securities (2)
 
680

 
400

 
240

 
40

Real estate (3)
 
64

 
64

 

 

Cash
 
2

 
2

 

 

Other
 
6

 
12

 
(6
)
 

Total
 
$
1,015

 
$
687

 
$
274

 
$
54

 
 
 
January 30, 2016
 
 
U.S. Pension Plans
 
International Plans
 
 
 
 
Quoted Prices in Active Markets for Identical Assets
 
Significant Other Observable Inputs
 
Unobservable Inputs
 
 
 
Quoted Prices in Active Markets for Identical Assets
 
Significant Other Observable Inputs
 
Unobservable Inputs
Asset Category:
 
Fair Market
Value
 
Level 1
 
Level 2
 
Level 3
 
Fair Market
Value
 
Level 1
 
Level 2
 
Level 3
Equity securities (1)
 
$
13

 
$
13

 
$

 
$

 
$
264

 
$
209

 
$
37

 
$
18

Debt securities (2)
 
13

 
5

 

 
8

 
627

 
412

 
211

 
4

Real estate (3)
 
1

 
1

 

 

 
74

 
72

 
2

 

Cash
 

 

 

 

 
25

 
13

 
12

 

Other
 

 

 

 

 
16

 

 

 
16

Total
 
$
27

 
$
19

 
$

 
$
8

 
$
1,006

 
$
706

 
$
262

 
$
38


(1)
This category includes investments in equity securities of large, small and medium sized companies in the U.S. and in foreign companies, including those in developing countries. The funds are valued using the net asset value method in which an average of the market prices for the underlying investments is used to value the fund. For securities with unobservable inputs, the value is based on audited statements for the underlying fund.
(2)
This category includes investments in investment grade fixed income instrument, U.S. dollar denominated debt securities of emerging market issuers and high yield fixed-income securities that are rated below investment grade. The funds are valued using the net asset value method in which an average of the market prices for the underlying investments is used to value the fund. For securities with unobservable inputs, the value is based on discounted future cash flows.
(3)
This category includes investments in mortgage-backed and asset-backed securities. The funds are valued using the net asset value method in which an average of the market prices for the underlying investments is used to value the fund.

 
 
Changes in the fair value of pension assets valued using significant unobservable inputs
The change in the fair value for the pension assets valued using significant unobservable inputs (Level 3) was due to the following (in millions):
 
U.S. Plans
 
International Plans
Balance at January 30, 2016
$
8

 
$
38

Actual return on plan assets still held at the reporting date

 
16

Purchases, sales and settlements
(8
)
 

Balance at January 28, 2017
$

 
$
54

 
 
Schedule of expected benefit payments
The following table presents the expected benefit payments to pension plan participants for the next five years, and the aggregate for the following five years (in millions):
 
International
Pension Plans
2017
$
41

2018
41

2019
40

2020
40

2021
40

2022-2026
195