Microsoft Excel LibreOffice Calc

Common-Size Income Statement

Difficulty: Beginner

Comcast Corp., Common-Size Consolidated Income Statement

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Revenue 100.00    100.00    100.00    100.00    100.00   
Programming and production -30.03    -30.43    -30.26    -30.41    -30.42   
Gross profit 69.97% 69.57% 69.74% 69.59% 69.58%
Other operating and administrative -29.59    -29.11    -28.64    -28.88    -28.74   
Advertising, marketing and promotion -7.47    -7.60    -7.98    -7.38    -7.69   
Depreciation -9.36    -9.28    -9.10    -9.21    -9.67   
Amortization -2.78    -2.60    -2.55    -2.45    -2.50   
Other operating gains 0.52                   
Operating income 21.28% 20.97% 21.47% 21.67% 20.98%
Interest expense -3.65    -3.66    -3.63    -3.81    -3.98   
Gains on sales and exchanges of investments, net 0.01    0.06    0.02    0.28    0.75   
Investment impairment losses -0.03    -0.04    -0.08    -0.07    -0.04   
Interest and dividend income 0.16    0.15    0.15    0.17    0.17   
Other, net 0.16    0.10    0.02    0.06    0.02   
Investment income, net 0.30% 0.26% 0.11% 0.43% 0.89%
Equity in net income (losses) of investees, net 0.13    -0.13    -0.44    0.14    -0.13   
Other income (expense), net 0.07    0.41    0.43    -0.31    -0.56   
Other income (expense) -3.15% -3.12% -3.52% -3.55% -3.79%
Income before income taxes 18.13% 17.85% 17.95% 18.12% 17.19%
Income tax (expense) benefit 8.97    -6.60    -6.66    -5.63    -6.16   
Net income 27.09% 11.25% 11.29% 12.49% 11.04%
Net income attributable to noncontrolling interests and redeemable subsidiary preferred stock -0.22    -0.44    -0.34    -0.31    -0.49   
Net income attributable to Comcast Corporation 26.87% 10.81% 10.96% 12.18% 10.54%