XML 57 R31.htm IDEA: XBRL DOCUMENT v3.8.0.1
Short-term Borrowings and Long-term Debt (Tables)
12 Months Ended
Jan. 31, 2018
Debt Instrument [Line Items]  
Schedule of Line of Credit Facilities
These committed lines of credit are summarized in the following table:
 
 
As of January 31,
 
 
2018
 
2017
(Amounts in millions)
 
Available
 
Drawn
 
Undrawn
 
Available
 
Drawn
 
Undrawn
Five-year credit facility(1)
 
$
5,000

 
$

 
$
5,000

 
$
5,000

 
$

 
$
5,000

364-day revolving credit facility(1)
 
7,500

 

 
7,500

 
7,500

 

 
7,500

Total
 
$
12,500

 
$

 
$
12,500

 
$
12,500

 
$

 
$
12,500


(1)
In May 2017, the Company renewed and extended its existing five-year credit facility and its existing 364-day revolving credit facility, both of which are used to support its commercial paper program.
Schedule of Long-term Debt Instruments
The Company's long-term debt, which includes the fair value instruments further discussed in Note 8, consists of the following:
 
 
 
 
January 31, 2018
 
January 31, 2017
(Amounts in millions)
 
Maturity Dates
By Fiscal Year
 
Amount
 
Average Rate(1)
 
Amount
 
Average Rate(1)
Unsecured debt
 
 
 
 
 
 
 
 
 
 
Fixed
 
2019 - 2048
 
$
24,540

 
3.9%
 
$
30,500

 
4.7%
Variable
 
2019 - 2020
 
800

 
4.1%
 
500

 
5.5%
Total U.S. dollar denominated
 
 
 
25,340

 
 
 
31,000

 
 
Fixed
 
2023 - 2030
 
3,101

 
3.3%
 
2,674

 
3.3%
Variable
 
 
 

 
 
 

 
 
Total Euro denominated
 
 
 
3,101

 
 
 
2,674

 
 
Fixed
 
2031 - 2039
 
3,801

 
5.4%
 
4,370

 
5.3%
Variable
 
 
 

 
 
 

 
 
Total Sterling denominated
 
 
 
3,801

 
 
 
4,370

 
 
Fixed
 
2021 - 2028
 
1,655

 
0.4%
 
88

 
1.6%
Variable
 
 
 

 
 
 

 
 
Total Yen denominated
 
 
 
1,655

 
 
 
88

 
 
Total unsecured debt
 
 
 
33,897

 
 
 
38,132

 
 
Total other(2)
 
 
 
(114
)
 
 
 
139

 
 
Total debt
 
 
 
33,783

 
 
 
38,271

 
 
Less amounts due within one year
 
 
 
(3,738
)
 
 
 
(2,256
)
 
 
Long-term debt
 
 
 
$
30,045

 
 
 
$
36,015

 
 
(1)
The average rate represents the weighted-average stated rate for each corresponding debt category, based on year-end balances and year-end interest rates. Interest costs are also impacted by certain derivative financial instruments described in Note 8.
(2)
Includes deferred loan costs, discounts, fair value hedges, foreign-held debt and secured debt. At January 31, 2018 and 2017 the Company had secured debt in the amount of $10 million and $14 million, respectively, which was collateralized by property that had an aggregate carrying amount of approximately $101 million and $82 million, respectively.
Schedule of Maturities of Long-term Debt
Annual maturities of long-term debt during the next five years and thereafter are as follows:
(Amounts in millions)
Annual
Fiscal Year
Maturities
2019
$
3,733

2020
1,914

2021
3,336

2022
607

2023
2,934

Thereafter
21,259

Total
$
33,783

Schedule of Fiscal Year 2018 Debt Issuances
Information on significant long-term debt issued during fiscal 2018 is as follows:
(Amounts in millions)
 
 
 
 
 
 
 
 
 
 
Issue Date
 
Principal Amount
 
Maturity Date
 
Fixed vs. Floating
 
Interest Rate
 
Proceeds
July 18, 2017
 
70,000 JPY
 
July 15, 2022
 
Fixed
 
0.183%
 
$
619

July 18, 2017
 
40,000 JPY
 
