Analysis of Profitability Ratios
Quarterly Data
Profitability ratios measure the company ability to generate profitable sales from its resources (assets).
Profitability Ratios (Summary)
Microsoft Corp., profitability ratios (quarterly data)
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).
| 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 improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| Operating profit margin | A profitability ratio calculated as operating income divided by revenue. | Microsoft Corp. operating profit margin ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| Net profit margin | An indicator of profitability, calculated as net income divided by revenue. | Microsoft Corp. net profit margin ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| Profitability ratio | Description | The company |
|---|---|---|
| ROE | A profitability ratio calculated as net income divided by shareholders’ equity. | Microsoft Corp. ROE deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
| ROA | A profitability ratio calculated as net income divided by total assets. | Microsoft Corp. ROA deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 not reaching Q4 2023 level. |
Gross Profit Margin
Microsoft Corp., gross profit margin calculation (quarterly data)
| 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Gross margin | 42,397) | 40,215) | 39,394) | 36,729) | 35,259) | 34,670) | 35,436) | 33,745) | 34,768) | 31,671) | 32,161) | 28,661) | 28,882) | 26,152) | 25,694) | 24,046) | 24,548) | 22,649) | 23,305) | 20,401) | 20,048) | 19,179) | 20,343) | 17,550) | 17,854) | 16,260) | ||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Profitability Ratio | ||||||||||||||||||||||||||||||||||
| Gross profit margin1 | 69.75% | 69.44% | 68.92% | 68.45% | 68.16% | 68.26% | 68.40% | 68.73% | 68.83% | 68.86% | 68.93% | 68.38% | 68.35% | 68.27% | 67.78% | 68.17% | 67.71% | 66.56% | 65.90% | 65.44% | 65.10% | 65.21% | 65.25% | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Gross Profit Margin, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 32.58% | 32.50% | 32.34% | 32.25% | 32.12% | 32.02% | 31.99% | 32.26% | 32.30% | 32.35% | 32.38% | 31.99% | 31.66% | 31.81% | 31.53% | 31.36% | 31.28% | 31.08% | 30.81% | 30.61% | 30.31% | 30.10% | 29.91% | — | — | — | ||||||||
| Adobe Inc. | — | 88.08% | 87.87% | 87.89% | 87.77% | 87.66% | 87.70% | 87.76% | 87.87% | 88.04% | 88.18% | 88.17% | 87.87% | 87.45% | 86.62% | 85.96% | 85.60% | 85.19% | 85.03% | 85.16% | 85.55% | 86.04% | 86.77% | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 55.45% | 55.04% | 54.64% | 54.24% | 54.00% | 53.78% | 54.01% | 54.48% | 54.90% | 53.27% | 51.79% | 50.09% | 48.32% | 48.18% | 47.76% | 47.52% | 47.30% | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 78.08% | 78.12% | 78.13% | 78.46% | 79.00% | 79.99% | 81.09% | 82.36% | 82.11% | 82.13% | 82.53% | 82.67% | 82.23% | 82.85% | 82.05% | 80.50% | 82.25% | 82.55% | 82.80% | 83.52% | 83.41% | 83.13% | 83.62% | — | — | — | ||||||||
| Oracle Corp. | 71.88% | 72.26% | 72.85% | 74.50% | 76.10% | 77.78% | 79.08% | 79.44% | 79.96% | 80.22% | 80.59% | 80.59% | 80.33% | 79.96% | 79.68% | 79.80% | 79.67% | 79.77% | 79.76% | 79.53% | 79.54% | 79.66% | 79.71% | — | — | — | ||||||||
| Palo Alto Networks Inc. | 74.05% | 73.35% | 72.29% | 70.80% | 69.77% | 69.06% | 68.76% | 69.34% | 69.63% | 69.77% | 70.05% | 69.74% | 70.02% | 70.42% | 70.68% | 71.61% | 72.02% | 72.06% | 72.12% | 71.81% | 71.81% | 71.64% | 71.61% | — | — | — | ||||||||
| Salesforce Inc. | 74.52% | 73.78% | 73.34% | 72.69% | 72.61% | 73.10% | 73.48% | 74.02% | 74.34% | 74.32% | 74.41% | 74.47% | 74.62% | 74.90% | 75.23% | 75.01% | 74.77% | 74.32% | 74.02% | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 78.59% | 78.52% | 78.50% | 78.45% | 78.29% | 77.85% | 77.53% | 77.26% | 77.05% | 77.27% | 77.59% | 78.01% | 78.16% | 78.22% | 78.04% | 77.57% | 76.98% | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 79.33% | 79.08% | 78.79% | 78.51% | 78.91% | 79.07% | 79.48% | 80.05% | 79.78% | 79.50% | 79.11% | 78.93% | 78.81% | 78.44% | 78.56% | 78.04% | 77.69% | 77.60% | 76.98% | 76.50% | 76.43% | 76.42% | — | — | — | ||||||||
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).
1 Q2 2024 Calculation
Gross profit margin = 100
× (Gross marginQ2 2024
+ Gross marginQ1 2024
+ Gross marginQ4 2023
+ Gross marginQ3 2023)
÷ (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
= 100 × (42,397 + 40,215 + 39,394 + 36,729)
÷ (62,020 + 56,517 + 56,189 + 52,857)
= 69.75%
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 improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Operating Profit Margin
Microsoft Corp., operating profit margin calculation (quarterly data)
| 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Operating income | 27,032) | 26,895) | 24,254) | 22,352) | 20,399) | 21,518) | 20,534) | 20,364) | 22,247) | 20,238) | 19,095) | 17,048) | 17,897) | 15,876) | 13,407) | 12,975) | 13,891) | 12,686) | 12,405) | 10,341) | 10,258) | 9,955) | 10,379) | 8,292) | 8,679) | 7,708) | ||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Profitability Ratio | ||||||||||||||||||||||||||||||||||
| Operating profit margin1 | 44.17% | 43.01% | 41.77% | 40.85% | 40.58% | 41.69% | 42.06% | 42.56% | 42.52% | 42.14% | 41.59% | 40.15% | 39.24% | 38.17% | 37.03% | 37.46% | 36.74% | 35.20% | 34.14% | 33.49% | 32.82% | 32.47% | 31.77% | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Operating Profit Margin, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 13.76% | 13.60% | 13.74% | 14.42% | 14.90% | 15.27% | 15.21% | 15.20% | 15.12% | 15.19% | 15.08% | 15.03% | 14.89% | 14.84% | 14.69% | 14.68% | 14.66% | 14.65% | 14.59% | 14.45% | 14.31% | 14.20% | 14.04% | — | — | — | ||||||||
| Adobe Inc. | — | 29.95% | 34.26% | 33.95% | 33.64% | 33.91% | 34.64% | 35.45% | 36.25% | 36.72% | 36.76% | 36.53% | 35.75% | 34.75% | 32.93% | 32.10% | 31.36% | 30.10% | 29.25% | 28.36% | 28.55% | 29.65% | 31.45% | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 15.17% | 14.58% | 13.88% | 13.49% | 13.50% | 12.92% | 12.77% | 12.30% | 11.97% | 9.12% | 10.13% | 10.39% | 9.22% | 12.21% | 11.50% | 11.73% | 13.67% | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 23.00% | 22.86% | 21.86% | 21.67% | 19.48% | 18.41% | 20.20% | 23.68% | 22.49% | 24.10% | 25.95% | 29.04% | 26.95% | 30.30% | 28.34% | 22.46% | 26.81% | 27.03% | 27.33% | 28.42% | 27.32% | 25.34% | 25.10% | — | — | — | ||||||||
| Oracle Corp. | 27.73% | 27.01% | 26.21% | 28.06% | 30.42% | 22.92% | 25.74% | 26.22% | 26.62% | 37.78% | 37.58% | 37.74% | 37.13% | 36.29% | 35.57% | 34.82% | 34.65% | 34.49% | 34.26% | 34.47% | 34.36% | 34.23% | 34.34% | — | — | — | ||||||||
| Palo Alto Networks Inc. | 7.98% | 8.15% | 5.62% | 2.30% | 0.37% | -1.56% | -3.43% | -5.12% | -6.74% | -7.51% | -7.15% | -6.56% | -5.49% | -4.79% | -5.25% | -5.24% | -4.27% | -2.45% | -1.87% | -1.29% | -2.64% | -4.41% | -5.68% | — | — | — | ||||||||
| Salesforce Inc. | 8.18% | 4.42% | 3.29% | 1.64% | 0.26% | 0.77% | 2.07% | 3.67% | 4.69% | 4.25% | 2.14% | 1.11% | 0.35% | -0.29% | 1.74% | 2.97% | 3.37% | 3.95% | 4.03% | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 8.49% | 7.64% | 6.32% | 5.41% | 4.90% | 3.40% | 3.30% | 3.95% | 4.36% | 4.34% | 4.55% | 5.10% | 4.40% | 4.96% | 4.97% | 2.88% | 1.22% | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 22.40% | 21.72% | 19.11% | 18.81% | 20.70% | 22.87% | 22.93% | 23.18% | 20.72% | 17.48% | 18.17% | 18.81% | 17.82% | 16.83% | 15.77% | 13.85% | 13.64% | 15.48% | 13.68% | 12.02% | 12.61% | 11.54% | — | — | — | ||||||||
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).
1 Q2 2024 Calculation
Operating profit margin = 100
× (Operating incomeQ2 2024
+ Operating incomeQ1 2024
+ Operating incomeQ4 2023
+ Operating incomeQ3 2023)
÷ (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
= 100 × (27,032 + 26,895 + 24,254 + 22,352)
÷ (62,020 + 56,517 + 56,189 + 52,857)
= 44.17%
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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Net Profit Margin
Microsoft Corp., net profit margin calculation (quarterly data)
| 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Net income (loss) | 21,870) | 22,291) | 20,081) | 18,299) | 16,425) | 17,556) | 16,740) | 16,728) | 18,765) | 20,505) | 16,458) | 15,457) | 15,463) | 13,893) | 11,202) | 10,752) | 11,649) | 10,678) | 13,187) | 8,809) | 8,420) | 8,824) | 8,873) | 7,424) | (6,302) | 6,576) | ||||||||
| Revenue | 62,020) | 56,517) | 56,189) | 52,857) | 52,747) | 50,122) | 51,865) | 49,360) | 51,728) | 45,317) | 46,152) | 41,706) | 43,076) | 37,154) | 38,033) | 35,021) | 36,906) | 33,055) | 33,717) | 30,571) | 32,471) | 29,084) | 30,085) | 26,819) | 28,918) | 24,538) | ||||||||
| Profitability Ratio | ||||||||||||||||||||||||||||||||||
| Net profit margin1 | 36.27% | 35.31% | 34.15% | 33.25% | 33.05% | 34.37% | 36.69% | 37.63% | 38.50% | 38.51% | 36.45% | 35.02% | 33.47% | 32.29% | 30.96% | 33.36% | 33.02% | 31.66% | 31.18% | 28.58% | 28.31% | 16.38% | 15.02% | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Net Profit Margin, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 10.89% | 10.65% | 10.72% | 11.27% | 10.99% | 11.30% | 11.17% | 11.12% | 11.27% | 11.53% | 11.69% | 12.05% | 11.95% | 11.74% | 11.52% | 11.11% | 11.13% | 11.06% | 11.06% | 10.93% | 10.51% | 9.99% | 9.76% | — | — | — | ||||||||
| Adobe Inc. | — | 24.08% | 27.97% | 27.12% | 26.34% | 26.32% | 27.01% | 28.00% | 29.29% | 29.90% | 30.55% | 38.67% | 38.79% | 40.68% | 40.88% | 31.05% | 30.71% | 27.72% | 26.42% | 26.10% | 26.25% | 28.08% | 28.69% | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 12.13% | 11.32% | 3.34% | 3.03% | 2.71% | 2.08% | 9.36% | 9.46% | 10.01% | 7.81% | 8.16% | 7.76% | 7.59% | 10.53% | 10.43% | 11.78% | 12.22% | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 18.35% | 17.53% | 16.59% | 15.91% | 14.22% | 14.10% | 16.23% | 19.44% | 19.03% | 20.28% | 21.41% | 23.93% | 22.64% | 25.10% | 23.78% | 19.50% | 22.88% | 22.79% | 22.95% | 24.34% | 22.89% | 20.71% | 20.31% | — | — | — | ||||||||
| Oracle Corp. | 19.63% | 18.40% | 17.02% | 17.46% | 19.09% | 13.15% | 15.83% | 18.08% | 24.79% | 34.16% | 33.96% | 32.32% | 26.34% | 26.13% | 25.94% | 27.06% | 27.62% | 27.71% | 28.05% | 27.13% | 10.01% | 9.74% | 9.60% | — | — | — | ||||||||
| Palo Alto Networks Inc. | 30.24% | 8.52% | 6.38% | 3.32% | 0.56% | -2.46% | -4.85% | -7.54% | -9.50% | -11.20% | -11.72% | -11.00% | -9.73% | -8.36% | -7.83% | -7.01% | -5.58% | -3.42% | -2.82% | -2.30% | -3.47% | -5.04% | -6.51% | — | — | — | ||||||||
| Salesforce Inc. | 4.77% | 1.18% | 0.66% | 0.92% | 1.83% | 3.59% | 5.45% | 6.96% | 9.99% | 19.87% | 19.16% | 17.53% | 12.21% | -0.92% | 0.74% | 4.64% | 6.45% | 8.26% | 8.36% | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 19.30% | 18.72% | 17.76% | 5.25% | 4.49% | 2.90% | 2.79% | 3.56% | 3.90% | 3.99% | 3.30% | 3.15% | 2.62% | 16.60% | 18.42% | 18.20% | 18.11% | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 22.96% | 21.05% | 18.71% | 17.41% | 18.22% | 19.38% | 20.86% | 21.19% | 20.18% | 18.02% | 18.48% | 20.27% | 18.91% | 18.03% | 17.88% | 13.96% | 14.31% | 15.84% | 18.94% | 18.74% | 18.59% | 13.86% | — | — | — | ||||||||
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).
1 Q2 2024 Calculation
Net profit margin = 100
× (Net income (loss)Q2 2024
+ Net income (loss)Q1 2024
+ Net income (loss)Q4 2023
+ Net income (loss)Q3 2023)
÷ (RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023)
= 100 × (21,870 + 22,291 + 20,081 + 18,299)
÷ (62,020 + 56,517 + 56,189 + 52,857)
= 36.27%
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 Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Return on Equity (ROE)
Microsoft Corp., ROE calculation (quarterly data)
| 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Net income (loss) | 21,870) | 22,291) | 20,081) | 18,299) | 16,425) | 17,556) | 16,740) | 16,728) | 18,765) | 20,505) | 16,458) | 15,457) | 15,463) | 13,893) | 11,202) | 10,752) | 11,649) | 10,678) | 13,187) | 8,809) | 8,420) | 8,824) | 8,873) | 7,424) | (6,302) | 6,576) | ||||||||
| Stockholders’ equity | 238,268) | 220,714) | 206,223) | 194,683) | 183,136) | 173,566) | 166,542) | 162,924) | 160,010) | 151,978) | 141,988) | 134,505) | 130,236) | 123,392) | 118,304) | 114,501) | 110,109) | 106,061) | 102,330) | 94,864) | 92,128) | 85,967) | 82,718) | 79,239) | 78,360) | 89,647) | ||||||||
| Profitability Ratio | ||||||||||||||||||||||||||||||||||
| ROE1 | 34.64% | 34.93% | 35.09% | 35.45% | 36.83% | 40.21% | 43.68% | 44.47% | 44.49% | 44.67% | 43.15% | 41.65% | 39.40% | 38.49% | 37.43% | 40.41% | 40.25% | 38.75% | 38.35% | 36.82% | 36.41% | 21.89% | 20.03% | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| ROE, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 25.92% | 25.79% | 26.75% | 28.28% | 29.20% | 30.69% | 31.11% | 30.99% | 31.09% | 30.45% | 30.25% | 29.87% | 29.81% | 29.33% | 30.05% | 30.91% | 32.13% | 32.05% | 33.17% | 34.05% | 33.53% | 33.21% | 39.17% | — | — | — | ||||||||
| Adobe Inc. | — | 31.05% | 32.86% | 32.46% | 32.71% | 33.35% | 33.85% | 33.49% | 34.96% | 35.04% | 32.59% | 40.51% | 40.30% | 41.09% | 39.66% | 32.97% | 34.00% | 30.89% | 28.03% | 27.12% | 26.70% | 27.17% | 27.67% | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 33.29% | 30.00% | 9.12% | 8.48% | 7.47% | 6.29% | 28.79% | 28.98% | 30.38% | 21.44% | 24.31% | 25.11% | 27.14% | 37.27% | 38.33% | 45.08% | 45.25% | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 16.38% | 15.21% | 13.81% | 12.73% | 12.28% | 11.69% | 12.57% | 14.75% | 13.93% | 21.49% | 20.89% | 21.37% | 19.70% | 37.50% | 35.76% | 28.21% | 43.76% | 43.49% | 41.53% | 40.54% | 52.65% | 45.36% | 51.44% | — | — | — | ||||||||
| Oracle Corp. | 262.21% | 395.57% | 792.45% | — | — | — | — | — | — | — | 262.43% | 144.16% | 131.11% | 107.99% | 83.94% | 75.58% | 70.25% | 59.43% | 50.87% | 45.33% | 13.02% | 10.19% | 8.37% | — | — | — | ||||||||
| Palo Alto Networks Inc. | 52.25% | 28.28% | 25.15% | 17.47% | 4.71% | -28.23% | -127.14% | -115.40% | -391.77% | -98.34% | -78.63% | -43.97% | -35.50% | -40.11% | -24.23% | -30.74% | -10.84% | -6.81% | -5.16% | -4.36% | -8.39% | -9.75% | -15.30% | — | — | — | ||||||||
| Salesforce Inc. | 2.72% | 0.66% | 0.36% | 0.47% | 0.89% | 1.70% | 2.48% | 3.05% | 4.24% | 10.44% | 9.81% | 8.82% | 6.16% | -0.48% | 0.37% | 2.21% | 5.53% | 7.04% | 7.11% | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 22.69% | 22.08% | 20.56% | 7.14% | 6.46% | 4.44% | 4.39% | 5.58% | 6.22% | 6.24% | 5.21% | 5.01% | 4.18% | 26.20% | 29.38% | 29.85% | 29.45% | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 21.10% | 20.01% | 17.36% | 15.79% | 16.72% | 17.85% | 18.42% | 18.13% | 16.87% | 14.31% | 14.63% | 15.88% | 14.80% | 13.54% | 13.66% | 11.10% | 11.64% | 13.04% | 15.91% | 15.49% | 15.61% | 12.43% | — | — | — | ||||||||
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).
1 Q2 2024 Calculation
ROE = 100
× (Net income (loss)Q2 2024
+ Net income (loss)Q1 2024
+ Net income (loss)Q4 2023
+ Net income (loss)Q3 2023)
÷ Stockholders’ equity
= 100 × (21,870 + 22,291 + 20,081 + 18,299)
÷ 238,268 = 34.64%
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 deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024. |
Return on Assets (ROA)
Microsoft Corp., ROA calculation (quarterly data)
| 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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||||||||
| Net income (loss) | 21,870) | 22,291) | 20,081) | 18,299) | 16,425) | 17,556) | 16,740) | 16,728) | 18,765) | 20,505) | 16,458) | 15,457) | 15,463) | 13,893) | 11,202) | 10,752) | 11,649) | 10,678) | 13,187) | 8,809) | 8,420) | 8,824) | 8,873) | 7,424) | (6,302) | 6,576) | ||||||||
| Total assets | 470,558) | 445,785) | 411,976) | 380,088) | 364,552) | 359,784) | 364,840) | 344,607) | 340,389) | 335,418) | 333,779) | 308,879) | 304,137) | 301,001) | 301,311) | 285,449) | 282,794) | 278,955) | 286,556) | 263,281) | 258,859) | 257,619) | 258,848) | 245,497) | 256,003) | 249,097) | ||||||||
| Profitability Ratio | ||||||||||||||||||||||||||||||||||
| ROA1 | 17.54% | 17.29% | 17.56% | 18.16% | 18.50% | 19.40% | 19.94% | 21.03% | 20.91% | 20.24% | 18.36% | 18.13% | 16.87% | 15.78% | 14.70% | 16.21% | 15.67% | 14.73% | 13.69% | 13.27% | 12.96% | 7.30% | 6.40% | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| ROA, Competitors2 | ||||||||||||||||||||||||||||||||||
| Accenture PLC | 13.70% | 13.35% | 13.41% | 14.29% | 14.54% | 14.97% | 14.55% | 14.38% | 14.42% | 14.19% | 13.68% | 13.72% | 13.65% | 13.72% | 13.78% | 14.12% | 14.84% | 14.66% | 16.04% | 16.62% | 16.33% | 15.77% | 16.61% | — | — | — | ||||||||
| Adobe Inc. | — | 16.70% | 18.23% | 17.60% | 17.44% | 17.76% | 17.51% | 18.00% | 18.57% | 18.58% | 17.70% | 22.33% | 21.82% | 22.28% | 21.66% | 17.23% | 17.13% | 15.24% | 14.22% | 13.85% | 13.48% | 13.75% | 13.80% | — | — | — | ||||||||
| International Business Machines Corp. | — | — | 5.55% | 5.35% | 1.53% | 1.37% | 1.29% | 1.00% | 4.38% | 4.14% | 4.35% | 3.30% | 3.63% | 3.61% | 3.58% | 5.13% | 5.11% | 5.88% | 6.20% | — | — | — | — | — | — | — | ||||||||
| Intuit Inc. | 9.33% | 9.07% | 8.58% | 7.74% | 7.15% | 6.93% | 7.45% | 8.77% | 8.26% | 14.07% | 13.29% | 13.50% | 11.97% | 20.26% | 16.70% | 17.22% | 24.34% | 25.55% | 24.78% | 23.85% | 27.59% | 25.61% | 23.39% | — | — | — | ||||||||
| Oracle Corp. | 7.55% | 6.86% | 6.33% | 6.36% | 6.85% | 4.46% | 6.15% | 6.96% | 9.60% | 11.35% | 10.48% | 10.86% | 9.44% | 9.03% | 8.78% | 11.13% | 11.11% | 10.31% | 10.20% | 9.82% | 3.36% | 3.02% | 2.79% | — | — | — | ||||||||
| Palo Alto Networks Inc. | 12.45% | 4.15% | 3.03% | 1.52% | 0.26% | -1.14% | -2.18% | -3.51% | -4.44% | -4.89% | -4.87% | -4.59% | -3.88% | -3.43% | -2.95% | -3.52% | -2.43% | -1.51% | -1.24% | -1.01% | -1.58% | -2.11% | -2.54% | — | — | — | ||||||||
| Salesforce Inc. | 1.71% | 0.41% | 0.21% | 0.30% | 0.57% | 1.08% | 1.52% | 1.99% | 2.65% | 6.85% | 6.14% | 6.01% | 4.10% | -0.31% | 0.23% | 1.47% | 2.85% | 3.49% | 3.61% | — | — | — | — | — | — | — | ||||||||
| ServiceNow Inc. | — | — | 9.96% | 10.51% | 9.54% | 2.94% | 2.44% | 1.81% | 1.66% | 2.03% | 2.13% | 2.33% | 1.86% | 1.73% | 1.36% | 9.09% | 11.17% | 10.92% | 10.41% | — | — | — | — | — | — | — | ||||||||
| Synopsys Inc. | — | 13.33% | 11.90% | 10.42% | 9.40% | 9.85% | 10.45% | 11.07% | 10.95% | 10.21% | 8.66% | 8.88% | 9.69% | 9.02% | 8.27% | 8.19% | 6.48% | 6.70% | 8.31% | 10.17% | 9.77% | 9.30% | 7.04% | — | — | — | ||||||||
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).
1 Q2 2024 Calculation
ROA = 100
× (Net income (loss)Q2 2024
+ Net income (loss)Q1 2024
+ Net income (loss)Q4 2023
+ Net income (loss)Q3 2023)
÷ Total assets
= 100 × (21,870 + 22,291 + 20,081 + 18,299)
÷ 470,558 = 17.54%
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 deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 not reaching Q4 2023 level. |