Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Analysis of Profitability Ratios

Microsoft Excel

Profitability Ratios (Summary)

Microsoft Corp., profitability ratios

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Return on Sales
Gross profit margin 68.92% 68.40% 68.93% 67.78% 65.90% 65.25%
Operating profit margin 41.77% 42.06% 41.59% 37.03% 34.14% 31.77%
Net profit margin 34.15% 36.69% 36.45% 30.96% 31.18% 15.02%
Return on Investment
Return on equity (ROE) 35.09% 43.68% 43.15% 37.43% 38.35% 20.03%
Return on assets (ROA) 17.56% 19.94% 18.36% 14.70% 13.69% 6.40%

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).

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Microsoft Corp. gross profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Microsoft Corp. operating profit margin ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Microsoft Corp. net profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Microsoft Corp. ROE improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
ROA A profitability ratio calculated as net income divided by total assets. Microsoft Corp. ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Gross Profit Margin

Microsoft Corp., gross profit margin calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Gross margin 146,052 135,620 115,856 96,937 82,933 72,007
Revenue 211,915 198,270 168,088 143,015 125,843 110,360
Profitability Ratio
Gross profit margin1 68.92% 68.40% 68.93% 67.78% 65.90% 65.25%
Benchmarks
Gross Profit Margin, Competitors2
Accenture PLC 32.34% 31.99% 32.38% 31.53% 30.81% 29.91%
Adobe Inc. 87.87% 87.70% 88.18% 86.62% 85.03% 86.77%
International Business Machines Corp. 55.45% 54.00% 54.90% 48.32% 47.30%
Intuit Inc. 78.13% 81.09% 82.53% 82.05% 82.80% 83.62%
Oracle Corp. 72.85% 79.08% 80.59% 79.68% 79.76% 79.71%
Palo Alto Networks Inc. 72.29% 68.76% 70.05% 70.68% 72.12% 71.61%
Salesforce Inc. 73.34% 73.48% 74.41% 75.23% 74.02%
ServiceNow Inc. 78.59% 78.29% 77.05% 78.16% 76.98%
Synopsys Inc. 79.08% 79.07% 79.50% 78.44% 77.60% 76.42%

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).

1 2023 Calculation
Gross profit margin = 100 × Gross margin ÷ Revenue
= 100 × 146,052 ÷ 211,915 = 68.92%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Microsoft Corp. gross profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Operating Profit Margin

Microsoft Corp., operating profit margin calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Operating income 88,523 83,383 69,916 52,959 42,959 35,058
Revenue 211,915 198,270 168,088 143,015 125,843 110,360
Profitability Ratio
Operating profit margin1 41.77% 42.06% 41.59% 37.03% 34.14% 31.77%
Benchmarks
Operating Profit Margin, Competitors2
Accenture PLC 13.74% 15.21% 15.08% 14.69% 14.59% 14.04%
Adobe Inc. 34.26% 34.64% 36.76% 32.93% 29.25% 31.45%
International Business Machines Corp. 15.17% 13.50% 11.97% 9.22% 13.67%
Intuit Inc. 21.86% 20.20% 25.95% 28.34% 27.33% 25.10%
Oracle Corp. 26.21% 25.74% 37.58% 35.57% 34.26% 34.34%
Palo Alto Networks Inc. 5.62% -3.43% -7.15% -5.25% -1.87% -5.68%
Salesforce Inc. 3.29% 2.07% 2.14% 1.74% 4.03%
ServiceNow Inc. 8.49% 4.90% 4.36% 4.40% 1.22%
Synopsys Inc. 21.72% 22.87% 17.48% 16.83% 15.48% 11.54%
Operating Profit Margin, Sector
Software & Services 28.03% 27.98% 28.89% 25.05% 24.34%
Operating Profit Margin, Industry
Information Technology 26.32% 28.47% 28.76% 24.95% 25.42%

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).

1 2023 Calculation
Operating profit margin = 100 × Operating income ÷ Revenue
= 100 × 88,523 ÷ 211,915 = 41.77%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Microsoft Corp. operating profit margin ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Net Profit Margin

