Stock Analysis on Net
Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Common-Size Income Statement

Microsoft Corp., common-size consolidated income statement

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Product 30.53 36.68 42.28 47.58 52.50 58.44
Service and other 69.47 63.32 57.72 52.42 47.50 41.56
Revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product -8.40 -9.62 -10.84 -11.20 -12.93 -13.97
Service and other -22.68 -21.98 -20.24 -21.02 -21.17 -20.78
Cost of revenue -31.08% -31.60% -31.07% -32.22% -34.10% -34.75%
Gross margin 68.92% 68.40% 68.93% 67.78% 65.90% 65.25%
Research and development -12.83 -12.36 -12.32 -13.47 -13.41 -13.34
Sales and marketing -10.74 -11.01 -11.97 -13.70 -14.47 -15.83
General and administrative -3.57 -2.98 -3.04 -3.57 -3.88 -4.31
Operating income 41.77% 42.06% 41.59% 37.03% 34.14% 31.77%
Interest and dividends income 1.41 1.06 1.27 1.87 2.19 2.01
Interest expense -0.93 -1.04 -1.40 -1.81 -2.13 -2.48
Net recognized gains on investments 0.12 0.23 0.73 0.02 0.51 2.17
Net gains (losses) on derivatives -0.22 -0.03 0.01 0.13 0.11 -0.17
Net gains (losses) on foreign currency remeasurements 0.09 -0.04 0.03 -0.13 -0.07 -0.20
Other, net -0.11 -0.02 0.06 -0.03 -0.05 -0.05
Other income, net 0.37% 0.17% 0.71% 0.05% 0.58% 1.28%
Income before income taxes 42.14% 42.22% 42.30% 37.08% 34.72% 33.05%
Provision for income taxes -8.00 -5.54 -5.85 -6.12 -3.53 -18.03
Net income 34.15% 36.69% 36.45% 30.96% 31.18% 15.02%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-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 2021 to 2022 but then slightly decreased from 2022 to 2023 not reaching 2021 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 decreased from 2021 to 2022 and from 2022 to 2023.
Net income The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Microsoft Corp. net income as a percentage of revenue increased from 2021 to 2022 but then decreased significantly from 2022 to 2023.