Switch to:
Microsoft Corp  (NAS:MSFT) Asset Turnover: 0.10 (As of Sep. 2017)

Asset Turnover measures how quickly a company turns over its asset through sales. It is calculated as Revenue divided by Total Assets. Microsoft Corp's Revenue for the three months ended in Sep. 2017 was \$24,538 Mil. Microsoft Corp's Total Assets for the quarter that ended in Sep. 2017 was \$245,092 Mil. Therefore, Microsoft Corp's asset turnover for the quarter that ended in Sep. 2017 was 0.10.

Asset Turnover is linked to ROE % through Du Pont Formula. Microsoft Corp's annualized ROE % for the quarter that ended in Sep. 2017 was 32.47%. It is also linked to ROA % through Du Pont Formula. Microsoft Corp's annualized ROA % for the quarter that ended in Sep. 2017 was 10.73%.

Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Microsoft Corp Annual Data

 Jun08 Jun09 Jun10 Jun11 Jun12 Jun13 Jun14 Jun15 Jun16 Jun17 Asset Turnover 0.59 0.55 0.54 0.46 0.41

Microsoft Corp Quarterly Data

 Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Asset Turnover 0.11 0.11 0.10 0.10 0.10

Calculation

Asset Turnover measures how quickly a company turns over its asset through sales.

Microsoft Corp's Asset Turnover for the fiscal year that ended in Jun. 2017 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (A: Jun. 2017 ) / ( (Total Assets (A: Jun. 2016 ) + Total Assets (A: Jun. 2017 )) / 2 ) = 89950 / ( (193468 + 241086) / 2 ) = 89950 / 217277 = 0.41

Microsoft Corp's Asset Turnover for the quarter that ended in Sep. 2017 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (Q: Sep. 2017 ) / ( (Total Assets (Q: Jun. 2017 ) + Total Assets (Q: Sep. 2017 )) / 2 ) = 24538 / ( (241086 + 249097) / 2 ) = 24538 / 245091.5 = 0.10

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Companies with low profit margins tend to have high asset turnover, while those with high profit margins have low asset turnover. Companies in the retail industry tend to have a very high turnover ratio.

Explanation

Asset Turnover is linked to Return on Equity (ROE) through Du Pont Formula.

Microsoft Corp's annulized ROE % for the quarter that ended in Sep. 2017 is

 ROE % (Q: Sep. 2017 ) = Net Income / Total Equity = 26304 / 81020.5 = (Net Income / Revenue) * (Revenue / Total Assets) * (Total Assets / Total Equity) = (26304 / 98152) * (98152 / 245091.5) * (245091.5/ 81020.5) = Net Margin % * Asset Turnover * Leverage Ratio = 26.8 % * 0.4005 * 3.0251 = ROA % * Leverage Ratio = 10.73 % * 3.0251 = 32.47 %

Note: The Net Income data used here is four times the quarterly (Sep. 2017) net income data. The Revenue data used here is four times the quarterly (Sep. 2017) revenue data.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

It is also linked to Return on Assets (ROA) through Du Pont Formula:

Microsoft Corp's annulized ROA % for the quarter that ended in Sep. 2017 is

 ROA % (Q: Sep. 2017 ) = Net Income / Total Assets = 26304 / 245091.5 = (Net Income / Revenue) * (Revenue / Total Assets) = (26304 / 98152) * (98152 / 245091.5) = Net Margin % * Asset Turnover = 26.8 % * 0.4005 = 10.73 %

Note: The Net Income data used here is four times the quarterly (Sep. 2017) net income data. The Revenue data used here is four times the quarterly (Sep. 2017) revenue data.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Be Aware

In the article Joining The Dark Side: Pirates, Spies and Short Sellers, James Montier reported that In their US sample covering the period 1968-2003, Cooper et al find that firms with low asset growth outperformed firms with high asset growth by an astounding 20% p.a. equally weighted. Even when controlling for market, size and style, low asset growth firms outperformed high asset growth firms by 13% p.a. Therefore a company with fast asset growth may underperform.

