Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

$19.99

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel LibreOffice Calc

Paying users area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

Microsoft Corp., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018 Jun 30, 2017
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

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-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Microsoft Corp. net fixed asset turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Microsoft Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from 2020 to 2021 and from 2021 to 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Microsoft Corp. total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Microsoft Corp. equity turnover ratio deteriorated from 2020 to 2021 but then slightly improved from 2021 to 2022.

Net Fixed Asset Turnover

Microsoft Corp., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
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
Property and equipment, net of accumulated depreciation
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
Salesforce Inc.
ServiceNow Inc.
Visa Inc.
Net Fixed Asset Turnover, Sector
Software & Services
Net Fixed Asset Turnover, Industry
Information Technology

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
Net fixed asset turnover = Revenue ÷ Property and equipment, net of accumulated depreciation
= ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Microsoft Corp. net fixed asset turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Microsoft Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
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
 
Property and equipment, net of accumulated depreciation
Operating lease right-of-use assets
Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
Salesforce Inc.
ServiceNow Inc.
Visa Inc.
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Software & Services
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Information Technology

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
Net fixed asset turnover (including operating lease, right-of-use asset) = Revenue ÷ Property and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Microsoft Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from 2020 to 2021 and from 2021 to 2022.

Total Asset Turnover

Microsoft Corp., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
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
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
Salesforce Inc.
ServiceNow Inc.
Visa Inc.
Total Asset Turnover, Sector
Software & Services
Total Asset Turnover, Industry
Information Technology

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
Total asset turnover = Revenue ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Microsoft Corp. total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Equity Turnover

Microsoft Corp., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
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
Stockholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Mastercard Inc.
Oracle Corp.
PayPal Holdings Inc.
Salesforce Inc.
ServiceNow Inc.
Visa Inc.
Equity Turnover, Sector
Software & Services
Equity Turnover, Industry
Information Technology

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
Equity turnover = Revenue ÷ Stockholders’ equity
= ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Microsoft Corp. equity turnover ratio deteriorated from 2020 to 2021 but then slightly improved from 2021 to 2022.