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, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
United States 0.67 0.93 0.94 1.10 1.20 1.16
Other countries 1.04 1.44 1.64 1.61 1.64 1.61

Based on: 10-K (reporting date: 2024-06-30), 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).

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

Area Asset Turnover: United States

Microsoft Corp.; United States; area asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Revenue 124,704 106,744 100,218 83,953 73,160 64,199
Long-lived assets 186,106 114,380 106,430 76,153 60,789 55,252
Area Activity Ratio
Area asset turnover1 0.67 0.93 0.94 1.10 1.20 1.16

Based on: 10-K (reporting date: 2024-06-30), 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).

1 2024 Calculation
Area asset turnover = Revenue ÷ Long-lived assets
= 124,704 ÷ 186,106 = 0.67

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

Area Asset Turnover: Other countries

Microsoft Corp.; Other countries; area asset turnover calculation

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Revenue 120,418 105,171 98,052 84,135 69,855 61,644
Long-lived assets 115,263 72,859 59,938 52,161 42,504 38,380
Area Activity Ratio
Area asset turnover1 1.04 1.44 1.64 1.61 1.64 1.61

Based on: 10-K (reporting date: 2024-06-30), 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).

1 2024 Calculation
Area asset turnover = Revenue ÷ Long-lived assets
= 120,418 ÷ 115,263 = 1.04

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Revenue

Microsoft Corp., revenue by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
United States 124,704 106,744 100,218 83,953 73,160 64,199
Other countries 120,418 105,171 98,052 84,135 69,855 61,644
Total 245,122 211,915 198,270 168,088 143,015 125,843

Based on: 10-K (reporting date: 2024-06-30), 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).


Long-lived assets

Microsoft Corp., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
United States 186,106 114,380 106,430 76,153 60,789 55,252
Other countries 115,263 72,859 59,938 52,161 42,504 38,380
Total 301,369 187,239 166,368 128,314 103,293 93,632

Based on: 10-K (reporting date: 2024-06-30), 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).