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, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
United States 0.94 1.10 1.20 1.16 1.26 1.16
Other countries 1.64 1.61 1.64 1.61 1.54 1.50

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.
Other countries Other countries area asset turnover ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 not reaching 2020 level.

Area Asset Turnover: United States

Microsoft Corp.; United States; area asset turnover calculation

Microsoft Excel
Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
Selected Financial Data (US$ in millions)
Revenue 100,218  83,953  73,160  64,199  55,926  45,248 
Long-lived assets 106,430  76,153  60,789  55,252  44,501  39,118 
Area Activity Ratio
Area asset turnover1 0.94 1.10 1.20 1.16 1.26 1.16

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

1 2022 Calculation
Area asset turnover = Revenue ÷ Long-lived assets
= 100,218 ÷ 106,430 = 0.94

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

Area Asset Turnover: Other countries

Microsoft Corp.; Other countries; area asset turnover calculation

Microsoft Excel
Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
Selected Financial Data (US$ in millions)
Revenue 98,052  84,135  69,855  61,644  54,434  44,702 
Long-lived assets 59,938  52,161  42,504  38,380  35,381  29,844 
Area Activity Ratio
Area asset turnover1 1.64 1.61 1.64 1.61 1.54 1.50

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

1 2022 Calculation
Area asset turnover = Revenue ÷ Long-lived assets
= 98,052 ÷ 59,938 = 1.64

Area activity ratio Geographic area The company
Area asset turnover Other countries Other countries area asset turnover ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 not reaching 2020 level.

Revenue

Microsoft Corp., revenue by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
United States 100,218  83,953  73,160  64,199  55,926  45,248 
Other countries 98,052  84,135  69,855  61,644  54,434  44,702 
Total 198,270  168,088  143,015  125,843  110,360  89,950 

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


Long-lived assets

Microsoft Corp., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
United States 106,430  76,153  60,789  55,252  44,501  39,118 
Other countries 59,938  52,161  42,504  38,380  35,381  29,844 
Total 166,368  128,314  103,293  93,632  79,882  68,962 

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