Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)

Common-Size Income Statement
Quarterly Data

Low level of difficulty

Comcast Corp., common-size consolidated income statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 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
Revenue 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
Programming and production -31.00 -30.74 -31.90 -33.23 -30.32 -28.99 -32.60 -31.45 -28.96 -29.96 -29.68 -31.09 -32.85 -28.50 -28.90 -30.32 -29.90 -30.25 -30.60 -30.22 -28.42 -28.94 -33.94
Gross profit 69.00% 69.26% 68.10% 66.77% 69.68% 71.01% 67.40% 68.55% 71.04% 70.04% 70.32% 68.91% 67.15% 71.50% 71.10% 69.68% 70.10% 69.75% 69.40% 69.78% 71.58% 71.06% 66.06%
Other operating and administrative -30.16 -30.11 -29.41 -31.50 -29.11 -29.28 -28.58 -30.59 -30.61 -28.63 -28.48 -29.15 -28.12 -29.90 -29.40 -29.03 -28.89 -28.17 -28.45 -29.14 -29.89 -29.23 -27.30
Advertising, marketing and promotion -7.09 -7.02 -7.03 -7.58 -7.53 -7.61 -7.04 -7.16 -7.40 -7.87 -7.48 -7.61 -6.97 -8.10 -7.81 -8.06 -8.08 -8.15 -7.59 -7.50 -7.72 -7.37 -6.95
Depreciation -7.92 -8.18 -8.34 -7.94 -9.21 -9.30 -8.82 -9.30 -9.49 -9.31 -9.36 -9.26 -8.75 -9.69 -9.50 -9.23 -9.09 -8.93 -9.15 -9.19 -9.17 -9.49 -9.01
Amortization -3.94 -4.02 -4.02 -3.54 -2.62 -2.68 -2.58 -2.77 -2.81 -2.70 -2.87 -2.62 -2.49 -2.70 -2.62 -2.57 -2.60 -2.60 -2.42 -2.59 -2.50 -2.38 -2.30
Other operating gains 0.00 0.00 0.00 0.00 0.64 0.92 0.00 0.00 2.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
Operating income 19.91% 19.94% 19.29% 16.21% 21.85% 23.07% 20.38% 18.74% 22.84% 21.54% 22.14% 20.28% 20.83% 21.10% 21.76% 20.80% 21.43% 21.90% 21.79% 21.36% 22.30% 22.58% 20.50%
Interest expense -4.35 -4.23 -4.28 -4.05 -3.75 -3.71 -3.41 -3.68 -3.65 -3.58 -3.69 -3.60 -3.52 -3.80 -3.74 -3.50 -3.53 -3.80 -3.67 -3.74 -3.95 -3.85 -3.69
Investment and other income (loss), net -0.41 -0.20 2.52 -1.14 -0.50 0.35 0.55 0.56 0.33 0.47 0.64 1.08 0.16 0.12 0.79 -0.57 -0.42 0.51 0.94 -0.07 -0.25 0.61 0.75
Income before income taxes 15.15% 15.50% 17.53% 11.02% 17.60% 19.71% 17.52% 15.61% 19.52% 18.42% 19.08% 17.77% 17.47% 17.43% 18.81% 16.72% 17.48% 18.61% 19.06% 17.54% 18.10% 19.35% 17.56%
Income tax (expense) benefit -2.89 -3.58 -4.01 -1.75 -4.51 -4.96 -3.59 52.99 -6.73 -6.44 -6.15 -6.27 -6.57 -6.63 -6.98 -6.04 -6.55 -7.01 -7.06 -6.28 -2.42 -7.33 -6.42
Net income 12.26% 11.93% 13.52% 9.27% 13.08% 14.76% 13.94% 68.61% 12.79% 11.98% 12.94% 11.50% 10.90% 10.79% 11.84% 10.68% 10.93% 11.60% 11.99% 11.26% 15.68% 12.02% 11.13%
Net (income) loss attributable to noncontrolling interests and redeemable subsidiary preferred stock -0.26 -0.29 -0.29 -0.25 -0.05 0.04 -0.25 -0.23 -0.16 -0.10 -0.40 -0.58 -0.41 -0.27 -0.48 -0.44 -0.24 -0.20 -0.46 -0.40 -0.24 -0.20 -0.38
Net income attributable to Comcast Corporation 11.99% 11.64% 13.23% 9.02% 13.04% 14.80% 13.68% 68.38% 12.63% 11.87% 12.54% 10.92% 10.49% 10.52% 11.36% 10.24% 10.69% 11.40% 11.53% 10.86% 15.44% 11.83% 10.75%

Based on: 10-Q (filing date: 2019-10-24), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

Income statement item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Comcast Corp.’s operating income as a percentage of revenue increased from Q1 2019 to Q2 2019 but then slightly declined from Q2 2019 to Q3 2019.
Income 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. Comcast Corp.’s income before income taxes as a percentage of revenue declined from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Net income attributable to Comcast Corporation The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Comcast Corp.’s net income attributable to Comcast Corporation as a percentage of revenue declined from Q1 2019 to Q2 2019 but then slightly increased from Q2 2019 to Q3 2019.