Common-Size Income Statement
Quarterly Data

Difficulty: Beginner

Cisco Systems Inc., Common-Size Consolidated Income Statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended Oct 27, 2018 Jul 28, 2018 Apr 28, 2018 Jan 27, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016 Jan 23, 2016 Oct 24, 2015 Jul 25, 2015 Apr 25, 2015 Jan 24, 2015 Oct 25, 2014 Jul 26, 2014 Apr 26, 2014 Jan 25, 2014 Oct 26, 2013 Jul 27, 2013 Apr 27, 2013 Jan 26, 2013 Oct 27, 2012
Product 75.66 75.07 74.65 73.26 74.60 74.40 74.41 73.32 75.31 75.58 73.96 75.32 77.62 77.17 76.84 76.06 77.05 77.14 76.40 75.51 77.76 78.41 78.25 78.00 78.28
Service 24.34 24.93 25.35 26.74 25.40 25.60 25.59 26.68 24.69 24.42 26.04 24.68 22.38 22.83 23.16 23.94 22.95 22.86 23.60 24.49 22.24 21.59 21.75 22.00 21.72
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% 100.00% 100.00%
Product -29.06 -29.84 -29.09 -28.22 -29.79 -29.56 -28.52 -28.54 -27.55 -28.60 -26.78 -29.18 -30.38 -31.67 -29.53 -31.89 -32.00 -32.18 -31.14 -38.75 -31.01 -33.45 -30.96 -31.88 -31.56
Service -8.62 -8.48 -8.66 -8.71 -9.01 -8.25 -8.52 -8.63 -8.62 -8.30 -8.88 -8.51 -7.86 -8.11 -8.47 -8.71 -8.11 -7.90 -8.18 -7.90 -7.70 -7.38 -7.56 -7.42 -7.49
Cost of sales -37.68% -38.32% -37.74% -36.92% -38.80% -37.81% -37.04% -37.17% -36.17% -36.90% -35.66% -37.69% -38.24% -39.79% -38.00% -40.60% -40.11% -40.07% -39.32% -46.65% -38.71% -40.83% -38.52% -39.30% -39.05%
Gross margin 62.32% 61.68% 62.26% 63.08% 61.20% 62.19% 62.96% 62.83% 63.83% 63.10% 64.34% 62.31% 61.76% 60.21% 62.00% 59.40% 59.89% 59.93% 60.68% 53.35% 61.29% 59.17% 61.48% 60.70% 60.95%
Research and development -12.30 -12.66 -12.76 -13.03 -12.91 -12.35 -12.62 -13.02 -12.51 -12.67 -13.55 -12.65 -12.30 -12.05 -12.75 -12.81 -12.93 -12.89 -13.56 -12.66 -14.27 -12.22 -12.62 -12.00 -12.05
Sales and marketing -18.44 -18.28 -18.66 -18.80 -19.23 -19.10 -18.64 -19.19 -19.58 -19.33 -20.39 -19.17 -19.26 -19.85 -20.18 -19.34 -20.54 -20.01 -20.29 -20.41 -19.95 -19.01 -19.44 -19.73 -20.34
General and administrative -1.61 -4.23 -4.50 -4.06 -4.59 -4.08 -4.08 -3.94 -4.49 -4.22 -4.72 -1.48 -4.25 -4.17 -4.20 -4.11 -4.12 -4.11 -3.98 -4.04 -4.26 -4.75 -4.34 -4.83 -4.72
Amortization of purchased intangible assets -0.26 -0.26 -0.54 -0.50 -0.50 -0.48 -0.49 -0.55 -0.63 -0.65 -0.68 -0.60 -0.54 -1.14 -0.58 -0.60 -0.58 -0.55 -0.61 -0.64 -0.54 -0.53 -0.73 -0.98 -1.03
Restructuring and other charges -0.60 -0.20 -0.66 -0.82 -1.25 -1.17 -0.59 -1.15 -3.33 -0.10 -0.14 -0.80 -1.12 -0.57 -0.20 -0.58 -2.60 -0.66 -0.23 -0.65 -1.96 0.00 -0.27 -0.11 -0.50
Operating expenses -33.21% -35.63% -37.11% -37.23% -38.49% -37.19% -36.42% -37.85% -40.54% -36.97% -39.48% -34.69% -37.48% -37.78% -37.90% -37.43% -40.76% -38.23% -38.67% -38.40% -40.98% -36.51% -37.40% -37.64% -38.63%
Operating income 29.11% 26.05% 25.15% 25.85% 22.71% 25.01% 26.54% 24.98% 23.29% 26.14% 24.87% 27.62% 24.28% 22.43% 24.10% 21.97% 19.13% 21.70% 22.02% 14.94% 20.31% 22.66% 24.08% 23.05% 22.32%
Interest income 2.63 2.75 3.05 3.33 3.12 2.97 2.96 2.84 2.39 2.16 2.25 1.99 1.77 1.64 1.57 1.58 1.46 1.48 1.47 1.52 1.40 1.38 1.33 1.32 1.36
Interest expense -1.69 -1.74 -1.90 -2.08 -1.94 -1.83 -1.83 -1.92 -1.60 -1.42 -1.46 -1.36 -1.25 -1.16 -1.15 -1.16 -1.14 -1.15 -1.26 -1.22 -1.16 -1.15 -1.19 -1.22 -1.25
Other income (loss), net -0.15 0.91 -0.19 0.08 0.51 0.07 -0.95 -0.32 -0.17 -0.02 0.03 -0.53 -0.06 -0.08 0.49 1.68 -0.18 0.45 0.66 0.49 0.46 0.23 -0.11 -0.18 -0.28
Interest and other income (loss), net 0.80% 1.92% 0.95% 1.34% 1.70% 1.20% 0.18% 0.60% 0.62% 0.72% 0.83% 0.10% 0.46% 0.40% 0.91% 2.10% 0.15% 0.78% 0.87% 0.79% 0.70% 0.46% 0.02% -0.07% -0.17%
Income before (provision for) benefit from income taxes 29.90% 27.97% 26.10% 27.19% 24.41% 26.21% 26.73% 25.59% 23.91% 26.86% 25.69% 27.72% 24.74% 22.84% 25.01% 24.07% 19.27% 22.48% 22.88% 15.73% 21.02% 23.12% 24.11% 22.98% 22.15%
(Provision for) benefit from income taxes -2.75 1.64 -4.51 -101.03 -4.68 -6.23 -5.66 -5.31 -5.11 -4.60 -6.12 -1.33 -5.57 -4.78 -4.93 -3.99 -4.34 -4.30 -3.99 -2.92 -4.50 -4.84 -3.82 3.00 -4.54
Net income (loss) 27.15% 29.61% 21.59% -73.85% 19.73% 19.98% 21.06% 20.28% 18.80% 22.26% 19.58% 26.39% 19.16% 18.06% 20.08% 20.08% 14.93% 18.18% 18.89% 12.81% 16.52% 18.28% 20.28% 25.98% 17.62%

