Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

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

Ratio	Description	The company
Net fixed asset turnover	An activity ratio calculated as total revenue divided by net fixed assets.	Microsoft Corp.’s net fixed asset turnover deteriorated from 2016 to 2017 and from 2017 to 2018.
Total asset turnover	An activity ratio calculated as total revenue divided by total assets.	Microsoft Corp.’s total asset turnover deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Equity turnover	An activity ratio calculated as total revenue divided by shareholders’ equity.	Microsoft Corp.’s equity turnover improved from 2016 to 2017 and from 2017 to 2018.

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

		Jun 30, 2018	Jun 30, 2017	Jun 30, 2016	Jun 30, 2015	Jun 30, 2014	Jun 30, 2013
	Selected Financial Data (USD $ in millions)
	Revenue
	Property and equipment, net of accumulated depreciation
	Ratio
	Net fixed asset turnover¹
	Benchmarks
	Net Fixed Asset Turnover, Competitors
	Adobe Inc.
	Alphabet Inc.
	Facebook Inc.
	International Business Machines Corp.
	Oracle Corp.
	salesforce.com inc.
	Net Fixed Asset Turnover, Sector
	Software & Computer Services
	Net Fixed Asset Turnover, Industry
	Technology

2018 Calculations

¹ Net fixed asset turnover = Revenue ÷ Property and equipment, net of accumulated depreciation
= hidden ÷ hidden = hidden

Ratio	Description	The company
Net fixed asset turnover	An activity ratio calculated as total revenue divided by net fixed assets.	Microsoft Corp.’s net fixed asset turnover deteriorated from 2016 to 2017 and from 2017 to 2018.

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

		Jun 30, 2018	Jun 30, 2017	Jun 30, 2016	Jun 30, 2015	Jun 30, 2014	Jun 30, 2013
	Selected Financial Data (USD $ in millions)
	Revenue
	Total assets
	Ratio
	Total asset turnover¹
	Benchmarks
	Total Asset Turnover, Competitors
	Adobe Inc.
	Alphabet Inc.
	Facebook Inc.
	International Business Machines Corp.
	Oracle Corp.
	salesforce.com inc.
	Total Asset Turnover, Sector
	Software & Computer Services
	Total Asset Turnover, Industry
	Technology

2018 Calculations

¹ Total asset turnover = Revenue ÷ Total assets
= hidden ÷ hidden = hidden

Ratio	Description	The company
Total asset turnover	An activity ratio calculated as total revenue divided by total assets.	Microsoft Corp.’s total asset turnover deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Microsoft Corp., equity turnover calculation, comparison to benchmarks

		Jun 30, 2018	Jun 30, 2017	Jun 30, 2016	Jun 30, 2015	Jun 30, 2014	Jun 30, 2013
	Selected Financial Data (USD $ in millions)
	Revenue
	Stockholders’ equity
	Ratio
	Equity turnover¹
	Benchmarks
	Equity Turnover, Competitors
	Adobe Inc.
	Alphabet Inc.
	Facebook Inc.
	International Business Machines Corp.
	Oracle Corp.
	salesforce.com inc.
	Equity Turnover, Sector
	Software & Computer Services
	Equity Turnover, Industry
	Technology

2018 Calculations

¹ Equity turnover = Revenue ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

Ratio	Description	The company
Equity turnover	An activity ratio calculated as total revenue divided by shareholders’ equity.	Microsoft Corp.’s equity turnover improved from 2016 to 2017 and from 2017 to 2018.

	Microsoft Corp.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Microsoft Corp. (MSFT)

Long-term (Investment) Activity Analysis