Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Analysis of Geographic Areas 

Microsoft Excel

Area Asset Turnover

Microsoft Corp., asset turnover by geographic area

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
United States 0.93 0.94 1.10 1.20 1.16 1.26
Other countries 1.44 1.64 1.61 1.64 1.61 1.54

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Other countries Other countries area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Area Asset Turnover: United States

Microsoft Corp.; United States; area asset turnover calculation

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)
Revenue 106,744 100,218 83,953 73,160 64,199 55,926
Long-lived assets 114,380 106,430 76,153 60,789 55,252 44,501
Area Activity Ratio
Area asset turnover1 0.93 0.94 1.10 1.20 1.16 1.26

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
Area asset turnover = Revenue ÷ Long-lived assets
= 106,744 ÷ 114,380 = 0.93

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: Other countries

Microsoft Corp.; Other countries; area asset turnover calculation

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)
Revenue 105,171 98,052 84,135 69,855 61,644 54,434
Long-lived assets 72,859 59,938 52,161 42,504 38,380 35,381
Area Activity Ratio
Area asset turnover1 1.44 1.64 1.61 1.64 1.61 1.54

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
Area asset turnover = Revenue ÷ Long-lived assets
= 105,171 ÷ 72,859 = 1.44

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Revenue

Microsoft Corp., revenue by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
United States 106,744 100,218 83,953 73,160 64,199 55,926
Other countries 105,171 98,052 84,135 69,855 61,644 54,434
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).


Long-lived assets

Microsoft Corp., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
United States 114,380 106,430 76,153 60,789 55,252 44,501
Other countries 72,859 59,938 52,161 42,504 38,380 35,381
Total 187,239 166,368 128,314 103,293 93,632 79,882

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