Microsoft Excel LibreOffice Calc

Altria Group Inc. (MO)

Common-Size Income Statement
Quarterly Data

Difficulty: Beginner

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

Microsoft Excel LibreOffice Calc
3 months ended Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Net revenues 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 -29.79 -27.57 -28.39 -30.22 -28.83 -29.25 -29.76 -30.47 -29.59 -29.50 -30.89 -31.77 -28.84 -30.30 -30.96 -31.74 -32.03 -31.46 -31.76 -32.83 -29.59 -31.28 -23.50
Excise taxes on products -22.60 -22.62 -23.54 -22.73 -23.87 -23.94 -24.56 -24.30 -24.79 -25.15 -25.32 -25.15 -25.69 -26.28 -26.40 -26.29 -26.78 -26.93 -27.35 -27.57 -27.36 -28.22 -28.13
Gross profit 47.61% 49.82% 48.07% 47.04% 47.30% 46.81% 45.68% 45.23% 45.62% 45.35% 43.79% 43.08% 45.47% 43.41% 42.64% 41.98% 41.20% 41.61% 40.89% 39.61% 43.05% 40.51% 48.37%
Marketing, administration and research costs -10.24 -10.17 -10.12 -11.44 -8.44 -8.52 -8.68 -12.46 -11.09 -8.37 -9.22 -11.98 -10.42 -9.72 -10.51 -11.47 -10.21 -10.20 -9.43 -9.90 -10.13 -8.75 -9.44
Changes of PMI tax-related receivable/payable 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.61 0.00 0.00 0.05 -0.08 0.00 0.00 0.05 -0.38 0.00 0.00
Asset impairment and exit costs 0.03 -0.03 -0.03 -0.15 -0.12 -0.18 -0.07 -0.90 -0.03 -0.02 -1.98 0.00 0.00 -0.06 0.00 0.00 -0.11 0.16 -0.04 -0.16 0.00 -0.02 0.00
Operating income 37.40% 39.62% 37.92% 35.45% 38.74% 38.11% 36.94% 31.88% 34.50% 36.96% 32.59% 31.10% 34.44% 33.63% 32.13% 30.55% 30.80% 31.57% 31.43% 29.59% 32.53% 31.74% 38.93%
Interest and other debt expense, net -2.33 -2.82 -2.72 -2.95 -2.51 -2.66 -2.94 -2.82 -2.59 -2.94 -3.30 -3.29 -3.06 -2.95 -3.60 -3.39 -3.28 -3.68 -2.77 -4.19 -4.10 -4.19 -4.72
Net periodic benefit income, excluding service cost 0.31 0.14 0.11 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
Loss on early extinguishment of debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -11.92 0.00 0.00 0.00 0.00 0.00 -3.93 -0.70 0.00 0.00 0.00 -17.83 0.00 0.00 0.00
Earnings from equity investment in AB InBev 2.76 3.62 5.60 3.28 2.51 2.10 0.38 3.69 4.33 3.05 1.09 3.34 2.79 3.40 2.31 4.04 5.05 3.20 4.08 4.16 3.89 3.60 4.63
Other income, net 0.00 0.00 -0.54 0.00 0.55 6.12 0.00 218.49 0.70 1.79 0.66 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Earnings before income taxes 38.15% 40.56% 40.37% 35.78% 39.29% 43.67% 34.37% 251.25% 25.01% 38.86% 31.04% 31.23% 34.17% 34.08% 26.91% 30.50% 32.57% 31.09% 32.74% 11.73% 32.32% 31.15% 38.84%
(Provision) benefit for income taxes -9.71 -10.79 -9.35 45.65 -11.55 -13.81 -11.33 -86.85 -9.17 -13.49 -10.96 -11.48 -11.36 -12.17 -9.37 -10.75 -11.05 -10.92 -11.44 -3.70 -11.02 -11.07 -13.78
Net earnings 28.43% 29.77% 31.02% 81.43% 27.75% 29.87% 23.05% 164.40% 15.84% 25.36% 20.08% 19.75% 22.81% 21.91% 17.54% 19.75% 21.52% 20.17% 21.30% 8.03% 21.30% 20.08% 25.05%
Net earnings attributable to noncontrolling interests -0.01 -0.02 -0.02 -0.03 -0.01 -0.02 -0.02 -0.03 -0.01 -0.02 -0.02 -0.02 0.00 -0.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net earnings attributable to Altria 28.42% 29.75% 31.01% 81.40% 27.73% 29.85% 23.03% 164.36% 15.83% 25.35% 20.06% 19.74% 22.81% 21.90% 17.54% 19.75% 21.52% 20.17% 21.30% 8.03% 21.30% 20.08% 25.05%

Based on: 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-27), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-29), 10-Q (filing date: 2015-04-23), 10-K (filing date: 2015-02-25), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-07-22), 10-Q (filing date: 2014-04-24), 10-K (filing date: 2014-02-26), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-24), 10-Q (filing date: 2013-04-25).

Item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Altria Group Inc.’s operating income as a percentage of net revenues increased from Q1 2018 to Q2 2018 but then declined significantly from Q2 2018 to Q3 2018.
Earnings 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. Altria Group Inc.’s earnings before income taxes as a percentage of net revenues increased from Q1 2018 to Q2 2018 but then declined significantly from Q2 2018 to Q3 2018.
Net earnings attributable to Altria The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Altria Group Inc.’s net earnings attributable to Altria as a percentage of net revenues declined from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.