Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)


Common-Size Income Statement

Difficulty: Beginner

Walmart Inc., Common-Size Consolidated Income Statement

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
Net sales 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -75.50 -75.32 -75.06 -75.42 -75.71 -75.69
Gross profit 24.50% 24.68% 24.94% 24.58% 24.29% 24.31%
Membership and other income 0.80 0.92 0.95 0.73 0.71 0.68
Operating, selling, general and administrative expenses -21.00 -21.48 -21.16 -20.28 -19.37 -19.31
Operating income 4.30% 4.12% 4.73% 5.04% 5.63% 5.68%
Interest expense, debt, capital lease and financing obligations -0.46 -0.47 -0.49 -0.53 -0.51 -0.49
Interest income 0.04 0.03 0.02 0.02 0.02 0.03
Interest, net -0.42% -0.44% -0.47% -0.52% -0.49% -0.47%
Loss on extinguishment of debt 0.00 -0.63 0.00 0.00 0.00 0.00
Other gains and (losses) -1.64 0.00 0.00 0.00 0.00 0.00
Income from continuing operations before income taxes 2.25% 3.05% 4.26% 4.52% 5.14% 5.21%
Provision for income taxes -0.84 -0.93 -1.29 -1.37 -1.66 -1.71
Income from continuing operations 1.41% 2.12% 2.97% 3.15% 3.49% 3.50%
Income from discontinued operations, net of income taxes 0.00 0.00 0.00 0.00 0.06 0.03
Consolidated net income 1.41% 2.12% 2.97% 3.15% 3.55% 3.53%
Consolidated net income attributable to noncontrolling interest -0.10 -0.13 -0.14 -0.08 -0.15 -0.14
Consolidated net income attributable to Walmart 1.31% 1.99% 2.83% 3.07% 3.39% 3.39%

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
Operating income The net result for the period of deducting operating expenses from operating revenues. Walmart Inc.’s operating income as a percentage of net sales declined from 2017 to 2018 but then slightly increased from 2018 to 2019.
Income from continuing operations before income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. Walmart Inc.’s income from continuing operations before income taxes as a percentage of net sales declined from 2017 to 2018 and from 2018 to 2019.
Consolidated net income attributable to Walmart The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Walmart Inc.’s consolidated net income attributable to Walmart as a percentage of net sales declined from 2017 to 2018 and from 2018 to 2019.