Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Microsoft Corp. (NASDAQ:MSFT)

Common-Size Income Statement
Quarterly Data

Beginner level

Microsoft Corp., common-size consolidated income statement (quarterly data)

Microsoft Excel LibreOffice Calc
3 months ended: Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Product 42.53 47.71 45.32 49.46 47.70 50.73 50.53 49.95 59.48 57.04 56.36 61.99 58.27 59.05 60.62 68.65 65.97 67.86 69.75 75.53 74.68 100.00 100.00 100.00 100.00
Service and other 57.47 52.29 54.68 50.54 52.30 49.27 49.47 50.05 40.52 42.96 43.64 38.01 41.73 40.95 39.38 31.35 34.03 32.14 30.25 24.47 25.32 0.00 0.00 0.00 0.00
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 -9.68 -11.49 -9.64 -13.46 -10.00 -9.78 -11.26 -18.12 -12.55 -11.69 -12.77 -19.01 -12.14 -13.47 -13.92 -22.32 -17.51 -18.32 -18.51 -26.34 -19.80 -33.67 -32.96 -38.29 -35.66
Service and other -19.93 -20.95 -21.70 -20.03 -21.48 -21.10 -22.01 -20.13 -21.51 -20.69 -21.79 -19.25 -21.59 -22.79 -22.57 -18.78 -20.84 -20.39 -19.10 -15.15 -15.57 0.00 0.00 0.00 0.00
Cost of revenue -29.61% -32.44% -31.34% -33.49% -31.48% -30.88% -33.27% -38.26% -34.06% -32.38% -34.56% -38.26% -33.74% -36.27% -36.49% -41.10% -38.35% -38.71% -37.61% -41.49% -35.36% -33.67% -32.96% -38.29% -35.66%
Gross margin 70.39% 67.56% 68.66% 66.51% 68.52% 69.12% 66.73% 61.74% 65.94% 67.62% 65.44% 61.74% 66.26% 63.73% 63.51% 58.90% 61.65% 61.29% 62.39% 58.51% 64.64% 66.33% 67.04% 61.71% 64.34%
Research and development -13.26 -13.71 -13.95 -12.47 -13.81 -13.38 -14.12 -12.53 -13.67 -13.07 -13.85 -12.12 -14.57 -15.07 -15.19 -12.71 -15.19 -15.26 -14.51 -12.19 -14.53 -13.95 -13.73 -10.97 -13.21
Sales and marketing -11.39 -14.24 -14.02 -13.37 -13.12 -14.72 -14.93 -14.13 -14.09 -15.82 -16.16 -15.78 -15.54 -18.68 -17.56 -16.90 -15.81 -19.39 -16.59 -16.64 -16.36 -17.86 -17.07 -16.30 -16.07
General and administrative -3.01 -4.35 -3.63 -3.04 -3.21 -4.23 -3.86 -3.49 -3.95 -4.22 -4.50 -3.83 -4.75 -5.81 -5.44 -3.65 -5.11 -6.31 -5.55 -4.36 -5.32 -5.73 -5.02 -4.14 -4.96
Goodwill impairment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -22.99 0.00 0.00 0.00
Impairment and restructuring 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.31 0.00 0.00 0.00 -5.38 0.00 0.00 0.00 -15.05 -0.87 -0.92 -4.91
Operating income 42.73% 35.25% 37.05% 37.64% 38.38% 36.79% 33.83% 31.59% 34.23% 34.50% 30.92% 30.01% 31.41% 22.86% 25.32% 25.64% 25.55% 14.94% 25.73% 25.32% 28.43% -9.26% 30.35% 29.38% 25.19%
Other income (expense), net 0.67 0.04 -0.38 0.53 0.00 0.57 0.47 0.39 0.91 1.00 1.30 1.69 1.12 0.92 1.46 0.77 0.49 1.30 -1.20 -0.72 -1.37 1.34 -0.35 0.28 0.22
Income before income taxes 43.40% 35.29% 36.67% 38.16% 38.38% 37.36% 34.30% 31.98% 35.14% 35.50% 32.22% 31.71% 32.54% 23.78% 26.78% 26.41% 26.04% 16.24% 24.53% 24.60% 27.05% -7.92% 29.99% 29.66% 25.41%
Provision for income taxes -6.00 -5.84 -5.97 -6.60 -6.07 1.75 -5.49 -6.05 -4.80 -6.01 -4.54 -53.50 -5.74 4.15 -5.05 -4.83 -3.10 -1.09 -6.23 -3.52 -3.00 -6.49 -7.05 -7.51 -5.84
Net income (loss) 37.39% 29.45% 30.70% 31.56% 32.30% 39.11% 28.81% 25.93% 30.34% 29.49% 27.68% -21.79% 26.80% 27.93% 21.73% 21.59% 22.93% 15.15% 18.29% 21.09% 24.05% -14.40% 22.94% 22.15% 19.57%

Based on: 10-Q (filing date: 2020-10-27), 10-K (filing date: 2020-07-31), 10-Q (filing date: 2020-04-29), 10-Q (filing date: 2020-01-29), 10-Q (filing date: 2019-10-23), 10-K (filing date: 2019-08-01), 10-Q (filing date: 2019-04-24), 10-Q (filing date: 2019-01-30), 10-Q (filing date: 2018-10-24), 10-K (filing date: 2018-08-03), 10-Q (filing date: 2018-04-26), 10-Q (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-K (filing date: 2017-08-02), 10-Q (filing date: 2017-04-27), 10-Q (filing date: 2017-01-26), 10-Q (filing date: 2016-10-20), 10-K (filing date: 2016-07-28), 10-Q (filing date: 2016-04-21), 10-Q (filing date: 2016-01-28), 10-Q (filing date: 2015-10-22), 10-K (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-Q (filing date: 2015-01-26), 10-Q (filing date: 2014-10-23).

Income statement item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Microsoft Corp.’s operating income as a percentage of revenue decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.
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. Microsoft Corp.’s income before income taxes as a percentage of revenue decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.
Net income (loss) The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Microsoft Corp.’s net income (loss) as a percentage of revenue decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.