| Segments
|
|
|
|
|
|
• | insurance companies resulting from pharmacy sales; |
• | banks for customer credit and debit cards and electronic bank transfers that take in excess of seven days to process; |
• | consumer financing programs in certain international operations; |
• | suppliers for marketing or incentive programs; and |
• | real estate transactions. |
|
(Amounts in millions and net of income taxes) | Currency Translation and Other | Unrealized Gain on Available-for-Sale Securities | Net Investment Hedges | Cash Flow Hedges | Minimum Pension Liability | Total | ||||||||||||||||||
Balances as of February 1, 2017 | $ | (14,507 | ) | $ | 145 | $ | 1,435 | $ | (315 | ) | $ | (990 | ) | $ | (14,232 | ) | ||||||||
Other comprehensive income (loss) before reclassifications, net(1) | 2,374 | 657 | (121 | ) | 124 | 5 | 3,039 | |||||||||||||||||
Amounts reclassified from accumulated other comprehensive loss, net(1) | — | — | — | 19 | 41 | 60 | ||||||||||||||||||
Balances as of October 31, 2017 | $ | (12,133 | ) | $ | 802 | $ | 1,314 | $ | (172 | ) | $ | (944 | ) | $ | (11,133 | ) |
|
(Amounts in millions) | Long-term debt due within one year | Long-term debt | Total | |||||||||
Balances as of February 1, 2017 | $ | 2,256 | $ | 36,015 | $ | 38,271 | ||||||
Proceeds from long-term debt | — | 7,476 | 7,476 | |||||||||
Repayments of long-term debt | (1,535 | ) | (7,324 | ) | (8,859 | ) | ||||||
Reclassifications of long-term debt | 2,500 | (2,500 | ) | — | ||||||||
Other | 36 | 539 | 575 | |||||||||
Balances as of October 31, 2017 | $ | 3,257 | $ | 34,206 | $ | 37,463 |
(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 |
(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 | |||||||||
February 1, 2019 | 500 USD | Fixed | 4.125% | 135 | ||||||
July 8, 2020 | 1,500 USD | Fixed | 3.625% | 660 | ||||||
April 5, 2027 | 750 USD | Fixed | 5.875% | 207 | ||||||
September 4, 2035 | 2,500 USD | Fixed | 5.250% | 407 | ||||||
August 15, 2037 | 3,000 USD | Fixed | 6.500% | 1,549 | ||||||
April 15, 2038 | 2,000 USD | Fixed | 6.200% | 887 | ||||||
January 19, 2039 | 1,000 GBP | Fixed | 4.875% | 459 | ||||||
April 2, 2040 | 1,250 USD | Fixed | 5.625% | 382 | ||||||
July 9, 2040 | 750 USD | Fixed | 4.875% | 277 | ||||||
October 25, 2040 | 1,250 USD | Fixed | 5.000% | 605 | ||||||
April 15, 2041 | 2,000 USD | Fixed | 5.625% | 680 | ||||||
April 11, 2043 | 1,000 USD | Fixed | 4.000% | 290 | ||||||
October 2, 2043 | 750 USD | Fixed | 4.750% | 317 | ||||||
April 22, 2044 | 1,000 USD | Fixed | 4.300% | 469 | ||||||
Total repayment of extinguished debt | 7,324 | |||||||||
Total | $ | 8,824 |
|
• | Level 1: observable inputs such as quoted prices in active markets; |
• | Level 2: inputs other than quoted prices in active markets that are either directly or indirectly observable; and |
• | Level 3: unobservable inputs for which little or no market data exists, therefore requiring the Company to develop its own assumptions. |
October 31, 2017 | January 31, 2017 | ||||||||||||||
(Amounts in millions) | Notional Amount | Fair Value | Notional Amount | Fair Value | |||||||||||
Receive fixed-rate, pay variable-rate interest rate swaps designated as fair value hedges | $ | 5,000 | $ | (6 | ) | $ | 5,000 | $ | (4 | ) | |||||
Receive fixed-rate, pay fixed-rate cross-currency swaps designated as net investment hedges | 2,250 | 399 | 2,250 | 471 | |||||||||||
Receive fixed-rate, pay fixed-rate cross-currency swaps designated as cash flow hedges | 4,240 | (254 | ) | 3,957 | (618 | ) | |||||||||
Total | $ | 11,490 | $ | 139 | $ | 11,207 | $ | (151 | ) |
October 31, 2017 | January 31, 2017 | |||||||||||||||
(Amounts in millions) | Cost Basis | Fair Value | Cost Basis | Fair Value | ||||||||||||
Available-for-sale securities | $ | 1,901 | $ | 2,703 | $ | 1,901 | $ | 2,046 |
October 31, 2017 | January 31, 2017 | |||||||||||||||
(Amounts in millions) | Carrying Value | Fair Value | Carrying Value | Fair Value | ||||||||||||
Long-term debt, including amounts due within one year | $ | 37,463 | $ | 43,378 | $ | 38,271 | $ | 44,602 |
|
October 31, 2017 | January 31, 2017 | ||||||||||||||||||||||
(Amounts in millions) | Fair Value Instruments | Net Investment Instruments | Cash Flow Instruments | Fair Value Instruments | Net Investment Instruments | Cash Flow Instruments | |||||||||||||||||
Derivative instruments | |||||||||||||||||||||||
Derivative assets: | |||||||||||||||||||||||
Other assets and deferred charges | $ | 7 | $ | 399 | $ | 86 | $ | 8 | $ | 471 | $ | — | |||||||||||
Derivative liabilities: | |||||||||||||||||||||||
Deferred income taxes and other | 13 | — | 340 | 12 | — | 618 | |||||||||||||||||
Nonderivative hedging instruments | |||||||||||||||||||||||
Long-term debt | — | 4,423 | — | — | 3,209 | — |
|
Record Date | Payable Date | |
March 10, 2017 | April 3, 2017 | |
May 12, 2017 | June 5, 2017 | |
August 11, 2017 | September 5, 2017 | |
December 8, 2017 | January 2, 2018 |
|
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Ongoing inquiries and investigations | $ | 2 | $ | 24 | $ | 22 | $ | 68 | ||||||||
Global compliance program and organizational enhancements | 3 | 5 | 11 | 14 | ||||||||||||
Total | $ | 5 | $ | 29 | $ | 33 | $ | 82 |
|
|
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Net sales: | ||||||||||||||||
Walmart U.S. | $ | 77,724 | $ | 74,550 | $ | 231,898 | $ | 224,086 | ||||||||
Walmart International | 29,548 | 28,390 | 84,976 | 85,094 | ||||||||||||
Sam's Club | 14,864 | 14,236 | 43,737 | 42,387 | ||||||||||||
Net sales | $ | 122,136 | $ | 117,176 | $ | 360,611 | $ | 351,567 |
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Operating income (loss): | ||||||||||||||||
Walmart U.S. | $ | 4,030 | $ | 3,999 | $ | 12,917 | $ | 12,750 | ||||||||
Walmart International | 1,249 | 1,354 | 4,004 | 4,245 | ||||||||||||
Sam's Club | 447 | 396 | 1,265 | 1,281 | ||||||||||||
Corporate and support | (962 | ) | (630 | ) | (2,216 | ) | (1,717 | ) | ||||||||
Operating income | 4,764 | 5,119 | 15,970 | 16,559 | ||||||||||||
Interest, net | 541 | 585 | 1,679 | 1,712 | ||||||||||||
Loss on extinguishment of debt | 1,344 | — | 2,132 | — | ||||||||||||
Income before income taxes | $ | 2,879 | $ | 4,534 | $ | 12,159 | $ | 14,847 |
|
• | insurance companies resulting from pharmacy sales; |
• | banks for customer credit and debit cards and electronic bank transfers that take in excess of seven days to process; |
• | consumer financing programs in certain international operations; |
• | suppliers for marketing or incentive programs; and |
• | real estate transactions. |
|
(Amounts in millions and net of income taxes) | Currency Translation and Other | Unrealized Gain on Available-for-Sale Securities | Net Investment Hedges | Cash Flow Hedges | Minimum Pension Liability | Total | ||||||||||||||||||
Balances as of February 1, 2017 | $ | (14,507 | ) | $ | 145 | $ | 1,435 | $ | (315 | ) | $ | (990 | ) | $ | (14,232 | ) | ||||||||
Other comprehensive income (loss) before reclassifications, net(1) | 2,374 | 657 | (121 | ) | 124 | 5 | 3,039 | |||||||||||||||||
Amounts reclassified from accumulated other comprehensive loss, net(1) | — | — | — | 19 | 41 | 60 | ||||||||||||||||||
Balances as of October 31, 2017 | $ | (12,133 | ) | $ | 802 | $ | 1,314 | $ | (172 | ) | $ | (944 | ) | $ | (11,133 | ) |
|
(Amounts in millions) | Long-term debt due within one year | Long-term debt | Total | |||||||||
Balances as of February 1, 2017 | $ | 2,256 | $ | 36,015 | $ | 38,271 | ||||||
Proceeds from long-term debt | — | 7,476 | 7,476 | |||||||||
Repayments of long-term debt | (1,535 | ) | (7,324 | ) | (8,859 | ) | ||||||
Reclassifications of long-term debt | 2,500 | (2,500 | ) | — | ||||||||
Other | 36 | 539 | 575 | |||||||||
Balances as of October 31, 2017 | $ | 3,257 | $ | 34,206 | $ | 37,463 |
(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 |
(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 | |||||||||
February 1, 2019 | 500 USD | Fixed | 4.125% | 135 | ||||||
July 8, 2020 | 1,500 USD | Fixed | 3.625% | 660 | ||||||
April 5, 2027 | 750 USD | Fixed | 5.875% | 207 | ||||||
September 4, 2035 | 2,500 USD | Fixed | 5.250% | 407 | ||||||
August 15, 2037 | 3,000 USD | Fixed | 6.500% | 1,549 | ||||||
April 15, 2038 | 2,000 USD | Fixed | 6.200% | 887 | ||||||
January 19, 2039 | 1,000 GBP | Fixed | 4.875% | 459 | ||||||
April 2, 2040 | 1,250 USD | Fixed | 5.625% | 382 | ||||||
July 9, 2040 | 750 USD | Fixed | 4.875% | 277 | ||||||
October 25, 2040 | 1,250 USD | Fixed | 5.000% | 605 | ||||||
April 15, 2041 | 2,000 USD | Fixed | 5.625% | 680 | ||||||
April 11, 2043 | 1,000 USD | Fixed | 4.000% | 290 | ||||||
October 2, 2043 | 750 USD | Fixed | 4.750% | 317 | ||||||
April 22, 2044 | 1,000 USD | Fixed | 4.300% | 469 | ||||||
Total repayment of extinguished debt | 7,324 | |||||||||
Total | $ | 8,824 |
|
October 31, 2017 | January 31, 2017 | ||||||||||||||
(Amounts in millions) | Notional Amount | Fair Value | Notional Amount | Fair Value | |||||||||||
Receive fixed-rate, pay variable-rate interest rate swaps designated as fair value hedges | $ | 5,000 | $ | (6 | ) | $ | 5,000 | $ | (4 | ) | |||||
Receive fixed-rate, pay fixed-rate cross-currency swaps designated as net investment hedges | 2,250 | 399 | 2,250 | 471 | |||||||||||
Receive fixed-rate, pay fixed-rate cross-currency swaps designated as cash flow hedges | 4,240 | (254 | ) | 3,957 | (618 | ) | |||||||||
Total | $ | 11,490 | $ | 139 | $ | 11,207 | $ | (151 | ) |
October 31, 2017 | January 31, 2017 | |||||||||||||||
(Amounts in millions) | Cost Basis | Fair Value | Cost Basis | Fair Value | ||||||||||||
Available-for-sale securities | $ | 1,901 | $ | 2,703 | $ | 1,901 | $ | 2,046 |
October 31, 2017 | January 31, 2017 | |||||||||||||||
(Amounts in millions) | Carrying Value | Fair Value | Carrying Value | Fair Value | ||||||||||||
Long-term debt, including amounts due within one year | $ | 37,463 | $ | 43,378 | $ | 38,271 | $ | 44,602 |
|
October 31, 2017 | January 31, 2017 | ||||||||||||||||||||||
(Amounts in millions) | Fair Value Instruments | Net Investment Instruments | Cash Flow Instruments | Fair Value Instruments | Net Investment Instruments | Cash Flow Instruments | |||||||||||||||||
Derivative instruments | |||||||||||||||||||||||
Derivative assets: | |||||||||||||||||||||||
Other assets and deferred charges | $ | 7 | $ | 399 | $ | 86 | $ | 8 | $ | 471 | $ | — | |||||||||||
Derivative liabilities: | |||||||||||||||||||||||
Deferred income taxes and other | 13 | — | 340 | 12 | — | 618 | |||||||||||||||||
Nonderivative hedging instruments | |||||||||||||||||||||||
Long-term debt | — | 4,423 | — | — | 3,209 | — |
|
Record Date | Payable Date | |
March 10, 2017 | April 3, 2017 | |
May 12, 2017 | June 5, 2017 | |
August 11, 2017 | September 5, 2017 | |
December 8, 2017 | January 2, 2018 |
|
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Ongoing inquiries and investigations | $ | 2 | $ | 24 | $ | 22 | $ | 68 | ||||||||
Global compliance program and organizational enhancements | 3 | 5 | 11 | 14 | ||||||||||||
Total | $ | 5 | $ | 29 | $ | 33 | $ | 82 |
|
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Net sales: | ||||||||||||||||
Walmart U.S. | $ | 77,724 | $ | 74,550 | $ | 231,898 | $ | 224,086 | ||||||||
Walmart International | 29,548 | 28,390 | 84,976 | 85,094 | ||||||||||||
Sam's Club | 14,864 | 14,236 | 43,737 | 42,387 | ||||||||||||
Net sales | $ | 122,136 | $ | 117,176 | $ | 360,611 | $ | 351,567 |
Three Months Ended October 31, | Nine Months Ended October 31, | |||||||||||||||
(Amounts in millions) | 2017 | 2016 | 2017 | 2016 | ||||||||||||
Operating income (loss): | ||||||||||||||||
Walmart U.S. | $ | 4,030 | $ | 3,999 | $ | 12,917 | $ | 12,750 | ||||||||
Walmart International | 1,249 | 1,354 | 4,004 | 4,245 | ||||||||||||
Sam's Club | 447 | 396 | 1,265 | 1,281 | ||||||||||||
Corporate and support | (962 | ) | (630 | ) | (2,216 | ) | (1,717 | ) | ||||||||
Operating income | 4,764 | 5,119 | 15,970 | 16,559 | ||||||||||||
Interest, net | 541 | 585 | 1,679 | 1,712 | ||||||||||||
Loss on extinguishment of debt | 1,344 | — | 2,132 | — | ||||||||||||
Income before income taxes | $ | 2,879 | $ | 4,534 | $ | 12,159 | $ | 14,847 |
|