Microsoft Corp., net profit margin calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net income 72,361 72,738 61,271 44,281 39,240 16,571
Revenue 211,915 198,270 168,088 143,015 125,843 110,360
Profitability Ratio
Net profit margin1 34.15% 36.69% 36.45% 30.96% 31.18% 15.02%
Benchmarks
Net Profit Margin, Competitors2
Accenture PLC 10.72% 11.17% 11.69% 11.52% 11.06% 9.76%
Adobe Inc. 27.97% 27.01% 30.55% 40.88% 26.42% 28.69%
International Business Machines Corp. 12.13% 2.71% 10.01% 7.59% 12.22%
Intuit Inc. 16.59% 16.23% 21.41% 23.78% 22.95% 20.31%
Oracle Corp. 17.02% 15.83% 33.96% 25.94% 28.05% 9.60%
Palo Alto Networks Inc. 6.38% -4.85% -11.72% -7.83% -2.82% -6.51%
Salesforce Inc. 0.66% 5.45% 19.16% 0.74% 8.36%
ServiceNow Inc. 19.30% 4.49% 3.90% 2.62% 18.11%
Synopsys Inc. 21.05% 19.38% 18.02% 18.03% 15.84% 13.86%
Net Profit Margin, Sector
Software & Services 22.47% 22.24% 25.99% 20.85% 21.80%
Net Profit Margin, Industry
Information Technology 22.13% 24.07% 25.56% 21.38% 22.17%

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).

1 2023 Calculation
Net profit margin = 100 × Net income ÷ Revenue
= 100 × 72,361 ÷ 211,915 = 34.15%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Microsoft Corp. net profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Return on Equity (ROE)

Microsoft Corp., ROE calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net income 72,361 72,738 61,271 44,281 39,240 16,571
Stockholders’ equity 206,223 166,542 141,988 118,304 102,330 82,718
Profitability Ratio
ROE1 35.09% 43.68% 43.15% 37.43% 38.35% 20.03%
Benchmarks
ROE, Competitors2
Accenture PLC 26.75% 31.11% 30.25% 30.05% 33.17% 39.17%
Adobe Inc. 32.86% 33.85% 32.59% 39.66% 28.03% 27.67%
International Business Machines Corp. 33.29% 7.47% 30.38% 27.14% 45.25%
Intuit Inc. 13.81% 12.57% 20.89% 35.76% 41.53% 51.44%
Oracle Corp. 792.45% 262.43% 83.94% 50.87% 8.37%
Palo Alto Networks Inc. 25.15% -127.14% -78.63% -24.23% -5.16% -15.30%
Salesforce Inc. 0.36% 2.48% 9.81% 0.37% 7.11%
ServiceNow Inc. 22.69% 6.46% 6.22% 4.18% 29.45%
Synopsys Inc. 20.01% 17.85% 14.31% 13.54% 13.04% 12.43%
ROE, Sector
Software & Services 29.37% 32.03% 37.53% 31.80% 36.15%
ROE, Industry
Information Technology 31.93% 38.69% 42.56% 35.29% 36.68%

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).

1 2023 Calculation
ROE = 100 × Net income ÷ Stockholders’ equity
= 100 × 72,361 ÷ 206,223 = 35.09%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Microsoft Corp. ROE improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Return on Assets (ROA)

Microsoft Corp., ROA calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Net income 72,361 72,738 61,271 44,281 39,240 16,571
Total assets 411,976 364,840 333,779 301,311 286,556 258,848
Profitability Ratio
ROA1 17.56% 19.94% 18.36% 14.70% 13.69% 6.40%
Benchmarks
ROA, Competitors2
Accenture PLC 13.41% 14.55% 13.68% 13.78% 16.04% 16.61%
Adobe Inc. 18.23% 17.51% 17.70% 21.66% 14.22% 13.80%
International Business Machines Corp. 5.55% 1.29% 4.35% 3.58% 6.20%
Intuit Inc. 8.58% 7.45% 13.29% 16.70% 24.78% 23.39%
Oracle Corp. 6.33% 6.15% 10.48% 8.78% 10.20% 2.79%
Palo Alto Networks Inc. 3.03% -2.18% -4.87% -2.95% -1.24% -2.54%
Salesforce Inc. 0.21% 1.52% 6.14% 0.23% 3.61%
ServiceNow Inc. 9.96% 2.44% 2.13% 1.36% 10.41%
Synopsys Inc. 11.90% 10.45% 8.66% 8.27% 8.31% 7.04%
ROA, Sector
Software & Services 11.45% 11.67% 12.60% 10.03% 10.89%
ROA, Industry
Information Technology 13.10% 15.14% 15.65% 12.15% 12.80%

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).

1 2023 Calculation
ROA = 100 × Net income ÷ Total assets
= 100 × 72,361 ÷ 411,976 = 17.56%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Microsoft Corp. ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.