July 18, 2024
 
Fixed
 
0.298%
 
354

July 18, 2017
 
60,000 JPY
 
July 16, 2027
 
Fixed
 
0.520%
 
530

October 20, 2017
 
300 USD
 
October 9, 2019
 
Floating
 
Floating
 
299

October 20, 2017
 
1,200 USD
 
October 9, 2019
 
Fixed
 
1.750%
 
1,198

October 20, 2017
 
1,250 USD
 
December 15, 2020
 
Fixed
 
1.900%
 
1,245

October 20, 2017
 
1,250 USD
 
December 15, 2022
 
Fixed
 
2.350%
 
1,245

October 20, 2017
 
1,000 USD
 
December 15, 2024
 
Fixed
 
2.650%
 
996

October 20, 2017
 
1,000 USD
 
December 15, 2047
 
Fixed
 
3.625%
 
990

Total
 
 
 
 
 
 
 
 
 
$
7,476

Schedule of Fiscal 2018 and 2017 Debt Maturities
The following table provides details of debt repayments during fiscal 2018:
(Amounts in millions)
 
 
 
 
 
 
 
 
Maturity Date
 
Principal Amount
 
Fixed vs. Floating
 
Interest Rate
 
Repayment(1)
April 5, 2017
 
1,000 USD
 
Fixed
 
5.375%
 
$
1,000

April 21, 2017
 
500 USD
 
Fixed
 
1.000%
 
500

Total repayment of matured debt
 
 
 
 
 
 
 
1,500

 
 
 
 
 
 
 
 
 
December 15, 2018
 
1,000 USD
 
Fixed
 
1.950%
 
276

February 1, 2019
 
500 USD
 
Fixed
 
4.125%
 
136

July 8, 2020
 
1,500 USD
 
Fixed
 
3.625%
 
661

October 25, 2020
 
1,750 USD
 
Fixed
 
3.250%
 
553

April 15, 2021
 
1,000 USD
 
Fixed
 
4.250%
 
491

October 16, 2023
 
250 USD
 
Fixed
 
6.750%
 
98

April 5, 2027
 
750 USD
 
Fixed
 
5.875%
 
267

February 15, 2030
 
500 USD
 
Fixed
 
7.550%
 
412

September 4, 2035
 
2,500 USD
 
Fixed
 
5.250%
 
532

September 28, 2035
 
1,000 GBP
 
Fixed
 
5.250%
 
260

August 17, 2037
 
3,000 USD
 
Fixed
 
6.500%
 
1,700

April 15, 2038
 
2,000 USD
 
Fixed
 
6.200%
 
1,081

January 19, 2039
 
1,000 GBP
 
Fixed
 
4.875%
 
851

April 2, 2040
 
1,250 USD
 
Fixed
 
5.625%
 
499

July 9, 2040
 
750 USD
 
Fixed
 
4.875%
 
372

October 25, 2040
 
1,250 USD
 
Fixed
 
5.000%
 
731

April 15, 2041
 
2,000 USD
 
Fixed
 
5.625%
 
1,082

April 11, 2043
 
1,000 USD
 
Fixed
 
4.000%
 
291

October 2, 2043
 
750 USD
 
Fixed
 
4.750%
 
481

April 22, 2044
 
1,000 USD
 
Fixed
 
4.300%
 
498

Total repayment of extinguished debt
 
 
 
 
 
 
 
11,272

Total
 
 
 
 
 
 
 
$
12,772

(1) Represents portion of the principal amount repaid during fiscal 2018.
In connection with extinguishing debt, the Company paid premiums of approximately $3.1 billion during fiscal 2018, resulting in a loss on extinguishment of debt of approximately $3.1 billion.
During fiscal 2017, the following long-term debt matured and was repaid:
(Amounts in millions)
 
 
 
 
 
 
 
 
Maturity Date
 
Principal Amount
 
Fixed vs. Floating
 
Interest Rate
 
Repayment
April 11, 2016
 
1,000 USD
 
Fixed
 
0.600%
 
$
1,000

April 15, 2016
 
1,000 USD
 
Fixed
 
2.800%
 
1,000

 
 
 
 
 
 
 
 
$
2,000