Microsoft Excel LibreOffice Calc

Common-Size Income Statement

Difficulty: Beginner

AT&T Inc., 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
Service 90.69 90.90 89.70 89.42 92.62
Equipment 9.31 9.10 10.30 10.58 7.38
Operating revenues 100.00% 100.00% 100.00% 100.00% 100.00%
Equipment -11.65 -11.45 -13.13 0.00 0.00
Broadcast, programming and operations -13.18 -12.12 -8.17 0.00 0.00
Other cost of services, exclusive of depreciation and amortization -23.36 -23.37 -24.37 -45.76 -39.97
Cost of services and sales -48.20% -46.94% -45.67% -45.76% -39.97%
Gross profit 51.80% 53.06% 54.33% 54.24% 60.03%
Selling, general and administrative -21.75 -22.19 -22.42 -29.97 -22.07
Asset abandonments and impairments -1.82 -0.22 -0.02 -1.60 0.00
Depreciation and amortization -15.19 -15.78 -15.00 -13.80 -14.29
Operating income 13.05% 14.87% 16.88% 8.87% 23.67%
Interest expense -3.92 -3.00 -2.81 -2.73 -3.06
Equity in net income (loss) of affiliates -0.08 0.06 0.05 0.13 0.50
Other income (expense), net 0.38 0.17 -0.04 1.25 0.46
Other income (expense) -3.62% -2.77% -2.79% -1.35% -2.10%
Income before income taxes 9.43% 12.10% 14.10% 7.52% 21.57%
Income tax (expense) benefit 9.16 -3.96 -4.77 -2.60 -7.16
Net income 18.59% 8.14% 9.32% 4.92% 14.41%
Net income attributable to noncontrolling interest -0.25 -0.22 -0.23 -0.22 -0.24
Net income attributable to AT&T 18.34% 7.92% 9.09% 4.70% 14.17%

Based on: 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-18), 10-K (filing date: 2015-02-20), 10-K (filing date: 2014-02-21).

Item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. AT&T Inc.’s operating income as a percentage of operating revenues declined from 2015 to 2016 and from 2016 to 2017.
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. AT&T Inc.’s income before income taxes as a percentage of operating revenues declined from 2015 to 2016 and from 2016 to 2017.
Net income attributable to AT&T The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. AT&T Inc.’s net income attributable to AT&T as a percentage of operating revenues declined from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.