Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)


Common-Size Statement of Financial Position, Assets

Difficulty: Beginner

Walmart Inc., Common-Size Consolidated Statement of Financial Position, Assets

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Cash and cash equivalents 3.52 3.30 3.45 4.36 4.48 3.56
Receivables, net 2.87 2.74 2.93 2.82 3.33 3.26
Inventories 20.19 21.41 21.65 22.28 22.16 21.91
Prepaid expenses and other 1.65 1.72 0.98 0.72 1.09 0.93
Current assets of discontinued operations 0.00 0.00 0.00 0.00 0.00 0.22
Current assets 28.23% 29.17% 29.01% 30.18% 31.06% 29.88%
Property and equipment, net 47.57 52.65 54.17 55.20 56.10 56.34
Property under capital lease and financing obligations, net 3.23 3.49 3.25 3.18 1.17 1.24
Property and equipment, including property under capital lease and financing obligations, net 50.80% 56.14% 57.43% 58.38% 57.27% 57.59%
Goodwill 14.22 8.92 8.57 8.37 8.89 9.53
Other long-term assets 6.76 5.77 4.99 3.07 2.78 3.00
Long-term assets 71.77% 70.83% 70.99% 69.82% 68.94% 70.12%
Total assets 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 assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold, or consumed within one year (or the normal operating cycle, if longer). Assets are probable future economic benefits obtained or controlled by an entity as a result of past transactions or events. Walmart Inc.’s current assets as a percentage of total assets increased from 2017 to 2018 but then declined significantly from 2018 to 2019.
Property and equipment, including property under capital lease and financing obligations, net Amount after accumulated depreciation, depletion and amortization of physical assets used in the normal conduct of business to produce goods and services and not intended for resale. Examples include, but are not limited to, land, buildings, machinery and equipment, office equipment, and furniture and fixtures. Walmart Inc.’s property and equipment, including property under capital lease and financing obligations, net as a percentage of total assets declined from 2017 to 2018 and from 2018 to 2019.
Long-term assets Sum of the carrying amounts as of the balance sheet date of all assets that are expected to be realized in cash, sold or consumed after one year or beyond the normal operating cycle, if longer. Walmart Inc.’s long-term assets as a percentage of total assets declined from 2017 to 2018 but then increased from 2018 to 2019 exceeding 2017 level.