Stock Analysis on Net
Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Common-Size Income Statement
Quarterly Data

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

Microsoft Excel
3 months ended: Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 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
Product 30.54 27.49 29.99 29.49 31.31 31.41 34.62 35.18 40.17 36.70 41.03 40.46 45.18 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
Service and other 69.46 72.51 70.01 70.51 68.69 68.59 65.38 64.82 59.83 63.30 58.97 59.54 54.82 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
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% 100.00%
Product -9.62 -6.25 -6.89 -7.46 -10.79 -8.58 -8.40 -9.29 -12.24 -8.37 -9.29 -10.26 -14.06 -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
Service and other -22.02 -22.60 -23.00 -23.06 -22.37 -22.25 -23.28 -22.35 -20.55 -21.74 -21.03 -21.02 -18.89 -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
Cost of revenue -31.64% -28.84% -29.89% -30.51% -33.15% -30.83% -31.68% -31.63% -32.79% -30.11% -30.32% -31.28% -32.95% -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%
Gross margin 68.36% 71.16% 70.11% 69.49% 66.85% 69.17% 68.32% 68.37% 67.21% 69.89% 69.68% 68.72% 67.05% 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%
Research and development -11.52 -11.78 -11.99 -13.21 -12.98 -13.22 -13.21 -12.78 -11.13 -12.36 -12.32 -12.48 -11.37 -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
Sales and marketing -10.07 -9.18 -11.04 -10.88 -10.77 -10.23 -12.15 -11.34 -10.40 -10.03 -12.69 -12.19 -11.48 -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
General and administrative -3.19 -2.61 -3.91 -3.11 -4.43 -2.79 -3.37 -3.00 -2.68 -2.84 -3.30 -3.18 -2.64 -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
Operating income 43.59% 47.59% 43.17% 42.29% 38.67% 42.93% 39.59% 41.26% 43.01% 44.66% 41.37% 40.88% 41.55% 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%
Other income (expense), net -0.82 0.69 0.84 0.61 -0.11 0.11 -0.09 -0.35 0.52 0.63 0.67 0.45 1.02 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
Income before income taxes 42.77% 48.28% 44.01% 42.89% 38.56% 43.04% 39.50% 40.90% 43.53% 45.29% 42.05% 41.33% 42.57% 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%
Provision for income taxes -7.51 -8.83 -8.27 -8.28 -7.42 -8.01 -7.22 -7.01 -7.25 -0.04 -6.39 -4.27 -6.67 -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
Net income (loss) 35.26% 39.44% 35.74% 34.62% 31.14% 35.03% 32.28% 33.89% 36.28% 45.25% 35.66% 37.06% 35.90% 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%

Based on: 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).

Income statement item Description The company
Operating income The net result for the period of deducting operating expenses from operating revenues. Microsoft Corp. operating income as a percentage of revenue increased from Q4 2023 to Q1 2024 but then slightly decreased from Q1 2024 to Q2 2024 not reaching Q4 2023 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. income before income taxes as a percentage of revenue increased from Q4 2023 to Q1 2024 but then decreased significantly from Q1 2024 to Q2 2024.
Net income (loss) The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Microsoft Corp. net income (loss) as a percentage of revenue increased from Q4 2023 to Q1 2024 but then decreased significantly from Q1 2024 to Q2 2024.