Therefore, it is a good sign if a company's asset turnover is consistent or even increases. If a company's asset grows faster than sales, its asset turnover will decline, which can be a warning sign.

Related Terms

From the Internet

###### HPE shares tank on earnings and Meg Whitman departure news: 7 key takeaways

- theStreet 2017-11-21 18:29:00

###### Quality Dividend ETFs to Tackle Uncertainty

- Zacks 2017-11-21 16:43:00

###### Closing Bell: Stocks Finish Tuesday Strong as Tech, Healthcare Take the Lead

- theStreet 2017-11-21 16:32:00

###### Gamestop Become Cheap Ignore

- Seekingalpha 2017-11-21 16:23:20

###### Stocks Close Boldly Higher as Tech, Healthcare Send Indexes to New Records

- theStreet 2017-11-21 16:05:00

###### The 30 Dow Jones Stocks

- Fool 2017-11-21 15:39:00

###### Bank of America's P2P Payments Business Almost Doubled in October

- Fool 2017-11-21 15:17:00

###### You Might Already Own the Best Self-Driving Car Stock

- Fool 2017-11-21 15:05:00

###### Apple's Service Business Could Be the Key to Its Future

- Fool 2017-11-21 14:15:00

###### This Pink-sheets company is closing in on Amazon

- MarketWatch 2017-11-21 12:57:00

###### Why Square, like Roku and Box, was misunderstood by investors

- theStreet 2017-11-21 12:44:00

###### Microsoft Best Dow Jones Wealth Builder Stock Now

- Seekingalpha 2017-11-21 12:09:34

###### What Lies Ahead for Tech ETFs?

- Zacks 2017-11-21 11:45:00

###### Activision Blizzard, Walmart and Microsoft - The Best Black Friday Deals for Gam

- theStreet 2017-11-21 11:37:00

###### Stocks Flex Their Muscles as Dow, S&P 500 and Nasdaq All Reach Fresh Highs

- theStreet 2017-11-21 11:34:00

###### Wall Street Breakfast Tencent Tops Facebook Valuation

- Seekingalpha 2017-11-21 07:00:23

###### Tencent's \$292 Billion Rally Ousts Facebook From Global Top Five

- Bloomberg 2017-11-21 03:31:23

###### Apple Needs to Reach This Share Price to be Worth \$1 Trillion

- theStreet 2017-11-20 20:28:00

###### Lower S And P 500 P E Ratio

- Seekingalpha 2017-11-20 15:40:03

###### 10 best Black Friday tech deals from Amazon, Best Buy, Walmart and more

- theStreet 2017-11-20 15:38:00

###### Apple and big tech will drive total 2017 corporate cash stockpile up to \$1.9 trillion

- MarketWatch 2017-11-20 14:56:00

###### This is the most hated, and the most loved, stock among hedge funds

- MarketWatch 2017-11-20 14:07:00

###### Salesforce earnings: Analyst surveys pointing to a strong quarter

- MarketWatch 2017-11-20 13:53:00

###### Six promising stocks to buy when the biotech correction ends

- MarketWatch 2017-11-20 12:39:00

###### 10 Stocks Hedge Fund Billionaires Are Buying

- Fool 2017-11-20 11:49:00

###### 27 Stock Portfolio

- Seekingalpha 2017-11-20 11:42:14

###### Amazon launches a cloud service for US intelligence agencies

- cnbc 2017-11-20 11:34:56

###### Hong Kong's Tencent beats China's Alibaba to the \$500 billion market cap club

- MarketWatch 2017-11-20 10:54:00

###### Tracking Jeffrey Ubbens Valueact Portfolio Q3 2017 Update

- Seekingalpha 2017-11-20 04:47:24

###### Consumers Love the 'Death Star' That Is Amazon -- Jim Cramer's Top Thoughts

- theStreet 2017-11-20 01:00:00

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to \$400 per referral. ( Learn More)