Based on: 10-Q (filing date: 2018-11-20), 10-K (filing date: 2018-09-06), 10-Q (filing date: 2018-05-22), 10-Q (filing date: 2018-02-20), 10-Q (filing date: 2017-11-21), 10-K (filing date: 2017-09-07), 10-Q (filing date: 2017-05-23), 10-Q (filing date: 2017-02-21), 10-Q (filing date: 2016-11-22), 10-K (filing date: 2016-09-08), 10-Q (filing date: 2016-05-24), 10-Q (filing date: 2016-02-18), 10-Q (filing date: 2015-11-19), 10-K (filing date: 2015-09-08), 10-Q (filing date: 2015-05-20), 10-Q (filing date: 2015-02-18), 10-Q (filing date: 2014-11-20), 10-K (filing date: 2014-09-09), 10-Q (filing date: 2014-05-22), 10-Q (filing date: 2014-02-20), 10-Q (filing date: 2013-11-22), 10-K (filing date: 2013-09-10), 10-Q (filing date: 2013-05-21), 10-Q (filing date: 2013-02-19), 10-Q (filing date: 2012-11-20).

Item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Cisco Systems Inc.’s operating income as a percentage of revenue increased from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Income before (provision for) benefit from 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. Cisco Systems Inc.’s income before (provision for) benefit from income taxes as a percentage of revenue increased from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Net income (loss) The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Cisco Systems Inc.’s net income (loss) as a percentage of revenue increased from Q3 2018 to Q4 2018 but then slightly declined from Q4 2018 to Q1 2019.