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, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Product 26.42 30.53 36.68 42.28 47.58 52.50
Service and other 73.58 69.47 63.32 57.72 52.42 47.50
Revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product -6.23 -8.40 -9.62 -10.84 -11.20 -12.93
Service and other -24.01 -22.68 -21.98 -20.24 -21.02 -21.17
Cost of revenue -30.24% -31.08% -31.60% -31.07% -32.22% -34.10%
Gross margin 69.76% 68.92% 68.40% 68.93% 67.78% 65.90%
Research and development -12.04 -12.83 -12.36 -12.32 -13.47 -13.41
Sales and marketing -9.98 -10.74 -11.01 -11.97 -13.70 -14.47
General and administrative -3.10 -3.57 -2.98 -3.04 -3.57 -3.88
Operating income 44.64% 41.77% 42.06% 41.59% 37.03% 34.14%
Interest and dividends income 1.29 1.41 1.06 1.27 1.87 2.19
Interest expense -1.20 -0.93 -1.04 -1.40 -1.81 -2.13
Net recognized gains (losses) on investments -0.05 0.12 0.23 0.73 0.02 0.51
Net gains (losses) on derivatives -0.08 -0.22 -0.03 0.01 0.13 0.11
Net gains (losses) on foreign currency remeasurements -0.10 0.09 -0.04 0.03 -0.13 -0.07
Other, net -0.54 -0.11 -0.02 0.06 -0.03 -0.05
Other income (expense), net -0.67% 0.37% 0.17% 0.71% 0.05% 0.58%
Income before income taxes 43.97% 42.14% 42.22% 42.30% 37.08% 34.72%
Provision for income taxes -8.02 -8.00 -5.54 -5.85 -6.12 -3.53
Net income 35.96% 34.15% 36.69% 36.45% 30.96% 31.18%

Based on: 10-K (reporting date: 2024-06-30), 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).

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 decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 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 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.
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 decreased from 2022 to 2023 but then increased from 2023 to 2024 not reaching 2022 level.