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

Microsoft Corp. (NASDAQ:MSFT)

Common-Size Income Statement

Beginner level

Microsoft Corp., common-size consolidated income statement

Microsoft Excel LibreOffice Calc
12 months ended: Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015
Product 47.58 52.50 58.44 63.58 72.08 81.17
Service and other 52.42 47.50 41.56 36.42 27.92 18.83
Revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product -11.20 -12.93 -13.97 -16.87 -20.96 -22.88
Service and other -21.02 -21.17 -20.78 -21.22 -17.46 -12.43
Cost of revenue -32.22% -34.10% -34.75% -38.09% -38.42% -35.30%
Gross margin 67.78% 65.90% 65.25% 61.91% 61.58% 64.70%
Research and development -13.47 -13.41 -13.34 -14.49 -14.05 -12.87
Sales and marketing -13.70 -14.47 -15.83 -17.28 -17.23 -16.79
General and administrative -3.57 -3.88 -4.31 -4.98 -5.35 -4.93
Goodwill impairment 0.00 0.00 0.00 0.00 0.00 -5.45
Impairment and restructuring 0.00 0.00 0.00 -0.34 -1.30 -5.25
Operating income 37.03% 34.14% 31.77% 24.82% 23.65% 19.41%
Interest and dividends income 1.87 2.19 2.01 1.54 1.06 0.82
Interest expense -1.81 -2.13 -2.48 -2.47 -1.46 -0.83
Net recognized gains on investments 0.02 0.51 2.17 2.87 0.78 0.77
Net gains (losses) on derivatives 0.13 0.11 -0.17 -0.57 -0.52 -0.45
Net gains (losses) on foreign currency remeasurements -0.13 -0.07 -0.20 -0.18 -0.14 0.36
Other, net -0.03 -0.05 -0.05 -0.28 -0.23 -0.29
Other income (expense), net 0.05% 0.58% 1.28% 0.91% -0.51% 0.37%
Income before income taxes 37.08% 34.72% 33.05% 25.74% 23.15% 19.78%
Provision for income taxes -6.12 -3.53 -18.03 -2.16 -3.46 -6.75
Net income 30.96% 31.18% 15.02% 23.57% 19.69% 13.03%

Based on: 10-K (filing date: 2020-07-31), 10-K (filing date: 2019-08-01), 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31).

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 increased from 2018 to 2019 and from 2019 to 2020.
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 increased from 2018 to 2019 and from 2019 to 2020.
Net income The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. Microsoft Corp.’s net income as a percentage of revenue increased from 2018 to 2019 but then slightly decreased from 2019 to 2020.