Microsoft Excel LibreOffice Calc

Walmart Inc. (WMT)

Common-Size Income Statement
Quarterly Data

Difficulty: Beginner

Walmart Inc., Common-Size Consolidated Income Statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018 Oct 31, 2017 Jul 31, 2017 Apr 30, 2017 Jan 31, 2017 Oct 31, 2016 Jul 31, 2016 Apr 30, 2016 Jan 31, 2016 Oct 31, 2015 Jul 31, 2015 Apr 30, 2015 Jan 31, 2015 Oct 31, 2014 Jul 31, 2014 Apr 30, 2014 Jan 31, 2014 Oct 31, 2013 Jul 31, 2013 Apr 30, 2013
Net sales 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -75.67 -76.16 -75.16 -75.22 -75.40 -75.95 -74.95 -75.05 -75.25 -75.33 -74.66 -74.94 -75.26 -75.38 -75.00 -75.47 -75.86 -75.86 -75.58 -75.43 -75.95 -76.07 -75.46 -75.30 -75.89
Gross profit 24.33% 23.84% 24.84% 24.78% 24.60% 24.05% 25.05% 24.95% 24.75% 24.67% 25.34% 25.06% 24.74% 24.62% 25.00% 24.53% 24.14% 24.14% 24.42% 24.57% 24.05% 23.93% 24.54% 24.70% 24.11%
Membership and other income 0.79 0.76 0.80 0.76 0.87 0.83 0.85 1.15 0.87 0.91 0.86 1.21 0.80 0.76 0.69 0.75 0.72 0.70 0.78 0.66 0.69 0.71 0.71 0.63 0.67
Operating, selling, general and administrative expenses -21.10 -20.20 -21.62 -21.02 -21.24 -21.58 -22.00 -21.21 -21.13 -20.80 -21.83 -21.11 -20.95 -20.22 -20.80 -20.20 -19.88 -18.75 -19.89 -19.59 -19.32 -18.94 -19.75 -19.49 -19.10
Operating income 4.02% 4.40% 4.02% 4.53% 4.24% 3.31% 3.90% 4.89% 4.49% 4.78% 4.37% 5.16% 4.59% 5.16% 4.90% 5.09% 4.98% 6.08% 5.31% 5.65% 5.42% 5.70% 5.49% 5.84% 5.68%
Interest expense, debt, finance, capital lease and financing obligations -0.55 -0.49 -0.48 -0.44 -0.44 -0.40 -0.48 -0.50 -0.51 -0.45 -0.52 -0.49 -0.51 -0.44 -0.49 -0.48 -0.74 -0.48 -0.57 -0.48 -0.52 -0.45 -0.52 -0.51 -0.51
Interest income 0.04 0.05 0.05 0.04 0.04 0.03 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.01 0.02 0.02 0.02 0.03 0.02 0.03 0.02 0.02 0.01 0.03 0.04
Interest, net -0.51% -0.44% -0.43% -0.40% -0.40% -0.37% -0.44% -0.47% -0.48% -0.43% -0.50% -0.47% -0.49% -0.43% -0.47% -0.46% -0.72% -0.45% -0.56% -0.45% -0.50% -0.43% -0.50% -0.48% -0.47%
Loss on extinguishment of debt 0.00 0.00 0.00 0.00 0.00 -0.74 -1.10 -0.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Other gains and (losses) 0.68 0.15 -1.51 -3.82 -1.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Income from continuing operations before income taxes 4.19% 4.11% 2.08% 0.31% 2.32% 2.19% 2.36% 3.78% 4.01% 4.35% 3.87% 4.69% 4.10% 4.74% 4.43% 4.63% 4.26% 5.64% 4.75% 5.20% 4.93% 5.27% 4.99% 5.36% 5.21%
Provision for income taxes -1.02 -1.34 -0.61 -0.89 -0.45 -0.44 -0.80 -1.23 -1.31 -1.28 -1.14 -1.43 -1.30 -1.05 -1.50 -1.58 -1.38 -1.66 -1.51 -1.77 -1.68 -1.75 -1.62 -1.74 -1.74
Income (loss) from continuing operations 3.18% 2.77% 1.47% -0.57% 1.87% 1.75% 1.56% 2.55% 2.70% 3.07% 2.73% 3.26% 2.80% 3.69% 2.93% 3.05% 2.88% 3.97% 3.24% 3.43% 3.25% 3.53% 3.37% 3.62% 3.47%
Income from discontinued operations, net of income taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.23 0.01 0.08 0.01 0.01 0.01
Consolidated net income (loss) 3.18% 2.77% 1.47% -0.57% 1.87% 1.75% 1.56% 2.55% 2.70% 3.07% 2.73% 3.26% 2.80% 3.69% 2.93% 3.05% 2.88% 3.97% 3.24% 3.65% 3.26% 3.61% 3.38% 3.63% 3.48%
Consolidated net (income) loss attributable to noncontrolling interest -0.05 -0.09 -0.09 -0.11 -0.12 -0.14 -0.13 -0.17 -0.10 -0.18 -0.14 -0.10 -0.12 -0.14 -0.09 -0.13 0.05 -0.17 -0.10 -0.22 -0.12 -0.17 -0.13 -0.13 -0.14
Consolidated net income (loss) attributable to Walmart 3.12% 2.68% 1.38% -0.68% 1.75% 1.61% 1.43% 2.38% 2.61% 2.90% 2.59% 3.16% 2.68% 3.55% 2.83% 2.91% 2.93% 3.80% 3.14% 3.43% 3.15% 3.44% 3.25% 3.50% 3.34%

Based on: 10-Q (filing date: 2019-06-07), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-30), 10-Q (filing date: 2018-09-06), 10-Q (filing date: 2018-06-04), 10-K (filing date: 2018-03-30), 10-Q (filing date: 2017-12-01), 10-Q (filing date: 2017-08-31), 10-Q (filing date: 2017-06-02), 10-K (filing date: 2017-03-31), 10-Q (filing date: 2016-12-01), 10-Q (filing date: 2016-08-31), 10-Q (filing date: 2016-06-03), 10-K (filing date: 2016-03-30), 10-Q (filing date: 2015-12-02), 10-Q (filing date: 2015-09-09), 10-Q (filing date: 2015-06-05), 10-K (filing date: 2015-04-01), 10-Q (filing date: 2014-12-01), 10-Q (filing date: 2014-09-05), 10-Q (filing date: 2014-06-06), 10-K (filing date: 2014-03-21), 10-Q (filing date: 2013-12-06), 10-Q (filing date: 2013-09-05), 10-Q (filing date: 2013-06-07).

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 increased from Q3 2019 to Q4 2019 but then declined significantly from Q4 2019 to Q1 2020.
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 increased from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.
Consolidated net income (loss) 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 (loss) attributable to Walmart as a percentage of net sales increased from Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020.