Analysis of Reportable Segments
Microsoft Corp. operates in 3 segments: Productivity and Business Processes; Intelligent Cloud; and More Personal Computing.
Segment Profit Margin
Microsoft Corp., profit margin by reportable segment
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | |
|---|---|---|---|---|---|---|
| Productivity and Business Processes | 49.35% | 46.85% | 45.17% | 40.36% | 39.40% | 36.04% |
| Intelligent Cloud | 43.10% | 43.48% | 43.49% | 37.89% | 35.71% | 35.77% |
| More Personal Computing | 30.05% | 35.16% | 35.94% | 32.98% | 28.05% | 25.10% |
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).
| Segment profitability ratio | Reportable segment | The company |
|---|---|---|
| Segment profit margin | Productivity and Business Processes | Productivity and Business Processes segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023. |
| Intelligent Cloud | Intelligent Cloud segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023. | |
| More Personal Computing | More Personal Computing segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023. |
Segment Profit Margin: Productivity and Business Processes
Microsoft Corp.; Productivity and Business Processes; segment profit margin calculation
| 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 | 34,189) | 29,687) | 24,351) | 18,724) | 16,219) | 12,924) |
| Revenue | 69,274) | 63,364) | 53,915) | 46,398) | 41,160) | 35,865) |
| Segment Profitability Ratio | ||||||
| Segment profit margin1 | 49.35% | 46.85% | 45.17% | 40.36% | 39.40% | 36.04% |
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
Segment profit margin = 100 × Operating income ÷ Revenue
= 100 × 34,189 ÷ 69,274 = 49.35%
| Segment profitability ratio | Reportable segment | The company |
|---|---|---|
| Segment profit margin | Productivity and Business Processes | Productivity and Business Processes segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023. |
Segment Profit Margin: Intelligent Cloud
Microsoft Corp.; Intelligent Cloud; segment profit margin calculation
| 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 | 37,884) | 32,721) | 26,126) | 18,324) | 13,920) | 11,524) |
| Revenue | 87,907) | 75,251) | 60,080) | 48,366) | 38,985) | 32,219) |
| Segment Profitability Ratio | ||||||
| Segment profit margin1 | 43.10% | 43.48% | 43.49% | 37.89% | 35.71% | 35.77% |
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
Segment profit margin = 100 × Operating income ÷ Revenue
= 100 × 37,884 ÷ 87,907 = 43.10%
| Segment profitability ratio | Reportable segment | The company |
|---|---|---|
| Segment profit margin | Intelligent Cloud | Intelligent Cloud segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023. |
Segment Profit Margin: More Personal Computing
Microsoft Corp.; More Personal Computing; segment profit margin calculation
| 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 | 16,450) | 20,975) | 19,439) | 15,911) | 12,820) | 10,610) |
| Revenue | 54,734) | 59,655) | 54,093) | 48,251) | 45,698) | 42,276) |
| Segment Profitability Ratio | ||||||
| Segment profit margin1 | 30.05% | 35.16% | 35.94% | 32.98% | 28.05% | 25.10% |
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
Segment profit margin = 100 × Operating income ÷ Revenue
= 100 × 16,450 ÷ 54,734 = 30.05%
| Segment profitability ratio | Reportable segment | The company |
|---|---|---|
| Segment profit margin | More Personal Computing | More Personal Computing segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023. |
Revenue
Microsoft Corp., revenue by reportable segment
US$ in millions
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | |
|---|---|---|---|---|---|---|
| Productivity and Business Processes | 69,274) | 63,364) | 53,915) | 46,398) | 41,160) | 35,865) |
| Intelligent Cloud | 87,907) | 75,251) | 60,080) | 48,366) | 38,985) | 32,219) |
| More Personal Computing | 54,734) | 59,655) | 54,093) | 48,251) | 45,698) | 42,276) |
| Total | 211,915) | 198,270) | 168,088) | 143,015) | 125,843) | 110,360) |
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).
Operating income
Microsoft Corp., operating income by reportable segment
US$ in millions
| Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | Jun 30, 2018 | |
|---|---|---|---|---|---|---|
| Productivity and Business Processes | 34,189) | 29,687) | 24,351) | 18,724) | 16,219) | 12,924) |
| Intelligent Cloud | 37,884) | 32,721) | 26,126) | 18,324) | 13,920) | 11,524) |
| More Personal Computing | 16,450) | 20,975) | 19,439) | 15,911) | 12,820) | 10,610) |
| Total | 88,523) | 83,383) | 69,916) | 52,959) | 42,959) | 35,058) |
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).