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           
Broadcast, programming and operations -13.18    -12.12    -8.17           
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       
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%