Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)


Common-Size Statement of Financial Position, Liabilities and Stockholders’ Equity

Difficulty: Beginner

Walmart Inc., Common-Size Consolidated Statement of Financial Position, Liabilities and Stockholders’ Equity

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Short-term borrowings 2.38 2.57 0.55 1.36 0.78 3.75
Accounts payable 21.46 22.54 20.84 19.28 18.86 18.27
Accrued wages and benefits 2.97 3.42 3.07 2.91 2.43 2.27
Self-insurance 1.81 1.83 1.97 1.71 1.62 1.70
Accrued non-income taxes 1.36 1.50 1.42 1.27 1.27 1.25
Deferred gift card revenue 0.88 0.99 0.93 0.00 0.00 0.00
Other 3.08 3.08 3.00 3.93 4.07 3.96
Accrued liabilities 10.10% 10.82% 10.39% 9.82% 9.40% 9.18%
Accrued income taxes 0.20 0.32 0.46 0.26 0.50 0.47
Long-term debt due within one year 0.86 1.83 1.13 1.38 2.36 2.00
Capital lease and financing obligations due within one year 0.33 0.33 0.28 0.28 0.14 0.15
Current liabilities of discontinued operations 0.00 0.00 0.00 0.00 0.00 0.04
Current liabilities 35.33% 38.39% 33.66% 32.38% 32.04% 33.87%
Long-term debt, excluding due within one year 19.85 14.69 18.11 19.15 20.17 20.40
Long-term capital lease and financing obligations, excluding due within one year 3.05 3.32 3.02 2.91 1.28 1.36
Deferred income taxes and other 5.46 4.08 4.70 3.67 4.32 3.92
Long-term liabilities 28.36% 22.09% 25.83% 25.73% 25.77% 25.68%
Total liabilities 63.69% 60.48% 59.49% 58.11% 57.81% 59.55%
Redeemable noncontrolling interest 0.00 0.00 0.00 0.00 0.00 0.73
Common stock 0.13 0.14 0.15 0.16 0.16 0.16
Capital in excess of par value 1.35 1.29 1.19 0.90 1.21 1.15
Retained earnings 36.84 41.61 44.94 45.10 42.11 37.39
Accumulated other comprehensive loss -5.26 -4.98 -7.16 -5.81 -3.52 -1.46
Total Walmart shareholders’ equity 33.06% 38.07% 39.13% 40.36% 39.96% 37.24%
Nonredeemable noncontrolling interest 3.25 1.44 1.38 1.54 2.23 2.48
Total equity 36.31% 39.52% 40.51% 41.89% 42.19% 39.73%
Total liabilities, redeemable noncontrolling interest, and equity 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-30), 10-K (filing date: 2017-03-31), 10-K (filing date: 2016-03-30), 10-K (filing date: 2015-04-01), 10-K (filing date: 2014-03-21).

Item Description The company
Current liabilities Total obligations incurred as part of normal operations that are expected to be paid during the following twelve months or within one business cycle, if longer. Walmart Inc.’s current liabilities as a percentage of total liabilities, redeemable noncontrolling interest, and equity increased from 2017 to 2018 but then slightly declined from 2018 to 2019 not reaching 2017 level.
Long-term liabilities Amount of obligation due after one year or beyond the normal operating cycle, if longer. Walmart Inc.’s long-term liabilities as a percentage of total liabilities, redeemable noncontrolling interest, and equity declined from 2017 to 2018 but then increased from 2018 to 2019 exceeding 2017 level.
Total liabilities Sum of the carrying amounts as of the balance sheet date of all liabilities that are recognized. Liabilities are probable future sacrifices of economic benefits arising from present obligations of an entity to transfer assets or provide services to other entities in the future. Walmart Inc.’s total liabilities as a percentage of total liabilities, redeemable noncontrolling interest, and equity increased from 2017 to 2018 and from 2018 to 2019.
Total Walmart shareholders’ equity Total of all stockholders’ equity (deficit) items, net of receivables from officers, directors, owners, and affiliates of the entity which are attributable to the parent. The amount of the economic entity’s stockholders’ equity attributable to the parent excludes the amount of stockholders’ equity which is allocable to that ownership interest in subsidiary equity which is not attributable to the parent (noncontrolling interest, minority interest). This excludes temporary equity and is sometimes called permanent equity. Walmart Inc.’s total Walmart shareholders’ equity as a percentage of total liabilities, redeemable noncontrolling interest, and equity declined from 2017 to 2018 and from 2018 to 2019.