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 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.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.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%
Product -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.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 -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 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.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.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 -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.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.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 -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 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.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.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.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 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 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 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) 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-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).